CSCI 112: Fall 2021
Course Schedule

Dates and topics are approximate and are subject to change.
 
Dates Topics Labs Assignments /Quizzes Exams
Week 1 Introduction - Computer(Sept. 7)
Introduction - Data(Sept. 9)
No Lab - -
Week 2 Introduction - Models(Sept. 14)
Introduction - Excel and Advanced Excel(Sept. 16)
Lab 1 - Computer and Data Assignment 1 -
Week 3 Excel Model Building(Sept. 21)
VBA - Baiscs (I)(Sept. 23)
Lab 2 - Excel Assignment 2 -
Week 4 VBA - Basics (II)(Sept. 28)
National Day for Truth and Reconciliation - No class (Sept. 30)
Lab 3 - Excel Model Assignment 3 -
Week 5 VBA - Decision (I)(Oct. 5)
VBA - Decision (II)(Oct. 7)
Lab 4 - Basic VBA Program Assignment 4 -
Week 6 Midterm 1 (Oct. 12)
Userform - Introduction (Oct. 14)
Thanksgiving - No Lab - Midterm 1
Week 7 Event Driven Programming (Oct. 19)
Selection Program Examples(Oct. 21)
Lab 5 - Conditional Application Assignment 5 -
Week 8 VBA - Repetition (I) (Oct. 26)
VBA - Repetition (II) (Oct. 28)
Lab 6 - Userform and Conditional Application Assignment 6 -
Week 9 VBA - Nested Loop (Nov. 2)
VBA - Typical Loop Applications (Nov. 4)
Lab 7 - Simple Loop Application Assignment 7 -
- November 8 - 12
Fall Study week
- - -
Week 10 Midterm 2 (Nov. 16)
VBA - Classes and Objects (Nov. 18)
Lab 8 - Nested Loop Application Assignment 8 Midterm 2
Week 11 VBA - Procedure (Nov. 23)
VBA - Array (Nov. 25)
Lab 9 - Loop Application Assignment 9 -
Week 12 VBA - Typical Array Operations (Nov. 30)
Re-visit userforms and miscellaneous topics (Dec. 2)
Lab 10 - Procedures Assignment 10 -
Week 13 Data Collection, Storage and Manipulation (Dec. 7)
Final Review (Dec. 9)
Lab 11 - More Userforms - -

Last updated: August 26, 2021