ATTENDANCE/PARTICIPATION POLICYAUDITSACADEMIC HONESTY POLICYFall 2011 Academic CalendarCIS 122.01 Fall 2011 1 MICROSOFT ACCESS 2010 Comprehensive CIS 122.01 (Access Course) Wednesday, August 31 to December 14, 2011 in WA 117 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, Tuesdays 7:00 to 9:00 p.m. by Appointment ONLY in WA 226C, Wednesdays 3:00 to 5:00 p.m. in WA 226C, 5:30 to 6:00 p.m. and 9:00 to 9:30 p.m. in WA 117, Fridays 9:00 to 12:00 p.m. in WA 226C, 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 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.CIS 122.01 Fall 2011 2 ASSOCIATE DEGREE OUTCOMES The Jackson Community 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: “JCC'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 four tests, weekly JetNet quizzes, weekly class exercises (chapter-created databases), and weekly homework assignments. Please see schedule at the end of this syllabus 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) 2 Tests (125 points total) 12 Class exercises (10 points each) 12 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 JetNet quizzes (15 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.5 below 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 ofCIS 122.01 Fall 2011 3 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 two tests for this course. They will be multiple choice exams using our JetNet system. The first test is after the completion of Chapter 5. The second test is