TITLE: SHOP TILL YOU DROP
TEACHER: DAWN EVANS
DATE: APRIL 19, 2001
SUBJECT: COMPUTER, BUDGET, SPREADSHEET, AND INTERNET
OBJECTIVE: TSWBAT. . .create a budget to shop on the Internet. Then the student will use Microsoft word to put the information in a spreadsheet form.
MATERIALS: 1.Computer with Microsoft word and Internet
3.Pen or pencil
INTRODUCTION: Shopping made easy through the Internet. Let's create a budget and go shopping on the Internet!!
TRANSITION: Let the student 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 student's create a set budget and have them take their assignment home and use the internet at home to do their shopping. [So parents can supervise the Internet] 2.Have student's find at least 5-8 Internet sites. 3.Tell students to record the information that they have gathered. 4.Information that is needed is: store/E-mail address, description of article, quantity, price of article, and the total amount. Students in the higher grades should add taxes. 5.Have students bring in gathered information to class and put information in a spreadsheet form. [Use Microsoft word program. Go to Table; then to Insert Table; then pick number of columns and rows] 6.Have students save spreadsheet to a floppy disk and print a copy for the teacher.
CLOSURE: Bring class together to discuss their findings. Was it hard to stay in the budget? Was the Internet useful? Did the Internet save time?
EVALUATION OF STUDENT: HAVE STUDENTS GIVE FINAL COPY OF SPREAD SHEET TO THE TEACHER. EVALUATE STUDENT TO SEE IF HE/SHE STAYED WITHIN THE BUDGET, AND TO SEE IF THE OBJECTIVE WAS ACCOMPLISHED.