Home Gr. Level Lesson Plans Page Generators Copy and Paste
Student Award Generators Opinion Paragraph Generators Narrative Paragraph Generators Informative Generators FlipBooks Google Classroom
Graphic Organizers
Google Sheets
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
Clothes Shopping Expenses Spreadsheet

Assignment: Students create a clothes shopping expense spreadsheet with chart. Students shop online to select clothing to donate to a needy child using the Clothes Shopping List as a guide. Students should select as many items as they can for one girl or boy without going over $250. Students create a chart illustrating their purchase expenses.

Google Sheets Clothing Expense
Budget & Chart Finished Example

Clothes Shopping Expenses Spreadsheet - Finished Example

Clothes Shopping List:

Students can download this supply list and shop online for prices. Students use the items and prices to create their spreadsheet data.

Clothes Shopping List

Download: clothes-shopping-list

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