• Front Page
    • Digital Education
    • Terry Freedman's Books Bulletin
  • RSS
  • Search
    • 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
  • Newsletters
    • Digital Education
    • Terry Freedman's Books Bulletin
  • RSS
  • Search
  • 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
July 28, 2025
The Value of Stating the Obvious
July 28, 2025

Do advertisers know something we don’t?

Read more →
July 28, 2025
Using spreadsheets or Python to process words
October 4, 2023
Using spreadsheets or Python to process words
October 4, 2023

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

Read more →
October 4, 2023
Use a spreadsheet for literary criticism: it's more accurate (Updated)
March 14, 2022
Use a spreadsheet for literary criticism: it's more accurate (Updated)
March 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.

Read more →
March 14, 2022
Use a spreadsheet for literary criticism: it's more accurate
November 21, 2021
Use a spreadsheet for literary criticism: it's more accurate
November 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.

Read more →
November 21, 2021
Introducing kids to programming via a spreadsheet sweet shop
September 15, 2021
Introducing kids to programming via a spreadsheet sweet shop
September 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.

Read more →
September 15, 2021
Book review: 100 Top Tips - Microsoft Excel, by Sean McManus
September 3, 2020
Book review: 100 Top Tips - Microsoft Excel, by Sean McManus
September 3, 2020

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

Read more →
September 3, 2020
How to see the trend in students' grades at a glance
June 15, 2020
How to see the trend in students' grades at a glance
June 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.

Read more →
June 15, 2020
How teachers can use the tick box in Google Sheets
June 10, 2020
How teachers can use the tick box in Google Sheets
June 10, 2020

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

Read more →
June 10, 2020
A self-marking spreadsheet UPDATED
October 21, 2019
A self-marking spreadsheet UPDATED
October 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.

Read more →
October 21, 2019
Useless utilities, pointless programs -- and why we should encourage kids to create them
October 11, 2019
Useless utilities, pointless programs -- and why we should encourage kids to create them
October 11, 2019

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

Read more →
October 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
The Learning Rainforest Great Teaching in Real Classrooms Great Teaching in Real Classrooms.jpg
Review: The Learning Rainforest: Great Teaching in Real Classrooms

This is a great book for dipping into in order to read about different teaching and assessment strategies, backed up by research.

Read more →
Outstanding Formative Assessment Culture and Practice.jpg
Review: Outstanding Formative Assessment: Culture and Practice

This book contains numerous assessment for learning techniques.

Read more →
New Media in the Classroom Rethinking Primary Literacy.jpg
Review: New Media in the Classroom: Rethinking Primary Literacy

This provides a great deal of information about the different aspects of "literacy” and how digital tools can be brought into the service of literacy in the primary school.

Read more →
Designing the internet of things.jpg
Review: Designing the internet of things

This book takes you through the process of designing connected devices from prototyping to launching.

Read more →
Uneducated.jpg
Quick look: (Un)educated: My Life as a Teacher, and Why You Should Never Become One

“Some of it is laugh-out loud funny, but some of it, about his reference being spiked, made me angry …”

Read more →
Hot TYpe.jpg
A Heads-up: Hot Type: The Magnificent Machine that Gave Birth to Mass Media and Drove Mark Twain Mad

This is about the invention of linotype, and its consequences.

Read more →
The new dark ages.jpg
Are we in, or entering, a post-literate society?

I know that there are people who think that Tik-Tok videos and other (very) short-form content is a kind of literacy that’s on a par with reading, but I have my doubts.

Read more →
amazing worlds.jpg
Review: Amazing Worlds

A very good showcase for what can be achieved from a partnership between imagination and AI.

Read more →
The Batsford Book of Chess for Children.jpg
Review: The Batsford Book of Chess for Children New Edition: Beginner’s chess for kids

This book doesn’t have any education technology, but I think the game of chess is a worthwhile activity for kids for developing strategic thinking skills.

Read more →
Flattening Classrooms, Engaging Minds.jpg
Review: Flattening Classrooms, Engaging Minds: Move to Global Collaboration One Step at a Time (Pearson Resources for 21st Century Learning)

The authors of this book, ran several projects which entailed collaboration between students in classrooms in different countries.

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