(Revised 7/22/09)

CASPER COLLEGE COURSE SYLLABUS

COSC1200, Section 01, Computer Information Systems

Semester/Year: Spring 2011 Lecture Hours: 2 Lab Hours: 2 Credit Hours: 3 Class Time: 11:00 – 11:50 Days: MTTHF Room: BU307 Instructor’s Name: Karla Volpi Instructor's Contact Info: Office: BU 107 Email: kvolpi@caspercollege.edu

Office Phone: 307 268-3018

Office Hours: MW 2:00 – 4:30 TTh 10:00 – 10:50 or by Appointment Class Policies: Assignments may be turned via Moodle, or turned in via hardcopy first thing in Monday’s class. Do NOT try to email them, as the college email system often blocks emails from Yahoo and Hot Mail accounts, especially if they have attachments. The best way to contact me is via an email on Moodle, I check it several times a day, even on weekends. You can also use my office phone; I check messages at least once a day Monday through Friday. I will get back with you. Above all, if you have a question or need clarification, ASK, that is the reason I’m here. Course Description: An introduction to computers and information processing. Computer concepts covered include: the merger of computer and communication technologies, hardware, software, ethics, and security. Students develop basic software skills in: word processing, spreadsheets, databases, presentations, Web designing, and integrating software. Keyboarding skills equivalent to 20 wpm is needed to succeed. Statement of Prerequisites: None Goal: The goal of this course is to provide a broad overview computers and information processing, and to teach basic skills in the Microsoft Office Suite of products. Outcomes: Specific knowledge objectives include:

• The ability to use MS Word to create and edit documents, letters, envelopes and tables • The ability to use MS Excel to create and edit worksheets, and graphs, as well as how to use

formulas. • The ability to use MS Power-Point to create and edit effective presentations and handouts. • The ability to use MS Access to edit and create tables, meaningful relationships, forms, reports

and queries. • To understand the concepts of using technology both in business and in everyday life.

Methodology: Class content consists of the following areas:

1. This class has two portions, a lecture portion and a lab portion. You will be expected to complete the lab assignments within the text of each of the Microsoft Office Chapters ( 2 each for Word, Power Point, Excel, Access and one Integration). Each assignment is worth 10 points ( 90 points possible)

2. Two major projects will be assigned during the semester, the first, a Research Paper, should be done in the MLA format covered in Chapter 2 of the Word section of the text book. This project will be due shortly before midterm. The second, a database, will be an individual project and will be due the week before the final exam. Each project is worth 100 points. (200 points possible)

3. There will be at least one assignment for each chapter of the textbook. Each assignment is worth 10 points. (170 points possible)

4. Each chapter will have a 10 question quiz worth 10 points (140 points possible) 5. A midterm exam will be given during the semester and will cover specified chapters and

modules discussed. The exam is worth 100 points. 6. The final exam (given according to the college schedule for final exam week) is cumulative.

Approximately 2/3 of the exam will come from the most recent chapters and modules with the remaining 1/3 from chapters covered in the midterm exams. The final exam will follow the same format as the midterm exam and will also be worth 200 points.

Evaluation Criteria: Grades will be assignment on a total percentage basis. All points for the class will be added and a percentage figured against total possible points. In Class assignments 90 points possible Home work assignments 170 points possible Quizzes @ 10 points each 140 points possible 2 Feedback Forum @ 5 points each 10 points possible 2 projects @ 100 points each 200 points possible 1 midterm exam @ 100 points 100 points possible 1 final exam @ 200 points 200 points possible Total points 910 points possible Grades by Percent A 100-90% B 89-80% C 79-70% D 69-60%

Required Text, Readings, and Materials: : Discovering Computers & Microsoft Office 2007 : A Fundamental Combined Approach by Shelly and Vermaat (2011 Edition), ISBN: 978-0-538-47392-7 Last Date to Change to Audit Status or to Withdraw with a W Grade: Last day to withdraw – March 25, 2011. Student Rights and Responsibilities: Please refer to the Casper College Student Conduct and Judicial

