Skittles Lesson in Sheets: Fun Data Analysis for Classrooms

Imagine transforming a bag of Skittles into a dynamic learning tool that makes data analysis tangible and exciting. In this lesson, students collect, sort, and analyze candy data using spreadsheets, turning a sweet treat into a powerful educational experience.

Skittles come in multiple colors, making them ideal for counting, categorizing, and comparing.
Each bag is unique, so students can explore variability while practicing essential data skills.
Plus, who doesn't love eating candy during class? This activity bridges fun and learning seamlessly.

Start by having students open a new Google Sheet.
They'll create columns for 'Color', 'Count', and 'Total'.
Then, they sort Skittles by color, count each, and input the numbers.
Next, use formulas (like =SUM) to calculate totals and percentages.
Finally, generate a bar chart to visualize the data.
This process builds spreadsheet proficiency while teaching real-world data handling.

Take the lesson further by comparing multiple bags to discuss outliers and averages.
Introduce probability by predicting colors from a sealed bag.
Or, challenge students to design their own survey questions (e.g., 'Which color is most popular?') and analyze results.
These extensions foster critical thinking and make the activity adaptable for different age groups.

Ready to sweeten your classroom?
Download our free Google Sheets template for the Skittles lesson and watch your students light up as they crunch data and candy.
Share your results with #SkittlesSheets and inspire other educators!