|
Pupil Tracking
and Exam Analysis
Tracking
pupil progress can provide invaluable information to a school
and as a result enable Teachers, Heads of Department, Heads of
Year, Senior Leadership Teams and Headteachers to most
appropriately target support and resources.
The problem can be that data is inaccessible or that
members of staff do not have the computer skills necessary to
manipulate the data into a useable form.
The accompanying spreadsheet is designed to track
progress from Year 7 through to Year 11 on a single
spreadsheet. [Instructions will be added soon] This spreadsheet has been designed so that it is possible to enter a cohorts results onto a single spreadsheet. By entering the exam boundaries it calculates a 10 point split level. NEW 2 TIER Tracking Spreadsheet - Click here If you feel this might be of use and have any questions please email me at markgreenaway1@googlemail.com Exam Analysis You can enter the topics for each question and the number of marks and the spreadsheet analyses the performance of each pupil for each question - click here KS3 SATs analysis by Question, Pupil, Gender & Class You will need a sheet per
class, the spreadsheet produces a summary of the two papers
for each pupil which can be used by the pupil or teacher to
inform future work. KS3 SATs analysis by Question, Pupil, Gender & Class You will need a sheet per
class, the spreadsheet produces a summary of the two papers
for each pupil which can be used by the pupil or teacher to
inform future work.
Year 7 and 8 Optional Tests Year 7 Optional Test -
Click here |
|
|