Code for information concerning your rights and responsibilities as a Casper College Student. Chain of Command: If you have any problems with this class, you should first contact the instructor to attempt to solve the problem. If you are not satisfied with the solution offered by the instructor, you should then take the matter through the appropriate chain of command starting with the Department Head/Program Director, the Academic Dean, and lastly the Vice President for Academic Affairs. Academic Dishonesty - Cheating & Plagiarism: Casper College demands intellectual honesty. Proven plagiarism or any form of dishonesty associated with the academic process can result in the offender failing the course in which the offense was committed or expulsion from school. See the Casper College Student Code of Conduct. ADA Accommodations Policy: It is the policy of Casper College to provide appropriate accommodations to any student with a documented disability. If you have a need for accommodation in this course, please make an appointment to see me at your earliest convenience. Calendar or schedule indicating course content:

17 January - 23 January

Week 1 - Chapter 1 - Introduction to Computers

• Reading Assignments

• Read Chapter 1 Assignment •

Power Point Presentations • Power Point for Discovering Computers Chapter 1 file • Karla's Power Point for Chapter 1 file •

Assignments

• Short Answers Assignment • Log and register for the textbook website Assignment •

Quizzes

• Discovering Computers Chapter 1 Quiz •

Emerging Technology Research Paper

• Emerging Technology Research Presentation file

Q56nmMzJT2

Q56nmMzJT2

24 January - 30 January

Week 2 - PowerPoint Chapter 1

• Reading Assignments

• Read Power Point Chapter 1 Assignment •

Power Point Presentations

• Power Point Presentation for Power Point Chapter 1 file •

In Class Assignments

• Power Point File From Chapter 1 Assignment •

Assignments

• Extend Your Knowledge Assignment • Extend 1-1 Nutrition file • Creating a Presentation Assignment •

Quizzes

• Power Point Chapter 1 Quiz

Q56nmMzJT2

Q56nmMzJT2

31 January - 6 February

Week 3 - Power Point Chapter 2

• Reading Assignments

• Read Power Point Chapter 2 Assignment •

Power Point Presentations

• Power Point Presentation for Power Point Chapter 2 file •

Class Files • Power Point Chapter 2 Assignment • Files for PowerPoint Class zip archive •

Assignments

• Creating a Presentation Assignment •

Quizzes

• Power Point Chapter 2 Quiz •

Emerging Technology Research Paper

• Select Your Topic Assignment

Q56nmMzJT2

Q56nmMzJT2

7 February - 13 February

Week 4 - Discovering Computers - Chapter 2

• Reading Assignments

• Read Discovering Computers Chapter 2 and the Special Feature Assignment

• Power Point Presentations

• Power Point for Discovering Computers Chapter 2 file •

Assignments

• Web Research 1 and 2 Assignment •

Quizzes

• Discovering Computers Chapter 2 Quiz

Q56nmMzJT2

Q56nmMzJT2

14 February - 20 February

Week 5 - Word Chapter 1

• Reading Assignments

• Read Word Chapter 1 Assignment •

Power Point Presentations

• Power Point Presentation for Word Chapter 1 file •

Class Files

• Word Document from Class Assignment •

Assignments

• Modifying Text and Graphics Assignment • Extend 1-1 Baseball Sign Ups Flyer file • Advertise Yourself Assignment •

Quizzes

• Word Chapter 1 Quiz

Q56nmMzJT2

Q56nmMzJT2

21 February - 27 February

Week 6 - Word Chapter 2

• Reading Assignment

• Read Word Chapter 2 Assignment •

Power Point Presentations

• Power Point Presentation for Word Chapter 2 file •

Class Files

• Word Document from Class Assignment •

Assignments

• Preparing a Research Report Assignment

• Quizzes

• Word Chapter 2 Quiz

Q56nmMzJT2

Q56nmMzJT2

28 February - 6 March

Week 7 - Discovering Computers Chapter 3

• Reading Assignments

• Read Discovering Computers Chapter 3 and the Special Feature Assignment

• Power Point Presentations

• Power Point for Discovering Computers Chapter 3 file •

Assignments

• Short Answers Assignment •

Quizzes

• Discovering Computers Chapter 3 Quiz •

Power Point Research Project

• Emerging Technology Research Assignment

Q56nmMzJT2

Q56nmMzJT2

7 March - 13 March

Week 8 - Midterm and Excel Chapter 1

• Mid-term Exam - Please note: This exam is due by 11:55pm on Wednesday, March 9th.

• Midterm Test Quiz •

Reading Assignments

• Read Excel Chapter 1 Assignment •

Power Point Presentations

• Power Point Presentation for Excel Chapter 1 file •

