/ Course / Intermediate PC Office Applications:
Instructor / Kim Mapes
Credits / 3 Credit Hours
Term / Spring 2012
Meetings / 45% of the class will be online and 55% in the classroom.

Intermediate PC Office Applications: MapesSummer 2012 for Weekender Hybrid

Contact Information

Office Phone / 570 2682900
Emergency Contact / In the event of an emergency and you are unable to reach me, contact Joann Daly by emailing
Office Location / Towanda Campus Please use email to set up a face to face meeting.
Email Address /
Office Hours / Office hours are Wednesday from5 to 6noonPlease make an appointment by email.
Syllabus Changes / Instructor's reserve the right to make changes to the syllabus as needed, and you are responsible for keeping up with those changes.
Other Information / The best way to reach me is by email. I check my email every morning between 7 and 7:30. I usually answer within 24 hours. The least efficient way to find me is by phone. Here is my home number 570 506-5721. Please do not call after 9 PM.

Course Description &Information

Pre-requisites, Co-requisites, & other restrictions / Pre-requisites: Prerequisite: IT 105 or instructor consent.
Learning Expectations: To be successful academically in this class students must have be able to logon Keystone’s website
Course Description / Provides a continuation of IT 105 with advanced study of computer software packages used in business-related applications. Focus will be placed on the advanced applications and functions of word processing, spreadsheets, and database management systems. Hands-on course activities will include integration of programs and programs with the World Wide Web.
Required Readings / Microsoft® Office 2010: Advanced, 1st Edition
Gary B. Shelly
Misty E. Vermaat - Purdue University Calumet
ISBN-10: 1439078548 ISBN-13: 9781439078549
1240 Pages
Buying Textbooks / Please note that the Keystone College Bookstore has the most complete and up-to-date information about your course textbooks. Be sure you are purchasing the correct edition and receive all the materials you need.
Recommended Readings / Other application textbooks are on reserve and available at the front desk of the library for use with this course if needed.
Special Software/Hardware / All students enrolled in this class are required to have active Keystone e-mail and Blackboard accounts. Students are expected to have basic computer skills such as word processing, use of e-mail including sending file attachments, and searching the Internet are necessary. Installed software should include a web browser, Microsoft Office, (Microsoft Word/Excel) Windows Media Player, and Adobe Acrobat Reader. Internet Connection to Blackboard is only supported using Internet Explorer 5.0 or higher. Note: JavaScript& Cookies must be enabled.
Browser/Plugin/Viewer Info / For standard Browser/Plugin/Viewer visit this page:
http://web.keystone.edu/library/syllabus/browser.htm
Other Required Materials / Students will be completing a service learning project and this may require other materials.

Course Goals, Objectives/Outcomes

Student Learning Outcome #1: Students will demonstrate an understanding of how to create a research paper, cover letter and resume in MS Word
Supporting Student Activities:
·  Presentation and reading on MS Word
·  Students will complete in-class labs on creating research papers, cover letters and resumes in MS Word
Assessment Instrument:
·  Project on Mid-term exam relating to above activities
Student Learning Outcome #2: Students will apply their knowledge of MS Excel and develop spreadsheets with charts and formulas
Supporting Student Activities:
·  Presentation and reading on MS Excel
·  Students will complete in-class labs on creating spreadsheets with formatting, charts and formulas in MS Excel
Assessment Instrument:
·  Project on Final exam relating to above activities
Student Learning Outcome #3: Students will discover how to create practical and dynamic MS PowerPoint presentations
Supporting Student Activities:
·  Presentation and reading on MS PowerPoint
·  Students will complete in-class labs on creating presentations with formatting and graphics
Assessment Instrument:
·  Project on Final exam relating to above activities
Learning Outcomes / IT200 Pc Intermediate Office Applications
Learning Outcomes / Course Assessment and Evaluation
Assessment Methods that Support Measurement of Course Objectives
Assessment Method / Obj 1 / Obj 2 / Obj 3 / Obj 4
Tests / X / X / X / X
Tutorials / X / X / X / X
Exercises / X / X / X / X
Labs / X / X / X / X
PowerPoint Presentation / X / X / X / X

Grading

