Electronic Markbook / Pupil tracking system

This spreadsheet functions as an electronic mark book. It automatically tracks the progress of each student against the class average and displays a graph allowing you to see which pupils are beginning to under-perform. It also makes report writing much easier as you can see at a glance how the student has performed over the term.

It automatically calculates the averages for each piece of work completed and can include data columns - for instance mid-term grades and final report grades if required (but the maximum mark box must be EMPTY).

The spreadsheet is automatically weighted and assumes that the importance is related to the maximum number of marks for an assignment - a 55 mark test is 5x as important as a 11 mark prep. This can be changed by entering a value in the weighting column - if you require the 11 mark prep to have equal weighting with the 55 mark test either change the weighting of the test to 11 or the prep to 55 depending on the other marks in the spreadsheet. if you would like all the pieces of work to have equal weighting, then put the same number (any number) along the weighting row.

e.g. 1 1 1 1 1, or 20 20 20 20 20, etc...

 PTS Markbook v0.41
 PTS Markbook v0.45

New Version 0.45 - Works in (the free) open office. Download from http://download.openoffice.org/






























The red pupil's attainment has consistently slipped relative to the class average, whereas the blue pupil has improved and the green pupil went through a bad patch in the middle of the assessment period. PTS Markbook v0.45