CIS 202 Section 01 Fall 2000
Mr. Richardson
Class Syllabus
Monday and Wednesday, AJT 206, 1:00 – 2:50 p.m.
Instructor:
Rob Richardson
Office:
Room 110B A. J. Theisen Building
Phone:
(810)-989-5613
Email:
Office Hours:
SC4 Room 110B AJT:
Monday – Wednesday 11:00 - 11:50 a.m.
Tuesday 5:20 - 6:10 p.m.
Other Times by Special Arrangement
Text:
Microsoft Access 2000 (Benchmark Series), Meredith Flynn & Nita Rutkosky, EMCParadigm, 2000
Class Website:
Description
This course addresses the management of data bases on personal computers, more specifically, the use of the most commonly-used microcomputer data base management software. Topics covered include data base fundamentals that apply to all data base management software, and the use of the data management programming languages (SQL). Extensive emphasis is placed on the "hands-on" use of the software.
Course Objectives
1. Creating and Maintaining Database Tables
2. Access Query Facility
3. Custom Forms Creation
4. Custom Report Creation
5. OLE Objects
6. Access Macros
7. User Interface Design and Creation
8. Application Design and Creation
9. Access Visual Basic
10. Case Study (Custom Student Application)
11. Create Custom Relational Databases Using Visual Basic
12. Operate Relational Data Bases to Include Report Generation
Equipment:
During the course of this class students will find it necessary to purchase a Zip disk. Students may use the same Zip disk for other CIS classes, and do no have to purchase separate disks for class. Please ensure that all disks are clearly marked with your own name & contact information. It will be each student’s responsibility to bring his/her disks to class. Please be aware that Zip disks, particularly if used or stored improperly, can fail, and that backup disks are always a good idea. Backing up student data will require additional Zip or floppy disks. In the event that disks are lost or damaged, it will be the student’s responsibility to secure suitable replacements.
Students will be required to create and submit a portfolio of their work as one of the major activities of this course. In order to construct the portfolio students will be required to obtain a 3-ring binder and twelve index tabs. The instructor will describe the exact requirements and the desired portfolio contents as the course progresses.
Attendance:
Students are strongly encouraged to attend all classes. It will be each student’s responsibility to obtain copies of lecture notes and to complete all missed assignments without assistance from the instructor. There will be some unannounced in-class assignments and group projects which cannot be "made up". Students not present on those days will receive a zero for the assignment.
Although it is occasionally necessary for a student to miss a test, students are advised to make all efforts to take all tests and examinations on the scheduled date. There will be a total of 5 unit tests. In lieu of makeup unit tests, the lowest unit test score will be dropped. There will be no make up unit tests under any circumstances. Students who know in advance that they will miss multiple unit tests are encouraged to drop and take the class again at a later date.
There will be a comprehensive final examination beginning at 11 a.m. on Wednesday, December 20, 2000. The final exam is mandatory, and it is the student’s responsibility to arrange his/her schedule accordingly. Please note that the final examination is not considered to be a unit test and cannot be dropped as the lowest test score. Makeup final examinations are only available to those able to demonstrate extreme extenuating circumstances. This examination will be composed of both written and production components.
Grading:
Each assignment and examination will be graded according to the following scale:
A 93-100 A- 90-92 B+ 87-89 B 83-86 B- 80-82 C+ 77-79 C 73-76 C- 70-72 D+ 67-69 D 63-66 D - 60-62 F 00-59 Assignments are to be completed within 3 class periods. Late work may be assigned a penalty. Students who find it impossible to complete their work in a timely fashion should consider re-taking the course at a later date. Work not submitted by the final dates indicated on the course schedule will receive a zero.
Final Grades:
Final grades will be computed on the following basis:
Assignment Portfolio 25% Class Project 15% Average of 4 highest unit tests 40% Final Examination 20% In general, there will be an assignment every class period. Assignments will be made during class, and will reflect covered by the day’s reading and lecture. Students who have missed class can find the day’s assignment on the class website by 1 p.m. the following day.
Tests will consist of a combination of true/false, multiple choice, fill in the blank, matching and short essay. Some tests may also include a timed production component.
Please note that there will not be a curve for this class. There will, however, be ample opportunities for extra credit.