CIS 110: Computer Concepts

MWF Fall 2009

Reading and Homework Assignments

Your name, due date, class hour should be in the top left corner of every printed page.

Monday
August 31		 Overview of course syllabus
*Class always meets in room 340 on Mondays
Wednesday
September 2		 Login to MCC's network
Windows: Exploring the Basics of Microsoft Windows Vista in Microsoft Office 2007 text

Meet in Computer Classroom (room L363).
Friday
September 4		 Lecture over Module 1 (pages 3-52) in room 340
Bring answers to study questions for bonus points.
Monday
September 7		 No Class - Labor Day
Wednesday
September 9		 Using the Internet Meet in Computer Classroom (room L363)
Friday
September 11		 Quiz over Course Syllabus and Module 1 in room 340.
Homework Due Today: Answers to the Module 1 study questions
Monday
September 14		 Lecture over Module 2 (pages 53-85) in room 340
Bring answers to study questions for bonus points.
Wednesday
September 16		 Bring your USB drive to room L363!
  • Print screen demo
  • Downloading files from the Internet
  • Copying and unzipping self-extracting files like Vista.exe (65KB).
Friday
September 18		 Quiz over Module 2 in room 340.
Homework Due Today: Answers to the Module 2 study questions.
Monday
September 21		 Lecture over Module 3 (pages 95-133) in room 340
Bring answers to study questions for bonus points.
Wednesday
September 23		 Bring your USB drive to class. In the computer classroom we will go over Outlook Web Access and Outlook Calendar and Task Manager handouts and assignments.

Using Outlook Web Access. Due 10/9:
  1. Send email from Outlook Web Access handout to Dr. T. at Tim.Trainor@muskegoncc.edu with the following:
    • Subject line with your name.
    • Message that includes your name, class day and time, your current point totals and a short explanation about your expectations for class.
    • Attachment with screen capture of your class point totals from the electronic grade book.
    • Your personal Outlook signature.
  2. Print screen capture of distribution list.
Using Outlook Calendar and Task Manager. Due 10/9
  1. Printed screen of appointment dialog box before removing it on page 6.
  2. Printed screen of appointment dialog box with invited attendees email addresses and message from page 8.
  3. Printed screen of task dialog box from page 10.
Friday
September 25		 Bring your USB drive to room L363.
Hands on Activities and Lecture Notes for the File Managment Using Windows assignment.
Required data files are downloaded from Vista.exe (65KB).
Due 10/9 printed screen captures with your name and the following:
  1. Results of checking your USB drive for errors.
  2. Window's Desktop with shortcut to the Grades folder on your USB drive and a window displaying the contents of the Grades folder.
  3. Windows Explorer window displaying all of the folders on your USB drive in the left pane and the contents of the Memos folder in order by size in the right pane.
Homework Due Today: Internet Scavenger Hunt
Monday
September 28		 Lecture over Module 4 (pages144-199) in room 340
Bring answers to study questions for bonus points.
Wednesday
September 30		 Bring your USB drive to room L363.
Word Tutorial 1: Creating a Document. Your name should appear in every letter or memo you turn in as a homework assignment.
Note: Save all files in the cis110 folder your created as part of the File Management assignment last week instead of the Tutorial.01 folder identified on page WD15.

Due 10/23: Your name should appear in every document. These documents are to be printed and handed in during class:
  1. Letter printed on page WD35 with your name replacing Andrew Suri's (step #8 on page WD17)
  2. Letter printed as part of the Review Assignment starting on page WD38 to step 16. Replace Andrew Suri's name with your own name.
Alternative to Word Tutorial 1 assignment: Complete Case Problem 1 (page WD39) and Case Problem 3 (page WD41).
Friday
October 2		 Quiz over Modules 3 and 4 in room 340.
Homework Due Today: Answers to the Module 3 and Module 4 study questions
Monday
October 5		 Lecture over Module 5 (pages 210-247) in room 340
Bring answers to study questions for bonus points.
Wednesday
October 7		 Bring your USB drive to room L363.
Word Tutorial 2: Editing and Formatting a Document. NOTE: Your name should appear in every document you turn in as a homework assignment.
Due 10/23: Your name should appear in every document. These documents are to be printed and handed in during class.
  1. Handout printed on page WD84.
  2. Review Assignment starting on page WD87.
Alternative to Word Tutorial 2 assignment: Complete Case Problem 2 (page WD91) and Case Problem 3 (page WD92).

The following files are needed to complete the above assignments. All of these files are contained in Word.exe (91KB):
Friday
October 9		 Bring your USB drive to room L363.
Advanced Word Processing handout and hands-on bonus point activities.

