CIS 110: Computer Concepts

Monday Night Fall 2009

Reading and Homework Assignments

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

August 31 Overview of course syllabus

In the computer classroom (room L363) we will do the following:
  • Login to MCC's network
  • Windows: Exploring the Basics of Microsoft Windows Vista in Microsoft Office 2007 text
  • Web Browsers
  • Search engines
  • Internet Scavenger Hunt (due 9/21)
September 14 Lecture and quiz over Module 1 (pages 3-52) and the Course Syllabus in room 340

In the computer classroom we will do the following:
  • Use your USB drive
  • Print screen demo
  • Download files from the Internet
  • Copying and unzipping self-extracting files like Vista.exe (65KB).
Homework Due Today: Answers to the Module 1 study questions.
September 21 Lecture and quiz over Module 2 (pages 53-85)

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 9/28:
  1. Send email with the following:
    • Instructor's email address.
    • 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 9/28
  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.
Homework Due Today:
  1. Answers to the Module 2 study questions.
  2. Internet Scavenger Hunt
September 28 Lecture over Module 3 (pages 95-133) in room 340
Bring answers to study questions for bonus points.

In the computer classroom we will do the following:
  • Use your USB drive
  • Hands on Activities and Lecture Notes for the File Managment Using Windows assignment.
  • Required data files are downloaded from Vista.exe (65KB).
  • Due 10/12 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:
  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 from Outlook Web Acccess handout.
  3. Printed screen of appointment dialog box before removing it on page 6 from Outlook Calendar and Task Manager handout.
  4. Printed screen of appointment dialog box with invited attendees email addresses and message from page 8 from Outlook Calendar and Task Manager handout.
  5. Printed screen of task dialog box from page 10 from Outlook Calendar and Task Manager handout.
October 5 Lecture over Module 4 (pages 144-199) in room 340
Quiz over Modules 3 and 4

Bring your USB drive to the computer classroom. We will do the following:
  • Word Tutorial 1: Creating a Document. 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/12:
    1. Letter printed on page WD35 with your name replacing Andrew Suri's (step #8 on page WD17)
    2. Printed 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).
  • Word Tutorial 2: Editing and Formatting a Document.
    Due 10/19: 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).
NOTE: Your name should appear on every document.

The following files are needed to complete the above assignments. All of these files are contained in Word.exe (91KB): Homework Due Today: Answers to the Module 3 and Module 4 study questions
October 12 Lecture over Module 5 (pages 210-247) in room 340
Bring answers to study questions for bonus points.

Bring your USB drive to the computer classroom. We will do the following:
  1. Discuss PowerPoint project.
  2. PowerPoint Tutorial 1 (due 10/26):
      Your name must appear in the footer of each 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.
    Alternative to PowerPoint Tutorial 1 assignment: Case Problems 2 (page PPT35) and Case Problem 3 (page PPT36).
  3. Email Dr. T a brief description of project by 10/26. 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.
The following files are needed to complete the above assignments. All of these files are contained in PPT.exe (3MB): 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. Word Tutorial 1 (your name should appear in each document): the letters printed 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).
October 19 Lecture over Module 6 (pages 273-304) in room 340
Quiz over Modules 5 and 6

In the computer classroom we will go over Photoshop Worksheet Lecture Notes 1 and Lecture Notes 2 - bring your USB drive to the computer classroom.

Due 11/9 are the images printed as part the following:
  1. Photoshop Worksheets 1 Hands-On and Project.
  2. Photoshop Worksheets 2 Hands-On and Project.
The following files are needed to complete the Photoshop Worksheet 1 and 2 assignments. All of the files for the Photoshop worksheets are contained in p-images.exe (4.5MB): Homework Due Today:
  1. Answers to the Module 5 and Module 6 study questions.
  2. Word 2 tutorial (your name should appear in each document): 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).
October 26 Lecture over Module 7 (pages 317-353) in room 340
Bring answers to study questions for bonus points.

In the computer classroom we will go over Photoshop Worksheet 3 Lecture Notes as well as how to use a digital camera and scanner. Bring a photo of yourself to scan and your USB drive to the computer classroom.

Due 11/9: Images printed as part of Photoshop Worksheet 3 Hands-On and Project.

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): Homework Due Today:
  1. PowerPoint handouts (4 slides per page) from the Business Plan presentation printed on page PPT30. Your name must appear in the footer of each slide.
  2. PowerPoint notes for pages 3 and 6 from the Business Plan presentation printed on page PPT30. Your name must appear in the footer of each slide.
  3. Review Assignment starting on page PPT33. Your name must appear in the footer of each slide.
  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).
November 2 Lecture over Module 8 (pages 364-409) in room 340
Quiz over Modules 7 and 8

Bring your USB drive to class. In the computer classroom we will go over the following:
  1. Hands on Practice and Lecture Notes for Advanced Word Bonus Assignment.
  2. Hands on Practice and Lecture Notes for Advanced PowerPoint Bonus Assignment.
Homework Due Today: Answers to the Module 7 and Module 8 study questions.
November 9 Lecture over Module 9 (pages 420-459) in room 340
Bring answers to study questions for bonus points.

Bring your USB drive to the computer classroom.

Your name must appear in the footer of each worksheet. The following will be due 11/23:
  • Excel Tutorial 1: Getting Started with Excel
    1. Excel RipCity Digital Orders workbook printed on page EX43 and formula view printed on page 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).
  • Excel Tutorial 3: Working with Formulas and Functions
    1. Print the Documentation, 2010 Proposed Budget and Loan Analysis worksheets after completing the 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 file is needed to complete the Excel Tutorials 1 and 3. 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.
November 16 Lecture over Module 10 (472-485 and 530-565) in room 340
Quiz over Modules 9 and 10

Bring your USB drive to the computer classroom. The following will be due 12/7:

Excel Tutorial 4: Creating Charts and Graphics
  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): Homework Due Today: Answers to the Module 9 and Module 10 study questions.
November 23 Lecture over Module 11 (pages 577-611) in room 340
Bring answers to study questions for bonus points.
After the lecture we will assign everyone a project presentation day.

In the computer classroom we will discuss Software Installation and Firewall Testing assignments due 12/7.
Demonstrate related activities in room L363:
  • Downloading spyware scanner (Spybot)
  • Installing software
  • Uninstalling software
  • Testing firewall
Homework Due Today:
  1. Excel Tutorial 1: RipCity Digital Orders workbook printed on page EX43 and formula view printed 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).
November 30 Lecture over Module 12 (pages 623-649) in room 340
Quiz over Modules 11 and 12

PowerPoint final project presentations.
Homework Due Today: Answers to the Module 11 and Module 12 study questions
December 7 Discuss final examination review and computer procedures you need to know. Walk through sample final examination.
PowerPoint final project presentations.

Homework Due Today:
  1. 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.
  2. Printed results from the Firewall Testing assignment. Make sure your name appears on both test results.
  3. Excel Tutorial 4: Print the Documentation, Cover Sheet and Summary Report worksheets.
  4. Excel Tutorial 4: Review Assignment starting on page EX207.
Alternative to Excel Tutorial 4 assignment: Complete Case Problem 1 (page EX208) and Case Problem 2 (page EX209).

Last day to submit late work and regrades!
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.
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