• Front Page
  • Search
    • Digital Education
    • Terry Freedman's Books Bulletin
  • RSS
    • Welcome
    • The "About" Page
    • Testimonials
    • CV/Resumé
    • My Writing
    • Published articles
  • Corrections Policy
Menu

ICT & Computing in Education

Articles on education technology and related topics
  • Front Page
  • Search
  • Newsletters
    • Digital Education
    • Terry Freedman's Books Bulletin
  • RSS
  • Info
    • Welcome
    • The "About" Page
    • Testimonials
    • CV/Resumé
    • My Writing
    • Published articles
  • Corrections Policy

The Homework Excuse Management System, by Terry Freedman

Blast from the past: the homework excuse management system revisited

November 25, 2021

Or, how I eradicated the hassle of dealing kids who don’t do their homework, without resorting to detentions or any other kind of punishment

One year, I managed to ensure that nobody handed in their homework late, or not at all. I did so by the simple expedient of handing out a list of excuses at the start of the year, and telling my classes that if they didn't feel like doing their homework on occasion to simply let me know which number excuse they'd like to use. I would note that down in my markbook, and they needed to keep a record as well so that they didn't inadvertently use the same excuse twice.

I think the reason it worked so well was that the students knew I was on to them. As they were reading through the list of excuses I saw one or two exchange glances — the kind of glances that meant “Dang, we’ve been found out!”

There’s an app for that…

The ruse worked so well that I thought I'd digitise the system. The screenshot shows the Excel spreadsheet version. If an excuse was entered twice for the same pupil, a sad face would appear.

Behind the scenes were some quite complicated formulae, which if anyone is interested I'd be happy to share (if I can find them). The astonishing thing was that I was able to make the spreadsheet work without using any programming (in those days I employed Visual Basic for Applications a lot).

Fame at last!

Somehow or other, HEMS came to the attention of an education writer for The Guardian newspaper. He wrote something along the lines of: "And who can doubt the brilliance of the Homework Excuse Management System?!"

Lessons learnt

Very nice, to be sure, but there's a larger point to be made here I think. I developed HEMS for a laugh really. I know it's de rigeur to encourage pupils to find worthy problems that need sorting out, and to get on with sorting them (I advocate that myself). But in my opinion there's nothing wrong in creating or finding frivolous 'problems' that challenge pupils to really think about how best to solve them.

In the case of the HEMS, I could have used VBA, but I wanted to see if I could achieve the same result with no programming at all. It was a good exercise, because it really helped me to learn about a few kinds of formula and functions that I hadn't encountered before, and required a fair bit of research at the time.

Another advantage was that once I had worked out how to make the HEMS work, I was able to adapt and apply the formulae I used to other, more serious problems.

A great illustration of the fact that problem-solving, no matter how unimportant the problem, is never wasted.

This article first appeared in my free newsletter, Digital Education. Do sign up for tips, hints, news, views and reviews: Digital Education.

More spreadsheet-related articles
byway.jpg
Jul 28, 2025
The Value of Stating the Obvious
Jul 28, 2025

Do advertisers know something we don’t?

Jul 28, 2025
Using spreadsheets or Python to process words
Oct 4, 2023
Using spreadsheets or Python to process words
Oct 4, 2023

A couple of people and I started to discuss how we might use technology to process a block of text.

Oct 4, 2023
Use a spreadsheet for literary criticism: it's more accurate (Updated)
Mar 14, 2022
Use a spreadsheet for literary criticism: it's more accurate (Updated)
Mar 14, 2022

It seems to me that if you’re going to encourage students to use computer programming in literature studies, one very worthwhile project would be to get them to create a random book review or literary essay generator.

Mar 14, 2022
Use a spreadsheet for literary criticism: it's more accurate
Nov 21, 2021
Use a spreadsheet for literary criticism: it's more accurate
Nov 21, 2021

If book blurb writers had any sense, they wouldn’t put wordy descriptions on the back cover of books. They would put a graph there instead.

Nov 21, 2021
Introducing kids to programming via a spreadsheet sweet shop
Sep 15, 2021
Introducing kids to programming via a spreadsheet sweet shop
Sep 15, 2021

