{"id":225,"date":"2026-11-17T08:07:00","date_gmt":"2026-11-17T13:07:00","guid":{"rendered":"https:\/\/excelgames.cc\/blog\/?p=225"},"modified":"2026-11-15T03:33:21","modified_gmt":"2026-11-15T08:33:21","slug":"data-cleaning-relay-race-spreadsheet-drill","status":"publish","type":"post","link":"https:\/\/excelgames.cc\/blog\/data-cleaning-relay-race-spreadsheet-drill\/","title":{"rendered":"A Data-Cleaning Relay Race Spreadsheet Drill"},"content":{"rendered":"<p><strong>TL;DR \/ Summary:<\/strong> A data cleaning relay race teaches spreadsheet hygiene faster than a lecture. Each team inherits a deliberately messy file, fixes one defect per hand-off, and passes it on \u2014 with the clock running and a rules sheet enforcing the fixes.<\/p>\n<h2>The format in one paragraph<\/h2>\n<p>Four teams, four messy workbooks, ten minutes per leg. Each leg fixes one category of problem: duplicates, whitespace, date formats, or inconsistent categories. Then the workbook moves to the next team, which must accept what it inherits.<\/p>\n<p>The hand-off is the point. Cleaning data is rarely a solo activity, and working on a file someone else has already touched is a specific skill that most courses skip.<\/p>\n<p>Because the clock runs, teams stop polishing and start deciding what matters \u2014 which is exactly the judgement the exercise is meant to build.<\/p>\n<h2>Preparing the messy file<\/h2>\n<p>One workbook, five hundred rows, and a list of deliberate defects. Keep a master answer key so scoring is objective.<\/p>\n<p>Inject: duplicate customer records with a slightly different spelling, leading spaces in names, mixed date formats, inconsistent country codes, and a column of numbers stored as text.<\/p>\n<h3>Defect menu<\/h3>\n<ul>\n<li><strong>Duplicates<\/strong> \u2014 three pairs with transposed names<\/li>\n<li><strong>Whitespace<\/strong> \u2014 trailing spaces in the name and email columns<\/li>\n<li><strong>Dates<\/strong> \u2014 mixed formats, plus one impossible date<\/li>\n<li><strong>Categories<\/strong> \u2014 &#8220;UK&#8221;, &#8220;U.K.&#8221;, and &#8220;United Kingdom&#8221; in the same column<\/li>\n<li><strong>Numbers<\/strong> \u2014 a total column with three values stored as text<\/li>\n<\/ul>\n<p>Five defect types is enough. More than that turns the race into a scavenger hunt and hides the learning.<\/p>\n<h2>Rules that make it fair<\/h2>\n<p>Write the rules on one page and read them aloud before the first leg. Each leg may fix one defect type only; everything else must be left, even if it is obvious.<\/p>\n<p>No deleting rows except confirmed duplicates. No retyping a whole column by hand \u2014 formulas or tools only, because the point is technique.<\/p>\n<blockquote><p>The constraint is the teacher. Without it, the fastest typist wins and nobody learns a function.<\/p><\/blockquote>\n<p>Require a one-line change log per leg. It forces teams to name what they did and makes the debrief much sharper.<\/p>\n<h2>Running the relay<\/h2>\n<p>Teams of three work best: one drives, one reads the rule sheet, one checks the change log. Rotate the driver each leg so everyone touches the keyboard.<\/p>\n<p>Ten minutes per leg, with a two-minute hand-over briefing where the receiving team asks one question. That question is often the most valuable minute of the exercise.<\/p>\n<p>Score each leg on three criteria: the defect type was fixed, nothing else was damaged, and the change log is accurate. Accuracy of the log matters because it reflects whether the team understood what it did.<\/p>\n<h2>The debrief<\/h2>\n<p>Project the original file and the final file side by side. Ask what got fixed, what got broken, and what nobody noticed.<\/p>\n<p>Then show the master key. The gap between what teams believe they fixed and what actually changed is the lesson, and it is usually larger than anyone expects.<\/p>\n<p>Finish by asking which defect would be most expensive in a real report. Duplicates and text-stored numbers both quietly corrupt totals, and students usually spot that without prompting.<\/p>\n<h2>Adapting the difficulty<\/h2>\n<p>Beginners need obvious defects, a smaller file, and more time. Advanced groups get ambiguous cases: two records that might be the same customer, a date that could be read two ways.<\/p>\n<p>Add a final leg where one team member must explain the workbook to someone who has never seen it. If the explanation is confusing, the cleaning was incomplete.<\/p>\n<p>For other spreadsheet activities that build the same habits, <a href=\"https:\/\/excelgames.cc\/\">the Excel games collection<\/a> includes team formats and templates. Take the structure, replace the data with your own, and the exercise stays fresh each time you run it.<\/p>\n<p>Keep the fastest and cleanest workbook as an example for the next cohort. A real before-and-after is more persuasive than any explanation of why data hygiene matters.<\/p>\n<h2>Making the scoring visible<\/h2>\n<p>Project a simple scoreboard between legs: defects fixed, defects introduced, and log accuracy. Three columns, updated live.<\/p>\n<p>Teams respond to a visible score in a way they never respond to a rubric. The scoreboard also makes the trade-off between speed and care impossible to ignore.<\/p>\n<p>Weight the accuracy column heavily. A team that fixes five defects and breaks two has made the data worse, and the scoreboard should say so.<\/p>\n<blockquote><p>Score what you want repeated, not what is easy to count.<\/p><\/blockquote>\n<p>Announce the final scores with the before-and-after file. The combination of number and evidence is what the group remembers.<\/p>\n<p>Keep the scoreboard template for next time. Rebuilding it wastes the first ten minutes of the session.<\/p>\n<h2>Adapting it for remote teams<\/h2>\n<p>Share one workbook per team through a collaborative editor and use separate tabs per leg. The hand-off happens by moving the active tab, which keeps the history visible.<\/p>\n<p>Replace the physical hand-off with a short written message naming what was fixed. The message becomes the change log.<\/p>\n<blockquote><p>Remote drills need an explicit hand-off, because nobody can see the screen.<\/p><\/blockquote>\n<p>Keep the calls short and cameras off if bandwidth is limited. The exercise is about the file, not the meeting.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>TL;DR \/ Summary: A data cleaning relay race teaches spreadsheet hygiene faster than a lecture. Each team inherits a deliberately messy file, fixes one defect per hand-off, and passes it on \u2014 with the clock running and a rules sheet enforcing the fixes. The format in one paragraph Four teams, four messy workbooks, ten minutes [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":12,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[7],"tags":[],"class_list":["post-225","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-classroom-activities"],"blocksy_meta":{"styles_descriptor":{"styles":{"desktop":"","tablet":"","mobile":""},"google_fonts":[],"version":8}},"_links":{"self":[{"href":"https:\/\/excelgames.cc\/blog\/wp-json\/wp\/v2\/posts\/225","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/excelgames.cc\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/excelgames.cc\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/excelgames.cc\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/excelgames.cc\/blog\/wp-json\/wp\/v2\/comments?post=225"}],"version-history":[{"count":1,"href":"https:\/\/excelgames.cc\/blog\/wp-json\/wp\/v2\/posts\/225\/revisions"}],"predecessor-version":[{"id":226,"href":"https:\/\/excelgames.cc\/blog\/wp-json\/wp\/v2\/posts\/225\/revisions\/226"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/excelgames.cc\/blog\/wp-json\/wp\/v2\/media\/12"}],"wp:attachment":[{"href":"https:\/\/excelgames.cc\/blog\/wp-json\/wp\/v2\/media?parent=225"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/excelgames.cc\/blog\/wp-json\/wp\/v2\/categories?post=225"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/excelgames.cc\/blog\/wp-json\/wp\/v2\/tags?post=225"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}