×
Home Gr. Level Lesson Plans Page Generators Copy and Paste
Generators
Student Award Generators Opinion Paragraph Generators Narrative Paragraph Generators Informative Generators FlipBooks Google Classroom
Graphic Organizers
Google Sheets
Spreadsheets
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
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

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

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

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

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