**ALL PROJECTS are to be COMPLETED IN CLASS and DUE on the day assigned.

1. Task #1 - Create Folders (Click on Link)
2. Task #2 - Zip Your Folder / Email to Me (Click on Link)
3. Task #3 - Email Contact Info (Click on Link)
4. Task #4 - Syllabus Received & Reviewed

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: (Birds Census)- **Don't forget FOOTERS**
2. CLICK on LINK: PROJECT 1-2: (Technology Shop)**Don't forget FOOTERS**

INSTRUCTIONS:

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

Accessing Student Data Files (Off-Campus)

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

LESSON OBJECTIVES

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

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 as attachment.
   • To: yvonne.flores@guamcc.edu
   • Cc: your email address
   • Subject: CS151-## Excel Module 1b
4. VERIFY with instructor FILES 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.
• Log in using your guamcc email address.
• Right-click to Download each file.
• Open the Downloads folder, Drag the 2 files to your folder.

LESSON OBJECTIVES

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

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 Module folder, open MORNING
2. Page EX 125~ 126 Case Problem 1 #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 as as attachment.
   • To: yvonne.flores@guamcc.edu
   • Cc: your email address
   • Subject: CS151-## Excel Module 2a
4. VERIFY with instructor FILES 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.
• Log in using your guamcc email address.
• Right-click to Download each file.
• Open the Downloads folder, Drag the 2 files to your folder.

LESSON OBJECTIVES

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

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 Excel1 folder to your folder on the Desktop

EXCEL PROJECTS- (To be graded in class)

1. PRACTICE: Exam and Coyotes
2. Page EX 62 ~ 63 Case Problem 3 (#1-21 ONLY) - **Don't forget FOOTERS**

INSTRUCTIONS:

1. CALL INSTRUCTOR for grading.
2. CLOSE the files before EMAILING.
3. EMAIL your completed FTP Report as as attachment.
   • To: yvonne.flores@guamcc.edu
   • Cc: your email address
   • Subject: CS151-## Excel Module 2b
4. VERIFY with instructor FILES 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.
• Log in using your guamcc email address.
• Right-click to Download each file.
• Open the Downloads folder, Drag the 3 files to your folder.

LESSON OBJECTIVES

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

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 Excel3 folder to your folder on the Desktop

EXCEL PROJECTS- (To be graded in class)

1. PRACTICE: Exam, Golf and Reynolds
2. Complete the following Step-by-Step Module: Page EX134 ~ 151
   • **Don't forget FOOTERS on the Yield worksheet**

INSTRUCTIONS:

1. CALL INSTRUCTOR for grading.
2. CLOSE the files before EMAILING.
3. EMAIL your completed Wingait Farm as as attachment.
   • To: yvonne.flores@guamcc.edu
   • Cc: your email address
   • Subject: CS151-## Excel Module 3a
4. VERIFY with instructor FILES 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.
• Log in using your guamcc email address.
• Right-click to Download each file.
• Open the Downloads folder, Drag the 3 files to your folder.

LESSON OBJECTIVES

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

Accessing Student Data Files (On Campus)

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

EXCEL PROJECTS- (To be graded in class)

1. PRACTICE: Juice
2. Page EX 183 ~ 184 Case Problem 2
   • **Don't forget FOOTERS on the 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 as attachment.
   • To: yvonne.flores@guamcc.edu
   • Cc: your email address
   • Subject: CS151-## Excel Module 3b
4. VERIFY with instructor FILES 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.
• Log in using your guamcc email address.
• Right-click to Download each file.
• Open the Downloads folder, Drag the 2 files to your folder.

LESSON OBJECTIVES

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

• FILES are located in the CS151 FOLDER.
  • DRAG CS151\Excel\Excel4

EXCEL PROJECTS- (To be graded in class)

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

INSTRUCTIONS:

1. CALL INSTRUCTOR for grading.
2. CLOSE the files before EMAILING.
3. EMAIL your completed Market Analysis as as attachment.
   • To: yvonne.flores@guamcc.edu
   • Cc: your email address
   • Subject: CS151-## Excel Module 4a
4. VERIFY with instructor FILES 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.
• Log in using your guamcc email address.
• Right-click to Download each file.
• Open the Downloads folder, Drag the 2 files to your folder.

LESSON OBJECTIVES

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

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)
3. CLICK on LINK for Instructions: (Vote)

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

Accessing Student Data Files (Off-Campus)

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

LESSON OBJECTIVES

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

Excel Assessment Review Topics

BEFORE LEAVING EVERY CLASS

1. SIGN OUT of your MyGCC portal.
2. DELETE your Folder on the Desktop.
3. RIGHT-CLICK **Empty Recycle Bin**.
4. CLEAR YOUR BROWSER HISTORY (keyboard shortcut CTRL H).
5. CLEAN-UP up your Work Area and Return all equipment to the proper location.
6. CLOSE all Open Windows