Here is a report writer and comment bank that I put together in a mad fit of procrastination.
If you prefer here is an Excel version (Report Writer).
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.
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 catfisheducation@gmail.com
Thanks for posting this! It is going to be narrative writing time here pretty soon, so I really appreciate reading what other teachers are saying!
Narrative writing – that’s an excellent way to describe reports. I like that way of thinking about it.
is there a way you can automatically change the name and he /she?
Hmmmmm. Not sure, but I’ll investigate that – our report input is coded in that = the assigned gender of the student. But surely Sheets/Excel can manage this.