COURSE SCHEDULE

(Last Revised: April 18, 2018)

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.

 

Apr 4- Apr 23
Microsoft Word & Integration
Apr 4

SLO - Word Module 3

DOWNLOAD STUDENT DATA FILES

 

 

 

POST ASSESSMENT from OA101

Word Projects (to be graded in class):

    1. Page WD169 ~ 170 - Review Assignment (Computer Classes Report)
    2. Click to view the Solution: Computer Classes Report

Instructions:

  1. EMAIL file as an attachment.
    • To: yvonne.flores@guamcc.edu
    • Cc: your email address
    • Subject: CS151-## Word Module 3
  2. DRAG files into your Google Drive
  3. CALL ME for grading.
  4. DELETE
    • Everything in DOWNLOADS folder
    • Your FOLDER
    • AND EMPTY RECYCLE BIN
Apr 9

SLO - Word Module 4

DOWNLOAD STUDENT DATA FILES

Word Project (to be graded in class):

    1. Page WD234 ~ 235- Case Problem #1 (#1 - 15)
    2. Click to view the Solution: Biking Newsletter

Instructions:

  1. EMAIL file as an attachment.
    • To: yvonne.flores@guamcc.edu
    • Cc: your email address
    • Subject: CS151-## Word Module 4
  2. DRAG files into your Google Drive
  3. CALL ME for grading.
  4. DELETE
    • Everything in DOWNLOADS folder
    • Your FOLDER
    • AND EMPTY RECYCLE BIN
Apr 11

EXPORT: Access --> Excel

 

Integration: Word / Excel (Paste Link)

*You do not need to bring your book.

DOWNLOAD STUDENT DATA 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

Instructions:

  1. EMAIL (Java Menu, Coffee Prices, Computer Prices) files as an attachment.
    • To: yvonne.flores@guamcc.edu
    • Cc: your email address
    • Subject: CS151-## Integration 1
  2. DRAG files into your Google Drive
  3. CALL ME for grading.
  4. DELETE
    • Everything in DOWNLOADS folder
    • Your FOLDER
    • AND EMPTY RECYCLE BIN
Apr 16

Mail Merge:

Spreadsheet / Word Document

Word Table / Word Document

Access Database / Word Document

*You do not need to bring your book.

DOWNLOAD STUDENT DATA FILES

Integration Project (to be graded in class):

  1. Create a Name Tag Document
    • Use the Agents Excel worksheet and Name Tag Word Document
    • Use the Following Fields in your Name Tag
      • <<First Name>>
      • <<Last Name>>
      • <<Affliation>>
      • Search and Insert an appropriate image
      • Be CREATIVE!!
    • Save As: Agent Name Tags
  2. Click on Link for Instructions: Integration Project #2
  3. Click on Link for Instructions: Integration Project #3

Instructions:

  1. EMAIL (Agent Name Tags, New Checking Bank Merge, Abbott Sales Merge) files as an attachment.
    • To: yvonne.flores@guamcc.edu
    • Cc: your email address
    • Subject: CS151-## Integration 2 / 3
  2. DRAG files into your Google Drive
  3. CALL ME for grading.
  4. DELETE
    • Everything in DOWNLOADS folder
    • Your FOLDER
    • AND EMPTY RECYCLE BIN
Apr 18

Word Integration Skills Assessment

*You do not need to bring your book.

DOWNLOAD STUDENT DATA FILES

20% of your grade - Word / Integration Assessment

Word / Integration Assessment (to be graded in class):

  1. Click on Link for Instructions: Word Assessment
  2. Click on Link for Instructions: Integration Assessment

Instructions:

  1. Save: Bagel Mania and March Reminder Merge in your Google Drive.
  2. Email Bagel Mania and March Reminder Merge
    • To: yvonne.flores@guamcc.edu
    • Cc: your email address
    • Subject: CS151-## Word / Integration Assessment

© 2018 Yvonne C. Flores, Guam Community College