COURSE SCHEDULE

(Last Revised: October 15, 2019)

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.

 

Aug 20 - Sep 17
Introduction to Microsoft Excel
Sep 19 - Oct 10
Introduction to Microsoft Word
Sep 19

Accessing Student Data Files (On / Off-Campus)

  1. ON-CAMPUS - CS151 / Word / Word1
  2. OFF-CAMPUS - Click on this Link to Google Drive for files
Create a Shared CS151 Folder in your Google Drive
  1. Go to your Google Drive,
    • Create a CS151 folder. Right-click, SHARE the folder with me: yvonne.flores@guamcc.edu
    • Create the following 4 sub folders inside your CS151 folder.
      • Word
      • Integration
      • Access
      • PowerPoint

Lesson Objectives

SLO - Word Module 1

WORD PROJECTS- (To be graded in class)

  1. IN-CLASS DEMONSTRATION: Create a Letter and Save As: Brooks Letter (See page WD9 ~ WD29)
  2. Continued IN-CLASS DEMONSTRATION: Word1 / Module Folder - (Page WD32 ~ 52) Open Vinyl
  3. Word1 / Review Folder - Page WD55 - 56 Review Assignment
    • File needs to be created. Save As: Huang Letter
    • (**Follow the correct spacing for a block-style business letter. See Page WD 9**)
  4. Click to View the Solution: Huang Letter, Huang Envelope, Record Player Flyer
  5. Drag the 3 files inside your Shared Word folder.
Sep 24

Accessing Student Data Files (On / Off-Campus)

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

WORD PROJECTS- (To be graded in class)

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

Lesson Objectives

SLO - Word Module 2a

Sep 26

Accessing Student Data Files (On / Off-Campus)

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

WORD PROJECTS- (To be graded in class)

    1. Word2 / Module Folder Complete Page WD94 ~ WD112- Step-By-Step Exercise Open Ancient, Save As: Ancient Architecture
    2. Click to View the Solution: Ancient Architecture
    3. Drag the file inside your Shared Word folder.

Lesson Objectives

SLO - Word Module 2b

Oct 1

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. Word3 / Review Folder Page WD169 ~ 170 - Review Assignment
    2. Click to View the Solution: Computer Classes Report
    3. Drag the file inside your Shared Word folder.

 

Lesson Objectives

SLO - Word Module 3

 

Oct 3

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. 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

Oct 8

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
  2. Click to view the Solution: Java Menu.docx
  3. Drag the files (Java Menu, Coffee Prices, Computer Prices) inside your Shared Integration folder.

 

*You do not need to bring your book.

Lesson Objectives

SLO - Integration (Word / Excel - Paste Link)

Oct 10

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 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)

 

 

Word Assessment Review Topics

Oct 15

*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.)

© 2019 Yvonne C. Flores, Guam Community College