ITE 140 Schedule - Fall 2019

William M. Pegram
Home | Courses | Web Design | Server-Side Scripting | About Me

ITE 140 Schedule - Section 001L- Fall 2021

Revised: March 23, 2022

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/19 Course Introduction	Instructor introduction Course information Breakout rooms to meet other students
Week 2 - 1/24, 1/26	Chapter 1, Project A - Key Points Chapter 1, Project B Key Points	Excel Chapter 1 - Creating a Worksheet and Charting Data Upload Photo assignment
Week 3 - 1/31, 2/2	Chapter 2 - Project A - Key Points Chapter 2 - Project B - Key Points	Chapter 2, Using Functions, Creating Tables, and Managing Large Workbooks
Week 4 - 2/7, 2/9	Chapter 3 - Project A - Key Points Chapter 3 - Project B - Key Points	Chapter 3, Analyzing Data with Pie Charts, Line Charts, and What-If Analysis Tools Chapter 1-3 Study Guide
Week 5 -2/14, 2/16	Chapter 4 - Project A - Part 1 -Key Points Chapter 4 - Project A - Part 2 - Key Points	Chapter 4, Creating PivotTables and PivotCharts
Week 7 - 2/21, 2/23	Hands-On Test on Chapters 1-3 (2/21) Chapter 5 - Project A - Key Points	Chapter 5, Managing Large Workbooks and Using Advanced Sorting and Filtering
Week 8 - 2/28, 3/2	Chapter 5 - Project B - Key Points Chapter 6 - Project A	Chapter 6, Creating Charts, Diagrams, and Templates Steps to Create a Template and Worksheet Derived from a Template (will be revised)
Spring Break - no class (week of March 7)
Week 9 - 3/14, 3/16	Chapter 6 - Project B Chapter 7 - Project A, Part 1	Chapter 7, Use Financial and Lookup Functions, Define Names, Validate Data, and Audit Worksheets
Week 10 - 3/21, 3/23	Chapter 7, Project B, Part 1
Week 11 - 3/28, 3/30	Test - Chapters 3-5 (3/28) Chapter 8, Part A	Chapter 8, Using the Data Analysis, Solver and Scenario Features, and Building Complex Formulas
Week 12 - 4/4, 4/6	Chapter 8, Part B Chapter 9, Part A	Chapter 9, Using Macros and Visual Basic for Applications
Week 13 - 4/11, 4/13	Chapter 9, Part B Chapter 10, Part A	Chapter 10, Database Functions, Side-by-Side Tables, and Workbook Distribution and Collaboration
Week 14 - 4/18, 4/20, 4/25, 4/27, 5/2	Chapter 10, Part B Material from Cengage Excel book - financial and depreciation functions
Week 15 Final, May 4, 2-3:40PM	Final