COSC 1301 Personal Computing

Lesson Assignments

Understanding Essential Computer Concepts

  1. Reading Assignment → P. Concepts 1- 25
  2. Lab Project: Concepts Review, p.26-29 (I’ll hand out answers to check your work).
  3. After-class Homework: None.

Windows XP Unit A:  Getting Started with Windows XP

  1. Reading Assignment → p. Windows XP 1- 19.  Note that this chapter is the Green tabbed chapter near the end of the book.  It is NOT the green-tabbed Windows Vista chapter that is the book’s  2nd chapter.
  2. Lab Project: Handout distributed in class. It’s on Blackboard also, filename “Unit A Revised Skills Review”, in the Labs section
  3. (Suggested) After-class Homework: Independent Challenges 1, 2, 3, or 4. 

Windows XP Unit B:  Understanding File Management

  1. Reading Assignment → P. Windows XP 25-45. .  Note that this chapter is the Green tabbed chapter near the end of the book.  It is NOT the green-tabbed Windows Vista chapter that is the book’s  2nd chapter.
  2. Lab Project: Handout distributed in class (based on a local version of Skills Review . It’s on Blackboard, filename “Unit B Revised Skills Review”, in the Labs section of Blackboard
  3. (Suggested) After-class Homework: Independent Challenges 1-4 , p. Windows 50-51

Internet Unit A: Getting Started with Internet Explorer 7

  1. Reading Assignment → P. Internet 1-17.   Concepts Review page 18-19.
  2. Lab Project: Skills Review → P. Internet 19-21, augmented with classroom handout, on Blackboard Labs section, “IE lab addendum”.
  3. After-class Homework:  Independent Challenges 1-4, p. 21-23

Getting Started with Microsoft Office 2007

  1. Reading Assignment → P. Office 1-15.   Concepts Review page Office 16.
  2. Lab Project: Skills Review → Assigned in class.
  3. After-class Homework:  Independent Challenges 1 p. Office 16

Word 2007 Unit A:  Creating Documents with Word 2007

  1. Reading Assignment → P. Word 1-17.  Concepts Review page Word 18-19.
  2. Lab Project: Skills Review → p. Word 19-20.
  3. After-class Homework: Independent Challenges 1-2 → p. 21-22.

Word 2007 Unit B: Editing Documents

1.      Reading Assignment → P. Word 25-41

2.      Lab Project: Skills Review → P. Word 43-44.

3.      After-class Homework: Visual Workshop, p. Word 48.

Word 2007 Unit C Part 1: Formatting Text and Paragraphs (note: we cover this chapter over 2 class sessions)

  1. Reading Assignment → P. 49-57.
  2. Lab Project: Skills Review → P. Word 69-70, steps 1-4
  3. After-class Homework: Independent Challenge 2. ( steps a-f )

Word 2007 Unit C Part 2: Formatting Text and Paragraphs (note: we cover this chapter over 2 class sessions)

  1. Reading Assignment → P. Word 58-67.  Concepts Review page Word 68-69
  2. Lab Project: Skills Review → P. Word 69-70, steps 5-9
  3. After-class Homework: Independent Challenge 2. (complete)

Word 2007 Unit D: Formatting Documents

  1. Reading Assignment → P. Word 77-95.   Concepts Review pageWord 96-97.
  2. Lab Project: Skills Review → P. Word 97-98.
  3. After-class Homework:  Independent Challenge 2, p. Word 101.

Excel 2007 Unit A: Getting Started with Excel 2007

  1. Reading Assignment → P. Excel 1-17.  Concepts Review page Excel 18-19.
  2. Lab Project: Skills Review → P. Excel 19-20.
  3. After-class Homework: Independent Challenge 2, p. Excel 21.

Excel 2007 Unit B:  Working with Formulas and Functions

  1. Reading Assignment → P. Excel 25-41.   Concepts Review page Excel 42-43.
  2. Lab Project: Skills Review → P. Excel 44-45.
  3. After-class Homework: Independent Challenge #1 → p. Excel 46.

Excel 2007 Unit C: Formatting a Worksheet

  1. Reading Assignment → P. Excel 51-69.   Concepts Review page Excel 70-71.
  2. Lab Project: Skills Review → P. Excel 71-73.
  3. After-class Homework: Independent Challenge 2, p. Excel 74.

Excel 2007 Unit D:  Working With Charts

  1. Reading Assignment → P. Excel 79-95.   Concepts Review page Excel 96-97
  2. Lab Project: Skills Review → P. Excel 97-99.
  3. After-class Homework:  → Independent Challenge 2, p. Excel 101.

Integration Unit A:  Integrating Word and Excel

  1. Reading Assignment → Integration Unit A, p. Integration 1-11.
  2. Lab Project: Skills Review, p. Integration 12-14.
  3. After-class Homework:       Visual Workshop, p. Integration 16.

Access 2007 Unit A: Getting Started with Access 2007

  1. Reading Assignment → P. Access 1-19.  Concepts Review page Access 20-21.
  2. Lab Project: This class broken into two parts.  Each has a handout lab distributed in class.  Both are on Blackboard Labs section: (1)Access Part 1 lab, Access Part 2 lab.
  3. After-class Homework:  Independent Challenge 3, p. Access 24-25.

Access 2007 Unit B: Building and Using Queries

  1. Reading Assignment → P. Access 27-43.   Concepts Review page Access 44-45
  2. Lab Project:  Skills Review → p. Access 45-46.
  3. After-class Homework: Independent Challenge 3 → p. Access 48.

Access 2007 Unit C: Using Forms

  1. Reading Assignment →P. Access 51-67.  Concepts Review pages Access 68-69.
  2. Lab Project: Skills Review → p. Access 70-71.
  3. After-class Homework: Independent Challenge 3, p. Access 74.

Access 2007 Unit D:  Using Reports

  1. Reading Assignment → P. Access 77-93.  Concepts Review p. Access 94-95.
  2. Lab Project:Handout in class.  Also available on Blackboard, labs, Modified Skills Review
  3. After-class Homework: Independent Challenge 1 p. Access 99.

Integration Unit B:  Integrating Word, Excel and Access

  1. Reading Assignment → P. Integration 17-27.
  2. Lab Project: Skills Review  p. Integration 28-29.
  3. After-class Homework:  Independent Challenge 3 → p. Integration 31.