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 - Movies Expenses Chart

Students Create a Simple Expense Spreadsheet and Chart

Scenario:Students take a friend to the movies and buy two movie tickets as well as some food and drinks. Students select as many items as they can from the Mega Movies Menu and Price List without spending more than $55.00.

 

Assignment: Students create a spreadsheet using Google Sheets to show how much they have spent on movie expenses. 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-movie-expenses-spreadsheet-template

 

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

 

 

 

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

 

Download: google-sheets-mega-movies-menu-and-price-list

 

 

Google Sheets - Movie 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 Movie Expenses Spreadsheet and Chart Template

 

 

Google Sheets - Movie Expenses - Finished Example:

A finished copy for teachers to download and use.

Google Sheets Movie Expenses 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.

Google Sheets - Mega Movies Spreadsheet and Chart - Student Instructions

 

 

Mega Movies Menu and 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 - Movie Menu and Price 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