K5 Computer Lab Lesson Plans
HomeGr. Level Lesson Plans Poem Generators Google Classroom
Graphic Organizers
Google Classroom
Spreadsheets
iPad Classroom Tech Integration iPad - Mac
Graphic Organizers
Excel Word Word - Graphic Organizers PowerPoint MultiMedia Internet Research Apple Mac Keynote Apple Mac Pages Apple Mac Numbers Apple Mac Multimedia Coding For Kids Resources

Google Classroom - School Supplies Expense Chart

Students Create a Simple Expense Spreadsheet and Chart

Scenario:Students have $60.00 to spend for school supplies. Students try to purchase as much as they can without going over $60.00

 

Assignment: Students create a spreadsheet using Google Sheets to show how much they have spent on school supplies. Students use the SUM function to calculate the total expenses. Students create a lovely chart showing their school supplies expenses.

 

Grades 3+

 

 

Usage: Teachers download the files and make personal copies for themselves, then share the files with students as needed using Google Classroom or a Google Drive shared folder.

 

Download: google-sheets-school-supplies-expense-chart-template

 

Download: google-sheets-school-supplies-expense-chart-finished-example

 

 

 

Download: google-sheets-school-supplies-chart-student-instructions

 

Download: google-sheets-school-supplies-price-list

 

 

Google Sheets - School Supplies Spreadsheet Template

Download and share this Google Sheets template with students. Students enter their own title and spreadsheet data. Students create a chart using their data. Students add a relevant picture. Students can format text and colors to suit their preference.

Google Sheets School Supplies Expense Chart Template

 

 

Google Sheets - School Supplies Expenses - Finished Example:

A finished copy for teachers to download and use.

Google Sheets - School Supplies Expense Spreadsheet and Chart - Finished Example

 

 

Student Instructions: Google Sheets - Expense Chart

Download and make these assignment instructions available to students to guide their Google spreadsheets creations.

 

 

School Supplies Price List:

Download and share this price list with students. .

Students can use the items and prices on this list to create their spreadsheets.

School Supplies Shopping List

 

Google Sheets Budget Spreadsheet with Chart Tutorial

Learn how to create a simple google budget spreadsheet with a chart. This video covers the basics of entering and formatting a chart title, entering data, using simple formulas and creating a chart.

Time to Learn = 4 minutes