Find me a pupil

I pinched this idea from Joe Holmes while he was on placement at BRJ and I’ve modified it a bit. The original incarnation by Mike Hollis at MMU can be found here.
I’ve included the macro in my excel register and it selects a pupil at random – it’s great for keeping them all on their toes because they are not sure who is going to have to answer a question….
You can download a copy of the template below - I keep all my registers in one excel file along with a copy of my timetable, class progress, a list of all students – anything that works nicely as a seperate tab.