Monday, 16 May 2016

The fastest way to write your reports - Use a spreadsheet to write your reports

When I was in the classroom report time was not my favorite time of year. I could never think of the words to get started, and it was all a little overwhelming.

At the same time I have always been fascinated with spreadsheets, and so put these two together and over the last few years I have come up with this spreadsheet that basically writes reports for you based on a comment bank that you set up yourself.

This new version puts the student name and gender pronouns using a basic code (### for their name, and #his/her etc for the pronouns.

Here is a direct link to the spreadsheet, and embedded here is a short video that will tell you how to use the spreadsheet.

If you have any questions you can find me on Twitter @shaunyk or leave a comment on this post.

Thursday, 12 May 2016

Making the ultimate WANTED poster using Google Slides.

Recently as part of a social studies unit we had class I was asked to help create "Wanted" posters. Given our students have used Googles Slides for many projects this year we decided to create the posters using this tool. As a point of difference we used a custom slide size so that we could create portrait posters. A link to this template is here, as well as on the last page of the slideshow below. (It will prompt you to make a copy)

It was a great lesson and resulted in some terrific outcomes. I also gave students the option to use iPad apps such as "Over" or "PicCollage", but most of them ended up using Slides.