Google Sheets Lesson Plan
Emergency Supplies Budget Spreadsheet

Assignment: Students create a Emergency Supplies budget with chart. Students have an allowance of $500.00 to purchase emergency supplies. Students shop online for prices using the Emergency Supplies List. Students create a chart illustrating their purchase expenses.

Students create the budget showing how much they have to spend $500.00 (allowance) , and how much each item costs (expenses). Students use the SUM formula to calculate the total costs of the items. Students use a simple formula (allowance - total expenses = money left over) to show how much money is left over (money left over).

Google Sheets Emergency Supplies
Budget & Chart Finished Example

Emergency Supplies List:

Students can download this supply list and shop online for prices. Students use the items and prices to create their spreadsheet data.

Download: emergency-supplies-list

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