Back to School Supplies
Expense Spreadsheet w/ Chart
Assignment: Students create an expense chart using a spreadsheet to show how much they have spent on school supplies. Students use the autosum formula to easily calculate the total expense costs.
Download: excel-school-supplies-expenses-finished-example.xlsx
Excel School Supplies Expenses - Finished Example
![Excel School Supplies Expenses - Finished Example](https://oakdome.com/k5/lesson-plans/excel/images/excel-school-supplies-expenses.gif)
Download: excel-school-supplies-price-list.pdf
School Supplies Prices List
Students choose school supplies from this list for their spreadsheet.
![School Supplies Prices List](https://oakdome.com/k5/lesson-plans/excel/images/excel-school-supplies-price-list.gif)
Download: school-supplies-expense-spreadsheet-with-chart-instructions.pdf
Student Instructions
![Student Instructions](https://oakdome.com/k5/lesson-plans/excel/images/excel-school-supplies-expense-spreadsheet-instructions-550.gif)
Excel Mini-Course in 4 Minutes:
![](https://oakdome.com/k5/graphics/blue-play-btn-200.png)
Quickly learn the essentials you need for this lesson with these short, focused video tutorials. Watch all the videos to see how to create a budget and chart from start to finish or just watch the ones you need.
This Excel Lesson
Teaches the Following Basic Skills:
- Creating and formatting a spreadsheet title using "merge and center"
- Entering data in columns and rows
- Using the simple formula "Autosum" to automatically calculate total expenses
- Formatting numbers as currency and adding $ signs.
- Creating a chart using the data entered.
- Using different colors for chart bars to improve visual presentation
- Creating, sizing, and positioning the chart to fit on a single page with the data
- Searching, inserting, sizing, and positioning clipart or pictures
- Using print preview and printing
Download: rubric-for-spreadsheet-with-chart.pdf
Excel Spreadsheet Rubric for Grading Assignments
![Excel Spreadsheet Rubric for Grading Assignments](https://oakdome.com/k5/lesson-plans/excel/images/spreadsheet-rubric.gif)