Google Sheets Lesson Plan
School Supplies Expenses
Spreadsheet
Assignment: Students create a school supplies expense spreadsheet with chart. Students have $100.00 to spend for school supplies. Students try to purchase everything on the list without going over $100.00. Students create a chart illustrating their purchase expenses.
Google Sheets School Supplies Expense
Budget & Chart Finished Example
![School Supplies Expense Spreadsheet - Finished Example](https://oakdome.com/k5/lesson-plans/google-classroom/images/school-supplies-expenses-finished-example.webp)
School Supplies Price List:
Students can download this supplies list and shop online for prices of all the items to create their spreadsheet data.
![School Supplies List](https://oakdome.com/k5/lesson-plans/google-classroom/images/school-supplies-list-no-prices.webp)
Download: google-sheets-school-supplies-price-list
Student Instructions: Google Sheets
School Supplies Expense
Spreadsheet and Chart
Students use these instructions to guide their Google spreadsheets creations.
![Student Instructions: Google Sheets - School Supplies Expense Spreadsheet and Chart](https://oakdome.com/k5/lesson-plans/google-classroom/images/school-supplies-expense-spreadsheet-instructions-550.webp)
Download: google-sheets-school-supplies-spreadsheet-student-instructions
Students Learn and Practice
the Following Basic Spreadsheet
Skills:
- Creating and formatting a spreadsheet title using "merge and center"
- Entering data in columns and rows
- Using the simple formula "SUM" to automatically calculate total expenses
- Formatting numbers as currency and adding $ signs.
- Creating a chart using the expense data entered.
- Using different colors for chart segments to improve visual presentation
- Creating, sizing, and positioning the chart to fit on a single page with the data
- Searching, inserting, sizing, and positioning a related image
- Using print preview and printing
Spreadsheet Rubric for Grading Assignments
![Excel Spreadsheet Rubric for Grading Assignments](https://oakdome.com/k5/lesson-plans/excel/images/spreadsheet-rubric.gif)
Download: rubric-for-spreadsheet-with-chart.pdf