TPT
Total:
$0.00

Skittle Statistics MS Excel Mini-Lab

Rated 5 out of 5, based on 1 reviews
5.0 (1 rating)
;
3D-PT
125 Followers
Grade Levels
6th - 12th, Higher Education, Adult Education, Homeschool
Resource Type
Standards
Formats Included
  • Zip
  • Excel Spreadsheets
  • Webquests
Pages
5 pages
$5.00
$5.00
Share this resource
Report this resource to TPT
3D-PT
125 Followers
Easel Activity Included
This resource includes a ready-to-use interactive activity students can complete on any device.  Easel by TPT is free to use! Learn more.
Compatible with Digital Devices
The Teacher-Author has indicated that this resource can be used for device-based learning.
Easel Assessment Included
This resource includes a self-grading quiz students can complete on any device. Easel by TPT is free to use! Learn more.
Also included in
  1. Are you looking for a bundle of affordable STEM labs for your science class? This bundle has 38 files worth of field tested labs. All include materials list, worksheets, and field pictures! You can cover earth science, chemistry, biology as well as other topics with this package. The bundles cover
    Price $107.28Original Price $153.25Save $45.97
  2. This physics bundle is perfect for a semesters worth of physics! find out how to outrace zombies, play with slinkies, or calculate soundwaves! This full bundle combines my best hands-on labs into a full field tested bundle for your school year!This bundle is 10% off the total price!
    Price $58.50Original Price $70.75Save $12.25
  3. Chemistry is taught as a 2D flat part of the periodic table, but in truth it's 3D and interactive! This bundle is a whole semesters worth of chemistry!It includes 3D printable labs, class sized periodic tables, and hands-on labs for real learning!A full bundle here is at a 10% discount from full pri
    Price $49.73Original Price $60.50Save $10.77

Description

This is a 1 class MS Excel lab for a computer or math class. You can have the students explore the distribution of different color Skittles in class. This is a great mini-lab or half-day activity when you school ends up with a weird schedule day.

Tell them they can't eat till the Skittles till the end of class, or they will distort their numbers. Also make sure they don't throw them or shove them up their nose (Yes, stuck Skittles are hard to extract, ask me how I know..)

The goal of this lab is to practice excel, as well as programing the =SUM & =AVG function. They also build a simple clustered column chart. This is a fun way to build excel graphing skills.

This file has the full lab, and excel template you can use to produce the class graph.

I went to a bulk store and purchase a large 5 lb bag of skittles for this lab. You can use this with smaller bags, or vary the results with snack bags from Halloween assortments.

Easel Activity & Assessment

You can assign this as an activity for students devices in class, or as a make-up assignment from home.

The Assessment provides a great exit ticket!

Answer Key

In the ZIP file is the included Answer Key for your reference!

Total Pages
5 pages
Answer Key
N/A
Teaching Duration
1 hour
Report this resource to TPT
Reported resources will be reviewed by our team. Report this resource to let us know if this resource violates TPT’s content guidelines.

Standards

to see state-specific standards (only available in the US).
Recognize a statistical question as one that anticipates variability in the data related to the question and accounts for it in the answers. For example, “How old am I?” is not a statistical question, but “How old are the students in my school?” is a statistical question because one anticipates variability in students’ ages.
Understand that a set of data collected to answer a statistical question has a distribution which can be described by its center, spread, and overall shape.
Recognize that a measure of center for a numerical data set summarizes all of its values with a single number, while a measure of variation describes how its values vary with a single number.
Display numerical data in plots on a number line, including dot plots, histograms, and box plots.
Summarize numerical data sets in relation to their context, such as by:

Reviews

Questions & Answers

125 Followers