Have you ever wanted to keep all your subject marks together on the one file and display a graph to parents at interview time of their student's progress compared to the class average? This spreadsheet designed specifically for Secondary teachers is the answer.
A flexible and customisable spreadsheet that allows for the following:
• up to six subjects
• up to six tasks per semester
• customise maximum mark for tasks
• customise weightings for different tasks
• adjust weightings of different semesters for final mark
• automatically allocates a grade
• automatically allocates a class rank
• displays class average for each task
• customise subject names
It is advisable to "Save As" first of all to keep your original file in tact and create a working copy. Comments have also been built in on the first two spreadsheet tabs to explain features in detail. (Small red triangles on some cells.)
Please note: the file was created using 2011 version of Excel. Not all embedded features may work on earlier versions.