Teachers.Net
JoinLog in
Teachers.Net

Shop Till You Drop

By Dawn Evans

  • Computer
  • Elementary
Materials
Computer with Microsoft Word and Internet access Notebook Pen or pencil
Concepts / Topics
Budget
Resource Type
Lesson Plan

Students set a budget, research products on the Internet, record prices and quantities, then organize their findings in a Microsoft Word table and discuss them.

Shop till you Drop

Teacher: Dawn Evans Date: April 19, 2001 Subject: Computer, budget, spreadsheet, and Internet Grades: 3–6

Objective

Students will be able to create a budget to shop on the Internet. Then they will use Microsoft Word to put the information in spreadsheet form.

Materials

  • Computer with Microsoft Word and Internet access
  • Notebook
  • Pen or pencil

Introduction

Shopping made easy through the Internet. Let’s create a budget and go shopping on the Internet!

Transition

Let students pick what they want to shop for. Some ideas are clothes, hunting rifles, toys, games, sports gear, swimming pools, camping gear, electronics, etc.

Procedures

  1. Have students create a set budget. Have them take their assignment home and use the Internet at home to do their shopping so parents can supervise their Internet use.
  2. Have students find at least 5–8 Internet sites.
  3. Tell students to record the information they have gathered.
  4. The information needed is: store/email address, description of article, quantity, price of article, and total amount. Students in the higher grades should add taxes.
  5. Have students bring the gathered information to class and put it in spreadsheet form. Use Microsoft Word: go to Table, then Insert Table, then choose the number of columns and rows.
  6. Have students save the spreadsheet to a floppy disk and print a copy for the teacher.

Closure

Bring the class together to discuss their findings.

  • Was it hard to stay within the budget?
  • Was the Internet useful?
  • Did the Internet save time?

Student Evaluation

Have students give the final copy of the spreadsheet to the teacher. Evaluate whether each student stayed within the budget and accomplished the objective.

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