Comp100 Lectures

Spring 2008

The lecture schedule below may be subject to changes.  Be sure to review it weekly.

Week 01

• Lec 01 - 01/07/08: Welcome! Administrivia, Introduction to IT systems.
• Lec 02 - 01/9/08: Downloading data files.   Discuss OWLSPACE. Start PowerPoint Lesson 1
• Lec 03 - 01/11/08: Finish PowerPoint Lesson 1.  Start Lesson 2.

Week 02

• Lec 04 - 01/14/08: Finish PowerPoint Lesson 2.
• Lec 05 - 01/16/08: Access Tutorial 1.
• Lec 06 - 01/19/08: Access Tutorial 1.

Week 03

•  No class - 01/21/08: MLK Day
•  Lec 07 - 01/24/08: Access Tutorial 2.
•  Lec 08 - 01/26/08: Access Tutorial 2.

Week 04

• Lec 09 - 01/28/08: Finish Access Tutorial 2; Start Access Tutorial 3.
• Lec 10 - 01/30/08: Access Tutorial 3.
• Lec 11 - 02/01/08: Finish Access Tutorial 3: calculated fields, aggregate functions.

Week 05

• Lec 12 - 02/04/08: Discuss KEY point: defining relationships between tables; one-to-many relationship and many-to-many relationship. Click here for an example of Many-to-many Relationship
• Lec 13 - 02/06/08: More on one-to-many relationships
• Lec 14 - 02/08/08: Review for Exam 1 -
  • click here for the Spring 2003 exam 1
  • click here for the Fall 2006 exam 1.
  • click here for the Fall 2007 exam 1

Week 06

• Lec 15 - 02/11/08:  Exam #1 In Symonds 2 and in Sewall 101
• Lec 17 - 02/13/08:  Start Tutorial #4.   Go to the Resources page of OWLSPACE and download the MyNorthEast database.
  • sec 4.1: single form using form wizard
  • sec 4.2: main/subform using form wizard
• Lec 16 - 02/15/08: Access Tutorial #4 (cont.)
  • modify form auto-format
  • sec 4.3: modify form in design view; creating reports using report wizard.

Week 07

• Lec 17 - 02/18/08: Access Tutorial #5: Advanced queries
  • section 5.1
• Lec 18 - 02/20/08: Access Tutorial #5: Parametrized queries, custom forms. 
  • section 5.2
• Lec 19 - 02/22/08: Access Tutorial #5: Crosstab queries
  • section 5.3

Week 08

• Lec 20 - 02/25/08: Discussion of normal forms (click here for a link to the lecture notes in MS Word format).
• Lec 21 - 02/27/08: More on normal forms
• Lec 22 - 02/29/08: Discussion of the final database project
  • Click here for the project description in MS Word.
  • Click here for the project description in HTML

Week 09

• 03/02/08- 03/09/08: Spring Break: no classes

Week 10

• Lec 23 - 03/10/08:   More discussion of normal forms (click here for a link to the lecture notes in MS Word format). 
• Lec 24 - 03/12/08: Finish 3rd normal form. 
  • Collect Database project proposal. 
  • Introduction to electronic spreadsheet and MS EXCEL. Design of a checkbook register: update the balance given a withdrawal, copying formula, formatting cells as currency.
• Lec 25 - 03/14/08:  Excel tutorial #1

Week 11

• Lec 26 - 03/17/08: EXCEL Tutorial #2 -
• Lec 27 - 03/19/08:  EXCEL Tutorial #2 - section 2.2 on Financial functions.
• Lec 28 - 03/21/08: A detailed look of financial functions (download example here); Amortization Table (right-click here to download the financial functions spreadsheet); Future Value;

Week 12

• Lec 29 - 03/24/08: Finish amortization table.
• Lec 30 - 03/26/08: Review for Exam #2 - click here for exam 2 of Fall 2006
• Lec 31 - 03/28/08: Exam #2.

Week 13

• Lec 32 - 03/31/08:  EXCEL Tutorial 3
• Lec 33 - 04/02/0407: EXCEL Tutorial 4
• No Class - 04/04/08: Spring Recess

Week 14

• Lec 34 - 04/07/08: Binary Search and Goal Seek (Excel Tutorial 10.1); Start Using Solve (Excel Tutorial 10.2)
• Lec 35 - 04/09/08: Finish Working on Solve; In class exercise on using solve.
• Lec 36 - 04/11/08: In-class exercise on using Solve; Lookup Tables

Week 15

• Lec 37 - 04/14/ 06:  Web Access to Database (see Access Tutorial #8)
• Lec 38 - 04/16/08: Practice on Dynamic Web Pages.
• Lec 39 - 04/18/08: Review for Exam 3

Week 16

• Lec 40 - 04/21 /08: More Review.  Exam #3 (Take-home) posted in the evening.
• Lec 41 - 04/23/08: Exam #3 (Take-home) due in class.