Resources for Teachers

In this section, I’ll post some resources that we’ve come up with. Everything here is Open Source and free to use.

Report Writer and Comment Bank

Here is a report writer and comment bank that I put together in a mad fit of procrastination.

Report Writer Link

It is a Google Sheet with linked sheets. The first sheet is the Report Writer with it has a column for the name of the student  and then columns for drop down menu selection of the comments. I find this structure really useful for making sure that I hit all the points I want to in a report. The final column uses the =CONCATENATE(string 1, ” “, String 2, ” “, …) function to string all the different cells together in a coherent (as much as my reports are ever coherent) fashion. Not the ” ” places a space between the comments (Google Sheets – like Excel – removes the space at the end of the text in the cell).

The drop down menus come from a “Data Validation” where the list is a data range from Sheet 2. This data range is populated with cannibalized comments from previous reports.

Please feel free to share and use this as you want. I’ve set the link to view only which means you should be able to make a copy of it to edit and play with yourself.

Creative Commons License
This work is licensed under a Creative Commons Attribution-NonCommercial 4.0 International License.


Thanks for looking and if you have any questions comment, tweet us at @mr_van_w,  or send me an email at


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s