This is a preliminary
course schedule and may be changed. If there are any changes to this
schedule, the class will be informed in writing.
An explanation:
The Concepts / Lab column details the groundwork you should do in order to
prepare for the Exam/Lab and Lab Exams. The actual lab is listed in the Homework
column.
|
Week |
Concepts Lecture |
Lab Session |
Homework |
Due |
|
1 |
Orientation, Read Chapter 1
(LO 1.1, 1.2, 1.3, 1.4, ) |
Chapter
7 – Office XP (LO 7.1 thu 7.6) Chapter
8 – Managing Files (LO 8.1, 8.2,
8.3) Chapter
9 – Intro Office 2010 (LO 9.1 thru
9.6) |
On Your Own 9-1 |
09/25 |
|
2 |
Read Chapter 2
(LO 2.1, 2.2, 2.3, 2.4, 2.5, 2.6) |
Chapter
10 – Creating a Document (LO 10.1
thru 10.11) Chapter
11 – Formatting a Long Document (LO
11.1 thru 11.9) |
Practice It 10-1 Practice It 11-1 |
10/02 10/02 |
|
3 |
CONCEPT EXAM (CH
1-2) |
Chapter
12 – Enhancing a Document (LO 12.1 thru 12.5 only) |
Practice It 12-1 |
10/09 |
|
4 |
Read
Chapter 3 (LO 3.1, 3.2, 3.3, 3.47, 3.5, 3.6, 3.7) |
WORD LAB EXAM (SAM PROJECTS) |
|
|
|
5 |
Read
Chapter 4 (LO 4.1, 4.2, 4.3, 4.4, 4.5, 4.6) |
Chapter
13 – Creating a Workbook (LO 13.1
thru 13.7)
Chapter 14 – Formatting a
Worksheet (LO 14.1 thru 14.6) |
Practice It 13-1 Practice It 14-1 |
10/23 10/23 |
|
6 |
CONCEPT
EXAM (CH 3-4) |
Chapter
15 – Working with Formulas and
Functions (LO 15.1 thru 15.6) Chapter
16 – Inserting and Formatting Charts
(LO 16.1 thru 16.9) |
Practice It 15-1 Practice It 16-1 |
10/30 10/30 |
|
7 |
Read
Chapter 5 (LO 5.1, 5.2, 5.3, 5.4) |
EXCEL
EXAM (SAM PROJECTS) |
|
|
|
8 |
Read
Chapter 6 (LO 6.1, 6.2, 6.3, 6.4, 6.5, 6.6) |
Chapter
17 – Creating a Database (LO 17.1
thru 17.8)
Chapter 18 – Maintaining
and Querying a Database (LO 18.1 thru 18.4 only) |
Practice It 17-1
Practice It 18-1 |
11/13 11/13 |
|
9 |
CONCEPT
EXAM (CH 5-6) |
Chapter
19 – Creating Forms and Reports (LO
19.1 thru 19.7) |
Practice It 19-1 |
11/20 |
|
10 |
Enrichment Assignment |
ACCESS
EXAM (SAM PROJECTS) |
|
|
|
11 |
Present
PowerPoint Projects |
Chapter
20 – Creating a Presentation (LO
20.4 thru 20.7 Chapter 21 – Enhancing a Presentation
(LO 21.1 thru 21.4)
Chapter
22 - Integrating Word, Excel,
Access, and PowerPoint (LO 23.1 only) |
Practice It 20-1
Practice It 21-1 Practice It 22-1 (steps 1-15 only) |
12/04 12/04 12/04 |
|
12 |
DEPARTMENTAL
ASSESSMENT |
PowerPoint Exam (SAM Projects) |
|
12/11 |