The schedule will be updated as the
course progresses. The most current copy of this schedule can be found
www.billpegram.com.
| Week
| Class Topics
| Reading/Homework Due (more will be added
as course progresses)
|
Week 1
1/15 (no class-snow), 1/17
Course Introduction |
|
|
Week 2
1/22, 1/24
|
|
|
Week 3
1/29, 1/31
|
|
- Chapter 2, Using Functions, Creating Tables, and Managing Large Workbooks
|
Week 4
2/5, 2/7
|
|
- Chapter 2, Part B (Tuesday)
- Chapter 3, Analyzing Data with Pie Charts, Line Charts, and What-If Analysis Tools (Thursday)
|
Week 5
2/12, 2/14
|
|
- Chapter 4, Use Financial and Lookup Functions, Define Names, Validate Data, and Audit Worksheets
|
Week 6
2/19, 2/21(no class snow)
|
|
|
Week 7
2/26, 2/28
|
|
- Chapter 5, Managing Large Workbooks and Using Advanced Sorting and Filtering
|
Week 8
3/5, 3/7
|
|
|
| 3/12, 3/14 |
- NVCC Spring Break - no classes
|
|
Week 9
3/19, 3/21 |
- Multiple Choice Test - 3/19
- Hands-On Test (Chapter 1 and 2) - 3/21
|
|
Week 10
3/26, 3/28
|
|
- Chapter 6, Creating Charts, Diagrams, and Templates
|
Week 11
4/2, 4/4
|
|
- Chapter 7, Creating PivotTables and PivotCharts
|
Week 12
4/9, 4/11
|
|
- Chapter 8, Using the Data Analysis, Solver and Scenario Features, and Building Complex Formulas
|
Week 13
4/16, 4/18
|
|
- Chapter 9, Using Macros and Visual Basic for Applications
|
Week 14
4/23, 4/25
|
|
- Chapter 10, External Data, Database Functions, and Side-by-Side Tables
|
| 4/30, 5/2 |
|
- Chapter 11, Collaborating with Others and Preparing a Workbook for Distribution
|
Week 15
Thursday 5/9 8:00-9:40am
|
- Final
- Terms you should understand
- Things to practice - a study guide
|
|