Assessment Links

Key Questions for School Self Evaluation and Improvement

KS1

• Word 2003, 57kb/4 pages, 29/12/2009, key_questions_for_selfevaluation_KS1.doc

KS2

• Word 2003, 60kb/4 pages, 29/12/2009, key_questions_for_selfevaluation_KS2.doc

Guidance on possible preliminary data analysis of your 2010 KS2 results New

KS2

Suitable both for schools that took part in SATs and those that boycotted

• Word 2003, 163kb/3 pages, 14/07/2010, guidance_data_analysis_2010_ks2.doc

Spreadsheet for calculating Average Points Scores from sub-levels Updated

KS2

The following spreadsheet can be used to determine the Average Points Score at KS2 of pupils, on the basis of their attainment (by sub-level). Schools that did not take part in the KS2 tests could use this spreadsheet to convert their Teacher Assessment data into an Average Points Score.

Download this spreadsheet to your computer by right-clicking the file and selecting ‘Save Target As’.

• Excel 2003, 131kb/2 sheets, 14/07/2010, ks2_points_calculator.xls

Spreadsheets for converting KS2 test scores into 'fine' points scores and levels Updated

The following spreadsheets can be used to determine the Average Points Score at KS2 of pupils, on the basis of the marks they scored in KS2 tests.

To use, first download the appropriate spreadsheet (2009 or 2010) to your computer by right-clicking the file and selecting ‘Save Target As’.

Then, follow the guidance given on the ‘Guidance’ tab of the spreadsheet.

• Excel 2003, 195kb/6 sheets, 07/07/2010, ks2_2010_marks_fine_levels.xls
• Excel 2003, 251kb/6 sheets, 02/07/2009, ks2_2009_marks_fine_levels.xls

Spreadsheet for converting KS1 levels into points scores

The following spreadsheet can be used to calculate points scores on the basis of pupils' KS1 assessment levels.

Download this spreadsheet to your computer by right-clicking the file and selecting ‘Save Target As’.
To use, follow the guidance given on the ‘Guidance’ tab of the spreadsheet.

• Excel 2003, 141kb/3 sheets, 02/07/2009, ks1_points_calculator.xls