|
Wk
|
Topic
|
Date
|
Assignments
|
|
1
|
Introduction
|
Jan 15
|
Read: 1-Keyboard, 2-Formating, 3-Teaser VBA
|
|
2
|
Formulas and Functions
|
Jan 20
|
Read: 4-Formulas, 5-Functions
|
|
|
|
Jan 22
|
Due HW1
|
|
3
|
|
Jan 27
|
--storm interruption--
|
|
|
Data Entry
|
Jan 29
|
Read: 6-Data Entry
|
|
4
|
Excel Tables
|
Feb 03
|
Read: 7-Excel Table
Due HW2
|
|
|
|
Feb 05
|
Read: 8-Pivot Table
|
|
5
|
What-if Analysis
|
Feb 10
|
Read: 9-Data Table
Due Hw3
|
|
|
|
Feb 12
|
Read: 11 - Car Loan Analysis
|
|
6
|
Introduction to VBA
|
Feb 17
|
Read: 12, 13-Intro to VBA
Due Hw4
|
|
|
|
Feb 19
|
Read: 14 - Msgbox, Inputbox
|
|
7
|
|
Feb 24
|
Due Hw5
|
|
|
No Class: Prep for Proj 1
|
Feb 26
|
|
|
8
|
Team Proj 1 Presentations
|
Mar 03
|
Due Team Proj 1 Documents
|
|
|
Mid-Term Exam
|
Mar 05
|
|
|
9
|
Working with Ranges
|
Mar 10
|
Read: 15 每 Ranges (1)
|
|
|
|
Mar 12
|
Read: 16 - Ranges (2)
Due Hw6
|
|
10
|
Spring break
|
Mar 17
|
|
|
|
Spring break
|
Mar 19
|
|
|
11
|
Business Logic
|
Mar 24
|
Read: 17 - Control Logic (1)
|
|
|
|
Mar 26
|
Read: 18 - Control Logic (2)
Due Hw7
|
|
12
|
VBA Best Practices
|
Mar 31
|
Read: 19 - Best Practices
|
|
|
Worksheets and Workbooks
|
Apr 02
|
Read: 20 每 Worksheets and Workbooks
Due Hw8
|
|
13
|
User Interfaces
|
Apr 07
|
Read: 21 - User forms
|
|
|
Using Access
|
Apr 09
|
Read: 22- data input forms
|
|
14
|
|
Apr 14
|
Read: 22- data input forms
Due Hw9
|
|
|
|
Apr 16
|
Read: 23 每 Solver
|
|
15
|
|
Apr 21
|
Read: 24 每 Fine-tune the Application
Due Hw10
|
|
|
|
Apr 23
|
Read: 25 每 Record and Use Macros
|
|
16
|
No class: Prep for Proj 2
|
Apr 28
|
Due Hw11
|
|
17
|
Team Proj 2 Presentations
|
Apr 30
|
Due Team Proj 2 Documents
|
|
|
Final Exam(Comprehensive)
|
May 7
|
B&E 201 3:30-6:00pm
|