Comp100 Lectures

Fall 2009

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

Week 01

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

Week 02

• Lec 04 - 08/31/09: Finish PowerPoint Lesson 2.
• Lec 05 - 09/02/09: Access Tutorial 1: session 1.1
• Lec 06 - 09/04/09: Triumph of the Nerds Video - A history of the PC.

Week 03

•  No class - 09/07/09: Labor Day
•  Lec 07 - 09/09/09: Access Tutorial 1: session 1.2
•  Lec 08 - 09/11/09: Access Tutorial 2: session 2.1

Week 04

• Lec 09 - 09/14/09: Access Tutorial 2: session 2.1 (cont)
• Lec 10 - 09/16/09: Access Tutorial 2: Session 2.2
• Lec 11 - 09/18/09: Access Tutorial 2: session 2.2 (cont); Start Access Tutorial 3.

Week 05

• Lec 12 -09/21/09: Access Tutorial 3: session 3.1; start session 3.2
• Lec 13 - 09/23/09: Access Tutorial 3: session 3.2, calculated fields, aggregate functions.
• Lec 14 - 09/25/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

Week 06

• Lec 15 - 09/28/09:  More on one-to-many relationships
• Lec 16 - 09/30/09:  Review for Exam 1
• Lec 17 - 10/02/09:   Exam #1 In Symonds 2 and in some other lab (TBA)

Week 07

• Lec 18 - 10/05/09: Start Access Tutorial #4: forms, main/subform
• Lec 19 - 10/07/09: Access Tutorial #4 (cont.): reports
• Lec 20 - 10/09/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).

Week 08

• 10/12/09: Fall Break - No class
• Lec 21 - 10/14/09: Access Tutorial #5
• Lec 22 - 10/16/09: Access Tutorial #5 (cont)

Week 09

• Lec 23 - 10/19/09: Access Tutorial #5 (cont)
• Lec 24 - 10/21/09:  Access Tutorial #5: Crosstab queries, conditional formatting of column labels in crosstab query result, find duplicate queries,
• Lec 25 - 10/23/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).

Week 10

• Lec 26 - 10/26/09:  The third normal for m. Many-to-many relationship.  Collect Database Project Proposals.
• Lec 27 - 10/28/09: Review for Exam #2: click here for a copy of exam 2 of Spring 2009, the database file and the query output file to be used by the exam.
• Lec 28 - 10/30/09:  Exam #2 (in both Symonds 2 and Sewell 101)

Week 11

• Lec 29 - 11/02/09: EXCEL Tutorial #1
• Lec 30 - 11/04/09:EXCEL Tutorial #1 (cont)
• Lec 31 - 11/06/09: Excel Tutorial #2

Week 12

• Lec 32 - 11/09/09: Excel Tutorial #2 (cont)
• Lec 33 - 11/11/09:  Excel Tutorial #3
• Lec 34 - 11/13/0407: Excel Tutorial #4

Week 13

• Lec 35 - 11/16/09: EXCEL Tutorial #4 (cont)
• Lec 36 - 11/18/09: EXCEL Tutorial 4
• Lec 37 - 11/20/09: Excel Tutorial #9

Week 14

• Lec 38- 11/23/ 06:  Excel Tutorial #9 (cont)
• Lec 39 - 11/25/09: Excel Tutorial #7 - Section 7.1 and VLOOKUP function of Section 7.2
• 11/26/09 - 11/27/09: THANKSGIVING RECESS - NO CLASSES

Week 15

• Lec 40 - 11/30/09: Learn how to use Goal Seek and Solver by studying Exam #3 of Spring 2008.
• Lec 41 -  12/02/09: Review for Exam #3
• Lec 42 - 12/04/09: Wrap up - Take home Exam 3 will be posted on the WEB.