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)
- Project
1-1: (Birds Census)- **Don't forget FOOTERS**
- Project
1-2: (Technology Shop)**Don't
forget FOOTERS**
Instructions:
- PRINT
Technology Shop**(Print in Landscape if needed to fit on one
page).
- EMAIL
both files as attachments.
- To:
yvonne.flores@guamcc.edu
- Cc:
your email address
- Subject:
CS151-## Excel Module 1a
- DRAG
both files into your Google Drive
- CALL
ME for grading.
- 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)
- Page
EX 60 ~ 61 Case
Problem 2
- Filename:
(FLastName Balance Sheet)
Instructions:
- PRINT
Balance Sheet
- Scale
to Fit so it fits on one page.
- EMAIL
file as an attachment.
- To:
yvonne.flores@guamcc.edu
- Cc:
your email address
- Subject:
CS151-## Excel Module 1b
- DRAG
file into your Google Drive
- CALL
ME for grading.
- DELETE:
- Everything
in the Downloads folder
- Your
FOLDER on the Desktop
- EMPTY
RECYCLE BIN - (Right-click)
|
SLO
- Microsoft Excel: Module 1b
|
Jan
23 |
Access
Student Data Files:
|
Excel
Project - (To be graded in class)
- Page
EX 125 ~ 126 Case
Problem 1 (Green Clean)
- Filename:
(FLastName Green Clean)
- **Don't
forget FOOTERS only on the Income Statement Worksheet**
Instructions:
- PRINT
Income Statement Worksheet ONLY
- Print
in Landscape Orientation.
- Scale
to Fit so it fits on one page.
- EMAIL
file as an attachment.
- To:
yvonne.flores@guamcc.edu
- Cc:
your email address
- Subject:
CS151-## Excel Module 2a
- DRAG
file into your Google Drive
- CALL
ME for grading.
- DELETE:
- Everything
in the Downloads folder
- Your
FOLDER on the Desktop
- EMPTY
RECYCLE BIN - (Right-click)
|
SLO
- Microsoft Excel: Module 2a
|
Jan
25 |
Access
Student Data Files:
|
Excel
Project - (To be graded in class)
- 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:
- Set
your Print Area to the Range (A1:D9) ONLY
- PRINT
Speed Test Worksheet ONLY
- EMAIL
file as an attachment.
- To:
yvonne.flores@guamcc.edu
- Cc:
your email address
- Subject:
CS151-## Excel Module 2b
- DRAG
file into your Google Drive
- CALL
ME for grading.
- DELETE:
- Everything
in the Downloads folder
- Your
FOLDER on the Desktop
- EMPTY
RECYCLE BIN - (Right-click)
|
SLO
- Microsoft Excel: Module 2b
|
Jan
30 |
Access
Student Data Files:
-
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.
|
Excel
Projects:
(To
be graded in class)
- There
are 3 Projects (Investment, Cheese, Golf).
- Open
each file, instructions are on the worksheet.
- Make
sure to save the file in your folder.
Instructions:
- EMAIL
files as an attachment.
- To:
yvonne.flores@guamcc.edu
- Cc:
your email address
- Subject:
CS151-## Excel Module 3a
- DRAG
file into your Google Drive
- CALL
ME for grading.
- DELETE:
- Everything
in the Downloads folder
- Your
FOLDER on the Desktop
- EMPTY
RECYCLE BIN - (Right-click)
|
SLO
- Microsoft Excel: Module 3a
|
Feb
1 |
Access
Student Data Files:
-
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)
- Page
EX 183~ 184
Case Problem 2 (Capshaw Wages)
- Filename:
(FLastName Capshaw Wages)
- **Don't
forget FOOTERS only on the Work Schedule Worksheet**
Instructions:
- EMAIL
file as an attachment.
- To:
yvonne.flores@guamcc.edu
- Cc:
your email address
- Subject:
CS151-## Excel Module 3b
- DRAG
file into your Google Drive
- CALL
ME for grading.
- DELETE:
- Everything
in the Downloads folder
- Your
FOLDER on the Desktop
- EMPTY
RECYCLE BIN - (Right-click)
|
SLO
- Microsoft Excel: Module 3b
|
Feb
6 |
Access
Student Data Files:
-
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)
- **Don't
forget FOOTERS**
- Instructions
for Starburst is on the worksheet.
- Filename:
(FLastName Starburst Growth)
- Page
EX 251 Review
(Market Analysis) (
#4 - 13 only)
- Filename:
(FLastName Market Analysis)
Instructions:
- EMAIL
2 files as an attachment.
- To:
yvonne.flores@guamcc.edu
- Cc:
your email address
- Subject:
CS151-## Excel Module 4a
- DRAG
file into your Google Drive
- CALL
ME for grading.
- DELETE:
- Everything
in the Downloads folder
- Your
FOLDER on the Desktop
- EMPTY
RECYCLE BIN - (Right-click)
|
SLO
- Microsoft Excel: Module 4a |
Feb
8 |
Access
Student Data Files:
-
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 5 files to your folder.
|
Excel
Projects:
(To
be graded in class)
- **Don't
forget FOOTERS**
- Instructions
for National is on the worksheet.
- Filename:
(FLastName National Bank)
- Instructions
for Zoom is on the worksheet.
- Filename:
(FLastName Zoom Salaries)
- Instructions
for Vote is on the worksheet.
- Filename:
(FLastName Vote Tally)
Instructions:
- EMAIL
3 files as an attachment.
- To:
yvonne.flores@guamcc.edu
- Cc:
your email address
- Subject:
CS151-## Excel Module 4b
- DRAG
file into your Google Drive
- CALL
ME for grading.
- DELETE:
- Everything
in the Downloads folder
- Your
FOLDER on the Desktop
- EMPTY
RECYCLE BIN - (Right-click)
|
SLO
- Microsoft Excel: Module 4b
|
Feb
13 |
Access
Student Data Files:
-
Click on this Link to Google Drive for files.
- Log
in using your guamcc email address.
- Right-click
to Download the file.
- Open
the Downloads folder, Drag the file to your folder.
|
|
|
|
|
|