Shop Till You Drop
- Computer
- Elementary

- Materials
- Concepts / Topics
- Resource Type
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
- 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.
- Have students find at least 5–8 Internet sites.
- Tell students to record the information they have gathered.
- 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.
- 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.
- 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