Showcase - Spending Spree Lesson Plan

Lesson Plan - "Spending Spree"

Coyote Creek Elementary – 5th Grade
Douglas County School District
Saturday Cohort V – Summer 2003

Title: “Spending Spree”
Author: Jennifer Jensen
Grade Level/Discipline: 5th Grade Math - Technology
Length of Lesson: This lesson will take 1-2 days.
Context: This lesson utilizes another math activity. This activity has students learning about circle graphs. They have $100 to spend. After spending their money and creating a circle graph on paper, they move onto a spreadsheet in Appleworks. Here they create not only a circle graph, but a chart as well. These two documents will show how they spent their money.
Instructional Goal: Students will:
-Understand the concept of percent as it relates to their paper circle graph.
-Monitor their spending by using addition of numbers with decimals.
-Enter data into a spreadsheet.
-Create a circle graph using the entered data.
-Create a chart using the entered data.

Standards Addressed: The following standards are addressed:
1. Math – Addition, decimal points, money, percentages, and reading – creating – and interpreting graphs.
2. Technology – Use of spreadsheet, creating graphs, and creating charts.

Roles of Teacher/Student:
Teacher: Provide students with the guidelines surrounding the assignment. Also provide students with the needed computers. Be available to answer any curriculum or technology related questions.
Student: To ensure a high-level of interest, students can bring in the needed magazines or newspaper circulars from which they can shop. Each student will be responsible spending the exact amount of money. They will also need to enter their information into the spreadsheet, create a circle graph, and then create a chart.

Integration of Technology: During this lesson, students will use iBook computers. They will use the spreadsheet aspect of the program Appleworks.

Learning Objectives:
-Students will accurately spend their allotted $100.
-Students will enter appropriate information into the spreadsheet.
-Students will create a circle graph.
-Students will create a chart.
-Students will use the iBooks to complete all objectives.

Resources & Materials:
Teacher Materials:
-Worksheet for “$100 Spending Spree” assignment
-Specific graph/chart creating steps (if needed)

Student Materials:
-“$100 Spending Spree” worksheet
-Magazine/Newspaper circular ads
-iBooks
-Appropriate computer software
-Directions for assignment
-Printer
-Coloring utensils (colored pencils/markers)

Lesson Agenda & Procedure:
1. Using the “$100 Spending Spree” worksheet and circular ads, students will spend their $100. They will create a circle graph of their spending, as well as a three-columned chart including the following: name of the purchased item, price of the item, and percent spent on that item. If students have odd amounts of money left, they can put it into savings. You will also want to encourage students to round to the nearest dollar.
2. Students will check their graph with the teacher.
3. When the teacher has okayed their work, they can get an iBook and begin entering their data.
4. Upon completing their data entry, students will begin creating their circle graph.
5. After the graph is completed, they will need to make each section white before printing. Be sure that they do not use the fill feature. This approach will save money not printing in color, and allows students to have a “coloring book” type graph that will be easier to color when printed.
6. When students have completed their graph, they need to cut it from the spreadsheet and paste it into a new word processing document.
7. Next, students will use the same spreadsheet to create their chart. They will just need to add another column for their percentages.
8. After students have their desired look in the chart, they are ready to print.
9. When printing is complete, students can then return to their graph and add color.
10. In the hallway, or on a classroom bulletin board, mount a student’s graph and chart onto a large piece of construction paper and hang for display.

Assessment:
Teachers may assess students on their accuracy in spending, addition, accuracy of circle graph, accuracy of chart, and overall neatness.
Teachers may create their own technology skills assessment if they would like to assess this portion of the student work.

Variations/Differentiation:
I feel that this lesson meets the needs of all students with very little variation or differentiation. You may want to have students create questions for their graphs that other students could answer. These questions can be mounted and covered next to the graphs. This would make a great interactive bulletin board or math center.