Educational Application of Excel
K-4 Emotionally Impaired Classroom
Skittles Math Excel Worksheets with graphs
Feel free to click and download to use in your classroom!!
Excel worksheet from actual lesson:
Click on Sheets to see collected data.
Skittles Math Lesson Plan
Goals of Lesson
1. Students will collect data for individual graphs
2. Students will record data on Excel Spreadsheet, with adult support
3. Students will make predictions and use data to answer questions
4. Students will use data to make predictions about mystery bag of skittles
5. Students will review/practice math skills: adding, more than, less than, averages, written responses to mathematical thinking, estimation, reading a graph (titles, axis’s)
1. Bag of skittles for each student or groups of students, plus 1 extra bag for mystery bag
2. Plate or napkin for skittles, per student/group
3. Skittles Math handout, writing tool
4. Access to technology (Excel, projector, screen/SMARTBoard)
This lesson may be completed in 1 to 3 sessions, depending on time constraints and access to technology. (Day 1 data collection, Day 2 input into Excel, Day 3 writing about findings). If you don’t have access to Excel, this can be done by hand on an overhead with graph paper and calculators. This lesson also works with conversation hearts and m&m’s.
1. Have students wash their hands.
2. Explain to your students the goals/objective of lesson.
3. Give each student/group a bag of skittles; have them predict how many skittles are in their bag. Record on handout.
4. Ask students to predict and record the color their will be the most of in their bag on their handout. Record the color with the least.
5. Invite students to carefully open their bags of skittles, sort into color groups, and record data on handout.
6. Students may eat their skittles at an appropriate time.
7. Invite students to join you in front of whiteboard with their handouts. Open up Excel and ask each student in turn to share their data. Enter data as each student shares. Show them the total columns. Ask them what they are noticing. Depending on age level of class explains percents, share other examples of when percents and averages are used.
8. Enter data in class sheet. Print out completed sheet for each student.
9. Students take class graph to seat and answer remaining questions on handout (1. Which color was the greatest? 2. Which color was the least? 3. Student 1 had ______ strawberry. I had ______ strawberry. Who had more? How many more.)
10. While students are completing their handout, call each student up individually to add data to individual student sheets. Print individual student sheets.
11. Students return to their seat to complete handout with individual graph.
12. When class is finished, invite them back to whiteboard. Discuss the 2 different graphs (pie and bar). Ask questions about more, least, how many more, on average which color is in bags, etc.
13. Open up a mystery bag of skittles. Make predictions about what we should see…total # of skittles in the bag, least color, greatest color, etc. Students could also use mystery bag to create their own graph on paper or with excel.
14. Model writing a class paragraph on analyzing data.