|
West
Irondequoit Central School
District
Technology Rich Lesson
Plan |
|
Name: |
Kim
Coykendall |
|
Grade(s) |
3rd |
|
Information about the
Lesson
|
|
 Title:
|
Comparison of Public Market
Prices and grocery store prices |
|
Brief Description: |
After a field trip to the
Rochester Public Market, students compared prices of produce at the market
to prices at a local grocery store.
They input their data into an Excel spreadsheet and then made
graphs showing the price comparisons. |
|
Subject(s)
integration
|
|
|
(time required to complete
lesson, e.g. "two 45-minute sessions") |
This lesson took one session
of about 1 hour. |
|
|
Goals:
(curriculum and unit related;
National or State standards) |
To
compare prices and draw conclusions about where it is cheaper to
shop. |
|
|
Objectives:
(measurable specific activities
conducted by students) |
Students gathered data about
prices of produce at the Public Market. They also gathered data about
prices of produce at a local grocery store. They then compared the prices and
input that into an Excel spreadsheet. The spread sheet allowed them to
make bar graphs to show their comparisons. After the students printed
the graphs they were able to write comparison statements about where it is
better to shop. |
|
|
Teacher
Materials/Resources:
(specific materials the teacher must have to
conduct the lesson, e.g. Romeo and Juliet (video), American flag,
etc.) |
Excel Template
|
|
|
Student
Materials/Resources:
(specific materials the students must have to
complete the lesson, e.g. calculators, construction paper, finger paints,
etc.) |
Data collected at market and
Wegman’s, Excel Template
|
|
|
Procedures: |
|
|
|
Assessment: |
I
was able to assess the student’s learning by looking at the graphs they
created and reading the comparative statements they made. It was amazing the conclusions the
children made about how much cheaper it is to shop at the public
market. They were also able
to make conclusions about how important it is to support our local economy
and shop at the public market. |
|
|
Attach a File: (link to accompanying
files) |
Sample
Grocery Comparison Spreadsheet |
|