Calendar

Spring Term 2 - 2009 for Tuesday-Friday (8:00 a.m., 10:30 a.m., and 1:30 p.m.) classes. Our meeting location is the Sauer Classroom (formerly Classroom F) in Fuqua's East Wing. Assignments and quizzes are due by 11:59 p.m. EST on the dates shown.
PDF version


Date
Topic Assignment
Tue
3/17
Course Overview, Assignment 1 Overview, Databases, Lists, Tables, & Structured Data in Excel, Excel Filtering. Assignment 1 available.
Quiz 1 available.
Fri
3/20
Advanced Filtering, Subtotals, Dfunctions, Building a Dynamic Report with Filtering and Dfunctions, Data Tables.  
Tue
3/24
Techniques for Managing Common Data Problems, Data conversion, Data Validation, Data Exercises, Building an Interactive Form.  
Fri
3/27
The Excel Pivot Table, An Introduction to the Excel Recorded Macro in the context of a Pivot Table. Assignment 2 available.
Quiz 2 available.
Assignment 1 & Quiz 1 due by 11:59 p.m.
Tue
3/31
More Pivot Table techniques, Controlling Charts and Chart Data Sources, Excel-created Sparklines.  
Fri
4/3
Introduction to VBA, Excel User-Defined Functions, a Looping Macro with a UserForm, Creating an Automated System using Excel VBA. Assignment 3 available.
Quiz 3 available.
Assignment 2 & Quiz 2 due by 11:59 p.m.
Tue
4/7
Excel Web Queries, Access Introduction, Relational Database Design Part 1 .  
Fri
4/10
Relational Database Design Part 2, Access Tables, Access-Excel Links . Assignment 4 available.
Quiz 4 available.
Assignment 3 & Quiz 3 due by 11:59 p.m.
Tue
4/14
Access Query Basics.  
Fri
4/17
Advanced Access Query Techniques, Data Modeling.  
Tue
4/21
Action, Union, and Crosstab Queries; Automated Reporting; Switchboard (w/Access Macro); Custom Forms. Assignment 5 available.
Quiz 5 available.
Assignment 4 & Quiz 4 due by 11:59 p.m.
Fri
4/24
User-Friendly Access form (w/Access VBA), Decision-Making Queries, Access Pivot Tables and Charts, Custom Reporting  
Tue
4/27
No class meeting. Assignment 5 & Quiz 5 due by 11:59 p.m.

 


Last updated 2-24-2009