Home Gr. Level Lesson Plans Page Generators Copy and Paste
Student Award Generators Opinion Paragraph Generators Narrative Paragraph Generators Informative Generators FlipBooks Google Classroom
Graphic Organizers
Google Sheets
iPad Classroom Integration iPad - Mac
Graphic Organizers
Excel Word Word - Graphic Organizers PowerPoint MultiMedia Internet Research Apple / Mac Apple Mac Pages Apple Mac Numbers Apple Mac Multimedia Coding For Kids Resources

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 Expenses Spreadsheet - 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.

Emergency Supplies List

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

Excel Spreadsheet Rubric for Grading Assignments

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