|
Syllabus for CIS 251 Applications
in Databases |
Instructor
Kurt Jordan
Office: 514
Office Phone: 219 473-4290
E-mail: kjordan@ccsj.edu
Office Hours:
Monday 9:00 am -
1:30 pm
Tuesday 5:00 pm -
7:00 pm
Wednesday 8:00 am -
9:00 am, 12 noon - 1:30 pm
Friday 9:00 am -
1:30 pm, 5:00 pm - 5:30 pm
Course Time: 7:00pm - 10:00pm Tuesday
Course Description:
This
course will introduce students to relational database management theory and
database design concepts. Students will use Microsoft Access for database
creation, database record entry and update, database querying, and database
maintenance. Students will gain hands-on experience with database application
development.
Prerequisites: CIS 115 Computer Literacy
Learning
Outcomes/ Competencies:
After
completion of this course, students will be able to:
q
Design database tables
q
Create and maintain a database
q
Query a database
q
Maintain the data in a database
q
Create forms and Reports
q
Automate tasks using macros
q
Use and write Visual Basic applications code
Required
Textbook:
New
Perspectives Microsoft Office Access 2003, Course Technology, ISBN
0-619-20672-1
Learning
Strategies: Learning strategies for the class include lecture, demonstration
by instructor, collaborative learning, reading and following tutorials in
textbooks, and discussion of database applications in a business environment.
Assessment:
Exams (Midterm, Final, Quizzes) 60%
of grade
Assignments 40%
of grade
Cellular phones and pagers should be put on silent notification. Other
devices, such as CD players, radios, and similar personal electronic devices should
be turned off during class.
For written or printed assignments, make sure your name, and exercise
numbers are hand printed in black or blue ink upper-right corner. If an
exercise has multiple sheets, then staple them together. Do not staple
different assignments together. If there are multiple sheets are to be handed
in, then sequence them according to the order you were told to print them in
the exercise. “Do Tutorial Project 1” means “do the entire project on a PC.” Some
assignments require an electronic copy of your database. You must be prepared
to turn in an electronic copy when the assignment is due. Late assignments will be marked 50% off.
Cheating Policy
The guiding principle of academic integrity shall be that a student's
submitted work, examinations, reports, and projects must be that of the
student's own work. Students shall be guilty of violating the honor code if
they:
q Represent the work of others as their own.
q Use or obtain unauthorized assistance in any academic work.
q Give unauthorized assistance to other students.
q Modify, without instructor approval, an examination, paper, record, or
report for the purpose of obtaining additional credit.
q Misrepresent the content of submitted work.
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.
For this class, it is permissible to assist classmates in general
discussions of computing techniques. General advice and interaction are
encouraged. Each person, however, must develop his or her own solutions to the
assigned projects, assignments, and tasks. In other words, students may not
"work together" on graded assignments. Such collaboration constitutes
cheating. A student may not use or copy (by any means) another's work (or
portions of it) and represent it as his/her own
Grading Scale:
|
Grade |
Points |
|
A |
100-92 |
|
A- |
91-90 |
|
B+ |
89-88 |
|
B |
87-82 |
|
B- |
81-80 |
|
C+ |
79-78 |
|
C |
77-72 |
|
C- |
71-70 |
|
D+ |
69-68 |
|
D |
67-62 |
|
D- |
61-60 |
|
F |
59 and below |
Class Policy on
Attendance:
You are expected to attend every class. You are responsible for any
material you miss. Make-up exams will be
given only if prior arrangements are made with the instructor. The instructor
reserves the right to change these policies in extreme circumstances.
Course Outline:
Week 1: Introduction to
course Database design issues
Week 2: Tutorial 1
Week 3: Tutorial 2
Week 4: Tutorial 3
Week 5: Tutorial 4
Week 6: Tutorial 5
Week 7: Tutorial 6
Review
for test
Week 8: Test on database
design issues, Tutorials 1-6
Week 9: Tutorial 7
Week 10: Tutorial
8
Week 11: Tutorial 9
Week 12: Tutorial 10
Week 13: Tutorial 11
Week 14: Tutorial 12
Review for Final
exam
Week 15: Final exam on Tutorials
7-12
Note: The instructor reserves the right to modify the class schedule due
to unforeseen events.
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.
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. The Registrar must receive written
request for withdrawal 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. 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).