MICROSOFT ACCESS 2010 Comprehensive
CIS 122.01 at North Campus
August 26 to December 9, 2013
INSTRUCTOR:Chris Olds
TELEPHONE:517-796-8595 FAX: 517-796-8603
E-MAIL:Within the JetNet system is preferred
OFFICE: Atkinson 226C (main campus)
OFFICE HOURS:Mondays online in JetNet 9:00 am to Noon, Monday 5:00 to 6:00 pm at North Campus, Wednesdays 2:00 to 5:00 pm in WA 226C, Fridays online in JetNet 9:00 to 12:00 pm, and other hours online or in person by appointment only.
Course Description
Planning, creating and displaying databases, sorting and report preparation, data entry screens, data validation and data selection, and multiple file operations.
PREREQUISITES
Knowledge of Windows and ability to type 30 words per minute minimum, ENG 085, and ENG 090.
OBJECTIVES
To learn the fundamentals of Microsoft Access 2010
To learn practical procedures to create databases suitable for coursework, professional purposes, and personal use
To demonstrate the Microsoft Access 2010 level skill set for the Microsoft Office (MOS) Specialist Exam
TOPICS
The Microsoft Access topics include (and not be limited to) An Introduction to Databases and Database Objects; Querying a Database; Maintaining a Database; Creating Reports and Forms; Multiple Forms; Advanced Report Techniques; Using SQL; Advanced Forms Techniques; Macros, Navigation Forms, PivotTables, and PivotCharts; and Administering a Database System.
TEXT BOOK and OTHER RECOMMENDATIONS
- Microsoft Access 2010 Comprehensive, 1st Edition by Shelly, Pratt, and Last.
ISBN: 9781439079027 - Recommended: USB Memory Stick or re-writable CD
- SAM 2010 code (one-time purchase of JC’s MS Office “comprehensive” courses)
PREREQUISITE POLICY
A 2.0 or “C” is a passing grade. Only courses with passing grades count toward graduation. Other colleges transfer in only courses with passing grades. Many financial aid sources, including most employers, require passing grades. Additionally, earning less than a 2.0 in a class results in not being able to participate in the next level of courses in a discipline which requires this course as a prerequisite. If you attempt to register for the next course sequence and have not pass the prerequisite course, you will be dropped from that course.
ASSOCIATE DEGREE OUTCOMES
The Jackson College Board of Trustees has developed a list of essential skills which all of its associate degree graduates will enhance during their college experience. The Board has said:
“JC's goal is to prepare students to live productive and meaningful lives. Implicit in this goal are efforts to prepare students to: (a) live and work in the twenty-first century, (b) be employed in situations which will require retraining several times during a productive life, and (c) function in a rapidly changing informational society.”
ADO7—Proficient: Problem solving by demonstrating creativity. Students will synthesize key elements from the course into a cohesive project. (This is the final course project where 70% of the students will be expected to score 70% or higher.)
GRADING PROCEDURE
The work for this course includes three tests, weekly SAM quizzes, weekly class exercises (chapter-created databases), and weekly homework assignments. Please see schedule in JetNet for work which is expected to be submitted on a weekly basis. In addition, there is a final course project. Remember, this is not a self-paced course; there are specific due dates.
Points will be deducted for failure to follow instructions, spelling and punctuation errors, incorrect answers, and incomplete work. You should double-check your work before submitting as you will not be allowed to resubmit your class exercises and In the Lab assignments for a higher grade. Your grade will be determined by the following criteria:
Introduction e-mail to instructor (5 points)
Beginning Course Quiz (15 points)
3 Tests (200 points total)
11 Class exercises (10 points each)
10 Homework Assignments (20 points each)
(Homework assignments and class exercises will be accepted up to one week after the due-date – any work submitted after this grace period will not be accepted. If you take advantage of the one week grace period for late work, I expect that you will get caught up and submit future work on time. The grace period should not be taken advantage of on a regular basis.)
10 weekly SAM quizzes (20 points each)
Final Project (100 points)
Final Project idea (5 points)
GRADING SCALE (based on accumulated points/percentages):
94 – 100%4.0 64 – 69.5%1.5
88 – 93.5%3.5 58 – 63.5% 1.0
82 – 87.5%3.0 52 – 57.5%0.5
76 – 81.5%2.5below 52%0.0
70 – 75.5%2.0
CLASS EXERCISES
The class exercises for this course are the databases you create by working through each chapter. You should read the detailed information provided by the authors before attempting the rest of the assignment. The authors assume that the files you need are copied onto a USB drive. I recommend your hard drive,USB Memory Stick,your student folder in JetNet, or a re-writable CD. Each class exercise is worth a maximum of 10 points and is due with your other weekly work. You should double-check your work before submitting it as you will not be allowed to resubmit for a higher grade. Compare your work with the illustrations in the book. Class exercises are graded on effort, accuracy, and completeness.You will work with the same database for each exercise.
IN THE LAB HOMEWORK ASSIGNMENTS
At the end of each chapter, you will be assigned an “In the Lab” homework assignment. See the schedule at the end of this syllabus. You should double-check your work before submitting it and compare your work with the illustrations in the textbook. Your work will be graded on effort, accuracy, and completeness. You will not be allowed to resubmit your work for a higher grade. Since you will be using the same database for this entire semester, you will need to make any corrections I indicate as this could affect future assignments. You should also occasionally back-up your database to an alternative area/medium.
TESTS
There are three tests for this course. They will be SAM exams based on the weekly SAM Quizzes. The first test is after the completion of Chapter 5. The second test is after the completion of Chapter 10, and the third will cover all chapters. The tests are open book. However, they do have a time limit.
ATTENDANCE/PARTICIPATION POLICY
I treat frequency of work submitted as attendance. Your success will depend greatly on the time spent completing assignments and projects as well as practicing on the computer. Attendance will be taken during each class and reported periodically to the Registrar’s Office. Definitions include: “H”—the student is not doing acceptable work and needs “help” to be successful, “Q”—the student has not participated/attended and the instructor believes they have unofficially withdrawn, and “V”—the instructor “verifies” that the student is participating/attending and doing acceptable work. It is ultimately the responsibility of the student to withdraw from the course.You will be able to verify your attendance reporting via e-services at our JC homepage. You should also contact your instructor when considering a withdrawal.
WITHDRAWAL
Check your registration form for the withdrawal date. Students who stop attending class without completing a withdrawal form and who have not received a “Q” in the attendance reporting period, will receive a grade of 0.0. It is the student’s responsibility to withdraw from a course. You should initiate a withdrawal at the main campus Registrar’s Office or at any JC center if you cannot complete the course. You should also contact me when considering a withdrawal.
INCOMPLETES
No incomplete grades will be given in this class except under extenuating circumstances and if the student has completed at least 75% of the work and has at least 2.0 in the course. The grade of “I” is not awarded to students who did not attend, or seldom attended, or to those who simply are not pleased with their final grades. Students receiving an “I” submit only the remaining work that had not been completed at the end of the semester. Students do not redo work that had already been graded.
EXTRA HELP
Tutors (plus additionalservices for academic success) can be accessed by calling 517-796-8415 or by stopping by the Center for Student Success, Bert Walker Hall Room 123.
Students requiring special assistance (including those affected by the Americans with Disabilities Act) should contact the Center for Student Success. This is the first step in acquiring the appropriate accommodations to facilitate your learning.
STUDENT RESPONSIBILITIES
The student is responsible to complete the material covered each week and submit when it’s due. The student is also responsible to initiate a withdrawal from the course if the work cannot be completed and the student does not qualify for an incomplete. Finally, the student is responsible to notify his/her instructor if he/sheis going to miss any work.
AUDITS
Students who do not wish to receive a grade from the course may opt for an “audit,” which means they will not receive a grade. They may turn in their work and take tests for evaluation. Students who sign up to “audit” and now wish to receive a grade must contact the Registrar’s Office at main campus or personnel at the extension centers by the drop/add date listed in Academic Calendar within this syllabus.
ACADEMIC HONESTY POLICY
Academic honesty is expected of all students. No part of this course contains collaborative work! It is the ethical behavior that includes producing their own work and not representing others’ work as their own, either by plagiarism, by cheating, or by helping others to do so. While JC encourages students to collaborate in study groups, work teams, and with lab partners, each student should take responsibility for accurately representing his/her own contribution.
Plagiarism is the failure to give credit for the use of material from outside sources. Cheating means obtaining answers/material from an outside source without authorization.
Faculty members who suspect a student of academic dishonesty may penalize the student by taking appropriate action up to and including lowering the final grade by .5 and assigning a failing grade for the paper, project, report, exam, or the course itself. Instructors will document instances of academic dishonesty in writing to the Dean of Faculty.
In the event of a student dispute, both student(s) and faculty should follow the Conflict Resolution Policy. This policy is presented in Student Rights and Responsibilities (student handbook) and the faculty Master Agreement.
PROJECT SUCCESS DAY
Classes will not be held at JC on Project Success Day. Instead, the college is offering a wide variety of workshops and other events to help insure your success in your courses. Project Success Day is only held in the fall.
Fall 2013 Academic Calendar
Holiday, No Classes / August 31 - September 2
Project Success, No Classes / September 24
Holiday, No Classes / November 27 - December 1 / Thanksgiving Break Offices Closed
Last day of classes / December 15
1
CIS 122Fall 2013