COURSE SCHEDULE

(Last Revised: September 17, 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 15 Course Overview, Discuss Syllabus, Expectations, Participation Complete before leaving class:
  1. Task #1 - Create Folders (Click on Link)
  2. Task #2 - Zip Your Folder and Email to Me (Click on Link)
  3. Task #3 - Email Contact Information (Click on Link)
  4. Task #4
    • Read the entire Syllabus.
    • Check Your Email after today's class for Task#4.
    • Complete Task #4 before the next class.
Aug 20 - Sep 17
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. CLICK on LINK for Instructions: (Birds Census)- **Don't forget FOOTERS**
  2. CLICK on LINK for Instructions: (Technology Shop)**Don't forget FOOTERS**

INSTRUCTIONS:

  1. CALL INSTRUCTOR for grading.
  2. CLOSE the files before EMAILING.
  3. EMAIL your completed FLastName Birds Census (solution) and FLastName Technology Shop (solution) as as Attachments.
    • To: yvonne.flores@guamcc.edu
    • Cc: your email address
    • Subject: CS151-## Excel Module 1a

 

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. Excel1 > Module Folder - IN-CLASS DEMONSTRATION: Page EX 5 ~ 57 Open FINANCES
  2. Excel1 > Case Problem 2 Folder - Page EX 60 ~ 61 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 (solution) as as attachment.
    • To: yvonne.flores@guamcc.edu
    • Cc: your email address
    • Subject: CS151-## Excel Module 1b

 

Accessing Student Data Files (Off-Campus)

  • Click on this Link to Google Drive for files. (Use your guamcc email address).
  • Right-click to Download each file.
  • Depending on your computer, the files might download to the Desktop, or the Downloads folder, or another location depending on the setup of your computer.
  • Drag the 2 files to your folder.

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. Excel2 > Module Folder - IN-CLASS DEMONSTRATION: Page EX 69 ~ 121 Open MORNING
  2. Excel2 > Case Problem 1 Folder - Page EX 125~ 126 (#6-12 ONLY) - **Don't forget FOOTERS**

INSTRUCTIONS:

  1. CALL INSTRUCTOR for grading.
  2. CLOSE the files before EMAILING.
  3. EMAIL your completed Green Clean (solution) as as attachment.
    • To: yvonne.flores@guamcc.edu
    • Cc: your email address
    • Subject: CS151-## Excel Module 2a

 

Accessing Student Data Files (Off-Campus)

  • Click on this Link to Google Drive for files.(Use your guamcc email address).
  • Right-click to Download each file.
  • Depending on your computer, the files might download to the Desktop, or the Downloads folder, or another location depending on the setup of your computer.
  • Drag the 2 files to your folder.
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.
    • FOLDERS: CS151\Excel\
      • DRAG Excel1 and Excel2 folders to your folder on the Desktop

EXCEL PROJECTS- (To be graded in class)

  1. Excel2 > Module Folder - IN-CLASS DEMONSTRATION: Open MORNING
  2. Excel1 > Case Problem 3 Folder - Page EX 62 ~ 63 (#1-21 ONLY) - **Don't forget FOOTERS**
  3. Excel2 > Case Problem 2 Folder - Page EX 126 ~ 127 (#1-14 ONLY) - **Don't forget FOOTERS**

INSTRUCTIONS:

  1. CALL INSTRUCTOR for grading.
  2. CLOSE the files before EMAILING.
  3. EMAIL your completed FTP Report (solution) and Peak Bytes (solution) as as attachment.
    • To: yvonne.flores@guamcc.edu
    • Cc: your email address
    • Subject: CS151-## Excel Module 2b

 

Accessing Student Data Files (Off-Campus)

  • Click on this Link to Google Drive for files. (Use your guamcc email address).
  • Right-click to Download each file.
  • Depending on your computer, the files might download to the Desktop, or the Downloads folder, or another location depending on the setup of your computer.
  • Drag the 3 files to your folder.

LESSON OBJECTIVES

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

Accessing Student Data Files (On Campus)

  • FILES are located in the CS151 FOLDER.
    • DRAG CS151\2010\Excel\Excel Lesson 05
    • DRAG CS151\Excel\Excel3

EXCEL PROJECTS- (To be graded in class)

  1. Excel Lesson 05 Folder - IN-CLASS DEMONSTRATION Open Coyotes, Exam, Golf, Reynolds
  2. Excel3 > Module Folder - Complete Step-By-Step Page EX 134 ~ 151 - **Don't forget FOOTERS on YIELD and YIELD HISTORY Worksheet**

INSTRUCTIONS:

  1. CALL INSTRUCTOR for grading.
  2. CLOSE the files before EMAILING.
  3. EMAIL your completed Wingait Farms as attachment.
    • Yield and Yield History solution
    • To: yvonne.flores@guamcc.edu
    • Cc: your email address
    • Subject: CS151-## Excel Module 3a

 

Accessing Student Data Files (Off-Campus)

  • Click on this Link to Google Drive for files. (Use your guamcc email address).
  • Right-click to Download each file.
  • Depending on your computer, the files might download to the Desktop, or the Downloads folder, or another location depending on the setup of your computer.
  • Drag the 4 files to your folder.

 

LESSON OBJECTIVES

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

 
Sep 5

Accessing Student Data Files (On Campus)

  • FILES are located in the CS151 FOLDER.
    • DRAG CS151\2010\Excel\Excel Lesson 04
    • DRAG CS151\Excel\Excel3

 

EXCEL PROJECTS- (To be graded in class)

  1. Excel Lesson 04 Folder - IN-CLASS DEMONSTRATION Open Juice
  2. Excel3 > Case 2 Folder - Page EX 183 ~ 184
    • **Don't forget FOOTER on Work Schedule worksheet**
    • #11 Do not use the VLOOKUP function, just look at the table for Federal and click the cell for Single, 1 allowance
    • #14 Do not use the VLOOKUP function, just look at the table for State & Local and click the cell for Single, 1 allowance

INSTRUCTIONS:

  1. CALL INSTRUCTOR for grading.
  2. CLOSE the files before EMAILING.
  3. EMAIL your completed Capshaw Wages as attachment.

Accessing Student Data Files (Off-Campus)

  • Click on this Link to Google Drive for files. (Use your guamcc email address).
  • Right-click to Download each file.
  • Depending on your computer, the files might download to the Desktop, or the Downloads folder, or another location depending on the setup of your computer.
  • Drag the 2 files to your folder.

LESSON OBJECTIVES

Student Learning Outcomes (SLO) - Microsoft Excel: Module 3b
Sep 10 Accessing Student Data Files (On Campus)
  • FILES are located in the CS151 FOLDER.
    • DRAG CS151\Excel\Excel 4

EXCEL PROJECTS- (To be graded in class)

  1. Excel4 > Module Folder, - IN-CLASS DEMONSTRATION EX 198 ~ 215 Open Backspace (Pie, Clustered Column. Stacked Column)
  2. Excel4 > Review Folder - Page EX 251 (#4-9 ONLY)
    • **Don't forget FOOTERS on the Market Analysis Sheet**
    • Change Page Orientation to Landscape
    • Scale to Fit on One Page
  3. Excel4 > Case 2 Folder - Page EX 253 (#3-8 ONLY)
    • **Don't forget FOOTERS on the Summary Sheet**
    • Change Page Orientation to Landscape
    • Scale to Fit on One Page

INSTRUCTIONS:

  1. CALL INSTRUCTOR for grading.
  2. CLOSE the files before EMAILING.
  3. EMAIL your completed Market Analysis (solution) and Circuit Realty (solution) as attachments.
    • To: yvonne.flores@guamcc.edu
    • Cc: your email address
    • Subject: CS151-## Excel Module 4a

Accessing Student Data Files (Off-Campus)

  • Click on this Link to Google Drive for files. (Use your guamcc email address).
  • Right-click to Download each file.
  • Depending on your computer, the files might download to the Desktop, or the Downloads folder, or another location depending on the setup of your computer.
  • Drag the 3 files to your folder.

LESSON OBJECTIVES

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

**DO NOT BRING YOUR BOOK**

Accessing Student Data Files (On Campus)

  • FILES are located in the CS151 FOLDER.
    • DRAG CS151\2010\Excel\Excel Lesson 06
    • DRAG CS151\2010\Excel\Excel Lesson 07

 

EXCEL PROJECTS- (To be graded in class)

  1. PRACTICE: Salary and Crystal
  2. CLICK on LINK for Instructions: (Zoom) **Don't forget FOOTERS**
  3. CLICK on LINK for Instructions: (Vote) **Don't forget FOOTERS**

INSTRUCTIONS:

  1. CALL INSTRUCTOR for grading.
  2. CLOSE the files before EMAILING.
  3. EMAIL your completed Zoom Salaries (solution) and Vote Tally (solution) as attachments.
    • 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).

Accessing Student Data Files (Off-Campus)

  • Click on this Link to Google Drive for files. (Use your guamcc email address).
  • Right-click to Download each file.
  • Depending on your computer, the files might download to the Desktop, or the Downloads folder, or another location depending on the setup of your computer.
  • Drag the 4 files to your folder.

LESSON OBJECTIVES

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

Excel Assessment Review Topics
Sep 17

**DO NOT BRING YOUR BOOK**

**Excel 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