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
- Task
#1 - Create Folders (Click on Link)
- Task
#2 (Day1 Assessment / Participation)
- Task
#3 - Zip Your Folder / Email to Me (Click on Link)
- Task
#4 - Email Contact Info (Click on Link)
AFTER
COMPLETING Task #1 - 4,
- Verify
with instructor Zip folder received.
- 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)
- PRACTICE:
(Birds Census)- **Don't forget FOOTERS**
- PROJECT
1-2: (Technology Shop)**Don't
forget FOOTERS**
INSTRUCTIONS:
- CALL
INSTRUCTOR for grading.
- CLOSE
the files before EMAILING.
- 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
- 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)
- PRACTICE:
Page EX 5 ~ 57 Open FINANCES
- Page
EX 60 ~ 61 Case Problem 2 Open Balance, Save As: Balance Sheet
( **Don't
forget FOOTERS**)
INSTRUCTIONS:
- CALL
INSTRUCTOR for grading.
- CLOSE
the files before EMAILING.
- EMAIL
your completed BALANCE SHEET as an attachment.
- To:
yvonne.flores@guamcc.edu
- Cc:
your email address
- Subject:
CS151-## Excel Module 1b
- 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)
- PRACTICE:
Page EX 69 ~ 121 Open MORNING
- Page
EX 125~ 126 Case Problem 1 Open Green, Save As: Green Clean (
**Don't
forget FOOTERS**)
INSTRUCTIONS:
- CALL
INSTRUCTOR for grading.
- CLOSE
the file before EMAILING.
- EMAIL
your completed GREEN CLEAN as an attachment.
- To:
yvonne.flores@guamcc.edu
- Cc:
your email address
- Subject:
CS151-## Excel Module 2a
- 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)
- PRACTICE:
Exam and Coyotes
- Page
EX 126 ~ 127 Case Problem 2 (#1 - 14 only) Open Peak, Save As: Peak
Bytes (**Don't
forget FOOTERS**)
INSTRUCTIONS:
- CALL
INSTRUCTOR for grading.
- CLOSE
the file before EMAILING.
- EMAIL
your completed PEAK BYTES as an attachment.
- To:
yvonne.flores@guamcc.edu
- Cc:
your email address
- Subject:
CS151-## Excel Module 2b
- 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)
- PRACTICE:
Juice, Exam, and Reynolds
- 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:
- CALL
INSTRUCTOR for grading.
- CLOSE
the files before EMAILING.
- EMAIL
your completed INVESTMENT, CHEESE AND GOLF as an attachment.
- To:
yvonne.flores@guamcc.edu
- Cc:
your email address
- Subject:
CS151-## Excel Module 3a
- 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)
- Page
EX 183 ~ 184 Case Problem 2 Open Capshaw, Save As: Capshaw Wages (**Don't
forget FOOTERS**)
INSTRUCTIONS:
- CALL
INSTRUCTOR for grading.
- CLOSE
the file before EMAILING.
- EMAIL
your completed CAPSHAW WAGES as an attachment.
- To:
yvonne.flores@guamcc.edu
- Cc:
your email address
- Subject:
CS151-## Excel Module 3b
- 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)
- PRACTICE:
Backspace (Pie, Clustered Column, Combo Charts)
- Page
EX 251 (#4 - 13 ONLY) Review Assignment Open Market,
Save As: Market Analysis (**Don't
forget FOOTERS**)
INSTRUCTIONS:
- CALL
INSTRUCTOR for grading.
- CLOSE
the file before EMAILING.
- EMAIL
your completed Market Analysis
as an attachment.
- To:
yvonne.flores@guamcc.edu
- Cc:
your email address
- Subject:
CS151-## Excel Module 4a
- 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)
- PRACTICE:
Salary and Crystal
- Instructions
for Zoom is on the worksheet.
- Filename:
(Zoom Salaries) (**Don't
forget FOOTERS**)
- Instructions
for Vote is on the worksheet.
- Filename:
(Vote Tally) (**Don't
forget FOOTERS**)
INSTRUCTIONS:
- CALL
INSTRUCTOR for grading.
- CLOSE
the file before EMAILING.
- 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
- 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
|
|
BEFORE
LEAVING EVERY CLASS
- SIGN
OUT
of your Email.
- DELETE
everything
in the DOWNLOADS folder
- DELETE
your Folder.
- EMPTY
Recycle Bin
- CLEAR
YOUR BROWSER HISTORY
- CLEAN-UP
up your Work Area.
- 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.)
|