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

1. Task #1 - Create Shared Google Drive Folders (Click on Link)
2. Task #2 - Email Contact Information (Click on Link)
3. Task #3
• Read the entire Syllabus carefully.
• Check Your Email after 5:30 pm for Task#3.
• Complete Task #3 before the next class.

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 Attachments.
   • To: yvonne.flores@guamcc.edu
   • Cc: your email address
   • Subject: CS151-## (replace ## with your section number) Excel Module 1a

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 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. Open Excel1> Module Folder - IN-CLASS DEMONSTRATION: Page EX 5 ~ 57 Module folder, Open FINANCES
2. Open Excel1> Folder - 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 (solution) as as attachment.
   • To: yvonne.flores@guamcc.edu
   • Cc: your email address
   • Subject: CS151-## (replace ## with your section number) 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

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

SLO - Microsoft Excel: Module 2a

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. Open Excel2 > Module Folder - IN-CLASS DEMONSTRATION: Open MORNING
2. Open Excel1 > Case Problem 3 Folder - Page EX 62 ~ 63 (#1-21 ONLY) - FTP-Instructions **Don't forget FOOTERS**
3. Open Excel2 > Case Problem 2 Folder - Page EX 126 ~ 127 (#1-13 ONLY) - Peak-Instructions, **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 & Part I-Excel Mastery Assessment

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

SLO - Microsoft Excel: Module 2b

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. Open Excel Lesson 05 Folder - IN-CLASS DEMONSTRATION Open Exam, Reynolds
2. Open Excel3 > Review Folder - Page EX 181 (#1-9 ONLY) - **Don't forget FOOTERS on YIELD Worksheet**

INSTRUCTIONS:

1. CALL INSTRUCTOR for grading.
2. CLOSE the files before EMAILING.
3. EMAIL your completed Soybean Crop (solution) as as attachment.
   • 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 3 files to your folder.

LESSON OBJECTIVES

SLO - Microsoft Excel: Module 3a

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. Open Excel Lesson 04 Folder - IN-CLASS DEMONSTRATION Open Juice
2. Open Excel3 > Case 2 Folder - Page EX 183 ~ 184 (#3-16 ONLY)
   • **Don't forget FOOTER on Work Schedule worksheet**
   • #11, #14 Do not use the VLOOKUP function

INSTRUCTIONS:

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

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

SLO - Microsoft Excel: Module 3b

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

EXCEL PROJECTS- (To be graded in class)

1. Open Excel4 > Module Folder, - IN-CLASS DEMONSTRATION EX 198 ~ 215 Open Backspace (Pie, Clustered Column. Stacked Column)
2. Open 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. Open 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

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

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 (Click on Link)

**DO NOT BRING YOUR BOOK**

**Part II - Excel Mastery Assessment**

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