Copy the exported attendance list from a Teams lesson into the A column of this spreadsheet and press Sort Attendance. It will get rid of repeated names, separate first and last names, and sort the list in alphabetical order. For me, this has made doing attendance from a Teams meeting substantially quicker. You will need to enable macros to make this spreadsheet work and names may not be in perfect order if the pupil does not have a First Name Last Name naming structure.

This is a macro enabled spreadsheet to be used with mini white boards. Three quadratics are randomly generated in the form ax^2+bx+c. The green question has a=1 and b and c are both positive, ranging from 1 to 12. The amber question has a=1, but b and c could be either negative or positive, but their absolute values range from 1 to 12. The red question has a>1 with factors ranging from 1 to 6; b and c could be positive or negative with absolute values ranging from 1 to 12. When factorised, the constant and coefficient in each bracket are mutually prime, so you don’t end up with quadratics that could be factorised in more than one way. Variables are also randomised for each question with i, l, o, and t omitted as possible variables. There are a couple of places where you could have a coefficient of 1 that shows, but this is a downfall of Excel (or perhaps my Excel programming skills!). When I use this file in lessons, I use that as an opportunity to remind pupils that you don’t have to write the 1 if you don’t want to do so and that mathematicians rarely do.

This is a macro-enabled spreadsheet to use as a hook for introducing algebraic proofs (or just so you can convince pupils that you can read their minds!). It’s fun to have the entire class do the activity and reveal which symbol they were all thinking of on a mini white board. Do it a few times and some will start to see the pattern with multiples of 9s, which leads nicely on to first explaining and then proving why the answer will always be a multiple of 9. I have also included a short video to show an example of me using it.

This is a spreadsheet that automatically generates differentiated questions and answers for 1-step equations to be done on mini white boards. Teachers can set the range of values that they would like used, although all variable answers are integers. I’ve also included a video showing how to use the spreadsheet.