Skip to main content

Posts

Showing posts from September, 2014

Simple Random Group generator in Google Sheets

A member of staff asked me the other day if I could make a tool that would quickly generate a random set of groups from a list of students. Below is a brief video of spreadsheet I made that does the job. Its work in progress - in particular - I need to figure out how to use the indirect function in relationship to other functions for a dynamic range.

So the video:

Link to the spreadsheet here - feel free to make a copy - fix/improve etc.

Update - have fixed it so you don't ever have to fiddle with the formula - used the offset function for a dynamic range.

Set ChromeOS wallpaper by policy

You can now set the desktop wallpaper of ChromeOS via the management console. This is the top setting in 'user settings':
Simply upload a jpg file and away you go...
This is out one for the coming week:

Chris Bateman - our ace IT teacher made this image and a sequence for the whole year.

Special Characters and Definitions in Google Docs

Special Characters Demo

Definitions  in Docs