Week
|
Lecture/Notes
|
Assignments
|
|
#1
Jan 23-27
|
Module 1-1 Computer Concepts
|
Homework Assignment #1
Due: Monday Jan 30 @ 11:30PM
|
|
#2
Jan 30-Feb 3
|
Module 1-1 Computer Concepts Review
Module 1-2 Computer Concepts Networks
Module 1-3 Computer Concepts Email
|
In Class: Zip Folder Contents
⟹ Computer Concepts Exam Feb 6
on Module 1-1, 1-2 & 1-3
|
|
#3
Feb 6-10
|
Intro to File Explorer and Office
|
Read:
Chapter 1 - Office Fundamentals and File Management (pg. 55)
Chapter 1 - Intro to Word (pg. 137)
|
|
#4
Feb 13-17
|
Module 2-1 Intro to Word
Module 2-2 Document Presentation
|
In Class: Word 1 Practice 1 - Interview Tips
(pg. 187)
Homework:
Word 1 Practice 2 - Aztec Computers (pg. 189)
Word 1 Mid Level 1 - Runners at Heart (pg. 191)
**Do NOT print the exercises**
Due: Monday February 20 @ 1:00PM
Read:
Chapter 2 - Document Presentation
(pg. 197)
|
|
#5
Feb 20-24
|
Module 2-2 Document Presentation
|
In Class: Word 2 Practice 1 - Campus Safety
(pg. 248)
Homework:
Word 2 Practice 2 - Alcohol Awareness
(pg. 250)
Word 2 Mid Level 1 - Balloon Festival (pg. 253)
Due: Monday February 27 @ 1:00PM
Read:
Chapter 3 - Document Productivity
(pg. 259)
|
|
#6
Feb 27- Mar 3
|
Module 2-3 Document Productivity
|
In Class: Word 3 Practice 1 - Rental Car Business
(pg. 302)
Homework:
Word 3 Practice 2 - Restaurant Letter
(pg. 304)
Word 3 Mid Level 1 - Football Statistics
(pg. 306)
Due: Wednesday March 8 @ 1:00PM
Read:
Chapter 4 - Collaboration and Research
(pg. 313)
|
|
#7
Mar 6-10
|
Module 2-4 Collaboration and Research
|
In Class: Word 4 Practice 1 - Social Media and Marketing
(pg. 364)
Homework:
Word 4 Mid Level 1 - WWW Web Services Agency
**SKIP Steps G & H***
(pg. 368)
Due: Friday March 17 @ 11:30PM
⟹ Word Exam March 20
on Chapters 1, 2, 3, and 4
Word Exam Review
|
|
#8
Mar 13-17
|
SPRING BREAK - NO CLASSES
|
|
#9
Mar 20-24
|
Module 3-1 Introduction to Excel
|
Read:
Chapter 1 - Introduction to Excel (pg. 373)
|
|
#10
Mar 27-31
|
Module 3-2 Formulas and Functions
|
In Class: Excel 1 Practice 1 - Mathematics Review
(pg. 436)
Homework:
Excel 1 Practice 3 - Downtown Theatre
(pg. 439)
Excel 1 Mid Level 1 - Restaurant Receipt
(pg. 441)
Due: Monday April 3 @ 1:00PM
Read:
Chapter 2 - Formulas and Functions
(pg. 447)
|
|
#11
Apr 3-7
|
Module 3-3 Charts
|
In Class: Excel 2 Mid Level 1 - Metropolitan Zoo Gift Shop Weekly Payroll
(pg. 496)
Homework:
Excel 2 Practice 1 - Blue Canadian Skies Airlines
(pg. 491)
Excel 2 Practice 2 - Steggel Consulting Firm Salaries
(pg. 492)
Excel 2 Practice 3 - New Car Loan
(pg. 494)
Due: Monday April 10 @ 1:00PM
Read:
Chapter 3 - Charts
(pg. 505)
|
|
#12
Apr 10-14
|
Module 3-3 Charts
Module 3-4 Datasets and Tables
|
In Class: Excel 3 Mid Level 1 - Airport Passenger Counts
(pg. 550)
Excel 3 Mid Level 2 - Grade Analysis
(pg. 550)
Homework:
Excel 3 Practice 1 - Hulett Family Utility Expenses
(pg. 547)
Excel 3 Practice 2 - Trends in Market Value of Houses on Pine Circle
(pg. 548)
Due: Monday April 17 @ 1:00PM
Read:
Chapter 4 - Datasets and Tables
*Skipping Tables piece*
(pg. 555)
|
|
#13
Apr 17-21
|
Module 3-4 Datasets and Tables
|
Monday: In Class: Excel 4 Practice 2 - Dentist Association Donation List
(pg. 610)
*I will add modifications to this assignment while we complete it*
Wednesday: Open Lab - Excel Practice Exam
Excel Practice Exam Instructions
Excel Practice Exam Start
Excel Practice Exam Answer
*Submit to D2L by April 19th @ 11:30PM*
Friday: Excel Chapters 1, 2, 3, and 4 Review
⟹ Excel Exam April 24
on Chapters 1, 2, 3, and 4
Excel Exam Review
|
|
#14
Apr 24-28
|
Module 4-1 Introduction to PowerPoint
|
In Class: PowerPoint 1 Practice 2 - Tips for a Successful Presentation
(pg. 1115)
Homework:
PowerPoint Assignment
*Posted on D2L*
Due: Monday May 1 @ 1:00PM
⟹ PowerPoint Exam May 1
on Chapter 1
PowerPoint Exam Review
|
|
#15
May 1-5
|
Computer Concepts Exam Review
Word Exam Review
Excel Exam Review
PowerPoint Exam Review
|
**REVIEW FOR FINAL**
|
|
#16
May 8-12
|
FINALS WEEK
CSCI104-003: WEDNESDAY MAY 10TH
12:30-2:30PM
Hamilton LL
|
