| Day | Topic | Assignment |
| Class 1 August 25, 2009 |
Introduction to Class Assignment of lab sections Excel Introduction |
Read Chapter 1 and review slides Complete Worksheet in preparation for the homework quiz |
| Class 2 September 1, 2009 Lab Section DS 471 |
Delimited (Text) file used for Exercise Excel File generated in class Excel topics covered: Delimited files, formatting, formulae (average, min, max, sum, if/else, large,small) |
Read Chapter 2 and review slides Complete Worksheet (except 4c) Answers to Quizzes |
| Class 3 September 8, 2009 Lab Section DS 471 |
Delimited File used same as for Class 2 above Excel File Generated |
Prepare for the Excel Practical. A demo practical will be posted the evening of September 9, 2009 Click here for the Demo Practical and Solution. |
| Class 4 September 15, 2009 Lab Section DW 471 |
Excel Practical | |
| Class 5 September 22, 2009 CK 330 |
Lecture: Chapter 2 and Chapter 7 | Read the rest of Chapter 2 and Field Guide B (pp. 41-54 and 327-346) Complete the worksheet for these sections. Answers to Ch 1 and Ch 2 End of Chapter Questions Database Lecture Slides Field Guide Slides SQL Worksheet |
| Class 6 Lab Section |
Microsoft Access | Demo Database |