Automated spreadsheet templates for whole school grades summary

Rated 5.00 out of 5 based on 1 customer rating
(1 customer review)


Dear teachers, show-off your hard work on these four automated spreadsheets. It’s time to impress school management and parents during term reports and PTC’s.


These Spreadsheet templates can be used by primary, lower secondary and upper secondary year groups. Teachers can choose a template which best suits their work. The End-term Analysis template calculates both summative and formative grades in 40% and 60% and then displays term grade out of 100% marks. Teachers can change grade boundaries and percentage for summative and formative assessments. These templates also calculate maximum and minimum grades and displays them graphically. There are five worksheets in one Spreadsheet. Each spreadsheet displays a different analysis i.e attendance, modules, term marks, grades, comments, exam grades and their graphical representation. Teachers need to enter grades in the third worksheet. The rest is all calculated automatically.

Last but not the least, teachers can print out 4-5, A4 sized Spreadsheets in Landscape orientation, with all detailed analysis mentioned above.

All templates are password protected for additional security. Some rows and columns have cells locked in to avoid accidental deletion of formulas.

I have added several nested functions, such as the SUMIF and COUNTIF functions etc.

So sit back and relax because once you download these template, you will not need to calculate grades manually, anymore.

I am offering this simplified solution at a very reasonable price. I am sure these templates will bless you with more time to concentrate on other aspects of your job. Hope you like them and use them every day.

1 review for Automated spreadsheet templates for whole school grades summary

  1. Rated 5 out of 5


    Simply amazing! Very user-friendly! Highly recommended!

Add a review