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.
|
Jan
8 |
Course
Overview, Discuss Syllabus, Expectations, Participation |
Complete
before leaving class:
- Task
#1 - Create Shared Google Drive Folders (Click on Link)
- Task
#2 - Email Contact Information (Click on Link)
- Task
#3
- Read
the entire Syllabus carefully.
- Check
Your Email after 5:30 pm for Task#3.
- Complete
Task #3 before the next class.
|
Jan
13 - |
Introduction
to Microsoft Excel
|
Jan
13 |
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)
- CLICK
on LINK for Instructions: (Birds Census)- **Don't forget FOOTERS**
- CLICK
on LINK for Instructions: (Technology Shop)**Don't forget FOOTERS**
INSTRUCTIONS:
- CALL
INSTRUCTOR for grading.
- CLOSE
the files before EMAILING.
- 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
|
Jan
15 |
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)
- Open
Excel1> Module Folder
- IN-CLASS DEMONSTRATION: Page EX 5 ~ 57, Open FINANCES
- Open
Excel1> Case 2 Folder - Page EX 60 ~ 61 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 (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
|
Jan
20 |
**HOLIDAY
- MLK Jr. Day**
|
Jan
22 |
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)
- Open
Excel2 > Module Folder - IN-CLASS
DEMONSTRATION:
Page EX 69 ~ 121 Open MORNING
- Open
Excel2 > Case Problem 1 Folder - Page
EX 125~ 126 (#6, 7, 8, 11, 12 ONLY) - **Don't forget FOOTERS**
INSTRUCTIONS:
- CALL
INSTRUCTOR for grading.
- CLOSE
the files before EMAILING.
- 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
|
Jan
27 |
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)
- Open
Excel2 > Module Folder - IN-CLASS
DEMONSTRATION:
Open MORNING
- Open
Excel1 > Case Problem 3 Folder - Page
EX 62 ~ 63 (#1-21 ONLY) -
FTP-Instructions **Don't forget FOOTERS**
- Open
Excel2 > Case Problem 2 Folder - Page
EX 126 ~ 127 (#1-13 ONLY) - Peak-Instructions,
**Don't forget FOOTERS**
INSTRUCTIONS:
- CALL
INSTRUCTOR for grading.
- CLOSE
the files before EMAILING.
- 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
Part
I: Excel Mastery Assessment |
Jan
29 |
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)
- Open
Excel Lesson 05 Folder
- IN-CLASS
DEMONSTRATION
Open Exam, Reynolds
- Open
Excel3 > Review Folder - Page
EX 181
(#1-9 ONLY)
- **Don't forget FOOTERS on YIELD Worksheet**
INSTRUCTIONS:
- CALL
INSTRUCTOR for grading.
- CLOSE
the files before EMAILING.
- 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
|
Feb
3 |
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)
- Open
Excel Lesson 04 Folder
- IN-CLASS
DEMONSTRATION
Open Juice
- 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:
- CALL
INSTRUCTOR for grading.
- CLOSE
the files before EMAILING.
- 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
**DO
NOT MISS THIS IMPORTANT LESSON
|
Feb
5 |
Accessing
Student Data Files (On Campus)
- FILES
are located in the CS151 FOLDER.
|
EXCEL
PROJECTS- (To be graded in class)
- Open
Excel4 > Module Folder,
- IN-CLASS
DEMONSTRATION
EX 198 ~ 215 Open Backspace (Pie, Clustered Column. Stacked Column)
- 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
- 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:
- CALL
INSTRUCTOR for grading.
- CLOSE
the files before EMAILING.
- 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
|
Feb
10 |
**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)
- PRACTICE:
Salary and Crystal
- CLICK
on LINK for Instructions: (Zoom) **Don't forget FOOTERS**
- CLICK
on LINK for Instructions: (Vote) **Don't forget FOOTERS**
INSTRUCTIONS:
- CALL
INSTRUCTOR for grading.
- CLOSE
the files before EMAILING.
- 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)
|
Feb
12 |
**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).
|