Easy to input data from SATs papers taken throughout the year (including actual SATs results). Could be adjusted for other year groups. Automatically calculates totals and percentages (based on which test has been taken). Spreadsheet also allows percentage and raw comparison between scores (to check/show progress) - this shows raw and percentage score increases. Standardised scores can also be inputted.
Spreadsheet is particularly useful in showing test progress in low scoring students.
Notes:
- Spreadsheet currently only has space for 11 names, so cells/formula will need to be extended to the desired number of names.
- When inputting names, you only need to input these into the Autumn spreadsheet (the rest will fill in automatically).
- Conditional formatting of Standardised scores is based on typical 100=EXP/110=GD boundaries
- If a child scores 0 in an earlier test, a percentage increase cannot be shown (as dividing by 0 - they will have improved their score by an infinite percentage).
Spreadsheet is particularly useful in showing test progress in low scoring students.
Notes:
- Spreadsheet currently only has space for 11 names, so cells/formula will need to be extended to the desired number of names.
- When inputting names, you only need to input these into the Autumn spreadsheet (the rest will fill in automatically).
- Conditional formatting of Standardised scores is based on typical 100=EXP/110=GD boundaries
- If a child scores 0 in an earlier test, a percentage increase cannot be shown (as dividing by 0 - they will have improved their score by an infinite percentage).
Something went wrong, please try again later.
This resource hasn't been reviewed yet
To ensure quality for our reviews, only customers who have purchased this resource can review it
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.
£2.50