Tuesday, 10 December 2013

The Awesome Fast Report Starter Spreadsheet!

It's that time of year again when teachers need to write reports. When I was in the classroom I always had trouble getting started, so I created the "Awesome Fast Report Starter Spreadsheet"

It uses just a few basic functions to compile together, the Vlookup function which searches for information in another table based on a value existing, Concatenate which joins text together, and Substitute which swaps out the wildcard ### for the student's name.

This is a great way to get started on your reports, and a practical way to use spreadsheets to get started with your reports. As a disclaimer putting in high, medium and low comments is not the end of my report writing. Once I have my spreadsheet start I then go and edit the prepared comment, adding personal examples, next steps, pronouns and other individual feedback.

If you find this useful I'd love to hear back from you either on this blog or via twitter where you can find me @shaunyk .