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 Price List:

Students can download this supplies list and shop online for prices of all the items to create their spreadsheet data.

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.

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

Download: rubric-for-spreadsheet-with-chart.pdf