COURSE SCHEDULE

(Last Revised: September 24, 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.

 

Aug 15 Overview, Expectations, Assessment/Participation Complete before leaving class
  1. Task #1 - Create Folders (Click on Link)
  2. Task #2 (Day1 Assessment / Participation)
  3. Task #3 - Zip Your Folder / Email to Me (Click on Link)
  4. Task #4 - Email Contact Info (Click on Link)

AFTER COMPLETING Task #1 - 4,

  1. Verify with instructor Zip folder received.
  2. Verify with instructor Email Contact Info received.
Introduction to Microsoft Excel
Aug 20

Review Course Requirements

 

Accessing Student Data Files (On Campus)

  • FILES are located in the CS151 FOLDER.
    • FOLDER 1: CS151\2010\Excel\
      • DRAG Excel Lesson 02 folder to your folder on the Desktop

EXCEL PROJECTS- (To be graded in class)

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

INSTRUCTIONS:

  1. CALL INSTRUCTOR for grading.
  2. CLOSE the files before EMAILING.
  3. EMAIL your completed FLastName Bird Census and FLastName Technology Shop as as attachments.
    • To: yvonne.flores@guamcc.edu
    • Cc: your email address
    • Subject: CS151-## Excel Module 1a
  4. VERIFY with instructor FILE RECEIVED. (Look at the board to see if your email is in my Inbox and has a paperclip icon).

 

 

LESSON OBJECTIVES

 

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

Aug 22

Accessing Student Data Files (On Campus)

  • FILES are located in the CS151 FOLDER.
    • FOLDER 1: CS151\Excel\
      • DRAG Excel1 folder to your folder on the Desktop

EXCEL PROJECTS- (To be graded in class)

  1. PRACTICE: Page EX 5 ~ 57 Open FINANCES
  2. Page EX 60 ~ 61 Case Problem 2 Open Balance, Save As: Balance Sheet ( **Don't forget FOOTERS**)

INSTRUCTIONS:

  1. CALL INSTRUCTOR for grading.
  2. CLOSE the files before EMAILING.
  3. EMAIL your completed BALANCE SHEET as an attachment.
    • To: yvonne.flores@guamcc.edu
    • Cc: your email address
    • Subject: CS151-## Excel Module 1b
  4. VERIFY with instructor FILE RECEIVED. (Look at the board to see if your email is in my Inbox and has a paperclip icon).

 

LESSON OBJECTIVES

 

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

Aug 27

Accessing Student Data Files (On Campus)

  • FILES are located in the CS151 FOLDER.
    • FOLDER 1: CS151\Excel\
      • DRAG Excel2 folder to your folder on the Desktop

 

EXCEL PROJECTS- (To be graded in class)

  1. PRACTICE: Page EX 69 ~ 121 Open MORNING
  2. Page EX 125~ 126 Case Problem 1 Open Green, Save As: Green Clean ( **Don't forget FOOTERS**)

INSTRUCTIONS:

  1. CALL INSTRUCTOR for grading.
  2. CLOSE the file before EMAILING.
  3. EMAIL your completed GREEN CLEAN as an attachment.
    • To: yvonne.flores@guamcc.edu
    • Cc: your email address
    • Subject: CS151-## Excel Module 2a
  4. VERIFY with instructor FILE RECEIVED. (Look at the board to see if your email is in my Inbox and has a paperclip icon).

 

Accessing Student Data Files (Off-Campus)

 

LESSON OBJECTIVES

Student Learning Outcomes (SLO) - Microsoft Excel: Module 2a

Aug 29

Accessing Student Data Files (On Campus)

  • FILES are located in the CS151 FOLDER.
    • FOLDER 1: CS151\2010\Excel\
      • DRAG Excel Lesson 05 folder to your folder on the Desktop
    • FOLDER 2: CS151\Excel\
      • DRAG Excel2 folder to your folder on the Desktop

EXCEL PROJECTS- (To be graded in class)

  1. PRACTICE: Exam and Coyotes
  2. Page EX 126 ~ 127 Case Problem 2 (#1 - 14 only) Open Peak, Save As: Peak Bytes (**Don't forget FOOTERS**)

INSTRUCTIONS:

  1. CALL INSTRUCTOR for grading.
  2. CLOSE the file before EMAILING.
  3. EMAIL your completed PEAK BYTES as an attachment.
    • To: yvonne.flores@guamcc.edu
    • Cc: your email address
    • Subject: CS151-## Excel Module 2b
  4. VERIFY with instructor FILE RECEIVED. (Look at the board to see if your email is in my Inbox and has a paperclip icon).

 

Accessing Student Data Files (Off-Campus)

 

LESSON OBJECTIVES

Student Learning Outcomes (SLO) - Microsoft Excel: Module 2b

Sep 3
**HOLIDAY - Labor Day
Sep 5

Accessing Student Data Files (On / Off-Campus)

  • Use FILE EXPLORER
    • GO TO the DOWNLOADS folder
    • DELETE everything in the folder before doing the following.
  • Click on this Link to Google Drive for files.
  • Log in using your guamcc email address.
  • HIGHLIGHT ALL the files (6 files)
    • RIGHT-CLICK on the highlighted files
    • Click DOWNLOAD
  • Files will be downloaded as a ZIP FOLDER to the Downloads folder.
  • Use FILE EXPLORER
  • Go to the DOWNLOADS Folder
    • DRAG the folder to your folder on the Desktop
    • RIGHT-CLICK on the Zip folder
    • Click EXTRACT ALL
    • Click EXTRACT

EXCEL PROJECTS- (To be graded in class)

  1. PRACTICE: Juice, Exam, and Reynolds
  2. There are 3 Projects (Investment, Cheese, Golf).
    • Open each file
    • Instructions are on the worksheet
  3. Make sure to save the file in your folder.

INSTRUCTIONS:

  1. CALL INSTRUCTOR for grading.
  2. CLOSE the files before EMAILING.
  3. EMAIL your completed INVESTMENT, CHEESE AND GOLF as an attachment.
    • To: yvonne.flores@guamcc.edu
    • Cc: your email address
    • Subject: CS151-## Excel Module 3a
  4. VERIFY with instructor FILE RECEIVED. (Look at the board to see if your email is in my Inbox and has a paperclip icon).

 

LESSON OBJECTIVES

Student Learning Outcomes (SLO) - Microsoft Excel: Module 3a

Sep 10
Class Cancelled
Sep 12

Accessing Student Data Files (On / Off-Campus)

  • Use FILE EXPLORER
    • GO TO the DOWNLOADS folder
    • DELETE everything in the folder before doing the following.
    Click on this Link to Google Drive for files.
  • Log in using your guamcc email address.
  • Right-click to Download each file.
  • 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 Open Capshaw, Save As: Capshaw Wages (**Don't forget FOOTERS**)

INSTRUCTIONS:

  1. CALL INSTRUCTOR for grading.
  2. CLOSE the file before EMAILING.
  3. EMAIL your completed CAPSHAW WAGES as an attachment.
    • To: yvonne.flores@guamcc.edu
    • Cc: your email address
    • Subject: CS151-## Excel Module 3b
  4. VERIFY with instructor FILE RECEIVED. (Look at the board to see if your email is in my Inbox and has a paperclip icon).

 

 

LESSON OBJECTIVES

Student Learning Outcomes (SLO) - Microsoft Excel: Module 3b

Sep 17

Accessing Student Data Files (On / Off-Campus)

  • Use FILE EXPLORER
    • GO TO the DOWNLOADS folder
    • DELETE everything in the folder before doing the following.
    Click on this Link to Google Drive for files.
  • Log in using your guamcc email address.
  • Right-click to Download each file.
  • Open the Downloads folder, Drag the 2 files to your folder.

EXCEL PROJECTS- (To be graded in class)

  1. PRACTICE: Backspace (Pie, Clustered Column, Combo Charts)
  2. Page EX 251 (#4 - 13 ONLY) Review Assignment Open Market, Save As: Market Analysis (**Don't forget FOOTERS**)

INSTRUCTIONS:

  1. CALL INSTRUCTOR for grading.
  2. CLOSE the file before EMAILING.
  3. EMAIL your completed Market Analysis as an attachment.
    • To: yvonne.flores@guamcc.edu
    • Cc: your email address
    • Subject: CS151-## Excel Module 4a
  4. VERIFY with instructor FILE RECEIVED. (Look at the board to see if your email is in my Inbox and has a paperclip icon).

 

 

Student Learning Outcomes (SLO) - Microsoft Excel: Module 4a

Sep 19

Accessing Student Data Files (On / Off-Campus)

  • Use FILE EXPLORER
    • GO TO the DOWNLOADS folder
    • DELETE everything in the folder before doing the following.
    Click on this Link to Google Drive for files.
  • Log in using your guamcc email address.
  • Right-click to Download each file.
  • Open the Downloads folder, Drag the 4 files to your folder.

 

EXCEL PROJECTS- (To be graded in class)

  1. PRACTICE: Salary and Crystal
  2. Instructions for Zoom is on the worksheet.
    • Filename: (Zoom Salaries) (**Don't forget FOOTERS**)
  3. Instructions for Vote is on the worksheet.
    • Filename: (Vote Tally) (**Don't forget FOOTERS**)

INSTRUCTIONS:

  1. CALL INSTRUCTOR for grading.
  2. CLOSE the file before EMAILING.
  3. EMAIL your completed Zoom Salaries and Vote Tally as an attachment.
    • To: yvonne.flores@guamcc.edu
    • Cc: your email address
    • Subject: CS151-## Excel Module 4b
  4. VERIFY with instructor FILE RECEIVED. (Look at the board to see if your email is in my Inbox and has a paperclip icon).

 

Student Learning Outcomes (SLO) - Microsoft Excel: Module 4b

 

Excel Review Topics

BEFORE LEAVING EVERY CLASS

  1. SIGN OUT of your Email.
  2. DELETE everything in the DOWNLOADS folder
  3. DELETE your Folder.
  4. EMPTY Recycle Bin
  5. CLEAR YOUR BROWSER HISTORY
  6. CLEAN-UP up your Work Area.
  7. CLOSE all Open Windows
Sep 24

Microsoft Excel Mastery Assessment

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

© 2018 Yvonne C. Flores, Guam Community College