Someone just had to go and do this, didn't they? One of my sole pleasures in life (cue violins) has been pitting my wits against the spreadsheet application Excel. Against the odds, I have devised formulae and functions, and code, to push Excel into doing things it was probably never designed to do.
Many of these were useful, like a staff rota and a technical support reporting system. Others were simply for the heck of it, like my (in)famous Homework Excuse Management System, which will tell you instantly if a pupil has used the same excuse before for not handing in their homework.
cross-posted at www.ictineducation.org
Terry Freedman is an independent educational ICT consultant with over 35 years of experience in education. He publishes the ICT in Education website and the newsletter “Digital Education."