Google Sheets Lesson Plan
Clothing Expenses Spreadsheet with Chart

Assignment: Students create a clothing expense spreadsheet budget with chart. Students use a shopping list to buy some clothes and tally their expenses. Students create a chart illustrating their clothing purchases and expenses.

Google Sheets Clothing Expense
Budget & Chart Finished Example

Download: clothes-shopping-price-list.pdf

Clothes Shopping Price List:

Students choose clothing items from this list for their spreadsheet entries.

Download: student-instructions-clothes-shopping-expenses.docx

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