|
Syllabus for CIS 251 X Applications in Databases Fall Term of 2004
|
Term: Fall, 2004 (041) (August
30 December 11)
Course Number: CIS 251 Applications in Databases
Instructor
Roger Hartzler
Office: Computer lab for 20 minutes before class
Office Phone: If you need to leave me a message at the
college, call 219 473-7770 and ask the receptionist to place a message in my
mailbox. Please note that I am only on campus on Tuesday evening and Wednesday
afternoon.
E-mail: rogerhartzler@comcast.net
When using this e-mail account make sure you identify yourself as a student in
the subject line.
Home Phone: 219 987-2502 Make sure you identify yourself as a CCSJ student.
Course Time: 7 104 PM 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:
Students
in this course will gain insight into the fundamentals of:
q
Creating and maintaining a database
q
Querying a database
q
Creating forms and Reports
q
Automating tasks with macros
q
Using and writing Visual Basic applications code
Required
Textbook:
New
Perspectives Microsoft Office Access 2003,Published by Course Technology. ISBN
0-619-20672-1
Learning
Strategies: Learning strageti8es 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) 40%
of grade
Assignments 60%
of grade
Under no circumstances are children allowed in the classroom
Cellular phones, pagers, CD players, radios, and similar personal
electronic devices are prohibited in the classroom
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. Disorganized
assignments (pages out of order, mislabeled, unreadable, etc.) will receive a
grade of zero. 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
Word Project 1 in the Laboratory Assignment column means do the entire
project on a PC. All assignments not submitted using BlackBoard must be
accompanied with the disk of the assignment. No assignments will be accepted
without an accompanying disk.
Examination Policy
Preparing for Examinations: Listen during the lecture read the chapters.
At least 90% of the questions are taken directly from the reading material.
In Case You Are Late or Absent: It is your responsibility to get the
course notes, handouts, and laboratory assignments should you miss class or be
late. A summary of class activities will be posted on BlackBoard
Exam times. All exams are at the end of the class period. Exams will be
graded the same class period. All tests will be given on the dates and times
specified in the course progression part of the syllabus. If you miss a test
date for any reason, you may make-up the test during the last class session
after any other class business is completed.
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:
Student attendance is encouraged. While no credit is given for
attendance, students will find excessive absences make it difficult to keep up
with class assignments
Course Outline:
|
Class
Session |
Dates: |
Topics |
|
1 |
Aug 31 |
Intro to class, using BlackBoard, establishing accounts |
|
2 |
Sept 7 |
Tutorial 1 Intro to Miscrsoft
Access 20-3 |
|
3 |
Sept 14 |
Tutorial 2 Creating and
Maintaining a Database |
|
4 |
Sept 21 |
Tutorial 3 Querying a Database |
|
5 |
Sept 28 |
Tutorial 4 Creating Forms and
Reports |
|
6 |
Oct 5 |
Tutorial 5 Enhancing a Tables
Design and creating Advanced Queries |
|
7 |
Oct 12 |
Midterm |
|
8 |
Oct 19 |
Tutorial 6 Creating Custom
Forms |
|
9 |
Oct 26 |
Tutorial 7 Creating Custom
Reports |
|
10 |
Nov 2 |
Tutorial 8 Integrating Access
with Web and Other Programs |
|
11 |
Nov 9 |
Tutorial 9 Using Action Queries
and Defining Table Relationships |
|
12 |
Nov 16 |
Tutorial 10 Automating Tasks
with Macros |
|
13 |
Nov 23 |
Tutorial 11 Using and Writing Visual Basic for Applications Code |
|
14 |
Nov 30 |
Application Test |
|
15 |
Dec 7 |
Final |
Class
Participation:
No credit is
given for class participation. Your questions and relevant real-word
experiences are welcome. Lively class discussion makes the class more
interesting for everyone.
Course Grades:
This class will
use the grade book feature on BlackBoard. Check your course progress on a
regular basis. If you have questions, see the instructor at the end of the next
class. It is difficult to answer questions about grade computation several
weeks after the assignment has been graded.
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.
Please note:
Calumet College of St. Joseph subscribes to Turnitin.com and all papers can and
may be submitted for checks on plagiarism from the Internet/Electronic
sources/Databases.
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. 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).
School Closing Information:
Internet: http://www.ccsj.edu, http://www.EmergencyClosings.com
Telephone:
Calumet College of St. Joseph : 219.473.4770
Radio: WAKE 1500 AM, WGN - 720 AM, WIJE 105.5 FM, WLS 890 AM,
WZVN 107.1 FM, WBBM NEWS RADIO 78
TV Channels: 2, 5, 7, 9, 32
DISCLAIMER:
To accommodate
unusual circumstances, the instructor reserves the right to make reasonable
changes in the syllabus while the course is in progress. Any questions of
interpretation of course requirements or of misunderstandings between a student
and the instructor will be at the discretion of the instructor