K5 Computer Lab Lesson Plans

Google Classroom - Camping Trip Expenses Chart

Students Create a Simple Expense Spreadsheet and Chart

Scenario:Students shop for camping equipment using the Camping Trip Supplies Price List. Students should select as many items as they can without going over $300. 


Assignment: Students create a spreadsheet using Google Sheets to show how much they have spent on camping supplies. Students use the SUM function to calculate the total expenses. Students create a nice chart illustrating their 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-camping-expenses-spreadsheet-template


Download: google-sheets-camping-expenses-spreadsheet-finished-example




Download: google-sheets-camping-expense-spreadsheet-student-instructions


Download: google-sheets-camping-trip-supplies-price-list



Google Sheets - Camping Expenses 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 - Camping Expenses - Finished Example:

A finished copy for teachers to download and use.



Student Instructions: Google Sheets - Expense Chart

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



Camping Trip 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.


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