Class Files

• Excel Workbook from Class Assignment •

Assignments

• College Costs Assignment •

Quizzes

• Excel Chapter 1 Quiz

Q56nmMzJT2

Q56nmMzJT2

14 March - 20 March

Week 9 - Spring Break!

Q56nmMzJT2

Q56nmMzJT2

21 March - 27 March

Week 10 - Excel Chapter 2

• Database Project

• Database Project file •

Reading Assignment

• Read Excel Chapter 2 Assignment •

Power Point Presentations

• Power Point Presentation for Excel Chapter 2 file •

Class Files

• Excel Workbook from Class Assignment •

Assignments

• Sales Analysis Worksheet Assignment

• Quizzes

• Excel Chapter 2 Quiz

Q56nmMzJT2

Q56nmMzJT2

28 March - 3 April

Week 11 - Database Introduction

• Reading Assignment

• Read the first 12 pages of Access Chapter 1 Assignment •

Power Point Presentations

• Introduction to Access Power Point Presentation file •

Database Project

• Database description Assignment •

Please note: While the assignment for this week is just the introduction, we may start working through the rest of Access Chapter 1.

Q56nmMzJT2

Q56nmMzJT2

4 April - 10 April

Week 12 - Access Chapter 1

• Reading Assignments • Read Access Chapter 1 Assignment •

Power Point Presentations

• Power Point Presentation for Access Chapter 1 file •

Class Files

• Access Database from Class Assignment •

Assignments

• Hockey Fan Zone Database Assignment •

Quizzes

• Access Chapter 1 quiz •

Database Project

• E-R Diagram Assignment •

Please note: This week's assignment is from Access Chapter 1, but we may start working through Access Chapter 2

Q56nmMzJT2

Q56nmMzJT2

11 April - 17 April

Week 14 - Access Chapter 2

• Reading Assignments

• Read Access Chapter 2 Assignment •

Power Point Presentations

• Power Point Presentation for Access Chapter 2 file •

Class Files

• Access Database from Class Assignment •

Assignments

• Hockey Fan Zone Database Assignment •

Quizzes

• Access Chapter 2 quiz

Q56nmMzJT2

Q56nmMzJT2

18 April - 24 April

Week 14 - Integrating Office Programs and the World Wide Web

• Reading Assignment • Read Integrating Office 2007 Programs & the World Wide Web

Assignment •

Power Point Presentations

• Power Point for Intergating Office 2007 & the World Wide Web file •

Class Files • Makin-It Real Estate Website Assignment • Makin-It Real Estate Database file • Makin-It Real Estate Power Point file • Makin-It Real Estate Spreadsheet file • Makin-It Real Estate Word Document file • Upload your Radikal Ranch Website Assignment •

Assignment

• Radikal Ranch Project file • Radikal Ranch Project Files zip archive •

Quizzes

• Quiz for Integration Chapter

Q56nmMzJT2

Q56nmMzJT2

25 April - 1 May

Week 15 - Discovering Computers Chapter 4

• Reading Assignment

• Read Discovering Computers Chapter 4 and the Special Feature Assignment

• Powerpoint Presentations

• Power Point Presentation for Discovering Computers Chapter 4 file •

Assignments

• Short answer and Web Research Assignment •

Quizzes

• Discovering Computers Chapter 4 Quiz

Q56nmMzJT2

Q56nmMzJT2

2 May - 8 May

Week 16 - Discovering Computers Chapter 5 and Database Project due

• Reading Assignment

• Read Discovering Computers Chapter 5 and the Special Feature Assignment

• Power Point Presentations

• Power Point Presentation for Discovering Computers Chapter 5 file •

Assignments

• Short answer and Web Research Assignment •

Quizzes

• Discovering Computers Chapter 5 Quiz •

Database Project - PLEASE NOTE THIS IS DUE AT 12:55 ON Sunday, MAY 8, 2011

• Database Project Assignment

Q56nmMzJT2

Q56nmMzJT2

9 May - 15 May

Week 17 - Finals Week - Congratulations You Made It!

• Forums - Please note these open up on May 1st and close on May 10th. Only responses between May 1 and May 10th will be eligible for credit.

• Class Advantage Forum • What would you change? Forum •

Final Exam - Please note: This can be taken at any time, but MUST be done by 11:55 on Wednesday May 11th.

• Final Exam Quiz