By Cindy Ives EDU 553 ECSU
Materials: Computers with Microsoft Excel
Small Pieces of Paper and 5 small paper bags
5 types of Mexican Cheese
5 types of Mexican Fruit
5 types of Mexican Vegetables
5 types of Mexican Desserts
5 types of Mexican Bread
Objectives: Students will rotate to each type of food for a taste test. Using the results from the taste test, groups of students will create a graph showing the results of each type and be able to explain their graph.
Standards: Mathematics
# 3 � Geometry and Measurement
3.3 - Develop and apply units, systems, formulas, and appropriate
tools to estimate and measure.
# 4 � Working with Data: Probability and Statistics
4.1 - Collect, organize, and display data using appropriate
statistical and graphical methods.
Technology
# 4 � Problem Solving, Research, and Development: gather, record, and
organize data, based on observations.
Procedure:
1. Bring in 5 different types of food for each of the groups listed in the materials.
2. Create 5 centers for students to rotate through and try each of the types of food.
3. Break the class into five groups for the rotations and to analyze the data at the
end.
4. At each center, students are to try all 5 foods and then choose their favorite.
They are to then write their vote on a piece of paper and place it in the bag at
each center.
5. After each group has had a chance to taste all the different foods in each center,
assign each group a type: bread, cheese, fruit, vegetable, and dessert.
6. Each group is to collect the data for their type, tally the data, and create their
own table (every student in the group must create their own table).
7. After each group counts the votes, they are to go to the computer and create a
bar graph on Excel using the data written in their tables.
8. To end the lesson, have each group share their findings with the entire class.
9. Collect each group�s tables and graph.
10. After grading graphs/tables, hand back and have students keep these in the
Mexican folders. Students will share these with parents in near future.
Assessment: Each student will hand in a table, with labels, columns, rows, that shows the data accurately. Each group will effectively use Excel to hand in a bar graph with proper labeling, intervals, and data.
Lesson 1 Lesson 2 Lesson 4 Lesson 5