CIS 110: Computer Concepts

Reading and Homework Assignments

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

Week 1 Overview of course syllabus

In the computer classroom (room L363) we will do the following:
Week 2 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: Homework Due Today: Answers to the Module 1 study questions.
Week 3 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.

Due Week 4: Using Outlook Web Access.
  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.
Due Week 4: Using Outlook Calendar and Task Manager.
  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
Week 4 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 Week 6: 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@ttdk.com 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.
Week 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:
  • Due Week 6: 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.
    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).
  • Due Week 7: Word Tutorial 2: Editing and Formatting a 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).
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.
Week 6 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. Due Week 8: PowerPoint Tutorial 1
    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. Due Week 8: 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.
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).
Week 7 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 Week 10: 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).
Week 8 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 Week 10: 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).
Week 9 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.
Week 10 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.
  • Due Week 12: 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).
  • Due Week 12: 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.
Week 11 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.

Due Week 14: 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.
Week 12 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.

Due Week 14: Software Installation and Firewall Testing assignments
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).
Week 13 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.
Week 14 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!
Week 15 Final examination: A personal computer and USB drive 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
 Syllabus Study Questions Competencies Dr. T.'s Homepage TTDK Homepage

Please send comments regarding this web page to: Tim.Trainor@ttdk.com