Spreadsheets are dead, right? Wrong! Not only are they a great tool for teaching programming concepts, they can easily be addressed under the Computing programme of study.

Sep 15, 2021
Book review: 100 Top Tips - Microsoft Excel, by Sean McManus
Sep 3, 2020
Book review: 100 Top Tips - Microsoft Excel, by Sean McManus
Sep 3, 2020

Could this book of 100 top tips for using Excel benefit heads of department or subject leaders?

Sep 3, 2020
How to see the trend in students' grades at a glance
Jun 15, 2020
How to see the trend in students' grades at a glance
Jun 15, 2020

Updated! Here’s a little-known function in Google Sheets which gives you an in-cell graph. Handy for displaying trends in students' grades at a glance.

Jun 15, 2020
How teachers can use the tick box in Google Sheets
Jun 10, 2020
How teachers can use the tick box in Google Sheets
Jun 10, 2020

Google sheets has a tick box feature. Here are some ways you can make use of it.

Jun 10, 2020
A self-marking spreadsheet UPDATED
Oct 21, 2019
A self-marking spreadsheet UPDATED
Oct 21, 2019

I like a challenge so I thought I’d try to create a self-marking spreadsheet in Excel. I was inspired to have a go at this by someone called Lee Rymill, who uploaded a self-marking spreadsheet to the CAS resources area. However, I wanted to take it a few steps further, using the Visual Basic for Applications programming language.

Oct 21, 2019
Useless utilities, pointless programs -- and why we should encourage kids to create them
Oct 11, 2019
Useless utilities, pointless programs -- and why we should encourage kids to create them
Oct 11, 2019

We should encourage pupils to write useless bits of code. Here’s why.

Oct 11, 2019


In Blast from the past, On the lighter side Tags spreadsheet, HEMS, homework
← A perfect example of why you should keep copies of your articles...3 reasons your students are bored in Computing lessons, and 9 solutions →
Recent book reviews
digital culture shock.jpg
Quick look: Digital Culture Shock: Who Creates Technology and Why This Matters

Chapters look at how technology is used around the world, online communities, and building a culturally just infrastucture, amongst other topics.

Read More →
Artificially Gifted Notes from a Post-Genius World.jpg
Quick look: Artificially Gifted: Notes from a Post-Genius World

The author, Mechelle Gilford, explores how AI may render our usual way of interpreting the concept of “gifted” obsolete.

Read More →
dr bot.jpg
Quick look: Dr. Bot: Why Doctors Can Fail Us―and How AI Could Save Lives

Dr Bot discusses something I hadn’t really considered…

Read More →
seven lessons 2.jpg
Review: Seven Brief Lessons on Physics: Anniversary Edition

Rovelli draws readers into his world by describing the development of theories that scientists have posited to try and explain our world and the universe beyond.

Read More →
dear data.jpg
Review: Dear Data

The authors spent a year sending each other postcards on a different theme each week, with pictorial representations of the data they had collected.

Read More →
Blueprints.jpg
Review: Blueprints: How mathematics shapes creativity

What place might Blueprints merit on a teacher’s bookshelves?

Read More →
renaturing.jpg
Review: Renaturing: Small Ways to Wild the World

This book could prove useful to schools keen to cultivate their own dedicated ‘back to nature’ area.

Read More →
listen in.jpg
Review: Listen In: How Radio Changed the Home

A couple of generations before the first internet cafés were opened, someone attempted pretty much the same thing by opening a ‘radio café’.

Read More →
level up.jpg
Review: Level Up Your Lesson Plans: Ignite the Joy of Learning with Fun and Educational Materials

This book is awash with ideas.

Read More →
conversations-with-Third-Reich-Contemporaries.jpg
Review: Conversations With Third Reich Contemporaries: : From Luke Holland’s Final Account

This may be useful for the Hiostory department in your school.

Read More →
Dig+Ed+Banner.jpg

Contact us

Privacy

Cookies

Terms and conditions

This website is powered by Squarespace

(c) Terry Freedman All Rights Reserved