General School Parent Report Writing Template

Here is a spreadsheet template that you can use to create baseline Parent Reports for secondary school/college teachers to make report writing quick, easy and efficient!

Note that this spreadsheet has been designed to save time writing many reports for many students. This is just a generic parent report structure, however you can choose to edit this as you please!

The first sheet of this spreadsheet shows an example of this tool in action.
(This example is relevant for A-Level Maths, however you can easily edit this to suit whichever subject of your choice!)

How to use this spreadsheet:
1). In the third blank sheet ‘Parent Reports Template - BLANK’, copy and paste the names of your students in Columns A and B. (NOTE: You MUST have students’ first names in Column B, and surnames in Column A, if you wish to include surnames).

2). Type in the Gender of each student in Column C.
(NOTE: MUST ONLY use “M” for male students, “F” for female students or “NB” for students who use ‘they/them/their’ pronouns.

3). In the light blue cells (Columns AA to AF), you can input the main body of your parent reports as separate points to mention for MALE students in the grid provided.

Here is a suggested way that you could use this grid to structure your report:

• Row 1 comments can be used to represent an ‘Excellent student’
• Row 2 comments for a ‘Very Good student’
• Row 3 comments for a ‘Good/Satisfactory student’
• Row 4 comments for a ‘Below-par student’
• Row 5 comments for a ‘Poor student’.

4). In Column AG (the last light blue column), you can add a list of topics that you have covered in your course that you teach. (This can come from your course specification, etc.)
You can add up to 15 topics in this column, however you can tweak the formula in that column if you require more than 15 topics to be listed here.

5). Repeat Steps 3 and 4 above, but for the light pink cells (Columns AI to AO) - this is for FEMALE students.
(You can copy/paste your same references you used for the Male students, but just change the pronouns to female ones instead).

6). Repeat Steps 3 and 4 again above, but for the light yellow cells (Columns AQ to AW) - this is for students who go by ‘they/them/their’ pronouns.
(NOTE: This step is optional, if you don’t have any such students).
(However, again, you can copy/paste your same references you used for the Male and Female students already, but just change the pronouns accordingly for each cell, where appropriate).

7). Once the above is all been completed, you can now start to input the comments that you would like to use for your students:

• For the parent report comments, input a number from 1-5 in green Columns D, E, F, G, H which correspond to the Row numbers from Step 3 above.
• For the topic names, input a number from 1-15 in green Columns I, J, K, which correspond to the topic number you added in Step 4 above.

8). Finally, your Parent Reports are compiled in Columns V & W!