IS 201 SyllabusComputer Applications using Microsoft Office 2003 - IS 201 Sections I01/I02/IK1 Class Syllabus - Spring 2008 3 credits Please read completely through this syllabus and print it for future reference. Instructor:Cindy Hyslop e-mail:Use my WebCampus email. Office:High Tech Center - Room 128 – 775-753-2307(voice mail) Text: New Perspectives on Microsoft Office 2003,First Course, Second Edition Ann Shaffer, Patrick Carey, Kathy Finnegan ISBN: 0-619-26808-5 The textbook can be purchased with a credit card at the online Follett bookstore, by calling the Great Basin College Elko campus bookstore at 775/753-2270; or through the book's publisher, Thomson * Course Technology; or through many other online book sellers. Software: For this class you need to have access to four applications in the Microsoft Office 2003 Professional software suite (specifically Word 2003, Excel 2003, Access 2003, and PowerPoint 2003). If you are using MS Office 2007 you have to save as MS 2003 before submitting. This software is available for students to use in GBC campus computer labs; you can also purchase the software at an academic discount through the Follett bookstore on the Elko campus (775/753-2270), or you can purchase through other means such as a retail store or another online store. Student Responsibilities: Be able to access the class website through WebCampus. Contact the Technology Help Desk – 753-3511 if you do not yet have your user name and password. ü Have and maintain Internet access throughout the semester. ü Have and maintain all software used in the class throughout the semester. ü Have and maintain a virus-free computer throughout the semester. ü Have knowledge of Windows and file handling. An important note about online classes: ü Do not assume that online classes are easier than traditional "face-to-face" classes. ü Online classes can actually be more difficult than traditional classes. They require constant motivation and self-direction on the part of the student. ü You are responsible for reading, studying, asking questions, completing assignments, being organized, and staying on schedule. URL’s Data files download: http://www.course.com/catalog/downloads.cfm?isbn=1-4188-6076-X Mous Web Page: http://www.microsoft.com/learning/mcp/officespecialist/requirements.asp Catalog Description: An introduction to the most commonly used microcomputer business software with emphasis on operating systems, word processing, spreadsheets, database management, presentation software, and software integration. Substantial hands-on work provides practical experience using this software. Recommended co-requisite: IS 101 Course Description: Computer Applications teaches the most popular, integrated software used in the business world. Microsoft Office contains the tools most needed in business. There will be extensive hands-on activities. Keyboarding skills are a definite help during the class. The software used will be MS Office 2003. Course Objectives/Outcomes: Upon successful completion of this class, students will be able to... Use a computer as an effective tool. /a,b,c Use Word (word processing software) to create, edit, and format documents, including reports and newsletters /a,b,c Use Excel (spreadsheet software) to develop, modify, and format worksheets and charts for data evaluation /a,b,c Use Access (database software) to design, modify, and query databases; and create database forms and reports /a,b,c Use PowerPoint (presentation software) to create professional presentations with speaker notes and custom graphics /a,b,c Use object linking and embedding (OLE) to integrate the applications in Microsoft Office Professional /a,b,c These goals will be measured using a combination of: a. Turn in completed documents, workbooks, databases and slide shows solving business-oriented problems. b. Take hands-on subject tests. c. Take hands-on quizzes. Methods of Instruction: § Watching online chapter overview presentations § Reading the text § Doing the in-chapter, step-by-step exercises in boxes with light green backgrounds ("Green Exercises" or GEs) as you go through the chapters § Doing specified assignments at the end of each chapter that you will send in each week. § Online bulletin board discussions § Asking questions when things don't make sense. Discussion Information: The Discussion Board is a vital part of this class. Review the Rubric Grading and how Discussions work. Discussions are due by midnight – always on Wednesday. How Discussion Topics Work During the semester you will have eight graded discussion topics Because of the size of the class students might be divided into groups Each discussion is worth a total of 100 points. Respond to ALL parts of the question to earn the maximum number of points. Discussions count for 15% of your total grade. At a minimum, the response has to be at least 200 words. Reponses should be thoughtful, concise, and in your own words. Do not post Discussion as attachments. Correct grammar, capitalization, spelling, and sentence structure are expected. Responses should not be in the format of text messaging, this is a college-level class. Wikipedia and similar encyclopedia Internet related resources are not appropriate online resources. Abusive language and profanity is considered disruptive and unprofessional student conduct that will lead to a reduction of points and even removal from class. Responses are randomly selected and run through plagiarism detection software. Topics will be posted under the Discussion Topic link on the left-hand-side menu in WebCampus and under Learning Modules. View below the Rubric Grading to see how discussions are graded. Once a Bulletin Board topic's due date and time has passed, the topic link will no longer be available Make sure when answering the discussion you respond to the appropriate discussion area. Just saying I agree or disagree is not enough when responding. If you have any questions concerning the discussion questions please contact me through WebCampus email. Use appropriate net etiquette. Flaming is not appropriate and is defined as e-mail responses that are considered hostile and as a personal attack. Flaming occurs when two or more individuals engage in responses that escalate, thus limiting and disrupting the bulletin board discussion by the rest of the class. IS 201 Discussion Grading Form ExceptionalMeets ExpectationsNot Acceptable Response Quantity - Instructor(20 points) Respond to instructor within the first six days of the initial posting and one student on a different day during allotted time (5 points) Respond to instructor only or responded to student only (0 points) No responses submitted Response Complete - Instructor(20 points) Response to instructor is at least 150 words in length (10 points) Response to instructor is less than 150 words. (0 points) Less than 50 words Response Answers Instructor Questions(s)(20 points) Good response that thoroughly answers the instructor’s question(s). (5 points) Response answers very little of the instructor questions. (0 points) No responses submitted Spelling & Grammar(20 points) Response uses correct grammar, capitalization, spelling, and sentence structure (10 points) One or a few noticeable errors (0 points) Several errors Response Complete - Student(20 points) Response to student posting complete (5 points) Response to student posting is limited (0 points) No response submitted out of 100 CLASS EMAIL Checking the Class E-mail (on the left-hand side of the WebCampus window). I will be sending messages during the semester reminding students about due dates. Asking questions when things don't make sense: ask me or other students through WebCampus email or Discussions Board Assignments: Every week students are responsible for... ü Reading/printing and completing each week's assignment: the Weekly Assignments are listed on the class homepage ü Reading the assigned text ü Doing the in-chapter, step-by-step exercises. ü Doing specified assignments at the end of each chapter that you will send in each week through the Assignment Dropbox (there's detailed information about the Assignment Dropbox a few paragraphs below) ü Students are responsible for keeping track of assignments turned in and grades earned. · All Weekly Assignment course work must be completed and sent in to me through the Assignments area by the due date and time specified (Wednesday at midnight). · Once a Weekly Assignment's due date and time has passed, the link will no longer be available. · It's my intention to have your assignments graded by the Friday after the Wednesday they're due. Sometimes you'll get them back earlier than that, sometimes later, but always after the due date. · If it's going to be later than Friday I'll let you know by WebCampus email. · Your graded assignments in the Assignments area you might have brief comments from me in the Comments area. · You should open each graded assignment to see more detailed comments typed in it. The Assignments area link is available through the Course Content menu on the left-hand side of the WebCampus. On the Assignments area page, there will be a link that corresponds to each textbook assignment that you'll need to turn in Click on that assignment link, and then follow the instructions on screen to upload from your computer the corresponding assignment that you've completed. Assignment links in the Assignment area are available until their due dates and times. When instructions in the book direct you to print your work, that is optional, and only for your benefit, because the textbook-based work I get from you will be the computer files you create and send through the Assignments area. No late work is accepted. Anyone not in communication with me for any two-week periodwill have an F grade recorded for the class. I do not give extra credit. If, for some reason, you feel that you cannot complete the course, you must officially withdraw from the class by the course drop deadline This is done by contacting GBC Admissions & Records at 775-753-2102 and completing the Course Withdraw Form. Officially withdrawing results in a "W" on your grade report. The "W" is not used in computing your cumulative GPA; it will appear on your transcript and be permanent. If you do not officially withdraw, your grade will be based on the work you have completed averaged with zeros for work you have not completed. Bulletin Board Discussion ü Bulletin board postings are worth 100 points each. ü (postings should reflect thought & insight)15% Weekly Chapter Assignments ü Each end-of-chapter assignments are worth 100 points. ü Points deducted for errors will vary depending on what work is required for each assignment. 40% Integration Tutorial #2 (Integrating Word, Excel, & Access) ü Each Integration Tutorial is worth 100 points. ü Points deducted for errors will vary depending on what work is required15% Integration Tutorial #3 (Integrating Word, Excel, Access, & PowerPoint) ü Each Integration Tutorial is worth 100 points. ü Points deducted for errors will vary depending on what work is required15% Quizzes: Word (4 quizzes) – Excel – (4 quizzes) Access (1 quiz) 15% Communication: The student will communicate with the instructor through WebCampus e-mail and the Discussion Board. Students are encouraged to communicate with each other through WebCampus Email and the Discussion Board. I check class WebCampus Email, Discussion, and Assignment Drop Box on Monday and Thursday. Assigned assignments will be sent to me through the Assignments area through WebCampus. Grading and Attendance: This class will be for a letter grade. This class is intensive and requires attendance and work to be completed each week. It is good practice to check your WebCampus class at least twice a week. Percentage Letter Grade 94-100 A 90-93 A- 87-89 B+ 83-86 B 80-82 B- 77-79 C+ 73-76 C 70-72 C- 67-69 D+ 63-66 D 60-62 D- <60 F or less or W=Official Withdrawal if done before the withdrawal deadline. There is no curve in this grading scale. To determine your final course grade, all assignment grades will be calculated on a percentage scale and then recorded as the corresponding grade point value and letter grade as shown above. The most significant assignments include: weekly assignments, discussions, weekly quiz, discussions, Integration tutorials. Each student must complete his/her assignments, individually. If two or more students turn in the same assignment or collaborate on a test, punitive measures as described in the Rules and Disciplinary Procedures for Members of the University Community will be enforced. The worst part of an online class is procrastination!!! Anyone not in communication with me for any two-week period (without prior approval) will have an F grade recorded for the class. Grading will use + and - on assignments, tests and the final, recorded grade. Some times, and for very good reasons, a student is not able to finish a class, and needs to withdraw from the class. A grade of W (withdrawn) will be recorded for anyone who formally withdraws by meeting with the instructor and filling out a withdraw form. A grade of F will be recorded for anyone who simply does not participate any more. It is important to realize that for any one withdrawing from the class, the difference between earning an F and a W on the official class recording is the process of meeting with the instructor. After week 12: Anyone not withdrawn from the class will receive a grade based on the entire semester's assignments. ACADEMIC INTEGRITY All assignments are to be completed on an individual basis. That means you each do your own work. Period. If two (or more) students turn in work that has been done by only one person, each student involved earns a zero (0) for the assignment(s). If it happens a second time, each student involved will be dropped from the class. Academic dishonest is defined as an act of deception in which a student claims credit for the work or effort of another person or uses unauthorized materials or fabricated information in any academic work. Academic dishonesty is a violation of the GBC Student Code of Conduct and will not be tolerated in this class. Any evidence of academic dishonesty/plagiarism in this course will result in a failing grade on the assignment and/or a failing grade for the course. Appropriate institutional consequences will also be employed if necessary such as academic probation or suspension. This is a very critical offense. If you are ever uncertain about your use of another person’s work (ideas, language, data, etc.) you must contact me about it. Acts of academic dishonesty include, but are not limited to the following: CHEATING – unauthorized copying or collaborating on a test or assignment, or the use or attempted use of unauthorized materials. TAMPERING – altering or interfering with evaluation instruments and/or documents. FABRICATION – falsifying experimental data or results, inventing research or laboratory data on results for work not done, or falsely claiming sources not used. PLAGIARISM – representing someone else’s words, ideas, artistry, or data as one’s own, including copying another person’s work (including published and unpublished material, and material from the Internet) without appropriate referencing, presenting someone else’s opinions and theories as one’s own, or working jointly on a project, then submitting it as one’s own. (I have a computer program that will search your words on the Internet . . . so do not make the choice to plagiarize). Weekly Schedule Assignment/ Quiz NameDate OpensDates Due Case 1 (Word) Lecture Series (Word) Word Quiz 1 Disc 1 Opens January 19January 30 Gypsy Moth (Word) Tribune Brochure(Word) Word Quiz 2January 30February 6 Masterpiece Tour Report (Word) Noblewood Textile Report(Word) Word Quiz 3 Disc 2 Opens February 6 February 13 Conversion Newsletter (Word) Flannery Newsletter(Word) Word Quiz 4 February 13 February 20 Halleyy2 (Excel) Altac2 (Excel) Excel Quiz 1 Disc 3 Opens February 20 February 27 Chem2 (Excel) Sales2 (Excel) Excel Quiz 2February 27 March 5 Frosti2 (Excel) Packing2 (Excel) Excel Quiz 3 Disc 4 Opens March 5 March 12 Park2 (Excel) Powder2 (Excel) Excel Quiz 4 March 12 March 19 Video database (Access Tutorial 1) Disc 5 Opens March 19 April 2 Video database (Access Tutorial 2) April 2 April 9 Video database (Access Tutorial 3) Disc 6 Opens April 9 April 16 Video database (Access Tutorial 4) Access Quiz over all chapters April 16 April 23 (Integration Tutorial Two) Disc 7 Opens Disc 8 Opens – Class Comments April 23 April 30 Backpackers (PowerPoint) LASIK (PowerPoint) Public Library (PowerPoint) No quiz over PowerPoint April 30 May 7 Integration Tutorial Three May 7 May 14