Homework Due Today:
  1. The three printed screens with your name from the File Managment Using Windows assignment:
    • Results of checking your USB drive for errors.
    • Window's Desktop with shortcut to the Grades folder on your USB drive and a window displaying the contents of the Grades folder.
    • Windows Explorer window displaying all of the folders on your USB drive in the left pane and the contents of the Memos folder in order by size in the right pane.
  2. Send email from Outlook Web Access handout to Dr. T. at Tim.Trainor@muskegoncc.edu with the following:
    • Subject line with your name.
    • Message that includes your name, class day and time, your current point totals and a short explanation about your expectations for class.
    • Attachment with screen capture of your class point totals from the electronic grade book.
    • Your personal Outlook signature.
  3. Print screen capture of distribution list from Outlook Web Acccess handout.
  4. Printed screen of appointment dialog box before removing it on page 6 from Outlook Calendar and Task Manager handout.
  5. Printed screen of appointment dialog box with invited attendees email addresses and message from page 8 from Outlook Calendar and Task Manager handout.
  6. Printed screen of task dialog box from page 10 from Outlook Calendar and Task Manager handout.
Monday
October 12		 Lecture over Module 6 (pages 273-304) in room 340
Bring answers to study questions for bonus points.
Wednesday
October 14		 Bring your USB drive to room L363.
PowerPoint Tutorial 1: Creating a Presentation.
Discuss PowerPoint project.
Due 10/30 (Note - Your name must appear in the footer of every slide):
  1. PowerPoint handouts (4 slides per page) from the Business Plan presentation printed on page PPT30.
  2. PowerPoint notes for pages 3 and 6 from the Business Plan presentation printed on page PPT30.
  3. Review Assignment starting on page PPT33.
  4. Email Dr. T a brief description of project. The email MUST include the following information about your Final Project:
    • Subject line with your name and class hour.
    • Brief description of your PowerPoint project.
    • Outlook signature created for class that includes your name, MCC student number and telephone number.
Alternative to PowerPoint Tutorial 1 assignment: Case Problems 2 (page PPT35) and Case Problem 3 (page PPT36).

The following files are needed to complete the above assignments. All of these files are contained in PPT.exe (3MB):
Friday
October 16		 Quiz over Modules 5 and 6 in room 340.
Homework Due Today: Answers to the Module 5 and Module 6 study questions.
Monday
October 19		 Lecture over Module 7 (pages 317-353) in room 340
Bring answers to study questions for bonus points.
Wednesday
October 21		 Photoshop Worksheet 1 Lecture Notes - bring your USB drive to room L363.
Due 11/6: Images printed as part of the Hands-On Practice and Project for Photoshop Worksheet 1.

The following files are needed to complete the Photoshop Worksheet 1 assignments. All of the files for the Photoshop worksheets are contained in p-images.exe (4.5MB):
Friday
October 23		 Photoshop Worksheet 2 Lecture Notes - bring your USB drive to room L363.
Due 11/6: Images printed as part of the Hands-On Practice and Project for Photoshop Worksheet 2

The following files are needed to complete the Photoshop Worksheet 2 assignments. All of the files for the Photoshop worksheets are contained in p-images.exe (4.5MB): Homework Due Today (your name should appear in every document):
  1. Word 1 Tutorial: Printed letters from page WD35 and Review Assignment starting on page WD38 to step 16.
    Alternative: Case Problems 1 (page WD39) and Case Problem 3 (page WD41).
  2. Word 2 tutorial: hand-out printed on page WD84 and Review Assignment starting on page WD87.
    Alternative: Complete Case Problems 2 (page WD91) and Case Problem 3 (page WD92).
Monday
October 26		 Lecture over Module 8 (pages 364-409) in room 340
Bring answers to study questions for bonus points.
Wednesday
October 28		 Photoshop Worksheet 3 Lecture Notes as well as using digital camera and scanner. Bring a photo of yourself to scan and your USB drive to the computer classroom.

Due 11/6: Images printed as part of the Hands-On Practice and Project for Photoshop Worksheets 3.

The following files are needed to complete the Photoshop Worksheet 3 assignments. All of the files for the Photoshop worksheets are contained in p-images.exe (4.5MB):
Friday
October 30		 Quiz over Modules 7 and 8 in room 340.

Homework Due Today:
  1. Answers to the Module 7 and Module 8 study questions.
  2. PowerPoint handouts (4 slides per page) from the Business Plan presentation printed on page PPT30. Your name must appear in the footer of every slide.
  3. PowerPoint notes for pages 3 and 6 from the Business Plan presentation printed on page PPT30. Your name must appear in the footer of every slide.
  4. Review Assignment starting on page PPT33. Your name must appear in the footer of every slide.
  5. Email Dr. T a brief description of project. The email MUST include the following information about your Final Project:
    • Subject line with your name and class hour.
    • Brief description of your PowerPoint project.
    • Outlook signature created for class that includes your name, MCC student number and telephone number.
Alternative to PowerPoint Tutorial 1 assignment: Case Problems 2 (page PPT35) and Case Problem 3 (page PPT36).
Monday
November 2		 Lecture over Module 9 (pages 420-459) in room 340
Bring answers to study questions for bonus points.
Wednesday
November 4		 Bring USB drive to room L363.
Excel Tutorial 1: Getting Started with Excel
Due 11/20 (Note - Your name must appear in the footer of every worksheet):
  1. Excel RipCity Digital Orders workbook printed on page EX43 and formula view printed on EX45.
  2. Review Assignment starting on page EX48.
