Course: Workgroup Productivity Software – COMT 21010
    Fall 2006 / Tuscarawas / Call # 18469 / 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 4:00 – 4:50 PM or by appointment.

Class & Lab Time:    Tuesdays and Thursdays / 7:00 - 8:15 PM

Course Objectives: This is a laboratory and research project-oriented course emphasizing workgroup methodologies for group project management, problem definition, data retrieval and analysis, conclusions and recommendations.

This course covers post-advanced microcomputer applications including Microsoft Office Word 2003, Microsoft Office Excel 2003, Microsoft Office Access 2003, and Microsoft Office PowerPoint 2003. Topics include: creating an online form; working with macros and Visual Basic for Applications (VBA); working with a master document, an index, a table of contents, and XML; linking an Excel worksheet and charting its data in Word; formula auditing, data validation, and complex problem solving in Excel; importing data into Excel; working with XML, PivotCharts, PivotTables, and trendlines in Excel; creating a PivotTable List Web page using Excel; advanced Access report and form techniques, and creating multi-page forms; administering a database system; using SQL with Access; creating a self-running presentation containing shapes; importing templates and clips from the Office Online Web site.

Prerequisite:             COMT 12000 or faculty permission.

Supplemental Materials Required: Two or more 3½" HD Diskettes and/or CD-RWs.

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.

• 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.

• Also, see UNIVERSITY LIFE: DIGEST OF RULES AND REGULATIONS 2005-2006 at http://www.kent.edu/CurrentStudents/upload/0311252RulesandRegs.pdf.

   

Lab Assignments: Lab assignments and quizzes represent 41% of the final grade. Although the laboratory assignments comprise only 41% 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 or any of the exercises at the end of the Web Features for ten points, 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.

90 – 100	A
80 - 89	B
70 - 79	C
60 - 69	D
Below 60	F

Test Make-up Policy: Four 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 Quick Reference Summary at the back of the book for the application on which you are being tested. The Quick Reference Summary for each of the applications is also available at scsite.com/wd2003/qr, scsite.com/ex2003/qr, scsite.com/ac2003/qr, scsite.com/ppt2003/qr, scsite.com/out2003/qr.

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.

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.