Comp100 Lectures
Fall 2003
Week 01
-
Lecture 01: 08/25/03: Welcome! Administrivia, Introduction to IT systems.
-
Lecture 02: 08/27/03: Downloading and setting up of data disks, exploring
PowerPoint.
-
Lecture 03: 08/29/03: :PowerPoint Tutorial 1.
Week 02
-
09/01/03: Labor Day -- no class
-
09/03/03: Start PowerPoint Tutorial 2.
-
09/05/03: Finish up PowerPoint Tutorial 2.
Week 03
-
09/08/03: Access Tutorial 1.
-
09/10/03: Access Tutorial 1.
-
09/12/03: Access Tutorial 2.
Week 04
-
09/15/03: Access Tutorial 2.
-
09/17/03: Finish Access Tutorial 2; Start Access Tutorial 3.
-
09/19/03: Access Tutorial 3.
Week 05
-
09/22/03: Finish Access Tutorial 3.
-
09/24/03: More on Aggregate Functions;
Lookup Wizard (see pp. AC 5.05-5.09); Start Review for Exam 1
-
09/26/03: Review for Exam 1.
Week 06
Week 07
-
10/06/03: Return Exam #1; Finish Access Tutorial #4 on reports: adding a page
break.
-
10/08/03: Access Tutorial #5: Advanced queries.
-
10/10/03: Access Tutorial #5: Parametrized queries, custom forms.
Week 08
-
10/20//03: Review the three normal forms; Discussion of the final database
project; Jump starting homework #8 on normal forms.
-
10/22/03: Introduction to electronic spreadsheet and MS EXCEL.Design of a
checkbook register: update the balance given a withdrawal, copying formula,
formatting cells as currency.
-
10/24/03: Completion of the checkbook design: adding deposits to the design,
sum function; EXCEL Tutorial #1.
Week 10
- 10/27/03: Collect Database project proposal; EXCEL Tutorial #2
- 10/29/03: Finish EXCEL tutorial #2
- 10/31/03: Review Exam #2.
Week 11
- 11/03/03: exam #2 in Symonds 2 and Ryon 102. Students with last names starting
from A to K will take the exam in Symonds 2. The rest of the class will take
the exam in Ryon 102.
- 11/05/03: EXCEL Tutorial #3
- 11/07/03: EXCEL Tutorial #4
Week 12
Week 13
Week 14
Week 15