Grading (credit) Criteria / Student’s grade will be based on Home Work assignments, attendance, class participation, and the exams. The points will be distributed as follows:
Method: Points Total
Chapter Tutorials see rubrics for points 322pts
Apply Your Knowledge see rubrics for points 209pts
Extend Your Knowledge see rubrics for points 180pts
Make it Right see rubrics for points 200pts
Labs see rubrics for points 241pts
Mid Term 50 Points 50pts
Final Exam 100 Points 100pts
Quiz 2@25Points each 50pts
Class Attendance 50 Points 50pts
Discussion Posts 16@3 points each 36pts
1438pts
Midterm and Final grades are determined using the Keystone Grading Policy.

Letter grade GPA Percentage of total

A 4.0 94-100
A- 3.67 90-93
B+ 3.33 88-89
B 3.0 84-87
B- 2.67 80-83
C+ 2.33 77-79
C 2.0 74-76
C- 1.67 71-73
D+ 1.33 66-70
D 1.0 61-65
F 0.0 0-60
Inability to submit work on time or missing a final exam does not constitute a valid reason for an “incomplete” grade as described in the course catalog. No written work will be accepted late. If you have to be absent please arrange to hand in your work early.
Assignments / Assignments are to be attached directly to the grade book through the view/complete assignments link. A complete list of assignments can be found in the course calendar. Electronic submission will be required on some papers and projects. Learners will be required to type assignments.
Discussion Board Criteria / Instructions for posting to the discussion forum:
1.  You must answer the discussion question each week. You must also respond to one other learner per discussion question. You may respond to more than one learner, as it will greatly add to the discussions.
2.  If you use references, such as your text or a journal article, you must cite references in the body of your discussion and show your reference directly after the discussion text.
3.  Please be very cognizant of spelling, grammar, and punctuation, as you will lose points for errors.
4.  Use APA format for your references.
5.  Do not use attachments when posting.
6.  Only respond to questions that are posted in the discussion forum. If you have a comment regarding anything else in the course, please contact me via email.
7.  Please put your name at the end of all comments.
Guidelines for the Discussion Forum:
Please make your response at least 75 words in length. This is only a guideline however. If you have more to say, you should do so. If you cannot meet 75 words, post what you have as I will evaluate you on what you have written.
Responses to other learners should take into consideration the substance of what they have written. It will add greatly to the discussion if you can interject a question pertaining to the week’s reading in your response. A question may generate more discussion which is beneficial to learning. Be supportive and encouraging to your classmates. Try to offer feedback that is meaningful to the discussion and to your classmate.
Giving and receiving feedback:
1.  Please use the name of the person you are replying to. That way I can follow the discussion more easily.
2.  Plan what you are going to say. Make notes ahead of time so your comments make sense.
3.  Pay attention to the content…direct your comments to the work without any personal comments.
4.  Agree with what you know to be true even if you don’t agree with the principle.
5.  Accept that others have opinions also and are entitled to them.
6.  When reviewing feedback from another, pay attention to what is being said.
7.  Remember, just because someone disagrees with you does not mean that person does not like you. It is hard to dislike someone you have never met before.
8.  Attempt to make a connection with other students. One of them may become your best friend.
Checklist for posting to the discussion:
1.  Does the contribution fit with the dialogue, or have you gone off on a tangent.
2.  Are your ideas logically organized and written clearly?
3.  Are the ideas worthwhile or just filler?
4.  Can the reader (classmates and instructor) easily determine the main point?
5.  Does the contribution add to the discussion?
6.  Can you provide examples for your contributions?
7.  Are you respectful of others’ ideas?
8.  Are spelling, punctuation, and grammar correct?
9.  If you referenced your text or other works, did you provide proper citation and references?
Sometimes students really need you to spell out the requirements of the discussion board. You might find the sample rubric below to be helpful.
A total of 5 points is available for each mandatory discussion question. It's a good idea to log in to the course three separate days per week to keep up with the discussion.

DQ Participation Tips:

