| Assignments Given | ||||||
| Class # | Date | Topic | Lab? | Readings | (usually due in 1 week) | |
| 1 | 3-Sep | Weds | Procedures; Basics | |||
| 2 | 5-Sep | Fri | Finish Basics, Digital Economy | RT.1, RT.2 | ||
| 3 | 10-Sep | Weds | Microsoft Access I -- Tables and Forms | LAB | GB.2 | 1: Flat file creation |
| 4 | 12-Sep | Fri | Microsoft Access II -- Queries and Reports | LAB | GB.3 | |
| 5 | 17-Sep | Weds | Memory Storage Calculations | Handout | 2: Queries, Reports, Data Sizing | |
| 6 | 19-Sep | Fri | Data Management; Start Multi-Table Databases | RT.4 | ||
| 7 | 24-Sep | Weds | Database Theory, ER Diagrams, Bubble Diagrams | Handout | 3: Database Design | |
| 8 | 26-Sep | Fri | 1-to-Many Design Exercises | |||
| 9 | 1-Oct | Weds | Multiple Tables in Access I | LAB | GB.5 | 4: Database Design, Access |
| 10 | 3-Oct | Fri | Design Exercises, Multiple Tables in Access II | LAB | GB.4 | |
| 11 | 8-Oct | Weds | More forms, Switchboards, Subtypes | LAB | 5: Database Design, Access | |
| 12 | 10-Oct | Fri | Network Computing I, Data Transmission Times | RT.5, TG.4, TG.5 | ||
| 13 | 15-Oct | Weds | Network Computing II, Review for midterm | |||
| 14 | 17-Oct | Fri | Midterm 1 | |||
| 15 | 22-Oct | Weds | Many-to-many relationships, Multiple Tables in Access III | LAB | GB.6 | |
| 16 | 24-Oct | Fri | Database Design Exercises with Many-to-Many Relationships | |||
| 17 | 29-Oct | Weds | Normal forms and Normalization | 6: Database Design, Normalization | ||
| 18 | 31-Oct | Fri | Database Design Exercises, Multi-Path Relationships | |||
| 19 | 5-Nov | Weds | Query Lab | LAB | 7: Database Design, Queries | |
| 20 | 7-Nov | Fri | Advanced and Chained Query Lab | LAB | ||
| 21 | 12-Nov | Weds | More Query Chaining, Ethics and Security I | LAB | RT.3 | 8: Database Design, Queries |
| 22 | 14-Nov | Fri | Ethics and Security II | |||
| 23 | 19-Nov | Weds | Kinds of Information systems, Decision Support | RT.8, RT.9 | ||
| 24 | 21-Nov | Fri | Midterm 2 | |||
| 25 | 26-Nov | Weds | Database Design Exercises, Unary Relationships | LAB | ||
| -- | 28-Nov | Fri | No class -- Thanksgiving Recess | 9: Database Design, Access | ||
| 26 | 3-Dec | Weds | Acquisition and Development I | RT.10 | ||
| 27 | 5-Dec | Fri | Acquisition and Development II, Teacher Evaluations | |||
| 28 | 10-Dec | Weds | Review for Final | |||
| -- | 15-Dec | Mon | Final Exam, 4-7 PM (exam group F) | |||