Spring 2004

CLASS: Wednesday 7:00pm-9:50pm

ROOM: K125

INSTRUCTOR: Kathy Hurd

Mailbox: Located in the Part-time Faculty Room (M 163)

TEXTS: Microsoft Access 2002 Comprehensive by Adamski,& Finnegan

Download Access Tutorials from www.course.com or from the CIS141 folder

COURSE MATERIALS: The text, four 3½" double-sided high-density diskettes, and 2 two-pocket paper folders for assignment submissions.

COURSE DESCRIPTION: Topics include database design, database creation, database maintenance, screen form creation, report creation, sorting, and queries. No prior knowledge of a database management software is required; however, a working knowledge of Windows is required.

COURSE OBJECTIVES:

1. Design and create database models for business or personal use

2. Add, change, or delete database records

3. Perform mathematical operations and query functions on the database

4. Sort the database by single and multiple fields

5. Create customized input forms and print reports

6. Use Macros for automating tasks

PREREQUISITE: CIS 100, 101 or 106

RULES: Students are expected to be on time and attend every class (unless prior arrangements have been made with the instructor).
IF accepted, late assignments will be penalized 20%. No assignment will be accepted later than one week after due date. No assignment will be accepted after 7:00 PM, Wednesday, June 9, 2004.

Cheating will result in the pursuit of disciplinary action and may include a grade of ‘F’ for this course. More importantly, you will deny yourself an opportunity to learn something. Cheating includes copying labs, reports, projects, tests, exams, and plagiarism as well as helping another student cheat by giving them answers, files, or doing the work for them.

Food/drink is not allowed in the classroom/lab. Running electronic devices is not allowed in the classroom/lab. You are responsible for procuring/submitting all paperwork. In addition to the rules outlined in this syllabus and presented in class, it is the student’s responsibility to understand and abide by all COD academic policies as stated in the current catalog.

GRADING: Homework provides practice working with the concepts in each chapter and is worth 10 points for each Review Assignment, & 10 points for each Case Problem. Total points for homework is 160. Quizzes reinforce particular concepts covered during class and are worth 180 points (3 quizzes worth 60 points a piece). The project provides you the opportunity to demonstrate your ability to apply concepts learned from class and is worth 60 points. Tests and examinations illustrate your knowledge of this material. The Final Examination is worth 100 points. Changes to the grading scale, number of assignments, or relative weight are the instructor’s prerogative.

A = 450 - 500 Points
B = 400 - 449
C = 350 - 399
D = 300 - 349
F = below 300

Incompletes will not be given.

For S/F evaluation, you must obtain the appropriate form and submit it to me for approval. A minimum of 350 points are required to earn a grade of ‘S’. Note: Some institutions transfer a ‘S’ grade as a ‘D’.

If you decide not to complete the course, you must go to Registration and formally withdraw. Failure to do so will result in a grade of ‘F’ for the course.

The following guidelines apply to the completion of your homework and projects:

HOMEWORK & PROJECTS: All of your homework and projects are to be saved to the root folder of your floppy disk. Homework & projects must be submitted in a paper folder with your name on the outside of the folder. A disk is required and must be submitted with a label on the disk with your name on the label. A hard-copy (printed) output is also required with your name, tutorial number, page number, tutorial or review or case, and the step number. Projects or homework submitted without a folder, printed(hardcopy) or label (disk) will not be graded!

Note: Projects and homework must be turned in by the date due. Homework submitted by email must be received prior to the start of class. IF accepted, late projects or homework will be penalized 20%. No homework or project will be accepted later than one week after the due date. No homework or project will be accepted after 7:00 PM, Wednesday, June 9, 2004.
Changes to the homework or projects are the instructor’s prerogative.