{"product_id":"spreadsheet-skills-for-classroom-data-grades-5-8","title":"Spreadsheet Skills for Classroom Data | STEM \u0026 Computer Science Unit | Grades 5–8","description":"\u003cp\u003e\u003cstrong\u003eSpreadsheet Skills for Classroom Data\u003c\/strong\u003e 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.\u003c\/p\u003e\n\u003ch2\u003eWhat students work on\u003c\/h2\u003e\u003cul\u003e\n\u003cli\u003eReading and Building minutes with IDs 01 to 04, where record 03 appears twice and record 04 has no value.\u003c\/li\u003e\n\u003cli\u003eRecord 04 is filled in as Build 14, and students work out how the group means change.\u003c\/li\u003e\n\u003cli\u003eGroups A and B with a duplicated 02 row and a blank for 04, used to find clean group means.\u003c\/li\u003e\n\u003cli\u003eA learner who replaces the missing B value with 0 and drops the B mean to 6, which students explain is misleading.\u003c\/li\u003e\n\u003cli\u003eA dataset that mixes seconds and minutes, where students decide what to do before comparing means.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003ch2\u003eLesson sequence (4 × 90 minutes)\u003c\/h2\u003e\u003col\u003e\n\u003cli\u003e\n\u003cstrong\u003eFrom first reading to a model.\u003c\/strong\u003e 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.\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eA revised case and a new context.\u003c\/strong\u003e A late value for record 04 changes the picture, and students repeat the cleaning steps on a second dataset with groups A and B.\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eTesting evidence and transferring a method.\u003c\/strong\u003e Students test what happens when a blank becomes a zero and convert mixed units before any comparison.\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eLearning check and feedback.\u003c\/strong\u003e 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.\u003c\/li\u003e\n\u003c\/ol\u003e\n\u003ch2\u003eWhat's included\u003c\/h2\u003e\u003cul\u003e\n\u003cli\u003eTeaching 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\u003c\/li\u003e\n\u003cli\u003e16 classroom slides (PPTX) with teacher notes\u003c\/li\u003e\n\u003cli\u003eFive answer keys plus model responses\u003c\/li\u003e\n\u003cli\u003e20-point independent learning check with a 100-point scoring sheet\u003c\/li\u003e\n\u003cli\u003eSupport and extension cards for differentiation\u003c\/li\u003e\n\u003cli\u003eA4 format that prints on US Letter with fit to page\u003c\/li\u003e\n\u003cli\u003eDigital download, no physical item is shipped\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003ch2\u003eWho it's for\u003c\/h2\u003e\u003cul\u003e\n\u003cli\u003eUS grades 5–8 (STEM \u0026amp; Computer Science)\u003c\/li\u003e\n\u003cli\u003eUK Years 6–9 and Australia Years 5–8\u003c\/li\u003e\n\u003cli\u003eMiddle school math, science and computer science classes\u003c\/li\u003e\n\u003cli\u003eComputer labs and STEM electives\u003c\/li\u003e\n\u003cli\u003eHomeschool\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003ch2\u003eBefore you start\u003c\/h2\u003e\u003cp\u003eStudents 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.\u003c\/p\u003e\n\u003cp\u003eEvery resource is built around the curriculum you teach – and if something doesn't fit your standards, the \u003ca href=\"\/pages\/teachlessons-guarantee\"\u003eTeachLessons Guarantee\u003c\/a\u003e applies: we adapt it for you.\u003c\/p\u003e\n\u003cp\u003e\u003cem\u003eCreated with AI assistance. Texts and illustrations were developed with ChatGPT (OpenAI) and Claude (Anthropic) and edited for classroom use.\u003c\/em\u003e\u003c\/p\u003e\n\u003ch2\u003eFrequently Asked Questions\u003c\/h2\u003e\u003cp\u003e\u003cstrong\u003eWhich grades is Spreadsheet Skills for Classroom Data for?\u003c\/strong\u003e\u003c\/p\u003e\u003cp\u003eIt 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.\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eWhat's included and how long does it take?\u003c\/strong\u003e\u003c\/p\u003e\u003cp\u003eYou 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.\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eCan students do this in Google Sheets or Excel?\u003c\/strong\u003e\u003c\/p\u003e\u003cp\u003eYes. 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.\u003c\/p\u003e\n\u003cscript type=\"application\/ld+json\"\u003e{\"@context\": \"https:\/\/schema.org\", \"@type\": \"FAQPage\", \"mainEntity\": [{\"@type\": \"Question\", \"name\": \"Which grades is Spreadsheet Skills for Classroom Data for?\", \"acceptedAnswer\": {\"@type\": \"Answer\", \"text\": \"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.\"}}, {\"@type\": \"Question\", \"name\": \"What's included and how long does it take?\", \"acceptedAnswer\": {\"@type\": \"Answer\", \"text\": \"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.\"}}, {\"@type\": \"Question\", \"name\": \"Can students do this in Google Sheets or Excel?\", \"acceptedAnswer\": {\"@type\": \"Answer\", \"text\": \"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.\"}}]}\u003c\/script\u003e","brand":"Teach Lessons","offers":[{"title":"Default Title","offer_id":59157532016984,"sku":"TL-U140-074","price":24.99,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0882\/5667\/6184\/files\/074-spreadsheet-skills-for-classroom-data-01-thumbnail-a4.jpg?v=1794901253","url":"https:\/\/teachlessons.us\/products\/spreadsheet-skills-for-classroom-data-grades-5-8","provider":"Teach Lessons","version":"1.0","type":"link"}