WEEK 1
Monday, January 9
Lecture Topics: Course
Intro, Word: Basic Editing -- Navigation, Text Selection, Line Spacing,
Font Formatting, Special Character Show/Hide, Keyboard Shortcuts -
Ctrl-Z (featured)
Wednesday, January 11
Lecture Topics: Word:
Basic Editing -- Page Orientation, Paragraph Indents, Page Breaks,
Tabs, Find - Replace
>>
Homework 1 due 9:00pm, Thursday,
January 12
Friday, January 13
Lecture Topics:
Excel: Intro -- Data Entry, Editing Cell Contents, Formulas, Excel
Functions, Cell References and Ranges, Fill Handle
WEEK 2
* HOLIDAY - Martin Luther King Day - NO CLASS
Monday, January 16
Wednesday, January 18
Lecture Topics: Excel
Navigation, Selecting Cells and Ranges, Row|Columns - insert, delete,
resize, Formatting Cells - alignment, numeric formats, borders, Excel
Cell References, Formula Construction
>>
Homework 2 due 9:00pm, Thursday,
January 19
Friday, January 20
Lecture Topics: CLASS CANCELLED BY UNIVERSITY CLOSURE
WEEK 3
Monday, January 23
Lecture
Topics: Excel - More on Cell References, Worksheets, Comments,
Hide-Unhide, Filtering, Find-Replace -- Lecture includes Extra
Practice/Review Exercises at the end
Important Tidbits of
the Day
Wednesday, January 25
>> QUIZ 2 << (Basic Excel Formulas and
Formatting)
Lecture Topics: Time for
questions, Screen Captures
>>
Homework 3 due 9:00pm, Thursday,
January 26
Friday, January 27
>> QUIZ 1 << (Basic Word Editing)
Lecture Topics:
PowerPoint - What is PowerPoint?, Speaker Notes, View Options, Print
Options
Important Tidbits of
the Day
WEEK 4
Monday, January 30
Lecture Topics:
PowerPoint - Slide Master and Presentation Defaults, Insert | Delete |
Sort Slides, Changing Slide Layout, Inserting - Arranging - Formatting
Shapes and
Images, Formatting Bulleted Lists
Wednesday, February 1
>> QUIZ 3 << (Excel: Filtering, Formatting,
Formulas)
Lecture Topics:
PowerPoint - Any remaining topics and questions, Off-campus File Access
>>
Homework 4 due 9:00pm, Thursday,
February 2
Friday, February 3
Lecture Topics: Excel -
Function Wizard, Complex Filtering, SUBTOTAL function (with Filtering),
Freeze Panes, and
Split Window, Entering Patterned Data
WEEK 5
Monday, February 6
Lecture Topics: Excel -
Conditional Formatting, Sorting, Paste Special | Transpose, VLOOKUP,
Paste Special | Values
Wednesday, February 8
>> QUIZ 4 << (PowerPoint Essentials)
Lecture Topics: Excel -
Paste Special - Operations, VLOOKUP, Named Range
>>
Homework 5 due 9:00pm, Thursday,
February 9
Friday, February 10
Lecture Topics: Excel -
VLOOKUP Examples, Filter-Subtotal Revisited, Text to Columns
WEEK 6
Monday, February 13
Lecture Topics: Excel -
Concatenation, Charts
Wednesday, February 15
>> MIDTERM << (Random pick from Quizzes #1 through
#4)
Lecture Topics: Excel -
More on Charts, Pivot Tables
>>
Homework 6 due 9:00pm, Thursday,
February 16
* Old content from
previous year
Friday, February 17
Lecture Topics: Excel -
Homework 6 Review, Pivot Tables, Charts
WEEK 7
* Old content from
previous year
Monday, February 20
Lecture Topics: Pivot
Table Grouping
* Old content from
previous year
Wednesday, February 22
>> QUIZ 5 << (Excel: Sorting, Conditional
Formatting, Filter & SUBTOTAL,
VLOOKUP, Paste Special, Hide|Unhide)
Lecture Topics: Pivot
Tables, Charts
>>
Homework 7 due 9:00pm, Thursday,
February 23
* Old content from
previous year
Friday, February 24
Lecture Topics: Quiz 5
and Homework 7 Debrief, Charts
WEEK 8
* Old content from
previous year
Monday, February 27
Lecture Topics: Charts,
IF Function
* Old content from
previous year
Wednesday, February 29
>> QUIZ 6 << (Excel: Text to Columns,
Concatenation,
Pivot Tables, Charts)
Lecture Topics: IF
Function (ran out of time to deal with Messy Formulas)
>>
Homework 8 due 9:00pm, Thursday,
March 1
* Old content from
previous year
Friday, March 2
Lecture Topics: CLASS CANCELLED BY UNIVERSITY DELAYED OPENING
WEEK 9
* Old content from
previous year
Monday, March 5
Lecture Topics: Questions in review for the quiz
* Old content from
previous year
Wednesday, March 7
>> QUIZ 7 << (Excel: Charts, Pivot
Tables, VLookup
and IF Functions)
Lecture Topics: Advanced
Word Topics - Picture Formatting, Formatting Requiring Section
Breaks
* Old content from
previous year
Friday, March 9
Lecture Topics: Advanced
Word Topics - Formatting Requiring Section Breaks (page numbers,
headers/footers, mixed page orientation, margin changes), Image file
types and transparent backgrounds
WEEK 10
* Old content from
previous year
Monday, March 12
Lecture Topics: Student
Evaluation of Teaching, Homework 9 Questions, Excel Print Options
>>
Homework 9 due Noon, Monday, March
12
* Old content from
previous year
Wednesday, March 14
>> QUIZ 8 << (Excel: IF Function, Word: Section
Formatting and Picture Formatting)
Lecture Topics:
Microsoft Access - Introduction
>>
Homework 10 due in class, 10:00am, Friday, March 16
* Old content from
previous year
Friday, March 16
Lecture Topics: Homework 10 (MS Access) due IN CLASS
FINALS WEEK
Thursday, March 22, 2:00pm (1400)
>> Optional FINAL EXAM <<
