Assessment Links

Tracking Progress across KS1 Updated

KS1

These 2 Excel files can be used to show pupils' progress across KS1 - one sheet is designed for you to write children's names/initials in, the other to collate the numbers of children at each level. (Percentages will be automatically calculated.)

Please also see the Word document, which gives guidance and explanations.

(NB if your school uses the HCC suite of Assessment reports in SIMS AM7, these reports can be run straight from SIMS).

• Excel 2003, 24kb/1 sheet, 29/11/2010, herts_tracking_sheet_fs_to_ks1_2010_names.xls
• Excel 2003, 31kb/1 sheet, 29/11/2010, herts_tracking_sheet_fs_to_ks1_2010_numbers.xls
• Word 2003, 144kb/3 pages, 20/10/2011, tracking_progress_across_ks1.doc

Key Questions for School Self Evaluation and Improvement

Updated

KS1

• Word 2003, 61kb/4 pages, 14/11/2011, key_questions_for_selfevaluation_KS1_2011.doc

KS2

• Word 2003, 63kb/4 pages, 14/11/2011, key_questions_for_selfevaluation_KS2_2011.doc

Guidance on possible preliminary data analysis of your 2010 KS2 results

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

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, 2010 or 2011) 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, 198kb/7 sheets, 12/07/2011, ks2_2011_marks_fine_levels.xls
• 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