COURSE SCHEDULE

(Last Revised: March 10, 2020)

Disclaimer: The instructor reserves the right to make changes in the course schedule.

Date
Lesson / Step-By-Step Exercises
End-Of Lesson/Unit Projects
  Step-By-Step Exercises will be DEMONSTRATED in class. Mastery of the software requires PRACTICE.

**ALL PROJECTS are to be COMPLETED IN CLASS and DUE on the day assigned.

 

Jan 14 - Feb 11
Introduction to Microsoft Excel (Click on Link to view previous lessons)
Feb 18

Accessing Student Data Files (On / Off-Campus)

  1. ON-CAMPUS - CS151 / Word / Lesson 04
  2. OFF-CAMPUS - Click on this Link to Google Drive for files

 

WORD PROJECTS- (To be graded in class)

  1. IN-CLASS DEMONSTRATION: Create a Letter and Save As: Brooks Letter (See page WD9 ~ WD29)
  2. Open Word1 > Review Folder - Page WD55 Review Assignment (#1-13 ONLY)
    • File needs to be created. Save As: Huang Letter
      • **Follow the correct spacing for a block-style business letter. See Page WD 9**
    • New file needs to be created. Save As: Huang Envelope
  3. Open Word Lesson 04 - CLICK on HERE for Instructions: Save As: Checking Account Info
  4. Click to View the Solution: Huang Letter, Huang Envelope, Checking Account Info
  5. Drag the 3 files inside your Shared Google Drive Word folder

LESSON OBJECTIVES

Student Learning Outcomes (SLO) - Microsoft Word Module 1

Feb 20

Accessing Student Data Files (On / Off-Campus)

  1. ON-CAMPUS:
    • CS151 / Word / Word2
    • 2010 / CS151 / Word / Word Lesson 05
  2. OFF-CAMPUS - Click on this Link to Google Drive for files

WORD PROJECTS- (To be graded in class)

  1. IN-CLASS DEMONSTRATION, Open Word2 > Module Folder - (Page WD65 ~ 90), Open Home
  2. IN-CLASS DEMONSTRATION, Open Word Lesson 05 Folder - (NADA Memo - Setting Tabs)
  3. Open Word2 > Review Folder - Page WD113 (#1-10) Review Assignment
  4. Open Word Lesson 05 Folder - Open Shipping, CLICK HERE for Instructions
  5. Click to View the Solution: Commercial LEED, Overnight Shipping
  6. Drag the 2 files inside your Shared Word folder.

Lesson Objectives

SLO - Word Module 2a

Feb 25

Accessing Student Data Files (On / Off-Campus)

  1. ON-CAMPUS - CS151 / Word / Word3 folder
  2. OFF-CAMPUS - Click on this Link to Google Drive for files.

WORD PROJECTS- (To be graded in class)

    1. IN-CLASS DEMONSTRATION, Open Word3> Module Folder - (Page WD122 ~ 167), Open New
    2. Open Word3 > Review Folder Page WD169 ~ 170 - Review Assignment
      • # 12 - Skip Automatic Hyphenation
      • #16, DO NOT separate section 1 and section 2 header.
    3. Click to View the Solution: Computer Classes Report
    4. Drag the file inside your Shared Word folder.

Lesson Objectives

SLO - Word Module 3

 

Feb 27

Accessing Student Data Files (On / Off-Campus)

  1. ON-CAMPUS - CS151 / Word / Word4 folder
  2. OFF-CAMPUS - Click on this Link to Google Drive for files.

WORD PROJECTS- (To be graded in class)

    1. IN-CLASS DEMONSTRATION: Word4 >Module Folder - (Page WD178 ~ 227) Open Aria
    2. Open Word4 > Case 1 Folder Page WD234 ~ 235- Case Problem 1 (#1-15)
    3. Click to View the Solution: Biking Newsletter
    4. Drag the file inside your Shared Word folder.

Lesson Objectives

SLO - Word Module 4

Mar 3

*You do not need to bring your book.

Accessing Student Data Files (On / Off-Campus)

  1. ON-CAMPUS - CS151 / 2010 / Excel / Excel Unit Review folder
  2. OFF-CAMPUS - Click on this Link to Google Drive for files.

 

Integration Project (to be graded in class):

  1. Click on Link for Instructions: Integration Project #1 (do not PRINT)
  2. Click to view the Solution: Java Menu.docx
  3. Drag the files (Java Menu, Coffee Prices, Computer Prices) inside your Shared Integration folder.

Lesson Objectives

SLO - Integration (Word / Excel - Paste Link)

 

Mar 5

Accessing Student Data Files (On / Off-Campus)

DOWNLOAD STUDENT DATA FILES

  1. Integration 2 Files: Click on this Link to Google Drive for files.
  2. Integration 3 Files: Click on this Link to Google Drive for files.

Integration Project (to be graded in class):

  1. Click on Link for Instructions: Integration Project #2 (do not PRINT)
  2. Click on Link for Instructions: Integration Project #3 (do not PRINT)
  3. Drag the 2 files (New Checking Bank MERGE & Abbott Sales MERGE) inside your Shared Integration folder.

 

*You do not need to bring your book.

Lesson Objectives

  1. SLO - Integration: Mail Merge (Word Document / Word Table)
  2. SLO - Integration: Mail Merge (Word / Access Table)

 

 

Word Assessment Review Topics

Mar 10

*You do not need to bring your book.

**Word Mastery Assessment**

(REMINDER: As stated in the syllabus, ***NO MAKEUP*** will be allowed unless PRIOR arrangements are made.)

© 2020 Yvonne C. Flores, Guam Community College