This document is completely free for you to copy and adapt. Download here
Note the usage guidance underneath.
Describe your image
Report Writer Guide
I hope with some self-exploration and the example written in that the report spreadsheet should be straight forward to figure out. But if you can’t get your head around any of it, hopefully this will help:
To begin writing reports you will need to write out your templates. I imagined this around giving the option for you to structure your reports in up to 3 sections.
For example, section 1 may be outlining their recent progress data, section 2 could be about their behaviour and section 3 on how they could improve.
You do not need to use all three sections, but it allows flexibility and gives you the option to create lots of different combinations.
When writing out your templates, always write using male pronouns otherwise the formulas will not change them correctly. Also note that I have attempted to make the ‘they, them, their’ pronouns work, however quite regularly other words also need to change which I cannot build in, so I would highly recommend proof reading those carefully.
When writing your templates, use the codes where you want the formulas to replace things like First Name or Grade. e.g. If you wrote “Fname is a smart student” in as a template. When you pick this in the reports worksheet “Fname” will be picked up and change to the students’ first name.
Note that you can edit the labelling of the templates to whatever you choose. I have simply put A,B,C,D etc. but if you wanted to give them something more descriptive or a particular code you can modify these as you wish. The spreadsheet will adapt.
Also note that you can write quite a few templates, I expanded the formulas down to account for about 50 in each section. If you go further then formulas would need to be changed, but I think that unlikely.
Once you have written out your templates (or just a few couple to see how it works) go to the Reports worksheet to start generating reports. You will need to enter in (or copy over) student names and any of the additional data such as Grades and Attendance (note you do not actually have to use these to insert grades and attendance, they are just suggestions). Then select a label for each and all sections you wish to be included in the report. As you select them you will see the report being generated in column K.