{"id":233,"date":"2026-11-21T08:07:00","date_gmt":"2026-11-21T13:07:00","guid":{"rendered":"https:\/\/excelgames.cc\/blog\/?p=233"},"modified":"2026-11-15T03:33:21","modified_gmt":"2026-11-15T08:33:21","slug":"excel-game-sheets-for-substitute-teachers","status":"publish","type":"post","link":"https:\/\/excelgames.cc\/blog\/excel-game-sheets-for-substitute-teachers\/","title":{"rendered":"Excel Game Sheets a Substitute Teacher Can Run"},"content":{"rendered":"<p><strong>TL;DR \/ Summary:<\/strong> A substitute does not need a clever spreadsheet; they need a lesson that runs without you. Keep it to one tab, write instructions a non-specialist can follow in ninety seconds, and choose games that end on their own after thirty minutes.<\/p>\n<h2>Why a sub needs a self-running lesson<\/h2>\n<p>You are at home with a cold, and a stranger is standing in front of thirty students with your name on the board. Anything that requires your presence to explain is a liability.<\/p>\n<p>Spreadsheet games work well for substitutes because the screen does the teaching. The rules are visible, the score updates itself, and the activity has a defined end.<\/p>\n<p>The failure mode is a file with seven tabs, external links, and a hidden sheet that breaks when macros are disabled. It will break, and it will break at 08:45.<\/p>\n<h2>The one-tab rule<\/h2>\n<p>Everything a sub needs should live on a single visible tab: title, instructions, the game area, and a scoreboard. No navigation, no separate rules sheet, no \u201csee the second tab.\u201d<\/p>\n<p>If the game genuinely needs more space, duplicate the file and delete what is not required. A teaching file and a sub file are different artefacts with different jobs.<\/p>\n<p>Check that the tab is set as active when the file opens. A workbook that opens on a blank sheet is a workbook that causes a phone call.<\/p>\n<ul>\n<li><strong>One tab<\/strong> visible and active on open.<\/li>\n<li><strong>Instructions<\/strong> in the top ten rows, at 14 pt or larger.<\/li>\n<li><strong>No macros<\/strong> if the school disables them.<\/li>\n<li><strong>No external links<\/strong> that need approval.<\/li>\n<\/ul>\n<h2>Instructions a sub can read in ninety seconds<\/h2>\n<p>Write them as numbered commands, not as a description of the lesson\u2019s purpose. \u201c1. Open the file. 2. Read the rules aloud. 3. Split the class into pairs. 4. Students take turns typing a word in the yellow cell.\u201d<\/p>\n<p>Add one line about what to do when something goes wrong: \u201cIf the file will not open, play the paper version in the folder.\u201d A fallback removes the panic that makes substitutes abandon technology entirely.<\/p>\n<p>Keep the intended learning outcome out of the sub note. You can explain the pedagogy to a colleague later; the sub needs mechanics.<\/p>\n<h2>No-save policies and shared devices<\/h2>\n<p>Students will press random keys. Some will close the file. Decide in advance whether saving is allowed, and write it in the instructions.<\/p>\n<p>If the exercise is scored, ask students to screenshot the final screen and drop it into the class folder. That record survives a lost workbook and gives you something to grade.<\/p>\n<p>On shared devices, save a fresh copy per class period and name it by hour. Two classes writing to the same file produces a merge problem no substitute should have to solve.<\/p>\n<blockquote><p>If a lesson needs the teacher to rescue it, it is not a sub lesson.<\/p><\/blockquote>\n<h2>Two activities that survive thirty minutes<\/h2>\n<p>The first is a word or formula hunt: a grid of cells where students type answers and conditional formatting turns correct entries green. It needs no explanation beyond \u201cfind ten correct answers.\u201d<\/p>\n<p>The second is a simple score-keeping game in pairs, where each round asks a question and the pair records a point in a cell. The spreadsheet totals the points and declares a winner.<\/p>\n<p>Both have a visible finish line, both tolerate noisy classrooms, and both can be run by a sub who has never opened Excel.<\/p>\n<p>Thirty minutes is the sweet spot. Shorter and the room has nothing to do; longer and the last ten minutes become behaviour management.<\/p>\n<h2>What to leave on the desk<\/h2>\n<p>A printed page with the filename, the folder path, and three sentences about how to start. Print it even if you emailed it, because the sub may not have access to your inbox.<\/p>\n<p>Leave the fallback activity in the same folder, on paper. Assume the projector is broken, the network is down, or the devices are in another room for testing.<\/p>\n<p>Add a note about seating and pairings if your class has known combinations that should be avoided. A substitute cannot read the social map of a room in five minutes.<\/p>\n<p>Put the room number on the printed page too. Substitutes often move between rooms, and a filename without a location turns into a search at the worst possible moment.<\/p>\n<h2>Debrief questions for the returning teacher<\/h2>\n<p>When you come back, do not ask \u201cdid it go well.\u201d Ask three specific questions: how far did the class get, which instruction caused the most confusion, and how many students finished.<\/p>\n<p>Those answers tell you what to simplify in the file. Usually it is the instructions, not the game.<\/p>\n<p>Then fix the file that afternoon. The next absence is always sooner than expected, and a lesson that worked once tends to work again.<\/p>\n<h2>Building your own sub-proof sheet<\/h2>\n<p>Start from a game you already use, cut it to one tab, and rewrite the instructions in numbered steps. Add a paper fallback and a screenshot rule.<\/p>\n<p>Test it by handing it to a colleague who does not teach your subject and asking them to explain the first three steps back to you. If they hesitate, the sheet is not finished.<\/p>\n<p>A library of two or three of these, stored beside your lesson plans, turns a disrupted day into an ordinary one. <a href=\"https:\/\/excelgames.cc\/\">Excel-based classroom games<\/a> are only useful to a substitute if the file can explain itself, and that is a design decision you make in advance.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>TL;DR \/ Summary: A substitute does not need a clever spreadsheet; they need a lesson that runs without you. Keep it to one tab, write instructions a non-specialist can follow in ninety seconds, and choose games that end on their own after thirty minutes. Why a sub needs a self-running lesson You are at home [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":8,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[7],"tags":[],"class_list":["post-233","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\/233","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=233"}],"version-history":[{"count":1,"href":"https:\/\/excelgames.cc\/blog\/wp-json\/wp\/v2\/posts\/233\/revisions"}],"predecessor-version":[{"id":234,"href":"https:\/\/excelgames.cc\/blog\/wp-json\/wp\/v2\/posts\/233\/revisions\/234"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/excelgames.cc\/blog\/wp-json\/wp\/v2\/media\/8"}],"wp:attachment":[{"href":"https:\/\/excelgames.cc\/blog\/wp-json\/wp\/v2\/media?parent=233"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/excelgames.cc\/blog\/wp-json\/wp\/v2\/categories?post=233"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/excelgames.cc\/blog\/wp-json\/wp\/v2\/tags?post=233"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}