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.
Enjoy!
|