×
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
Movie Expenses Spreadsheet

Assignment: Students create a Movie expense spreadsheet with a chart. 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. Students create a chart illustrating their purchase expenses.

Google Sheets Movie Expense
Budget & Chart Finished Example

Movie Expense Spreadsheet - Finished Example

Movie 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.

Movie Price List

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

Student Instructions: Google Sheets
Movie Expense Spreadsheet and Chart

Students use these instructions to guide their Google spreadsheets creations.

Student Instructions: Google Sheets - Mega Movies Expense Spreadsheet and Chart

Download: google-sheets-movie-expense-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