Computer 133, Database Processing: Database processing for microcomputers emphasizes relational database theory as well as design and implementation. Practical applications will include using the Microsoft Access 2007 software, first to recreate examples from the text, then to create and build databases and define table structures. Once you have mastered these topics, you will learn to maintain and query databases, create and use forms and reports, and enhance your database with advanced tools and automated tasks. Lastly, you will build a database application. This course is taught using a combination of lectures, demonstrations, projects, group discussions, and assessments (discussed below).
A. Database Management Concepts
B. Building a database and understanding table relationships
C. Maintaining and updating a database
D. Retrieving information
E. Creating Forms and Reports
F. Advanced retrieval and enhanced table design
G. Customizing Forms
H. Customizing Reports
I. Sharing and Integrating data
J. Advanced Queries and Table Relationships
L. Building an Application
Upon successful completion of this course, the student will be able to:
· Understand and use proper database terminology.
· Understand the structure, process and procedure for building and editing a relational database.
· Create and utilize forms for input to a database.
· Create and utilize queries for extracting information from and modifying data existing in a database.
· Create and utilize reports for generating reports from a database.
· Create an actual, workable database application.
Time and Days
- Class (#20078) meets on Monday & Wednesday from 10:10-11:25 am in Room 719
Proper touch-typing techniques and keyboarding speed of at least 20 correct words per minute (cwpm) are strongly recommended.
Computer 5 or Computer 130 and Computer 140 or equivalent college course.
Required Texts and Materials
1. Microsoft Office Access 2010 - Comprehensive by Adamski and Finnegan.
2. Project Files - Available from the instructor or through the http://cengage.com\coursetechnology Web site.
3. Handouts - Additional handouts may be provided during the course.
Methods of Evaluation
These are subject to change but you may expect approximately the following:
· Chapter Assignments (10): Completion as required and due at the beginning of class. Grading will be based on completeness and accuracy.
· Projects - Final project (1).
2. Exams and Quizzes:
Quizzes: Chapter quizzes (5-7) on common terms (True-False/Multiple Choice). Done on the class day following finishing designated chapters.
Occasional unannounced quizzes will be given to help ensure students stay up with assigned material.
Exams: True/False- Multiple Choice exams (1 or 2), Written exams (1 or 2), Production (hands-on) exams (1 or 2)
Comprehensive Final exam - Production, Written, and T-F/MC.
Probable exam dates will be identified at least one week prior to the exam date. You are expected to be present on all exam days and the final exam will ONLY be given at the appropriate time during Finals Weeks (see the date and time listed on the tentative calendar).
F ( 0-60%)
Note! MAKE-UP EXAMS WILL BE GIVEN ONLY IN RARE SITUATIONS and are subject to a minimum 10% penalty (at least one letter grade). The penalty may be waived if the make-up arrangements are made PRIOR to the exam. It is the student's responsibility to contact me PRIOR to the next class meeting if a quiz or exam is missed and a make-up is requested
(10 @ 5-50 points each)
(7 @ 20 points each)
(1-2 @ 30 points each)
(1-2 @ 50 points each )
(1-2 @ 30 points each)
(1 @ 100 points)
Final Written Exam
(1 @ 30 points)
Final TF/MC Exam
(1 @ 70 points)
Final Performance Exam
(1 @ 30 points)
v I will reserve up to 10 bonus points for being prepared for class question and answer time and class participation. These are not automatic and will be awarded at my discretion.
v Participation and classroom decorum (including good hygiene) are extremely important to your success in this class .. you cannot participate if you are not here .. so attendance will be taken at every class meeting and students will be considered tardy if they arrive after attendance has been taken. Points can be deducted for each missed class for each tardy unless cleared in advance.
v Also, classroom disruption can result in up to 25 point total deduction from your final total points. If you are late and roll has been taken, it is YOUR responsibility to correct the record when leaving that class session to avoid being noted as absent. Being tardy can also affect the distribution of bonus points.
v Please notify the instructor at the beginning of class if you must leave early for any class session.
v If you know you will be unable to make it to class, e-mail me with an explanation.
It is the responsibility of any student desiring to drop the course to turn in the necessary drop forms. The instructor reserves the right to drop students who have missed the equivalent of two consecutive weeks of class (4 consecutive class meetings) or a total of 5 classes. The last day to drop a class without penalty of a grade is March 22, 2013.
This class requires outside computer time. For every one-hour (1) students are in class, the state expects at least two hours (2) of outside class work. This class meets approximately three hours (3) a week, so students may expect up to six hours (6) of class work each week. You will need to display your computer use permit when working on a Business Division computer outside of class. Computers are available in:
Room 712A (computer lab):
Open all day and possibly early evening during the week. You may reserve a computer for a particular day and time up to a week ahead of time. First come, first served if the computer isn't reserved or if the person who signed up doesn't show.
1. There are student tutors located in the computer lab to help you when you are working on a Business Division computer in either a classroom or the computer lab. Check Room 712A for more information.
2. There are personal student tutors available through the Tutorial Center. Check with the Tutorial Center (located in the library) for more information.
Cheating or Plagiarism
Cheating is a violation of the Code of Student Conduct and will not be tolerated. Cheating or plagiarism will result in receiving a zero for the entire exam or assignment and will be dealt with according to the Student Code of Conduct which includes consequences ranging from reprimand to expulsion.
It is your responsibility as a student to maintain an environment that is conducive to learning. You are expected to demonstrate a respect for others and their right to learn. Students should exercise their rights responsibly and in compliance with the established rules in order to maintain an orderly classroom. Students should strive to tolerate diversity in the class and to conduct themselves respectfully and responsibly. You will receive the grade YOU earn .. not the grade you think you should have. It is your responsibility to prepare yourself and take advantage of this learning experience .. I am just here to help you accomplish that.
In Particular . . . . .
§ Bring your notebook, the appropriate textbook, and your storage device (flash drive) to every class meeting.
§ Be prepared for each class with appropriate materials and assignments. (Typed assignments must be in order and stapled. They are due at the beginning of class.) Blackboard inputs are due prior to class on assigned date.
§ Do not print or type while the instructor is lecturing unless instructed to do so. Students using computers for personal use (i.e. games, or Internet) during class will be asked to leave the class.
§ No computer work other than current Computer 133 work-along is allowed while the instructor is talking.
§ Cellular phones and other electronic instruments (i.e., MP3/Ipods) are to be turned off during class sessions.
§ Computer Use Permit is required to use the computers during open lab hours. Permit must be displayed as it will be checked by instructors, computer technicians, or student tutors.
§ Discrimination and/or Sexual Harassment is in violation of school policy and will be dealt with immediately.
§ Students will participate through learning groups, computer activities, projects, oral presentations, and class discussions.
You can send me email at email@example.com or you may see me before or after class to schedule an appointment. (If you wish to use email, please put your first and last name on the subject line.)
Business Division Computer Use Rules
· Food or drinks are not permitted in the classroom
· Have your permit readily available to be shown upon request when your class is not in session.
· Be considerate of other students. No loud talking or other disruptive behavior allowed.
· Business Division computers cannot be used to run your own personal software or to access inappropriate Web sites.
College of the Sequoias will provide reasonable accommodations for students with disabilities, in accordance with the Americans with Disabilities Act of 1990 and Sections 504 and 508 of the Federal Rehabilitation Act of 1973.
The Disability Resource Center (DRC) at COS assists students who have learning disabilities, physical impairments, psychological diagnoses, sensory impairments, and other health conditions. Examples of reasonable accommodations include extended time for tests, note taking assistance, and course materials in alternate formats (audio, Braille, large print, etc.). Use of DRC services is voluntary and strictly confidential. (www.cos.edu/StudentServices/StudentSupportServices/DRC/Pages/DRC%20Home.aspx)
If you have a disability that may affect your coursework, contact the DRC in North Sequoia Building, Room 10 as soon as possible to ensure that reasonable accommodations are arranged in a timely fashion. Please also see me privately early in the semester to discuss your needs, and please bring your Academic Accommodations form provided by the DRC.
This publication can be made available in an alternative format. Please contact the Disability Resource Center (559)730-3805.
At the time of printing, all information may not have been made available to the instructor. Therefore, the instructor reserves the right to revise and/or modify the syllabus.
Do not be afraid to ask for help.