The third in an occasional series of emails to staff with ‘elearning tips’. This is the last of the ones I’ve already sent. I’ll add the others to the blog as and when I send them.
In the series teachers write the names of students on lolly sticks, which is nice, but something I don’t really have time to do *
Instead, I’ve created a quick spreadsheet which allows you to print out classlists in a way in which they can easily be printed on to card snipped into lolly stick equivalent. You can download the spreadsheet here.
If you fancy giving it a go, simply do the following.
- In SIMS find a marksheet for the class you want to make lolly sticks for. Click Explort (above the list of names). This will open the marksheet as a spreadsheet.
- Copy the column of names into the first worksheet of the attached spreadsheet. Click on the second workbook to see the names nicely formatted. Change the class in the top ‘stick’ to the name of you class. The others will automatically update.
- Print. Copy onto card. Cut them up. You’re away.
Give it a try and let me know how you get on. Have a look at the rest of the episode of the classroom experiment to see some of the various ways staff at that school found for making them work for you. They discuss this around 25 mins into episode 1
* I also don’t have any lolly sticks, but let’s gloss over that.