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 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-mega-movies-price-list

Student Instructions: Google Sheets
Movie Expense Spreadsheet and Chart

Students use these instructions to guide their Google spreadsheets creations.

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

Download: rubric-for-spreadsheet-with-chart.pdf