End of Year Report Writing Assistant

Save time and effort writing reports. A report writing assistant allowing you to automatically create termly or yearly student report cards from a statement bank. Quickly and easily create a report by selecting statements with a click from 18 statements in each of 9 categories (162 statements in all) to build up a complete report comment, all of which will automatically adjust gender pronouns (he/she etc) and insert the students name where appropriate. Comments can also be free typed in the report comment box. All the statements in each category can be customised by the user. A class list with the gender of the students can be inserted and the final report comments can be copied and pasted into any other report package and the overall class comments saved to an xls file for archiving. The spreadsheet uses macros and will require macro access to be enabled, see the help sheet in the spreadsheet for details how to do this.
see a demo at https://youtu.be/7rNxxekoUpk
Please note this spreadsheet will not run on Mac versions of Excel, it will only run on PC versions of , due to incompatibility issues between Microsoft Office on the 2 different platforms.

Save for later
  • Report_Writing_Assistant.xlsm
  • Teacher_Planner_Evaluation_Version.xls

About this resource


Created: Oct 23, 2017

Updated: May 30, 2019


pdf, 1 MB



xlsm, 87 KB



xls, 1,017 KB


Report a problem

Tes Paid Licence

How can I re-use this?