Excel 2007
Chapter 6:
Creating Templates & Working with Multiple Worksheets and Workbooks
All assignments on this page are due on 10 May, and may not be accepted for full credit past 14 May.
Chapter 6 Lessons |
eBook Lesson 6:
Creating Templates & Working with Multiple Worksheets and Workbooks
|
Files to turn in:
LN NextDVR Profit Potential.xlsx
LN NVDR Company Profit Potental.xltx (template)
LN NVDR Kansas City Profit Potental.xlsx
LN NVDR Louisville Profit Potental.xlsx
LN NVDR Portland Profit Potental.xlsx
LN NextDVR Workspace.xlsx
|
Rubric
|
20 points
|
Chapter 6
Review & Practice:
|
eBook Review Activities:
Apply Your Knowledge
Extend Your Knowledge
Make It Right
In the Lab
Lab 6-1
Lab 6-2
Lab 6-3
|
Files to turn in:
LN Apply 6-1 Annual Payroll Totals Complete.xlsx (skip printouts)
LN Extend 6-1 Tennis Summary Complete.xlsx
LN Make It Right 6-1 Gems for Everyone Complete.xlsx
LN Lab 6-1 Part 1 Rings and Things Annual Sales Analysis.xlsx
LN Lab 6-1 Part 2 Rings and Things Annual Sales Analysis.xlsx
LN Lab 6-1 Part 3 Rings and Things Annual Sales Analysis.xlsx
(skip printouts)
Folder (zipped) containing:
LN Lab 6-2 Part 1 Emp Annual Payroll Totals.xlsx
+ all support files
LN Lab 6-2 Part 2 Emp Annual Payroll Totals.xlsx
+ any changed support files
(skip printouts)
LN Lab 6-3 Learn-N-Earn Stock Club Portfolio.xlsx
(skip printouts)
|
Rubric
Rubric
Rubric
Rubric
Rubric
Rubric
|
10 points
10 points
10 points
40 points
25 points
20 points
|
Chapter 6 Assessments
Complete as Homework!
|
Vocab Quiz 6 (Quia)
Quia Review Worksheet 6 |
points
points
|
Chapter 6:
Reflection Question
Complete as Homework!
|
Copy and paste the questions below into a new email message.
Add the subject line Excel RQ 6
Answer each question fully as directed in the RQ guidelines & Rubric page
Send the email to kerri.pangman@eu.dodea.edu
. |
15 points
|
|