Grades 5–8 · STEM & Computer Science
How do you teach students to clean a small dataset and chart valid rows in Grades 5–8?
Short answer: Give students five or six rows with an ID, a group and a number, including one duplicate and one blank. They mark the duplicate and the missing value, calculate each group's mean from valid rows only, and propose a chart. Then they test what happens when someone fills a blank with zero.
- Grades5–8
- SkillsDuplicates, missing values, group means, chart choice
- Time4 × 90-minute double lessons
Students learn to make charts long before they learn to question the data behind them. A chart built from a table with a duplicated row and a blank treated as zero looks just as tidy as a correct one. The errors are invisible unless someone checks the rows first.
The Spreadsheet Skills for Classroom Data unit puts the checking first. Every dataset is small enough to read row by row, so students can see exactly which entries are problems and why. Once the data is clean, the means and the chart follow quickly. The unit works in any spreadsheet program, or on paper.
Units for this topic
Spreadsheet Skills for Classroom Data
The lead unit: duplicates, missing values, group means and charts from clean rows.
Data Labels and Machine Learning Bias Lab
The data labels and machine learning bias lab takes data quality into fairness questions for Grades 6–9.
Food-Truck Service Time Data Project
The food-truck service time project gives a longer real-world data set in math class.
Microplastics Sampling and Data Lab
The microplastics sampling and data lab applies careful data handling to a science investigation.
Sensor Calibration with a Paper Microcontroller
Sensor calibration with a paper microcontroller explores systematic error in measured data.
Student Data and Goal-Setting Binder
The student data and goal-setting binder applies fair comparison of scores to students' own progress.
The first dataset
The starting rows are: 01 Read 12, 02 Build 8, 03 Read 10, a duplicate 03 Read 10, and 04 Build with a blank. The number means minutes, and each ID stands for one unique observation. Students mark the duplicate 03 and the blank 04, then find the mean for each group using only valid rows.
Read has two valid observations, 12 and 10, for a mean of 11. Build has one valid observation, 8. Students then propose a chart that compares the two groups and note that Build rests on a single value.
- IDs identify unique observations, so a repeated ID is a duplicate
- A blank is missing, not zero
- Means use valid rows only
- Charts should show how many rows each mean is based on
Why a blank is not zero
The second context gives 01 A 4, 02 A 8, a duplicate 02 A 8, 03 B 12 and 04 B blank. Clean means are A = 6 and B = 12. In the next case a learner replaces the missing B value with 0, which changes the B mean to 6. Students explain why this is misleading: the zero was never measured, and it drags the mean down to match a group it has nothing to do with.
This is the conceptual center of the unit. Once students see how one invented zero halves a mean, they treat blanks carefully for the rest of the year.
Updating and comparing
A worksheet task fills in the missing value: record 04 becomes Build 14. Students recalculate, and Build's mean moves to 11, matching Read. The chart changes from showing a gap to showing no difference, which is a useful reminder that a conclusion depends on complete data.
The transfer challenge mixes units: some times are in seconds, some in minutes. Students decide what to do before comparing means. Converting to one unit first is the answer, and stating which unit was used is part of a complete response.
Spreadsheet or paper
Every task can be done with a pencil, which makes the unit easy to start. If students have spreadsheet access, they can enter the rows, highlight problem cells, use a filter to exclude them, and build a bar chart from the cleaned table. The teacher background explains both routes and where students typically go wrong, such as including the header row in a formula or averaging a column that still contains a duplicate.
The testing routine from the prerequisites applies here too: describe the input and expected result, run the calculation, record what happened, and change one thing at a time.
Materials and assessment
The unit includes a 42-page Teaching Unit PDF with four double lessons, entry diagnosis, differentiation, teacher background, five learner inputs with mini-checks, five ready-to-copy worksheets with answer keys, support and extension cards, and a 20-point independent learning check with model responses and a 100-point scoring sheet. Sixteen slides with teacher notes support whole-class modeling. The learning check item is short and telling: scores of 6, blank, 8 and 10, find the mean of valid scores.
A five-step sequence
-
Diagnose
Give the check item: 6, blank, 8, 10. Students who answer 6 are counting the blank as zero.
-
Mark problem rows
With the first dataset, students highlight the duplicate 03 and the blank 04 before calculating anything.
-
Calculate clean means
Find each group's mean from valid rows and write how many rows each mean uses.
-
Test a bad fix
Replace the missing B value with 0 and recalculate. Students explain in one sentence why the result misleads.
-
Chart and check
Build a bar chart from cleaned data, then complete the learning check and peer review pages.
Common mix-ups and what to try
A blank cell counts as zero.
A blank means no observation. Including it as zero lowers the mean, as the B group example shows.
More rows always make a better average.
Duplicate rows repeat one observation. They add weight without adding information.
Numbers in the same column can always be averaged.
Check units first. Seconds and minutes must be converted before comparing.
More STEM & Computer Science units
Related teaching guides
Frequently asked questions
Which spreadsheet program does it use?
None in particular. Tasks work in any spreadsheet program or on paper, and the teacher background covers both.
Do students need to know how to calculate a mean?
Yes, the basic idea of adding values and dividing by the count. The unit focuses on which values belong in the calculation.
Why are the datasets so small?
Small sets let students check every row by eye and understand each problem before using spreadsheet tools on bigger data.
Can it be used in a math class?
Yes. It fits statistics and data units in Grades 5–8 as well as computer science and STEM courses.
What if the unit does not fit our standards?
Every resource is built around the curriculum you teach – and if something doesn't fit your standards, the TeachLessons Guarantee applies: we adapt it for you.
How are charts assessed?
Students propose a chart and explain what it shows, including how many valid rows support each group. The scoring sheet rewards both.
Ready for your next lesson?
Teach students to check the rows before they trust the chart with Spreadsheet Skills for Classroom Data.
View Spreadsheet Skills for Classroom DataInstant digital download. Every resource is built around the curriculum you teach – and if something doesn't fit your standards, the TeachLessons Guarantee applies: we adapt it for you.

