✓ Added to cart


Spreadsheet Skills for Classroom Data | STEM & Computer Science Unit | Grades 5–8
Digital download · nothing is shipped
- Instant download: the download link appears right after checkout and is also emailed to you.
- Format: PDF + slides, ready to print or project.
- TeachLessons Guarantee: if it does not fit your standards or pacing, email us within 30 days of purchase and we adapt it at no extra cost. How the guarantee works
Spreadsheet Skills for Classroom Data | STEM & Computer Science Unit | Grades 5–8
Spreadsheet Skills for Classroom Data is a grades 5–8 unit on cleaning a small dataset before anyone draws conclusions from it. Students mark duplicate and blank rows, calculate group means from valid observations only, and propose a chart that compares the groups fairly.
What students work on
- Reading and Building minutes with IDs 01 to 04, where record 03 appears twice and record 04 has no value.
- Record 04 is filled in as Build 14, and students work out how the group means change.
- Groups A and B with a duplicated 02 row and a blank for 04, used to find clean group means.
- A learner who replaces the missing B value with 0 and drops the B mean to 6, which students explain is misleading.
- A dataset that mixes seconds and minutes, where students decide what to do before comparing means.
Lesson sequence (4 × 90 minutes)
- From first reading to a model. Students learn that each ID is one observation, flag the duplicate and the blank, and calculate the mean for each group from the rows that remain.
- A revised case and a new context. A late value for record 04 changes the picture, and students repeat the cleaning steps on a second dataset with groups A and B.
- Testing evidence and transferring a method. Students test what happens when a blank becomes a zero and convert mixed units before any comparison.
- Learning check and feedback. The independent check uses the scores 6, blank, 8 and 10, then students score their work, compare reasoning with a partner and revise one calculation.
What's included
- Teaching Unit PDF – 42 pages: four 90-minute double lessons, entry diagnosis, differentiation notes, teacher background, five learner inputs with mini-checks, five ready-to-copy worksheets, peer review and revision pages
- 16 classroom slides (PPTX) with teacher notes
- Five answer keys plus model responses
- 20-point independent learning check with a 100-point scoring sheet
- Support and extension cards for differentiation
- A4 format that prints on US Letter with fit to page
- Digital download, no physical item is shipped
Who it's for
- US grades 5–8 (STEM & Computer Science)
- UK Years 6–9 and Australia Years 5–8
- Middle school math, science and computer science classes
- Computer labs and STEM electives
- Homeschool
Before you start
Students should be able to describe what a data column holds, calculate a simple mean and record each step. No spreadsheet software is required, though the tasks transfer directly to Google Sheets or Excel.
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.
Created with AI assistance. Texts and illustrations were developed with ChatGPT (OpenAI) and Claude (Anthropic) and edited for classroom use.
Frequently Asked Questions
Which grades is Spreadsheet Skills for Classroom Data for?
It is written for US grades 5–8, which roughly matches UK Years 6–9 and Australian Years 5–8. The support and extension cards let you adjust the challenge for your group.
What's included and how long does it take?
You get a 42-page Teaching Unit PDF and 16 PPTX slides with teacher notes, planned as four 90-minute double lessons. Worksheets, answer keys, the learning check and scoring sheet are all in the PDF.
Can students do this in Google Sheets or Excel?
Yes. The worksheets are written for paper so any class can use them, but each cleaning step and mean calculation maps directly onto a spreadsheet if your students have devices.
$24.99 – buy now
PDF · instant download
🔒 Secure checkout · ♾️ reuse every yearFAQ about this resource
More Computer Science resources for Middle School




Our summary: Spreadsheet Skills for Classroom Data | STEM & Computer Science Uni...
Spreadsheet Skills for Classroom Data | STEM & Computer Science Unit | Grades... is a fully worked-out teaching resource for Computer Science at Middle School level (Grades 5–8). Its strength is that it is finished: worksheets, answer keys and teacher notes are all there, so a lesson can start without extra prep.
Teachers covering a topic at short notice, early-career teachers under planning pressure, and anyone picking up a cover lesson — and any situation where a lesson has to be ready today.
An editorial assessment of structure, scope and classroom use. It is not a customer review.

