Midlands Technical College
Information Systems Technology Syllabus
|
NAME OF COURSE: |
Microcomputer Database |
|
COURSE PREFIX: |
CPT 172 |
|
CREDIT: |
3.0 |
|
PREREQUISITES: |
CPT 170 or CPT 101 or CPT 104 |
|
TEXT: |
Benchmark
Series: Microsoft Access 2007, Levels 1 and 2, by: Rutkosky/Seguin/ |
MATERIALS NEEDED:
Instructor's
suggested storage device
COURSE DESCRIPTION:
This course introduces microcomputer database concepts, including generating
reports from database, creating, maintaining, and modifying databases.
LEARNING
OUTCOMES: Upon successful completion of this course, the
student will be able to perform the following tasks:
1. Define and describe database concepts and
terminology.
2. Design, maintain, and modify a database
file structure.
3. Design and modify custom screen formats.
4. Demonstrate knowledge of printing and
other output techniques of database reports.
5. Demonstrate ability to perform basic database
operations.
COURSE COMPETENCIES AND PERFORMANCE MEASURES: As part of the Information System Technology Department’s ongoing learning outcome assessment activities, the following competencies have been developed to support the stated learning outcomes, together with performance measures to assess the students' success in attaining those competencies.
Course Competency: Students will demonstrate ability to create a database, enter data into a database and edit and sort the data.
Measurement Instrument and Success Criteria:
Students will complete a
standardized project involving a database, data entry, sorting the data. The
project will be evaluated on a standard rubric. The success criteria is 80% of
the students will score 3 or higher on the rubric.
GRADING SCALE: A 94-100 B 87-93 C 78-86 F 0-77 All projects must be turned in on or before
the due date for that program or project. Late work will be accepted at the discretion
of the instructor. Make-up tests are given at the discretion of the instructor.
No incomplete grades will be given. Everyone must take the final exam. Any
deviation from this policy must be authorized by the department head. ATTENDANCE
POLICY:
The departmental policy will apply. The number of
absences allowed is equal to twice the number of times the course meets per
week. NOTE: Students must earn a grade of
a "C" or better in all the courses offered within the Information
Systems Department in order for the grade to be counted toward graduation. SPECIAL ACCOMMODATIONS: If you would like to request academic accommodations due to
a disability, please contact a counselor in the Disability Resource Center,
822-3510 and 738-7678. TTY telephone Airport 822-3401, Beltline
738-7800). CAMPUS
EMERGENCY PROTOCOL:
Students
and employees are asked to report safety concerns or suspicious activities
to Campus Security at 7199(on campus), or 738-7199 (cell phone and off
campus). In the event of an emergency, student and employee protocol is to
immediately call Campus Security or local 911. If an emergency occurs,
employees and students may seek additional information and instructions via
MTC Information Centers, email, college Intranet, the MTC website, campus
voice mail and loud speakers. The
College may be closed because of inclement weather. This news should be
available on the website at
www.midlandstech.edu, at the main phone number at
738-1400, and announced on WIS-TV and radio. Please check frequently in
changeable weather for closings and re-openings. If the College closing or
reopening means that you will have at least 30 minutes of a class, you should
come to class. Please do not call the IST Department office or the President’s
office with closure questions.