OFFC 2214
DATABASE
FALL SEMESTER 2008

Updated: 10/22/08

 

DATE

CLASSWORK

HOMEWORK DUE

1

8/20

Introduction
Copy student files for Access

Post your introduction in the Introductions discussion forum on the WebCT page.

2

8/27

Tutorial 1

Due 9/3

Work through Tutorial 1. Review Assignment, Case Problems 1, 2, 4 to be turned in.

3

9/3

Tutorial 2

Due 9/10

Work through Tutorial 2. Review Assignment, Case Problems 1, 2, 4 to be turned in. 

4

9/10

Tutorial 3
Quiz Tutorials 1-2

Due 9/17

Work through Tutorial 3. Review Assignment, Case Problems 1, 2, 4 to be turned in.

5

9/17

Tutorial 4

Quiz Tutorial 2-3

Due 9/24

Work through Tutorial 4. Review Assignment, Case Problems 1, 2, 4 to be turned in.   

6

9/24

Production Test
Tutorials1-4

 

7

10/1

Objective Test Tutorials 1-4

 

8

10/8

Tutorial 5

Due 10/15
Work through Tutorial 5. Review Assignment, Case Problems 1, 2, 4 to be turned in. 

 

10/10

Midterm

Last day to withdraw without academic penalty.

9

10/15

Tutorial 6
Quiz Tutorial 4 & 5

Due 10/29
Work through Tutorial 6. Review Assignment, Case Problems 1, 2, 4 to be turned in.

10

10/22

Tutorial 7

 

Due 11/12
Work through Tutorial 7.  Review Assignment, Case Problems 1, 2, 4 to be turned in.

11

10/29

Tutorial 8

No new material will be introduced, but I will be in the classroom from 6:30-8:00 if you need assistance or need to review something.

 

 

12

11/5

 No class - catch up day!

 


 

13

11/12

Tutorial 9

Quiz Tutorials 6 & 7

 

Due 11/19

Work through Tutorial 9.  Review Assignment, Case Problems 1, 2, 4 to be turned in.
 

14

11/19

Tutorial 10

Removing Duplicates Exercise - not in your book

Quiz Tutorial 9 &10

Due 12/3
Work through Tutorial 10 pp. 490-511, p. 520 - know definition of SQL, pp. 533-547.  Submit the Review, Case 1 and Case 2.  Omit #3 in both the review and case 1. 

Work through the Removing Duplicates exercise on the WebCT Vista home page.  Print out the Student Info (no dups) table and turn in.  Removing duplicates will be on the last test.

15

12/3

Production Test over  Tutorials 5-7, 9, and part of 10 that we covered and Removing Duplicates.  Test will be open book.

 

Project due. NOTE: Project must be turned in on either a floppy disk or USB stick.  NO EXTENSIONS ON DUE DATE!

 

12/10, time TBA

Online Objective Test over Tutorials 5-7, 9, and part of 10 that we covered

 

 

Quick Check (Short-answer questions) are included in each tutorial. They do not have to be turned in, but these are excellent ways to review for quizzes and theory tests. Answers are included at the end of each tutorial.

Project will be assigned at mid-term.

Instructor reserves the right to change the schedule as necessary. Changes will be announced in class and published on the Vista WebCT page for this class.