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

ITE 140 Schedule - Section 001L- Fall 2021

Revised: January 19, 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

 
Week 2 - 1/24, 1/26

Week 3 - 1/31, 2/2

 

  • Chapter 2, Using Functions, Creating Tables, and Managing Large Workbooks
Week 4 - 2/7, 2/9

Week 5 -2/14, 2/16


  • Chapter 4, Creating PivotTables and PivotCharts
Week 7 - 2/21, 2/23


 

 

 

  • Chapter 5, Managing Large Workbooks and Using Advanced Sorting and Filtering
Week 8 - 2/28, 3/2


Spring Break - no class (week of March 7)    
Week 9 - 3/14, 3/16
  • 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
  • Test - Chapters 4-6 (3/23) - study guide

Week 11 - 3/28, 3/30

  • Chapter 8, Part A
  • Chapter 8, Part B
  • Chapter 8, Using the Data Analysis, Solver and Scenario Features, and Building Complex Formulas

Week 12 - 4/4, 4/6

  • Chapter 9, Part A
  • Chapter 9, Part B

 

  • Chapter 9, Using Macros and Visual Basic for Applications

Week 13 - 4/11, 4/13


  • Chapter 10, Part A
  • Chapter 10, Part B
  • 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




  • Material from Cengage Excel book - financial and depreciation functions

Week 15

Final, May 4, 2-3:40PM


  • Final
 
Topics not covered or assigned Flash Short Assignment 2
Flash Assignment 3