Unit 4: Spreadsheets

1. Class Notes

2. Class Exercises - to practice and expand your Excel application skills

3. Independent Activities - to demonstrate your Excel application skills and various required topic knowledge

4. Excel Quiz

5. Spreadsheet Summative Assignment: Candies

* "How to Guide" to Microsoft Excel (reference notes)

* "Formatting Guide" to Microsoft Excel (reference notes)

* "Graphing Guide" for Microsoft Excel (reference notes)

See below for worksheet, note, and assignment files.

Excel How To NOTE.pdf

Microsoft Excel - How To Guide

Excel Formatting NOTE.pdf

Microsoft Excel - Formatting Guide

Spreadsheet Graphing NOTE.pdf

Microsoft Excel - Graphing Guide

Class Exercises:

Yard Masters Requirements.pdf

Yard Masters - class exercise instructions

Yard Masters ROUGH.xlsx

Yard Masters - ROUGH

Yard Masters GOOD COPY.pdf

Yard Masters - COMPLETE

GraphExample_Bar_ROUGH.xlsx

Bar Graph - ROUGH

GraphExample_Bar_GOOD COPY.pdf

Bar Graph - COMPLETE

GraphExample_Line_ROUGH.xlsx

Line Graph - ROUGH

GraphExample_Line_GOOD COPY.pdf

Line Graph - COMPLETE

GraphExample_Pie_ROUGH.xlsx

Pie Graph - ROUGH

GraphExample_Pie_GOOD COPY.pdf

Pie Graph - COMPLETE

Independent Activities:

1. Grocery Shopping Requirements.pdf

Grocery Shopping - assignment

1. GroceryShopping_ROUGH.xlsx

Grocery Shopping - ROUGH

2. Home Expenses Requirements.pdf

Home Expenses - assignment

2. HomeExpenses_ROUGH.xlsx

Home Expenses - ROUGH

3. Veggie Spot Requirements.pdf

Veggie Spot - assignment

3. VeggieSpot_ROUGH.xlsx

Veggie Spot - ROUGH

4. Bowling Requirements.pdf

Bowling - assignment

4. Bowling_ROUGH.xlsx

Bowling - ROUGH

5. Baseball Requirements.pdf

Baseball - assignment

5. Baseball_ROUGH.xlsx

Baseball - ROUGH

6. Payroll Requirements.pdf

Payroll - assignment

6. Payroll_ROUGH.xlsx

Payroll - ROUGH

7. Composition Requirements.pdf

Composition - assignment

7. Composition_ROUGH.xlsx

Composition - ROUGH

8. Marks Requirements.pdf

Marks - assignment

8. Marks_ROUGH.xlsx

Marks - ROUGH

9. CanadaPopulation Requirements.pdf

Canada's Population - assignment

9. CanadaPopulation_ROUGH.xlsx

Canada's Population - ROUGH

Summative Assignment:

Candies Requirements.pdf

Candies - assignment

Candies Marking Key.pdf

Candies - rubric