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