Week
|
Lecture/Notes
|
Assignments
|
|
#1
Jan 13-17
|
Module 1-1 Computer Concepts
|
In Class: In Class Exercise #1
|
|
#2
Jan 20-24
|
NO CLASS ON MONDAY JANUARY 20TH
Module 1-1 Computer Concepts
Module 1-1 Computer Concepts Review
Module 1-2 Computer Concepts Networks
|
Homework Assignment #1
Due: Monday January 27th @ 2:00PM
|
|
#3
Jan 27-31
|
Module 1-2 Computer Concepts Networks
Module 1-3 Computer Concepts Email
|
In Class:
In Class Exercise #2
Zip Folder Contents
⟹ Computer Concepts Exam
Monday February 3rd
on Modules 1-1, 1-2 & 1-3
Read:
Office 365 Common Features:
Taking the First Step
(pg. 2)
Chapter 1 - Introduction to Word:
Organizing a Document
(pg. 70)
|
|
#4
Feb 3-7
|
**Exam on Computer Concepts**
Modules 1-1, 1-2 & 1-3
Office 365 Common Features
Module 2-1 Introduction to Word
|
In Class: Word 1 Practice 1 - River City Media
(pg. 120)
Homework:
Word 1 Practice 2 - Freshwater Research
(pg. 122)
Word 1 Mid Level 1 - Water for Life
(pg. 124)
Due: Monday February 10th @ 2:00PM
Read:
Chapter 2 - Document Presentation: Editing and Formatting
(pg. 128)
|
|
#5
Feb 10-14
|
Module 2-2 Document Presentation
|
In Class: Word 2 Practice 1 - Campus Safety
(pg. 183)
Homework:
Word 2 Practice 2 - Drug Abuse
(pg. 185)
Word 2 Mid Level 1 - Mount Vernon Balloon Festival
(pg. 188)
Due: Monday February 17th @ 2:00PM
Read:
Chapter 3 - Document Productivity: Working with Tables and Mail Merge
(pg. 194)
|
|
#6
Feb 17-21
|
Module 2-3 Document Productivity
|
In Class: Word 3 Practice 2 - Fitness Matters
(pg. 241)
Homework:
Word 3 Practice 1 - Academics
(pg. 239)
Word 3 Mid Level 1 - Football Statistics
(pg. 244)
Due: Monday February 24th @ 2:00PM
Read:
Chapter 4 - Research and Collaboration: Communicating with and Producing Professional Papers
(pg. 250)
|
|
#7
Feb 24-28
|
Module 2-4 Research and Collaboration
|
⟹ Word Exam
Friday March 6th
on Modules 2-1, 2-2, 2-3 & 2-4
In Class: Word 4 Practice 1 - Live. Work. Dine. Shop.
(pg. 300)
Homework:
Word 4 Mid Level 2 - Study Abroad
(pg. 305)
Due: Monday March 2nd @ 2:00PM
|
|
#8
Mar 2-6
|
**Exam on Word**
Modules 2-1, 2-2, 2-3 & 2-4
Word Exam Review
|
Read:
Chapter 1 - Introduction to Excel: Creating and Formatting a Worksheet
(pg. 310)
|
|
#9
Mar 9-13
|
SPRING BREAK - NO CLASSES
|
|
#10
Mar 16-20
|
Module 3-1 Introduction to Excel
Module 3-1 Introduction to Excel (2013)
|
In Class: Excel 1 Practice 1 - Mathematics and Formatting
(pg. 377)
Homework:
Excel 1 Mid Level 1 - Guest House Rental Rates
(pg. 381)
Excel 1 Mid Level 2 - Real Estate Sales Report
(pg. 382)
Due: Monday March 23rd @ 2:00PM
Read:
Chapter 2 - Formulas and Functions: Performing Quantitative Analysis
(pg. 388)
|
|
#11
Mar 23-27
|
Module 3-2 Formulas and Functions
Module 3-2 Formulas and Functions (2013)
|
In Class: Excel 2 Mid Level 1 - Metropolitan Zoo Gift Shop Weekly Payroll
(pg. 427)
Homework:
Excel 2 Practice 1 - Hamilton Heights Auto Sales
(pg. 424)
Excel 2 Practice 2 - Garten Realty
(pg. 425)
Due: Monday March 30th @ 2:00PM
Read:
Chapter 3 - Charts: Depicting Data Visually
(pg. 432)
|
|
#12
Mar 30-Apr 3
|
Module 3-3 Charts
Module 3-3 Charts (2013)
|
In Class: Excel 3 Mid Level 1 - Airport Passenger Counts
(pg. 484)
Excel 3 Mid Level 2 - Grade Analysis
(pg. 485)
Homework:
Excel 3 Practice 1 - Loza Family Utility Expenses
(pg. 480)
Excel 3 Practice 2 - Trends in Market Value of Houses on Pine Circle
(pg. 482)
Due: Monday April 6th @ 2:00PM
Read:
Chapter 4 - Datasets and Tables: Managing Large Volumes of Data
(pg. 490)
|
|
#13
Apr 6-10
|
Module 3-4 Datasets and Tables
Module 3-4 Datasets and Tables (2013)
|
⟹ Excel Exam
Wednesday April 15th
on Modules 3-1, 3-2, 3-3 & 3-4
In Class: Excel 4 Practice 1 - Institute for Study Abroad
(pg. 545)
*I will add modifications to this assignment while we complete it*
Homework:
Excel Practice Exam
Excel Practice Exam Instructions
Excel Practice Exam Start
Due: Monday April 13th @ 2:00PM
Read:
Chapter 1 - Introduction to PowerPoint: Creating a Basic Presentation
(pg. 784)
|
|
#14
Apr 13-17
|
**Exam on Excel**
Modules 3-1, 3-2, 3-3 & 3-4
Excel Exam Review
Module 4-1 Introduction to PowerPoint
|
⟹ PowerPoint Exam
Friday April 24th
on Module 4-1
Homework:
PowerPoint Assignment
(Posted on D2L)
Due: Wednesday April 22nd @ 2:00PM
|
|
#15
Apr 20-24
|
**Exam on PowerPoint**
Module 4-1
PowerPoint Exam Review
|
In Class: PowerPoint 1 Practice 2 - Introduction to PowerPoint
(pg. 835)
|
|
#16
Apr 27-May 1
|
FINAL EXAM REVIEW
Computer Concepts Exam Review
Word Exam Review
Excel Exam Review
PowerPoint Exam Review
|
FINALS WEEK
CSCI104-004: FRIDAY MAY 1ST
2:45PM-4:45PM
BF LIB 114
|
