Randomised Times Tables Test Excel Grid

A little self-randomising times-tables test utility I’m particularly pleased with for some reason. It’s a simple 10x10 tables grid, which randomly blanks out half its boxes and leaves the other half blank to be filled in. The pupils seem to particularly like them that way, and responded well to having a limited random arrangement to test themselves on as a starter every lesson (I’d also often get them to colour code their boxes, green, yellow or red, depending on how quickly and easily they were able to complete them).

I’d suggest using as a easy timed starter. Bear in mind you can very quickly generate thirty distinct and separate ones, to ensure every pupil has their own unique one, and thus cut down on ‘over the shoulder’ copying.

Just press F9 in Excel to update the random grid.

Note: This is included in my larger collection of all my self-randomising Excel worksheets.