CT 273--3 Credit Hours

3 Contact Hours Per Week

PREREQUISITE: CT 114 or departmental approval

TEXT: Microsoft Access 2003, Complete Concepts and Techniques, Shelly, Cashman, Pratt, Course Technology, ITP, 2004.(old Textbook)

MATERIALS REQUIRED:
SAM (Skills Assessment Manager) CD for Training and Testing (old from 2006)
Jump Drive (256 MB)
Pocket Folder

STUDENTS FOR WHOM THE COURSE IS INTENDED:

This course is designed for students who are seeking an Information Systems, Business Management, Networking, or Office Technology/Administrative Support degree.

PURPOSE:

The purpose of this course is to help students develop a core level in databases using Access.  The student will be ready to practice for MOS (Microsoft Office Specialist) Certification by the end of the second semester of Access.

CATALOG COURSE DESCRIPTION:

This course will teach the necessary concepts and tasks to prepare the student for the MOS (Microsoft Office Specialist) exam. Students will use “Microsoft Approved Courseware”.  Topics include creating and manipulating databases, tables, queries, reports, forms, using a switchboard manager, database maintenance, PivotTables, PivotCharts. Fall semester.

ATTENDANCE POLICY:

Regular class attendance and punctuality are expected. The instructor will call roll at the beginning of class and record those absent.  

*COURSES MEETING TWICE PER WEEK:
	Students are permitted four (4) absences.
	Warning notice sent at four (4) absences.
The instructor will warn a student in danger of becoming excessively absent by sending a warning notice to the Advisement Center so that the student can be contacted by an advisor either by phone or in writing.  If the student is absent more times than allowed by an instructor, the instructor will deduct 5 points from the student’s final grade for each two absences over the permitted number.  The instructor may also drop the student from the class roll with a grade of EW or F by notifying the Office of Admissions in writing.
If a student is unable to adhere to this attendance policy, the student should withdraw from this class and receive a  "W".

When you know you will miss class ahead of time, let the instructor know. Assignments missed must be made up on your own time. The instructor's Web Site for this course will list all materials covered and the assignments given.  It is the student's responsibility to initiate and complete missed assignments.

Academic Honesty Policy:
Cheating Policy
Students are expected to uphold the school’s standard of conduct relating to academic honesty.  Students assume full responsibility for the content and integrity of the academic work they submit.  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:

1.      Represent the work of others as their own.
2.      Use or obtain unauthorized assistance in any academic work.
3.      Give unauthorized assistance to other students.
4.      Modify, without instructor approval, an examination, paper, record,   or report for the purpose of obtaining additional credit.
5.      Misrepresent the content of submitted work.

Administrative Procedure Number: 404.05
Cheating in any form (including using unauthorized materials, information, or study aids in any academic exercise; plagiarism; falsification of records; unauthorized possession of examinations; any and all other actions that may improperly affect the evaluation of a student's academic performance or achievement; and assisting others in any such act) is forbidden. An instructor who has proof that a student is guilty of cheating may take appropriate action up to and including assigning the student a grade of "F" for the course and suspending the student from class. A description of the incident and the action taken will be reported through the dean to the Vice Chancellor for Instruction and placed in the student's file in the Office of Admissions and Records.  The student may appeal either the finding of cheating or the penalty, or both, as described in Administrative Procedure No. 404.06, Academic Appeal Procedure.

Cheating in this class:
Cheating will not be tolerated.  If you are cheating on one occasion, you will receive an “F” for the whole project’s work (not limited to that one assignment.) If found cheating on a second occasion, you will be asked to drop the class.  If the cheating occurs after the drop date, or if you choose not to drop, you will receive an “F” for this class.  All work must be on your disk or in your portfolio unless the instructor directs you to destroy them.

The Micro Labs, Rooms A107 and A110, are open daily from 8:00 a.m. until 4 p.m. and may be used during those hours unless there is a class going on in one of them.

(Old from 2006)
GRADES:

Grades are based on the following criteria:

Attendance

Learn It!

SAM Training

10%

Project Assignments

20%

Expand It!

Cases & Places Assignment

Review It!

SAM Project Task Practice

SAM Project Objective Practice

Test It!

SAM Exam

GRADING SCALE:

90 - 100

80 - 89

70 - 79

60 - 69

Below 60 

• Demonstrate the ability to use computer technology.
• Develop a critical thinking approach in applying theory to application.