Teachers.Net
JoinLog in
Teachers.Net

It's a Sale!

By Richard Filler

  • Mathematics
  • Elementary
Activity Time
3 class periods, about 3 hours
Materials
spreadsheet, list of sale items with retail and Discount % off
Concepts / Topics
Percentage, finding sale price,

Students calculate discounts and sale prices for listed products, compare savings in a spreadsheet, create a bar graph, and discuss what the comparisons show.

Purpose

Help students make good decisions about purchasing items on sale and understand how percentages affect cost.

Objectives

  • Students will comparison shop with items on sale.
  • Students will use a spreadsheet to explore how percentages affect cost.

Procedure

  1. Introduce the lesson by asking students what they spend their money on and who gets an allowance.
  2. Ask whether they ever wait for an item to go on sale before buying it.
  3. Show students how to find the sale price of an item using a percent.
  4. As a group, find the sale price of a few items.
  5. Lay out a spreadsheet on the board, an overhead projector, an LCD display, or another display to show how it would look.
  6. Have students work in groups to complete the spreadsheet using all the items. Include the item, retail price, percent off, discount, and sale price.
  7. Once the spreadsheet is complete, have students answer the questions about the items they used.

Sale Items

ItemRetail pricePercent off
‘N Sync CD$19.955%
BackStreet Boys CD$19.957%
New shoes$55.7410%
Pokemon cards$15.9920%
6-pack of Pepsi$2.245%
New Sega game$34.9910%
N64 game$48.758%
Baseball glove$78.995%
New bike$145.957%
Ugly pants$33.988%
Who Wants to Be a Millionaire board game$27.5020%
Binder$3.3510%
Loose-leaf paper$1.455%
Harry Potter book$22.997%
Basketball$27.998%
Shirt$16.8925%

Questions

  1. What is the formula that we use to find a sale price?
  2. What happens to the sale price when the percentage increases?
  3. Are all of the highest discount percentages the best savings? Why?
  4. What items do you save the most on? Why?
  5. Which items are the best discount? Why? Explain your answer.
  6. What do you notice about retail price and sale price?

Part 2

Using the items in the list, create a spreadsheet in the cells below those you have used, or use Sheet 2. Pick five items of various prices. Enter each item and its retail price, then apply each of the given discount percentages, recording the discount and sale price for each percentage.

For example, enter the ‘N Sync CD at $19.95, then 5% off with the discount and sale price, then 7% off with the discount and sale price, then 8% off with the discount and sale price, and so on. Once you have done this, compare the prices and create a bar graph using your spreadsheet.

Questions

  1. What happens to the prices as the percentage increases?
  2. Is the discount always the same if the percent off is the same? If not, why?
  3. Pick two products and compare the sale price at the lowest discount to the sale price at the highest discount. How much of a difference is there?

Wrap-Up

Explain why percentages off the retail price do not always mean “big” savings. Tell why you think people believe they are saving so much money when they go to a sale.

Extension

Go to a local store and find items on sale. Use their retail prices and percentages off to figure out how much savings the store is giving you. Use these figures in your spreadsheet and create a chart of your savings.

Teachers.Net · https://teachers.net/lessons/1651.html