Alternative to Excel Tutorial 1 assignment: Complete Case Problem 1 (page EX49) and Case Problem 4 (page EX54).

The following file is needed to complete the Case 1 alternative. All of the files used in the Excel assignments are contained in Excel.exe (157KB):
Friday
November 6		 Bring USB drive to room L363.
Excel Tutorial 3: Working with Formulas and Functions
Due 11/20 (Note - Your name must appear in the footer of every worksheet):
  1. Print the Documentation, 2010 Proposed Budget and Loan Analysis worksheets after completing tutorial.
  2. Review Assignment starting on page EX152.
Alternative to Excel Tutorial 3 assignment: Complete Case Problem 1 (page EX153) and Case Problem 3 (page EX157).

The following files are needed to complete the above assignments. All of the files used in the Excel assignments are contained in Excel.exe (157KB): Homework Due Today: Output from Hands-On Practice and Projects from Photoshop Worksheets 1, 2 and 3.
Monday
November 9		 Lecture over Module 10 (pages 472-485 and 530-565) in room 340
Bring answers to study questions for bonus points.
Wednesday
November 11		 Bring USB drive to room L363.
Excel Tutorial 4: Creating Charts and Graphics
Due 12/4 (Note - Your name must appear in the footer of every worksheet):
  1. Print the Documentation, Cover Sheet and Summary Report worksheets after completing the tutorial.
  2. Review Assignment starting on page EX207.
Alternative to Excel Tutorial 4 assignment: Complete Case Problem 1 (page EX208) and Case Problem 2 (page EX209).

The following files are needed to complete Excel Tutorial 4. All of the files used in the Excel assignments are contained in Excel.exe (157KB):
Friday
November 13		 Quiz over Modules 9 and 10 in room 340.
Homework Due Today: Answers to the Module 9 and Module 10 study questions.
Monday
November 16		 Lecture over Module 11 (pages 577-611) in room 340
Bring answers to study questions for bonus points.
Wednesday
November 18		 Discuss Software Installation and Firewall Testing assignments due 12/4.
Demonstrate related activities in room L363:
  • Downloading spyware scanner (Spybot)
  • Installing software
  • Uninstalling software
  • Testing firewall
Friday
November 20		 Project presentation day assigned in room L363.

Cover Hands on Practice and Lecture Notes for Advanced PowerPoint Bonus Assignment.

Homework Due Today (your name must appear in the footer of every worksheet):
  1. Excel Tutorial 1: RipCity Digital Orders workbook printed on page EX43 and formuls view on page EX45
  2. Excel Tutorial 1: Review Assignment starting on page EX48.
  3. Excel Tutorial 3: Print the Documentation, 2010 Proposed Budget and Loan Analysis worksheets.
  4. Excel Tutorial 3: Review Assignment starting on page EX152.
Alternative to Excel Tutorial 1 assignment: Complete Case Problem 1 (page EX49) and Case Problem 4 (page EX54).
Alternative to Excel Tutorial 3 assignment: Complete Case Problem 1 (page EX153) and Case Problem 3 (page EX157).
Monday
November 23		 Lecture over Module 12 (pages 623-649) in room 340
Bring answers to study questions for bonus points.
Wednesday
November 25		 Final examination review and discuss computer procedures you need to know.
Friday
November 27		 No class -- Thanksgiving Holiday
Monday
November 30		 PowerPoint final project presentations in room 340.
Wednesday
December 2		 Walk through sample final examination, work on late assignments or PowerPoint presentations in room L363.
Friday
December 4		 Quiz over Modules 11 and 12 in room 340.

Homework Due Today (your name must appear in the footer of every worksheet):
  1. Answers to the Module 11 and Module 12 study questions.
  2. Excel Tutorial 4: Print the Documentation, Cover Sheet and Summary Report worksheets.
  3. Excel Tutorial 4: Review Assignment starting on page EX207.
  4. Screen captures from Software Installation assignment. Make sure your name appears on both screen captures and that the clock in the lower right corner of the screen.
  5. Printed results from the Firewall Testing assignment. Make sure your name appears on both test results.
Alternative to Excel Tutorial 4 assignment: Complete Case Problem 1 (page EX208) and Case Problem 2 (page EX209).
Monday
December 7		 PowerPoint final project presentations in room 340.
Wednesday
December 9		 PowerPoint final project presentations in room 340.
Last day to submit late work and regrades!
Friday
December 11		 PowerPoint final project presentations in room 340.
Starting
December 14		 Final examination: A personal computer and diskette are provided. Students are given 2 hours to find information on the Internet, create a Word document and Excel worksheet as well as edit an image with Photoshop using data supplied by Dr. T. Students will be asked to create a file folder and make copies of the final examination results. This examination is open textbook and open note.

Final Examination date and time will be posted around campus two weeks before final exam week.
Page Top
 CIS110 Syllabus Study Questions Grades Competencies Other Syllabi MCC's Home Page

Please send comments regarding this web page to: Tim.Trainor@muskegoncc.edu


MUSKEGON COMMUNITY COLLEGE
221 South Quarterline Road
Muskegon, MI 49442
231.773.9131