Assessment Links

Ofsted: Data Dashboard

Ofsted released the Data Dashboard in February 2013 with the aim that school governors and members of the public could easily investigate the results of any school.

There were some methodological problems with the early release of this tool, which have since been fixed. However there are still some interesting issues and limitations regarding the data shown in the dashboard. The purpose of the document is to explain these issues so that Headteachers and staff may have a better understanding of what the dashboard is saying and be able to explain it to governors.

The dashboard can be found by going to http://dashboard.ofsted.gov.uk and typing the name of a school into the search box.

Assessment Guidance document:

• Word 2003, 231kb/2 pages, 17/04/2013, guidance_ofsted_data_dashboard.doc

Tracking Progress across KS1

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

• Word 2003, 266kb/3 pages, 22/01/2013, tracking_progress_across_ks1_2013.doc updated
• 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

Key Questions for School Self Evaluation and Improvement

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 2012 KS2 results

KS2

• Word 2003, 156kb/ 5 pages, 20/07/2012, guidance_data_analysis_2012_ks2.doc
• Word 2003, 156kb/ 4 pages, 20/07/2012, attainment_progress_judgements_endY6.doc

Guidance on preliminary data analysis of your 2012 EYFS and KS1 results

EYFS/KS1

• Word 2003, 53kb/ 5 pages, 20/07/2012, guidance_preliminary data analysis_eyfs _KS1_2012.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

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 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, 413kb/7 heets, 20/07/2012, ks2_2012_marks_fine_levels.xls
• 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
• Excel 2003, 163kb/6 sheets, 02/07/2008, ks2_2008_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