·  Participate EARLIER in the WEEK rather than at the last possible moment.
·  Reply to others EARLIER in the WEEK rather than at the last possible moment.
·  Check in and participate in the discussion two separate days per week.
Your participation in the discussion question is assessed using the rubric shown below:
Points / Exceptional
3 points / Average
2 point / Needs Improvement
1 point / Unacceptable
0 points
Content / Content is complete, accurate and offers new ideas.
The discussion is well supported with details that explain the participant’s conclusions.
Content encourages further discussion on topic. / Content is complete and accurate, but lacking in new ideas, or there may be one areas an opinion is presented without supporting facts or references.
Content generally doesn't invite further discussion or investigation. / Ideas were incomplete or had inaccuracies, or there are two or more opinions are presented without supporting facts. / Response was not applicable to the discussion or did not follow Netiquette.
Critical Thinking / Clear evidence of critical thinking (application, analysis, synthesis, and evaluation). Postings are characterized by originality and relevance to the topic. / Some critical thinking evident, but posting may not directly address the issue. / Lacking critical thinking. Postings tend to address peripheral issues. Generally accurate, but with omissions or clear recitation. / Lacking critical thinking. Postings tend to be inaccurate or unclear.
Timeliness / --- / Answer is on or before the due date. / Participant’s answer is late but before the end of the week. / Participant did not participate in the discussion.
Involvement and Responsiveness / --- / Enters class 3 days per week and responds to other students. Communication encourages further responses, raises questions or politely offers alternative perspectives. / Enters class 2 or fewer days per week and/or fails to responds to others. Interaction is best described as "good idea ..." and of little substance to continue discussion. / Does not enter class during the week and/or fails to respond to others.
Make-Up& Late Work / It is important to stay with the class for assignments. Reading and noting of the chapters is strongly suggested prior to attending class.. Students missing deadlines will not be able to make up work unless a note from the Centers office reports your absence as excused.
Extra Credit / There is no specific extra credit offered for this class. There are many class projects and methods of evaluation that allow learners to show their knowledge without extra credit.
Class Preparation & Participation / Deadlines are set for class participation to enable everyone to have an equal voice. You will need to log in to the discussion board and come to class at least 3 times a week.You will need to log in and post a comment by Tuesday at Midnight, Thursday at midnight and Saturday at Midnight each week.Make sure you set aside time and make a schedule that works for you to be in class.Most students log in everyday for 5 to 15 minutes just to see what is going on

Course Policies

Make-Up Exams / Examinations and assignments are to be done in the time frame allotted. Exams can only be made up with an excuse from the Dean’s Office.
Extra Credit / No extra credit is offered in this class
Late Work / No late work is accepted without an excuse from the Dean’s office.
Special Assignments / There are no special assignments
Class Attendance / Deadlines are set for class participation to enable everyone to have an equal voice. You will need to log in to the discussion board at least 3 times a week. You will need to log in and post a comment by Tuesday at Midnight, Thursday at midnight each week.Make sure you set aside time and make a schedule that works for you to be in class.Most students log in everyday for 5 to 15 minutes just to see what is going on
Student Conduct/ Netiquette / We absolutely love the online environment for both teaching and learning. Here in cyberspace we can learn in new and exciting ways that are just not possible in a traditional classroom.
For those of you who are new to online learning we would like to spend a little time discussing our new classroom. The main place where we meet each other is in the Discussion Board. The discussion board is the equivalent of our online classroom. We discuss topics, do group projects, evaluate our learning, and form a community here.
Physical Classroom v. Cyberspace Classroom
We know what to expect when we go into a physical classroom but this is not so in a cyberspace classroom. Generally we take a lot of clues from the people we can see in a physical classroom. First of all you can see the professor and have some idea of what type of instructor he or she might be based on age, accessories, clothes, etc. Also, in the physical classroom you could more easily discern your classmates age, gender and interests. In a physical classroom we can tell when someone is joking or being sarcastic because we can see their body language and read the physical cues that tell us how they feel when they speak. If someone is mad or happy or silly we can know that in a second and we can respond in an appropriate fashion. This is not so in a cyberspace classroom and we must be extra careful to make sure we address everyone with the respect and consideration we ourselves would like to be shown. We need to know that certain rules will be followed and everyone will be safe to express themselves. There are rules of etiquette that people in polite societies follow and we will also discuss netiquette. (Etiquette for the Internet.)