|
Tuesdays
|
Thursdays
|
| Aug 26 -
Introduction |
Aug 28 - Excel Functions, Features
Excel Chapter 3
|
|
Sept 2 - Data Management
in Excel
Excel Chap 5: pg 193-237
Excel Ch 6: pg 249-268
Data Management Assignment
|
Sept 4 - VBA
Intro
Excel Chap 7: pg 290-321
VBA Primer: pg 1-27
|
|
Sept 9 - VBA Programming
Data Management Assn Due
|
Sept 11 - No Class
Try these tutorials. You need
speakers or headphones (The computers in the HA 205 lab have front
speaker jacks, but they don't work. Plug in to the sound card
in the back. The volume control is the speaker symbol in the tray
in the lower right-hand part of the screen.) These tutorials require
a Flash plug-in (The computers in our labs have it installed)
If-Then-Else
tutorial
Multiple Choice
tutorial
Do-Loop tutorial
For-Next tutorial
VBA Primer: pg 28-40
|
|
Sept 16 - VBA Events and Errors
VBA Primer: pg 41-62
Programming
Assignment I
|
Sept
18 - Lab Day - Programming Assn I |
Sept
23 - VBA Dialog Boxes
Programming Assn I Due
|
Sept 25 - No Class
|
|
Sept 30 - Advanced
Dialog Boxes
|
Oct 2 - Custom Functions
Programming Assignment
II
|
|
Oct 7 - Lab Day for Prog Assn
II
|
Oct 9 - Excel
Macros
Excel
Assignment
|
|
Oct 14 - Lab Day
for Excel Assignment
|
Oct
16 - PowerPoint
|
|
Oct 21 - Advanced PowerPoint
PowerPoint Assignment
|
Oct 23 - Database
Tables, Forms
Access Chap 1: pg 1-41
Access Chap 2: pg 47-89
|
|
Oct 28 - Database
Queries
Access Chap 3: pg 115-149
PowerPoint Presentations
Programming Assn II Due
|
Oct 30 - Instructor gone
|
|
Nov 4 -
Relational Databases,
Subforms
Access Chap 4: pg 161-184
Access Chap 5: pg 205-224
Excel
Assignment Due
|
Nov 6 - Advanced
Queries
Access Chap 6: pg 259-291
|
Nov
11 - Access
Applications
Access Chap 4: pg 185-195
Access Chap 7: pg 315-355
Access Chap 8: pg 368-38
Final
Project Assn
|
Nov 13 - Access
Applications
Access Chap 4: pg 185-195
Access Chap 7: pg 315-355
Access Chap 8: pg 368-38
Access
Assignment
|
|
Nov 18 - Presentation of Project
Proposals
|
Nov
20 - Lab Day for Access Assn |
|
Nov 25 - Office Integration, Merging
data
Integration
Assignment
Access Assignment Due
|
Nov
27 - Fall Break |
Dec
2 - Applications, Add-ins
Access Assn due back |
Dec
4- Lab day for Integration Assn |
|
Dec 9 - Lab Day for Final Projects
Integration Assignment
Due
|
Dec
11 - Study Day - No Class! |
|
Thursday, Dec 18 - Final Project Presentations -
3:00 pm- Attendance Mandatory!
|
