Comp100 Lectures

Spring 2009

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

Week 01

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

Week 02

• Lec 04 - 01/12/09: Finish PowerPoint Lesson 2.
• Lec 05 - 01/14/09: Access Tutorial 1: session 1.1
• Lec 06 - 01/16/09: Access Tutorial 1: session 1.1 (cont)

Week 03

•  No class - 01/19/09: MLK Day
•  Lec 07 - 01/21/09: Access Tutorial 2: session 2.1
•  Lec 08 - 01/23/09: Access Tutorial 2: session 2.2

Week 04

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

Week 05

• Lec 12 - 02/02/09: 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/04/09: More on one-to-many relationships
• Lec 14 - 02/06/09: Review for Exam 1 -

Week 06

• Lec 15 - 02/09/09:  Exam #1 In Symonds 2 and in Sewall 101
• Lec 16 - 02/11/09:  Start Access Tutorial #4: forms, main/subform
• Lec 17 - 02/13/09: Access Tutorial #4 (cont.): reports

Week 07

• Lec 18 - 02/16/09: Access Tutorial #5
• Lec 19 - 02/18/09: Access Tutorial #5 (cont)
• Lec 20 - 02/20/09: Access Tutorial #5: Crosstab queries, conditional formatting of column labels in crosstab query result, find duplicate queries,

Week 08

• Lec 21 - 02/23/09: Discussion of the final database project
  • Click here for the project description in MS Word.
  • Click here for the project description in PDF
  • Click here for the project desciption in HTML (Web page format).
• Lec 22 - 02/25/09: Discussion of normal forms: The first and second normal forms.(click here for a link to the lecture notes in MS Word format, click here for the PDF version).
• Lec 23 - 02/27/09: The third normal for m. Many-to-many relationship.  Collect Database Project Proposals.

Week 09

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

Week 10

• Lec 24 - 03/09/09:  Review for Exam #2 
• Lec 25 - 03/11/09: Exam #2
• Lec 26 - 03/13/09:  Introduction to electronic spreadsheet and MS EXCEL. Design of a checkbook register: update the balance given a withdrawal, copying formula, formatting cells as currency.

Week 11

• Lec 27 - 03/16/09: EXCEL Tutorial #1 -
• Lec 28 - 03/18/09:  EXCEL Tutorial #1 (cont)
• Lec 29 - 03/20/09: Excel Tutorial #2

Week 12

• Lec 30 - 03/23/09:Excel Tutorial #2 (cont)
• Lec 31 - 03/25/09: Excel Tutorial #3
• Lec 32 - 03/27/09: Excel Tutorial #4

Week 13

• Lec 33 - 03/30/09:  EXCEL Tutorial #4 (cont)
• Lec 34 - 04/01/0407: EXCEL Tutorial 4
• No Class - 04/03/09: Spring Recess

Week 14

• Lec 35 - 04/06/09: Excel Tutorial #9
• Lec 36 - 04/08/09: Excel Tutorial #9 (cont)
• Lec 37 - 04/10/09: Excel Tutorial #7 - Section 7.1 and VLOOKUP function of Section 7.2

Week 15

• Lec 38- 04/13/ 06:  Learn how to use Goal Seek and Solver by studying Exam #3 of Spring 2008.
• Lec 39 - 04/15/09: Review for Exam #3
• Lec 40 - 04/17/09: Wrap up - Take home Exam 3 will be posted on the WEB.