COURSE SCHEDULE

(Last Revised: February 13, 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
Jan 11 Overview, Expectations, Assessment/Participation Complete before leaving class

Complete before class on Thursday, January 18

  • Task #5 (Check your MyGCC email after 5:00 pm Tuesday)
Jan 16

Review Course Requirements

Demonstrate Access Student Data Files (On Campus)

 

Excel Projects - (To be graded in class)

  1. Project 1-1: (Birds Census)- **Don't forget FOOTERS**
  2. Project 1-2: (Technology Shop)**Don't forget FOOTERS**

Instructions:

  1. PRINT Technology Shop**(Print in Landscape if needed to fit on one page).
  2. EMAIL both files as attachments.
    • To: yvonne.flores@guamcc.edu
    • Cc: your email address
    • Subject: CS151-## Excel Module 1a
  3. DRAG both files into your Google Drive
  4. CALL ME for grading.
  5. DELETE FOLDERS AND EMPTY RECYCLE BIN
  • DELETE your Folder.
  • DELETE everything in the Downloads folder.
  • Right-click on the Recycle Bin and choose Empty Recycle Bin

 

Student Learning Outcomes (SLO) - Microsoft Excel: Module 1

 

 

Jan 18

Access Student Data Files:

 

Excel Project - (To be graded in class)

    1. Page EX 60 ~ 61 Case Problem 2
      • Filename: (FLastName Balance Sheet)
      • **Don't forget FOOTERS**

Instructions:

  1. PRINT Balance Sheet
    • Scale to Fit so it fits on one page.
  2. EMAIL file as an attachment.
    • To: yvonne.flores@guamcc.edu
    • Cc: your email address
    • Subject: CS151-## Excel Module 1b
  3. DRAG file into your Google Drive
  4. CALL ME for grading.
  5. DELETE:
    • Everything in the Downloads folder
    • Your FOLDER on the Desktop
  6. EMPTY RECYCLE BIN - (Right-click)

 

SLO - Microsoft Excel: Module 1b

 

 

 

Jan 23

Access Student Data Files:

 

Excel Project - (To be graded in class)

    1. Page EX 125 ~ 126 Case Problem 1 (Green Clean)
      • Filename: (FLastName Green Clean)
      • **Don't forget FOOTERS only on the Income Statement Worksheet**

Instructions:

  1. PRINT Income Statement Worksheet ONLY
    • Print in Landscape Orientation.
    • Scale to Fit so it fits on one page.
  2. EMAIL file as an attachment.
    • To: yvonne.flores@guamcc.edu
    • Cc: your email address
    • Subject: CS151-## Excel Module 2a
  3. DRAG file into your Google Drive
  4. CALL ME for grading.
  5. DELETE:
    • Everything in the Downloads folder
    • Your FOLDER on the Desktop
  6. EMPTY RECYCLE BIN - (Right-click)

 

SLO - Microsoft Excel: Module 2a

 

 

 

Jan 25

Access Student Data Files:

 

Excel Project - (To be graded in class)

  1. Page EX 126 ~ 127 Case Problem 2 (#1 - 14) (Peak Bytes)
    • Filename: (FLastName Peak Bytes)
    • **Don't forget FOOTERS only on the Speed Test Worksheet**

Instructions:

  1. Set your Print Area to the Range (A1:D9) ONLY
  2. PRINT Speed Test Worksheet ONLY
  3. EMAIL file as an attachment.
    • To: yvonne.flores@guamcc.edu
    • Cc: your email address
    • Subject: CS151-## Excel Module 2b
  4. DRAG file into your Google Drive
  5. CALL ME for grading.
  6. DELETE:
    • Everything in the Downloads folder
    • Your FOLDER on the Desktop
  7. EMPTY RECYCLE BIN - (Right-click)

 

SLO - Microsoft Excel: Module 2b

 

 

 

Jan 30

Access Student Data Files:

  1. Click on this Link to Google Drive for files.
  2. Log in using your guamcc email address.
  3. Right-click to Download each file.
  4. Open the Downloads folder, Drag the 3 files to your folder.

Excel Projects: (To be graded in class)

  1. There are 3 Projects (Investment, Cheese, Golf).
  2. Open each file, instructions are on the worksheet.
  3. Make sure to save the file in your folder.

Instructions:

  1. EMAIL files as an attachment.
    • To: yvonne.flores@guamcc.edu
    • Cc: your email address
    • Subject: CS151-## Excel Module 3a
  2. DRAG file into your Google Drive
  3. CALL ME for grading.
  4. DELETE:
    • Everything in the Downloads folder
    • Your FOLDER on the Desktop
  5. EMPTY RECYCLE BIN - (Right-click)

 

SLO - Microsoft Excel: Module 3a

Feb 1

Access Student Data Files:

  1. Click on this Link to Google Drive for files.
  2. Log in using your guamcc email address.
  3. Right-click to Download each file.
  4. Open the Downloads folder, Drag the 2 files to your folder.

Excel Projects: (To be graded in class)

  1. Page EX 183~ 184 Case Problem 2 (Capshaw Wages)
    • Filename: (FLastName Capshaw Wages)
    • **Don't forget FOOTERS only on the Work Schedule Worksheet**

Instructions:

  1. EMAIL file as an attachment.
    • To: yvonne.flores@guamcc.edu
    • Cc: your email address
    • Subject: CS151-## Excel Module 3b
  2. DRAG file into your Google Drive
  3. CALL ME for grading.
  4. DELETE:
    • Everything in the Downloads folder
    • Your FOLDER on the Desktop
  5. EMPTY RECYCLE BIN - (Right-click)

 

SLO - Microsoft Excel: Module 3b

Feb 6

Access Student Data Files:

  1. Click on this Link to Google Drive for files.
  2. Log in using your guamcc email address.
  3. Right-click to Download each file.
  4. Open the Downloads folder, Drag the 4 files to your folder.

Excel Projects: (To be graded in class)

  1. **Don't forget FOOTERS**
  2. Instructions for Starburst is on the worksheet.
    • Filename: (FLastName Starburst Growth)
  3. Page EX 251 Review (Market Analysis) ( #4 - 13 only)
    • Filename: (FLastName Market Analysis)

Instructions:

  1. EMAIL 2 files as an attachment.
    • To: yvonne.flores@guamcc.edu
    • Cc: your email address
    • Subject: CS151-## Excel Module 4a
  2. DRAG file into your Google Drive
  3. CALL ME for grading.
  4. DELETE:
    • Everything in the Downloads folder
    • Your FOLDER on the Desktop
  5. EMPTY RECYCLE BIN - (Right-click)
SLO - Microsoft Excel: Module 4a
Feb 8

Access Student Data Files:

  1. Click on this Link to Google Drive for files.
  2. Log in using your guamcc email address.
  3. Right-click to Download each file.
  4. Open the Downloads folder, Drag the 5 files to your folder.

Excel Projects: (To be graded in class)

  1. **Don't forget FOOTERS**
  2. Instructions for National is on the worksheet.
    • Filename: (FLastName National Bank)
  3. Instructions for Zoom is on the worksheet.
    • Filename: (FLastName Zoom Salaries)
  4. Instructions for Vote is on the worksheet.
    • Filename: (FLastName Vote Tally)

Instructions:

  1. EMAIL 3 files as an attachment.
    • To: yvonne.flores@guamcc.edu
    • Cc: your email address
    • Subject: CS151-## Excel Module 4b
  2. DRAG file into your Google Drive
  3. CALL ME for grading.
  4. DELETE:
    • Everything in the Downloads folder
    • Your FOLDER on the Desktop
  5. EMPTY RECYCLE BIN - (Right-click)

 

SLO - Microsoft Excel: Module 4b

Feb 13

Access Student Data Files:

  1. Click on this Link to Google Drive for files.
  2. Log in using your guamcc email address.
  3. Right-click to Download the file.
  4. Open the Downloads folder, Drag the file to your folder.

 

Excel Review Topics

     
 

© 2018 Yvonne C. Flores, Guam Community College