Comp100 Lectures

Fall 2007

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

Lec 01 - 08/27/07: Welcome! Administrivia, Introduction to IT systems.
Lec 02 - 08/29/07: Downloading and setting up of data disks, exploring PowerPoint. Start PowerPoint Lesson 1
Lec 03 - 08/31/07: Finish PowerPoint Lesson 1. Start Lesson 2.

Lec 12 - 09/24/07: Finish Access Tutorial 3: calculated fields, aggregate functions.
Lec 13 - 09/26/07: In class exercise: Case 3 of Tutorial 1. This Case problem is to be used in Access 2 homework. Submit this in-class exercise to OWLSPACE.
Lec 14 - 09/28/07: IMPORTANT: identifying and defining relationships between tables - one-to-many relationship, many-to-many relationship; click here for an example of a database with many-to-many relationship between tables.; how to define composite (or combination) keys, that is a key consisting one two or more fields in a table.

Lec 15: 10/01/07: Review for Exam 1 - click here for exam 1 of Spring 2007 that can be used as a review. Click here for the solutions to the database questions.
10/03/07: Exam #1 in class (Symonds 2) and in Sewall 101. If you plan to use your own laptop, then come to Symonds2.
Lec 16 - 10/05/07: Start Tutorial #4. Click here to download the solution database for Tutorial #3.

Lec 17 - 10/08/07: Access Tutorial #4: forms, main/subform;
Lec 18 - 10/10/07: Finish Access Tutorial #4 on reports: adding a page break. Access Tutorial #5: Advanced queries.
Lec 19 - 10/12/07: Access Tutorial #5: Parameterized queries, custom forms.

10/15/07: Fall break (No Class)
Lec 20 - 10/17/07: Discussion of normal forms (click here for a link to the lecture notes in MS Word format).
Lec 21 - 10/19/07: The second normal form; The third normal form..

Lec 22 - 10/22: 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 23 - 10/24/07: Completion of the checkbook design: adding deposits to the design, sum function; EXCEL Tutorial #1.
Lec 24 - 10/26/07: Start EXCEL Tutorial #2

Lec 25 - 10/29/07: Discussion of the final database project
- Click here for the project description in MS Word.
- Click here for the project description in HTML
EXCEL Tutorial #2: section 2.2 Financial Functions - (right-click here to download the financial functions spreadsheet) - PMT function
Lec 26 - 10/31/07: More Discussion of financial functions - Total Payments, total interest, using IF fuction., PV function: right-click here to download the spreadsheet done in class.
Lec 27 - 11/02/07: Amortization Table (right-click here to download the financial functions spreadsheet); Future Value Collect Database project proposal;

11/05/07: Review Exam #2.
Lec 28 - 11/07/07: exam #2 (take home) ; EXCEL Tutorial #3
Lec 29 - 11/09/07: Finish the discussion of the financial spreadsheet (check OWLSPACE resource for the finance2.xls spreadsheet.) Start EXCEL Tutorial #3

Lec 30 - 11/12/07: Complete Excel Tutorial #3 in class; Start Excel Tutorial #4: working with graphs and charts
Lec 31 - 11/14/07: Complete Excel Tutorial #4 in class;
Lec 32 - 11/16/07: Finish Working on Solve; In class exercise on using solve.

Lec 33 - 11/19/07: Binary Search and Goal Seek (Excel Tutorial 10.1); Start Using Solve (Excel Tutorial 10.2)
Lec 34 - 11/21/07: Finish Working on Solve; In class exercise on using solve.
11/23/07: Thanksgiving Holidays; no class.