Midlands Technical College
Information Systems Technology Syllabus
| NAME OF COURSE: | Advanced Microcomputer Database |
| COURSE PREFIX: | CPT 272 |
|
CREDIT: PREREQUISITES: TEXT:
|
3.0
CPT 172
Text to be selected SOFTWARE: Access 2007 must be installed. This book assumes a complete installation. |
COURSE DESCRIPTION: This course emphasizes accessing databases using advanced concepts in microcomputer database application software. Techniques include SQL, application generators and database programming to generate various applications.
STUDENT COMPETENCIES: Upon successful completion of this course, the student will be able to utilize the advanced features of a microcomputer database.
Achievement of these competencies will be measured by a combination of projects and performance on tests.
Evaluation Methods: Weight:
Three tests 25% each
Course project 25%
Semester Project: *** DUE NO LATER THAN THE LAST CLASS MEETING OF THE SEMESTER.
The student’s final grade will be determined by the total points earned divided by the total possible points; i.e., 376 points earned out of 400 = 376/400 = 94% = A, 348 points earned out of 400 = 348/400 = 87% = B, etc.
*** Note: The instructor will NOT drop the lowest test or project score when computing the final grade for the course.
GRADING SCALE:
| A | 94 – 100 |
| B | 87 – 93 |
| C | 78 – 86 |
| F | 0 - 77 |
Per departmental policy, a grade of D cannot be awarded for this course.
PROJECTS AND ASSIGNMENTS: Tutorials and exercises are assigned to provide practice in learned skills and in applying those skills to various situations. They will not be graded. However, they must be completed and turned in by the indicated date. A penalty may be assessed for late assignments:
Lesson Exercises: 1 point penalty for each class session late.
Unit Applications: 1 point penalty for each class session late.
(Points will be subtracted from total semester points earned.)
All projects must be turned in on or before the due date for that program or project. No projects will be accepted after the due dates.
No incomplete grades will be given. Everyone must take the final exam.
Any deviation from this policy must be authorized by the Department Head.
OTHER: No incomplete grades will be given. Everyone must take the final exam. Any deviation from this policy must be authorized by the Department Chairman. College policies as outlined in the Student Handbook will be followed regarding classroom demeanor. Courtesy and consideration of others will be expected.
ATTENDANCE POLICY: It is essential that you attend class in order to receive a passing grade. If you must miss class then please let the instructor know in advance, if possible. If you miss more than 4 classes for a class that meets 2 times a week, or 6 classes for a class that meets 3 times a week, then the instructor may withdraw you from the class.
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.