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.
- 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).