Calumet College of St.
Joseph
\SYLLABUS FOR
APPLICATIONS IN DATA PROCESSING: ACCESS
Term: Fall,
2001-2002 (011) (Sept. 4 – Dec. 15)
Course Number: CIS
250x
Instructor: Roger Hartzler
Office
Phone: 219
473-4294
E-mail: computerinstructor@hotmail.com
Home
Phone: 219 987-2502 (when calling and leaving a message
make sure you identify yourself as a CCSJ student)
Office
Hours: Thirty
minutes before class in classroom.
Course
Time: Fridays
6:30 – 9:30p
Course
Description: This course will introduce the student to the
integrated database, Architecture of the relational data base system, storage
structures, data base management systems respective to MS Access, and online
process concepts. During the term focus will be centered on data design,
database creation, database querying, and database maintenance. Also, the
student will gain hands-on experience in developing an applications program in
a MS Access data base environment.
Learning
Outcomes/ Competencies:
Students in this
course will learn the fundamentals of Microsoft Access 2000 by:
q
Creating a database using design and datasheet
views
q
Querying a database using the select query window
q
Maintaining a database using the design and update
features of access
q
Creating reports, forms, and combo boxes
q
Enhance forms with OLE fields, hyperlinks and sub
forms
q
Create an application system using macros, wizards,
and the switchboard manager
q
Create a report using the design view
q
Customize forms using VBA, charts and PivotTable
objects
q
Use Access data in other applications
q
Use Excel worksheet data in an Access database.
Textbook:
Microsoft
Access 2000—Comprehensive Concepts and Techniques
by Shelly, Cashman, and Pratt. Published by Course Technology, ISBN
0-7895-5610-3
Learning
Strategies:
Course learning strategies will include lecturing
and demonstration of Access features using NetMeeting and Blackboard. Students
will be directed to Internet websites for review and reinforcement of class
topics.
Grading
Scale:
The grade for this course is based on a point
system. Each in-class activity, assignment, quiz, test, and student project
will be valued a specific number of points. The course grade will be computed
by dividing the total number of points earned by the total number of points
possible. The grade for the percentage earned will be based on the scale as
follows:
A: 92-100 A-: 90-91 B+: 88-89 B: 82-87 B-:
80-81 C+: 78-79
C: 72-77
C-: 70-71 D+: 68-69
D: 62-67 D-: 60-61
F: 59 & below
Assessment:
Points are earned by:
Four unannounced quizzes @ 20 pts 80
Nine lab assignments @ 100 pts 900
Twelve in class activities @ 10 pts 120
Student application project 250
Midterm 150
Final 150
Total points available 1650
Exams (midterm, final, unannounced quizzes) 23%
of grade
In-class activities, assignments
62% of grade
Student project 15% of grade
Class
Policy for Assignments:
All assignments must be labeled, arranged in the
correct order, and accompanied by a disk. The disk must have files for the
assignments using the names given in the textbook. Assignments without the
corresponding files on a disk submitted with the assignment will NOT receive
credit. Assignments received after the
due date and time will receive a 50% reduction of points earned. No assignments
will be accepted after 7:30 PM on December 14, 2001.
Class
Policy on Attendance:
Students are expected to attend all classes. Students
will find it difficult to keep with class work if they are absent from class. NO MAKEUP OF CLASS ACTIVITIES INCLUDING
QUIZES AND DEMONSTRATION TESTS IS PERMITTED FOR ANY REASON. If students are
absent for the midterm, arrangements must be made to take the midterm BEFORE
returning to the next class.
Class
Policy on Electronic Devices:
All personal electronic devices (cell phones,
beeper, pagers, etc.) must be turned off at all times.
Children
in the Classroom:
Children are not permitted in the classroom at any
time for any reason.
Course
Outline:
|
Week |
Date |
Class Activities |
Assignment |
|
1 |
Sept
7 |
File
management Introduction
to class and Access 2000 |
|
|
2 |
Sept
14 |
Project
1 |
Project
1: Step by Step, In the Lab 1, In the Lab 3 (100 pts.) Due 6:30 PM Sept 28 |
|
3 |
Sept
21 |
Project
2 |
Project
2: Step by Step, In the Lab 1, In the Lab 3 (100 pts.) Due 6:30 PM Oct 5 |
|
4 |
Sept
28 |
Project
3 |
Project
3: Step by Step, in the Lab 1, In the Lab 3 (100 pts.) Due 6:30 PM Oct 12 |
|
5 |
Oct
5 |
Project
4 |
Project
4: Step by Step, in the Lab 1, In the Lab 3 (100 pts.) Due 6:30 PM Oct 19 |
|
6 |
Oct
12 |
Review
for midterm, Discussion of student project using Access 2000 (Due Dec 7) |
|
|
7 |
Oct
19 |
Midterm
exam (200 pts) |
|
|
8 |
Oct
26 |
Project
5 |
Project
5: Step by Step, in the Lab 1, In the Lab 3 (100 pts.) Due 6:30 PM Nov 9 |
|
9 |
Nov
2 |
Project
6 |
Project
6: Step by Step, in the Lab 1, In the Lab 3 (100 pts.) Due 6:30 PM Nov 16 |
|
10 |
Nov
9 |
Project
7 |
Project
7: Step by Step, in the Lab 1, In the Lab 3 (100 pts.) Due 6:30 PM Nov 30 |
|
11 |
Nov
16 |
Project
8 |
Project
8: Step by Step, in the Lab 1, In the Lab 3 (100 pts.) Due 6:30 PM Dec 7 |
|
12 |
Nov
30 |
Project
9 |
Project
9: Step by Step, in the Lab 1, In the Lab 3 (100 pts.) Due 6:30 PM Dec 14 |
|
13 |
Dec
7 |
Integrating
of Access with Excel Presentation
of student projects (250 pts) Review
for final |
|
|
14 |
Dec
14 |
Final
(200 pts) |
No
assignments accepted after 7:30 PM |
Class
Participation:
No part of the course grade is based on class
participation. However, your contribution makes class more interesting for
everyone. Discussion is expected and input from everyone is anticipated.
Center
for Academic Excellence:
Tutoring
assistance is free to all students of Calumet College of St. Joseph. Call the
Center for Academic Excellence (CAE), to make an appointment at 473-4287. The
Center has experienced and well-trained tutors in most subject areas to help
students who are struggling in a course or who are doing well and would like to
do better. Regular weekly tutoring sessions are likely to improve your grade.
Statement
of Plagiarism:
If an instructor or other Calumet College of St.
Joseph personnel find that a student has plagiarized or been involved in
another form of academic dishonesty, the instructor or other personnel may
elect to bring the matter up for judicial review. The maximum penalty for any
form of academic dishonesty is dismissal from the College. The procedures for
judicial review are listed under the section of CCSJ handbook that addresses
student grievances. (Academic Planner 2001/2002 p.27)
Citation
Guidelines:
Calumet College
of St. Joseph adheres to citation guidelines as prescribed by the particular
discipline (i.e., MLA, APA, and Chicago Manual of Style or Turabian.). All of these guidelines are available in the
Calumet College of St. Joseph library or bookstore. These texts outline how to cite references from a variety of
sources, including electronic media.
Withdrawal
from Classes Policy:
After the last
day for class changes has passed (see College calendar), students may withdraw
from a course in which they are registered with permission from the faculty
member conducting the course. A written request detailing the reason(s) for the
withdrawal must be filed with the Registrar. Written request for withdrawal
must be received by the Registrar by the last day of classes prior to the final
examination dates specified in the catalogue. Written requests may be mailed to
the Registrar or faxed to the College fax number 219-473-4259. Students are to
make note of the refund schedule when withdrawing from courses. The request is
forwarded to the faculty member, who makes the final determination to accept or
deny the request. If the request is honored, the student will receive
notification of official withdrawal; if denied, the notification will indicate
why the withdrawal is disallowed. Note: Degree Completion Division (DCD)
students should consult the DCD Student Handbook for information on DCD
withdrawals.
An official
withdrawal is recorded as a "W" grade on the student's transcript.
Dropping a course without written permission automatically incurs an
"F" grade for the course (see Refund Schedule).
Exceptions and Changes:
To accommodate
unusual circumstances, the instructor reserves the right to make reasonable
changes in the syllabus while the course is in progress. Any understandings
between a student and the instructor including, but not limited to, changes,
exceptions, or modifications to course requirements or procedures, must be in
writing and must be signed by both parties.