A spreadsheet to try to remove some of the "guess work" in measuring KS3 progress without using levels.
You will need to create topic tests for your Scheme of Work. The spreadsheet is set up for these to be out of 60 marks but can be adapted otherwise.
For each student, enter their name, target GCSE grade, and mark for each topic test.
The spreadsheet calculates an integer value from -2 to 2 to indicate progression (nb - students with a target of 9 can only score a maximum of 0 for progress).
The spreadsheet calculates a "weighted average" score of a number of tests - weightings are based on the Edexcel 1MA0 specification (Higher).
Please note - this is still "work in progress" - any suggestions welcome.
You will need to create topic tests for your Scheme of Work. The spreadsheet is set up for these to be out of 60 marks but can be adapted otherwise.
For each student, enter their name, target GCSE grade, and mark for each topic test.
The spreadsheet calculates an integer value from -2 to 2 to indicate progression (nb - students with a target of 9 can only score a maximum of 0 for progress).
The spreadsheet calculates a "weighted average" score of a number of tests - weightings are based on the Edexcel 1MA0 specification (Higher).
Please note - this is still "work in progress" - any suggestions welcome.
Something went wrong, please try again later.
Report this resourceto let us know if it violates our terms and conditions.
Our customer service team will review your report and will be in touch.
£0.00