Computer Technology Division
Course Syllabus for: COMT 12000

Spring 2006
Instructor: Joe Bolen
Course: Introduction to Computer Systems II – COMT 12000
Spring 2006 / Tuscarawas / Call # 18222 / Section 850 / Room A200
Instructor: Joe Bolen
Work Phone: (330) 343-1753
E-Mail: JBolen@kent.edu
Fax: (413) 556-0739
Web Site: http://personal.tusc.kent.edu/~jbolen
Office Hours: Before class 5:30 – 6:40 PM or by appointment.
Class Time: Mondays / 6:45-8:25 PM
Lab Time: Wednesdays / 6:45-8:25 PM
Course Objectives: Lab-oriented course covering advanced concepts of Computer applications, emphasizing software suites. Materials cover presentation software, databases and spreadsheet applications.
This course covers advanced microcomputer applications including Microsoft Office Word 2003, Microsoft Office Excel 2003, Microsoft Office Access 2003, Microsoft Office PowerPoint 2003, Microsoft Office Outlook 2003, and integration of the applications. Topics include form letters, merging, financial functions, amortization schedules, data tables, creating and querying a worksheet database, templates, creating customized reports and forms in Access, Switchboard Manager, embedded visuals, and modifying visual elements and presentation formats in PowerPoint.
Prerequisite: COMT 11000 or equivalent knowledge.
Texts Required: Microsoft Office 2003: Advanced Concepts and Techniques Shelly Cashman Vermaat (ISBN: 0-619-20025-1)
Textbook Web Site: www.scsite.com/off2003/
Supplemental Materials Required: Two or more 3˝" HD Diskettes and/or CD-RWs which are in a protective case clearly labeled with student's name.
Course Requirements: Students are expected to attend class regularly, be on time, and have all assignment prepared prior to class. You are encouraged to read materials ahead in order to get the most out of class discussion and lab work.
Attendance Policy: Regular class attendance is necessary to gain the full benefit of the course. Students are expected to attend class regularly and be on time for each class. A record will be kept. An excessive number of absences will be reflected in your final grade.
Classroom Policy:
Set cell phones and pagers set to vibrate mode. Calls are to be taken in hallway.
No smoking, food or drink is permitted in the classroom.
For teaching purposes, the computer security environment has been lowered. Therefore, students shall not copy from, paste to, interfere or alter other student’s or staff’s data or computer settings.
Grading Policy:
No assignments will be accepted more than two weeks late. Late assignments are penalized 25%, and assignments two weeks late are penalized 50%. Plan to spend approximately six to eight hours each week working on laboratory assignments.
You are expected to read each assigned project prior to the lecture. Lectures will be short, to the point, and will discuss the highlights of the Project for that week. Most of the class time will be spent working on your Laboratory assignments.
Weekly Laboratory assignments can only be handed in immediately BEFORE lecture begins the following week. Laboratory assignments handed in after lecture begins the following week are considered late.
Make sure your name and exercise numbers appear in the upper-left corner. If an exercise has multiple sheets, then staple them together. Do not staple different assignments together. Disorganized assignments (pages out of order, mislabeled, unreadable, etc.) will receive zero points. If your assignment is multiple sheets, sequence it according to the order of the exercise.
Tests: Tests represent 64% of the final grade.
Lab Assignments: Lab assignments and practice tests represent 36% of the final grade. Although the laboratory assignments comprise only 36% of a grade, a student can receive a final grade no greater than a D if more than three laboratory assignments are not completed. Laboratory assignments receiving less than 50% are incomplete.
Extra Credit: You may complete any Cases and Places exercise at the end of a project to receive up to a maximum of 10 points. Each Cases and Places exercise must come from a different project. Extra credit will not be accepted late.
Grading Scale:
| 90 – 100 | A |
| 80 - 89 | B |
| 70 - 79 | C |
| 60 - 69 | D |
| Below 60 | F |
Test Make-up Policy: Three online examinations will be given. No make-up exams will be allowed without prior arrangements being made. Make-up exams must be taken when scheduled.
To prepare for examinations, attend lecture and read the chapters. At least 90% of the questions are taken directly from the reading material. Review the Chapter Review Questions, Multiple Choice Questions and Important Terms sections at the end of the chapters on which you are being tested.
If you are absent or late, you are responsible for getting the course notes, handouts, and laboratory assignments you missed.
Students with Disabilities: Kent State University recognizes its responsibility for creating an institutional climate in which students with disabilities can succeed. In accordance with University Policy, if you have a documented disability, you may request accommodations to obtain equal access and to promote your learning in this class. Please contact Robert Brindley, Coordinator, Academic Services and Career Planning, in room A104 or at or at (330) 339-3391 ext. 47433. After your eligibility for accommodations has been determined, you will be given a letter which, when presented to an instructor, will help that instructor know how best to assist you.
Tentative Course Calendar:
The following is a tentative schedule for the course. The instructor reserves the right to make schedule changes based on the needs of the students in the class.
|
Week |
Monday/Wednesday |
Reading Assignment |
Lab Assignment |
Test Pts. |
Lab Pts. |
|
1 |
Wednesday, January 18, 2006 |
|
|
|
|
|
2 |
Monday, January 23, 2006 |
1. Word Project 4 |
|
|
|
|
|
Wednesday, January 25, 2006 |
|
1. Do Word Project 4 |
|
25 |
|
3 |
Monday, January 30, 2006 |
Word Project 5 |
|
|
|
|
|
Wednesday, February 01, 2006 |
|
1. Do Word Project 5 |
|
15 |
|
4 |
Monday, February 06, 2006 |
Word Project 6 |
|
|
|
|
|
Wednesday, February 08, 2006 |
|
1. Do Word Project 6 |
|
15 |
|
5 |
Monday, February 13, 2006 |
Word Collaboration |
|
|
|
|
|
Wednesday, February 15, 2006 |
|
1. Do Word Collaboration |
|
15 |
|
6 |
Monday, February 20, 2006 |
1. Excel Project 4 |
|
|
|
|
|
Wednesday, February 22, 2006 |
|
1. Do Excel Project 4 |
WD Exam |
15 |
|
7 |
Monday, February 27, 2006 |
Excel Project 5 |
|
|
|
|
|
Wednesday, March 01, 2006 |
|
1. Do Excel Project 5 |
|
15 |
|
8 |
Monday, March 06, 2006 |
Excel Project 6 |
|
|
|
|
|
Wednesday, March 08, 2006 |
|
1. Do Excel Project 6 |
|
15 |
|
9 |
Monday, March 13, 2006 |
Excel Integration |
|
|
|
|
|
Wednesday, March 15, 2006 |
|
1. Do Excel Integration |
|
15 |
|
10 |
Monday, March 20, 2006 |
1. Access Project 4 |
|
|
|
|
|
Wednesday, March 22, 2006 |
|
Online Practice Test |
EX Exam |
5 |
|
11 |
Monday, March 27, 2006 |
Spring Break |
|
|
|
|
|
Wednesday, March 29, 2006 |
|
|
|
|
|
12 |
Monday, April 03, 2006 |
Access Project 5 |
Do Access Project 4 |
|
10 |
|
|
Wednesday, April 05, 2006 |
|
1. Do Access Project 5 |
|
15 |
|
13 |
Monday, April 10, 2006 |
Access Project 6 |
|
|
|
|
|
Wednesday, April 12, 2006 |
|
1. Do Access Project 6 |
|
15 |
|
14 |
Monday, April 17, 2006 |
1. PowerPoint Project 3 |
|
|
|
|
|
Wednesday, April 19, 2006 |
|
1. Do PPT Project 3 |
AC Exam |
15 |
|
15 |
Monday, April 24, 2006 |
PowerPoint Project 4 |
|
|
|
|
|
Wednesday, April 26, 2006 |
PPT CD Packager |
1. Do PPT Project 4 |
|
15 |
|
16 |
Monday, May 01, 2006 |
Outlook Project 2 |
CD Package Project |
|
5 |
|
|
Wednesday, May 03, 2006 |
|
Online Practice Test |
PPT Exam |
5 |
|
17 |
Monday, May 08, 2006 |
|
1. Do Outlook Project 2 (Opt.) 2. Extra Credit Due |
|
10 |
|
|
Wednesday, May 10, 2006 |
|
|
|
|