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

ITE 140 Schedule - Section 001L- Fall 2021

Revised: November 1, 2021

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 - 8/23
Course Introduction

  
8/25
  • Excel Chapter 1 - Creating a Worksheet and Charting Data

Week 2 - 8/30,

9/1 (cancelled due to weather)

 

Week 3 - 9/8, 9/13

 
  • Chapter 2, Using Functions, Creating Tables, and Managing Large Workbooks

Week 4 - 9/15
  • finished Chapter 2 (9/15)

 

  
Week 5 - 9/20, 9/22
Week 6 - 9/27,9/29


  • Chapter 4, Creating PivotTables and PivotCharts
Week 7 - 10/4, 10/6 10/13
10/11 (non-instructional day)


 

 

 
  • Chapter 5, Managing Large Workbooks and Using Advanced Sorting and Filtering
Week 8 - 10/18,10/20
Week 9 - 10/25, 10/27
  • Chapter 7, Use Financial and Lookup Functions, Define Names, Validate Data, and Audit Worksheets
Week 10 - 11/1, 11/3
  • Chapter 8
  • Chapter 8, Using the Data Analysis, Solver and Scenario Features, and Building Complex Formulas

Week 11 - 11/8, 11/10
  • Test - Chapters 4-7 (11/8) - study guide
  • Chapter 9, Part A
  • Chapter 9, Using Macros and Visual Basic for Applications

Week 12 - 11/15, 11/17
  • Chapter 9, Part B
  • Chapter 10, Part A

 

 

Week 13 - 11/22, 11/29
  • Chapter 10, Part B
  • Chapter 10, Database Functions,

    Side-by-Side Tables, and Workbook Distribution and Collaboration

Week 14 - 12/1, 12/6




  

Week 15

Final, December 8, 7-8:40PM
  • Final
  • Terms you should understand
  • Things to practice - a study guide
  
     
Topics not covered or assigned Flash Short Assignment 2
Flash Assignment 3