Student Assessment Table & Auto Chart Generator | Google Sheets Template

This is a Google Sheet for entering student data for multiple assessments (it is configured for up to 52 assessments and 36 students, although you can add more, or delete, if needed).

You can have a difficult value for the total number of marks available for each assessment. It will use the value you input and the students score to calculate a percentage automatically.

In addition, it will colour-code the scores against your chosen banding data (Eg. For an assessment out of 20, you might have: above average > 15, average 6-14, below average < 5).

Finally, it is set up to create a bar chart showing each child’s scores across the different assessments (so each child gets their own bar chart). You could use this to help the children to see trends and possible areas of weakness or where further work may be needed.

This assessment sheet was created as part of testing for an improvement to our Google Sheets Editable Teacher Planner and is released free, either for users of our planner to insert into their planner, or as a standalone resource.

You will receive a PDF with a link to the Google Drive to make a copy of the resource.