ATTENDANCE/PARTICIPATION POLICYAUDITSACADEMIC HONESTY POLICYMICROSOFT ACCESS 2003 ComprehensiveCIS 122.DL (Access Course)Online Course INSTRUCTOR: Chris OldsTELEPHONE: 517-796-8595 FAX: 517-796-8633E-MAIL: Within the Educator system is preferredOFFICE: Whiting 239 (main campus) OFFICE HOURS: By appointment onlyCOURSE DESCRIPTION Planning, creating and displaying databases, sorting and report preparation, data entry screens, data validation and data selection, and multiple file operations. PREREQUISITESKnowledge of Windows and ability to type 30 words per minute minimum.OBJECTIVES To learn the fundamentals of Microsoft Access 2003 To learn practical procedures to create databases suitable for coursework, professional purposes, and personal use To demonstrate the Microsoft Access 2003 level skill set for the Microsoft Office User Specialist ExamTOPICSCreating a database, using forms, modifying a database, viewing information, organizing information, locating information, refining results of a query, analyzing data, creating sub-forms,building a relational database, integrating information with other applications, utilizing Web capabilities, maintaining data integrity, building a form for other users, and producing reports.TEXT BOOK and OTHER REQUIREMENTS- Microsoft Access 2003 Comprehensive Concepts and Techniques by Shelly, Cashman, and Pratt. IBSN: 1-4188-4363-6- SAM 2003 software CD/card (one-time purchase for Office 2003 courses), version 3.0- USB Memory Stick (recommended) or Re-writable CDASSOCIATE DEGREE OUTCOMESThe 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.The highest priority skills include, among others:CIS 122.DL Winter 200611. Learn Access: maintain a database, query a database, and create forms and reports (ADO 2). 2. Create more advanced queries and custom forms, customize reports and integrate with other programs, and use the Web and hyperlink fields (ADO 4).3. Use replication, query wizards, and action queries, automate tasks with Macros, and create custom toolbars and menus, and write Visual Basic code for applications (ADO 7).GRADING PROCEDUREThe work for this course includes four tests, weekly quizzes on terms (in Educator) and concepts (SAM 2003—Skills Assessment Manager--software), class exercises (chapter projects), and homework assignments (In the Lab assignments—please see schedule located in Educator as a separate file). In addition, there is a final course project. Points will be deducted for failure to follow instructions, spelling and procedural errors, incorrect answers, and incomplete work. Your grade will be determined by the following criteria:4 Tests (combination of Terms and SAM for first three tests—200 points)9 Class exercises (10 points each)3 Web and Integration feature class exercises (5 points each)9 Homework Assignments (20 points each)(Homework assignments and class exercises will be accepted up to one week after thedue-date – any work submitted after this grace period will not be accepted.)10 weekly on-line (Educator) terms quizzes (15 points each)12 weekly SAM quizzes (points vary each week)Final project (100 points)Final project idea (5 points)GRADING SCALE (based on accumulated points/percentages): 94 - 100% 4.0 64 - 69% 1.5 88 - 93% 3.5 58 – 63% 1.0 82 - 87% 3.0 52 – 57% 0.5 76 - 81% 2.5 below 52% 0.0 70 - 75% 2.0CLASS EXERCISESThe class exercises for this course are the chapters for each project. 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 diskette. I recommend your hard drive, USB Memory Stick, or a re-writable CD. Each class exercise is worth a maximum of 10 points and is due with your other weekly work. You will work with the same database for each exercise.IN THE LAB HOMEWORK ASSIGNMENTSAt 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. 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. Frequently making a backup is highly recommended.CIS 122.DL Winter 20062TESTSThere are four tests for this course. The first three tests are made up of two parts: part one (Educator) covers terms explained in the chapters, and part two is SAM (Skills Assessment Manager). The first test is after the completion of Project 3, the second test is after the completion of Project 6, and the third test is after Project 9. The last (final) test is only a SAM test that covers all possible tasks from the textbook. The tests are open book. However, they do have a time limit.ATTENDANCE/PARTICIPATION POLICYI treat frequency of work submitted as attendance. Since regular attendance/participation is necessary for successful college work, work should be submitted on a weekly basis. Student work will be evaluated on effort, accuracy, and completeness. If you miss up to one week of work, you may still submit the work for evaluation (as long as the work is submitted within one week of the due date—remember work submitted over one week late will receive no points). Your participation and attendance are expected in each class session. 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’sOffice. 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