Google Classroom
Camping Trip Expenses Spreadsheet and Chart

Students Create a Spreadsheet and Chart
of Camping Trip Expenses

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.

Usage: Students download the files and make personal copies for themselves.

To Download: Sign in to your school gmail account. This is a GOOGLE sheets template. You MUST be signed into a gmail account to download it. While signed in to your Google / Gmail account, click the download link, then choose "Make a copy" when prompted. This will put a copy of the template directly in your Google Drive storage.

Google Sheets
Camping Trip Expenses Spreadsheet Template

Students download this template for a quick start. 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.

This template is great for use with Chromebooks, Google Classroom, and distance learning!

Usage: Students download the graphic organizer and make a personal copy for themselves.

To Download: Sign in to your school gmail account. This is a GOOGLE slides template. You MUST be signed into a gmail account to download it. While signed in to your Google / Gmail account, click the download link, then choose "Make a copy" when prompted. This will put a copy of the graphic organizer directly in your Google Drive storage.

If you tried to download this template but instead you seem to be stuck with a "View Only" copy in your browser that says "Request Edit Access" or similar, then stop right there. Find and click "File" on the top menu, (top left?) and then choose to "Make a copy". That will get you a copy that is editable.

Download: google-sheets-camping-expenses-spreadsheet-template

Camping Trip Expense
Spreadsheet and Chart Finished Example:

A finished copy for teachers to download and use. Change the numbers, pictures, titles, as quick teaching examples of how to create the spreadsheet and chart.

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

Camping Trip Supplies Price List:

Students can download this price list and use the items and prices on the list to create their spreadsheet data.

Alternatively, students can shop online for items and prices.

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

Student Instructions: Google Sheets
Camping Trip Expense Spreadsheet and Chart

Students use these instructions to guide their Google spreadsheets creations.

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

Spreadsheet Rubric for Grading Assignments:

The rubric is good for assessing basic spreadsheets with titles at the top, basic data entries for labels (text), values (numbers), formulas, formatting numbers with dollars signs, chart formatting and more.

Download: google-sheets-rubric-for-spreadsheet-with-chart

Video - Expense Spreadsheet with Chart Tutorial

Learn how to create an expense spreadsheet with a chart. This video covers the basics of entering and formatting a chart title, entering data, creating a chart, and using the SUM formula to calculate total expenses.

Time to Learn = 4 minutes