Lesson Plan

Budgeting a Clothing Allowance

Students will use the Excel app, Target.com, and Popplet to create a budget with a specified clothing allowance.
Rachel B.
Classroom teacher
Show More
My Grades Pre-K, K, 1, 2, 3, 4, 5, 6, 7, 8
My Subjects English Language Arts, Math, Science, Social Studies, Arts, Health & Wellness

Students will be able to...

- use an online shopping site to pretend to make purchases of clothing
- document ideas using mindmap software
- setup a spreadsheet to complete a budget
- enter data into a spreadsheet
- create and use formulas in spreadsheet software
- calculate the total cost of their shopping trip using a formula
- calculate the remaining money using a formula
- justify the reasons for their purchases to classmates
- identify other 

Grades 5 – 6
All Notes
Teacher Notes
Student Notes

1 Introduction

Activity: Presenting

Teacher begins by introducing the lesson. Teacher asks if students have ever helped their parents shop, or been given a certain amount of money to spend on clothing. Teacher then explains that students will pretend they have been given $150 to buy clothing for themselves. They will go shopping for their clothing on Target.com, document their ideas in Popplet, and then create a budget, complete with formulas, in the Excel app.

2 Part 1: Shopping for Clothing


Teacher will first provide instructions and a demonstration. Students will either be buying clothes for the fall/winter season OR the spring/summer season, depending on the time of year that this lesson is taught.

Teacher will first go to target.com and find the clothing section for children. Teacher will show how to find different clothing categories, and how to arrange the results in different ways. Teacher will demonstrate with shirts. They will locate shirts, choose the ones they'd like, and document their work on Popplet for later use. Teacher will explain that students will repeat these steps with the rest of the clothing they plan to purchase.

Teacher gives the following guidelines for the clothing allowance:

- $150 only to spend
- Must include 2 complete outfits, 1 pair of shoes, a set of socks, and a jacket, hoodie, or coat.
- Students can purchase more items, but they cannot go over the allotted budget.

Teacher pairs students off. Students work individually, but have the support of a classmate for any technical issues or questions that they might run into.

Student Instructions

Popplet: Students will create a working mind map. The center of their web will branch off into different clothing categories. Under each category, they will list what they have found. For example, if they are working with shirts, they will list the name of the product and the price. Since sales and other factors often play into constant web updates, students do not need to link to the product they have found.

3 Budgeting in Numbers


(For this section, students can also use Microsoft Excel app if available)

Teacher explains that students will now use the Numbers app to create a budget spreadsheet. Teacher will demonstrate how to set up the basics- title, column headings, and any other necessary labels. The column titles will be Item and Cost. Teacher will then observe as students complete this task.

Teacher will then use their shirt example from the previous section to input the data into the spreadsheet. They will enter the name of the item in one cell and then its cost in the next cell. Teacher explains that students will do this for all of their items.

Next, students will use a formula to calculate the cost of all of their items. They will use this to determine if they are under or over budget.

4 Budgeting in Numbers Part 2


To finish their budget, students will use the chart feature to create a chart based on their data. Students will then discuss the implications of what their budget shows:

- Have they spent too much money on one article of clothing? Why might that be?

- Is there something else they could have bought to cut the costs down?

- What might they do in the future to change the outcome of their chart?

5 Wrap-Up

Activity: Presenting

The whole class comes together and discusses the benefits of keeping a budget, such as the one they have for clothing. What purpose will this serve them in the real world? Teacher then explains how keeping budgets like the one they created can help them track their money and where it is spent. In the future, they will discover that they can keep a budget for more than just clothing.