ITE 140 Schedule - Fall 2019

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

ITE 140 Schedule - Section 001N- Fall 2019

Revised: November 20, 2019

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/20 Course Introduction	Course information Why are you taking this class; what do you hope to learn? Student Services at Annandale Student email Access your Google Drive and create a folder for ite140 and within that folder, create a folder for inclass work and within that, a folder for today - e.g. day1 or use date
8/22	Download student data files for book Chapter 1	Excel Chapter 1 - Creating a Worksheet and Charting Data
Week 2 - 8/27, 8/29	Sign up for myLabIT MyLabIT Intro Chapter 1 Key Points (revised 1/29/19)	Upload Photo assignment
Week 3 - 9/3, 9/5	Chapter 2 - Project A - Key Points Chapter 2 - Project B - Key Points	Chapter 2, Using Functions, Creating Tables, and Managing Large Workbooks
Week 4 - 9/10, 9/12	Chapter 3 - Project A - Key Points Hands-on Test on Chapters 1 and 2 (9/12)	Chapter 3, Analyzing Data with Pie Charts, Line Charts, and What-If Analysis Tools (Thursday)
Week 5 - 9/17, 9/19	Chapter 3 - Project B - Key Points Chapter 4 - Project A - Key Points	Chapter 4, Use Financial and Lookup Functions, Define Names, Validate Data, and Audit Worksheets
Week 6 - 9/24, 9/26	Chapter 4 - Project B - Key Points Chapter 5 - Project A - Key Points
Week 7 - 10/1, 10/3	Chapter 5 - Project B - Key Points Start Chapter 6A	Chapter 5, Managing Large Workbooks and Using Advanced Sorting and Filtering
Week 8 - 10/8. 10/10	Hands-on Test - Chapters 1-4 (10/8) Multiple Choice Test - Chapters 1-4 (10/10)
Week 9 - 10/15 (no class - non-instructional day)
Week 9 - 10/17	Chapter 6 - Project A Earthquake Drill, return exams
Week 10 - 10/22, 10/24	Chapter 6 - Project B Steps to Create a Template and Worksheet Derived from a Template No class 10/24	Chapter 6, Creating Charts, Diagrams, and Templates
Week 11 - 10/29, 10/31	Chapter 7 - Project A, Part 1 Chapter 7 - Part B	Chapter 7, Creating PivotTables and PivotCharts
Week 12 - 11/5, 11/7	Chapter 8	Chapter 8, Using the Data Analysis, Solver and Scenario Features, and Building Complex Formulas
Week 13 - 11/12, 11/14, 11/19	Chapter 9 (11/12, 11/19) Hands-On Test of Chapters 5-7 (11/14)	Chapter 9, Using Macros and Visual Basic for Applications
Week 14 - 11/21, 11/26	Chapter 10	Chapter 10, External Data, Database Functions, and Side-by-Side Tables
11/28 - Thanksgiving (no class)
Week 15 12/3, 12/5	Chapter 11	Chapter 11, Collaborating with Others and Preparing a Workbook for Distribution
Week 16 12/10 - no class (exam week) Thursday, 12/12 - Final Exam - 8am-9:40am	Final Terms you should understand Things to practice - a study guide