{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Guide to Ready Reckoners","Guidance","Data Input Guidance","Data Input","School VA Calculation","Interpreting the score","Data","Charts"],"not_rendered":{"charts":2,"images":9,"macros":0,"external_links":3,"defined_names":14,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Guide to Ready Reckoners","index":0,"n_rows":21,"n_cols":10,"rows_kept":21,"cut":false,"hidden":false,"merged":[[20,2,22,3]]}
[]
[null,"GUIDE TO 2018 KEY STAGE 2 TO 4 READY RECKONERS "]
[]
[null,"There are four key stage 2 to 4 ready reckoners."]
[]
[null,"This is the Progress 8 element breakdown school ready reckoner. The aim is to help the user understand how we arrive at a value added score for their school. "]
[null,"The ready reckoner allows the user to input the value added scores in Progress 8 or any of its elements, for all pupils in their school. "]
[null,"These value added scores can be copied and pasted directly from the pupil level file on the ",null,null,null,null,null,null,null,"Checking site."]
[]
[null,"The aim of the Progress 8 element breakdown pupil ready reckoner is to help the user to understand how we arrive at a value added score for their pupil. "]
[null,"The ready reckoner allows the user to input, for an individual pupil, their key stage 2 prior attainment and key stage 4 outcome in Attainment 8 or any of its elements. "]
[]
[null,"The aim of the EBacc subject pupil ready reckoner is to help the user to understand how we arrive at a value added score for their pupil. "]
[null,"The ready reckoner allows the user to input, for an individual pupil, their key stage 2 prior attainment and key stage 4 attainment in any of the three subject areas in the English Baccalaureate. "]
[]
[null,"The aim of the EBacc subject school ready reckoner is to help the user understand how we arrive at a value added score for their school. "]
[null,"The ready reckoner allows the user to input the value added scores in any of the three subject areas in the English Baccalaureate, for all pupils in their school. "]
[null,"These value added scores can be copied and pasted directly from the pupil level file on the ",null,null,null,null,null,null,null,"Checking site."]
[]
[]
[null,null,"To Guidance  --->"]

{"sheet":"Guidance","index":1,"n_rows":47,"n_cols":19,"rows_kept":47,"cut":false,"hidden":false,"merged":[[46,18,48,20],[46,14,48,16],[26,9,27,12],[36,2,36,4]]}
[]
[null,"2018 PROGRESS 8 SCHOOL LEVEL READY RECKONER GUIDANCE"]
[]
[null,"This ready reckoner allows the user to see how value added scores are calculated for their school from individual pupil scores for Progress 8 and elements making up Progress 8.  "]
[null,"For more information on calculating these scores for individual pupils, please see the pupil Progress 8 and Progress 8 elements ready reckoner."]
[null,"Please note that all attainment estimates and calculations relate to 2018 only."]
[null,"The following steps explain how to use the school level ready reckoner:"]
[]
[null,"Step 1)    ","The first step is to go to the 'Data Input' sheet. There you can select the progress measure you wish to use in the ready reckoner by changing the drop down"]
[null,null,"box at the top of the sheet. The circled part of the screenshot below shows the drop down box to select from…"]
[]
[]
[]
[]
[]
[]
[null,null,"You can then enter the individual pupil VA scores for pupils in your school under the heading 'Pupil VA Scores (centred around zero)' in the 'Data Input' sheet"]
[null,null,"The screenshot below shows where to enter the pupil data in the 'Data Input' sheet"]
[null,null,"For further guidance on inputting individual pupil VA scores from the pupil level data file on the Checking website, see the tab 'Data Input Guidance'."]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"Enter individual pupil VA score here"]
[]
[]
[]
[]
[]
[]
[]
[null,"Step 2)","The next step is to go to the 'School VA Calculation' sheet. This sheet provides information on how your school VA score has been calculated from"]
[null,null,"individual pupil VA scores. For more information on the calculation of school VA scores, please see the guidance at the following link:"]
[null,null,"Progress 8 and Attainment 8 guidance"]
[]
[null,"Step 3)","The final step is to go to the 'Interpreting the score' sheet. This sheet provides information on how to interpret your school's VA score and the associated "]
[null,null,"confidence intervals."]
[]
[null,null,"The guidance at the link above provides further detail on the calculation of confidence intervals and how to interpret them."]
[]
[null,"Note: ","The ready reckoner only provides correct calculations for pupils reaching the end of key stage 4 in 2018. "]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"To Data Input Guidance sheet --->",null,null,null,"To Data Input sheet --->"]

{"sheet":"Data Input Guidance","index":2,"n_rows":83,"n_cols":12,"rows_kept":83,"cut":false,"hidden":false,"merged":[[9,11,33,18],[68,11,71,14],[82,1,84,3],[5,8,5,12]]}
[]
[null,"DATA INPUT GUIDANCE - USING THE CHECKING EXERCISE WEBSITE "]
[]
[null,"The following guidance is designed to help users import individual pupil VA scores from the Checking website."]
[]
[null,"The first step is to visit the school Checking Site at ",null,null,null,null,null,null,"https://tableschecking.education.gov.uk/"]
[null,"Select the link '2018 Key Stage 4/16 to 18 Performance Tables Checking Exercise' and log in to your school’s account (you will need your username and password): "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Once logged in to your school account, select the ‘Guidance/Documents’ tab and select the ‘Key stage 4 pupil level’ file. "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Pupil Progress 8 scores can be found in column BI. Pupil VA scores for the English, maths, EBacc, and open elements of Progress 8 can be found in columns BJ, BK, BM, and BO respectively"]
[null,"Copy and paste all of the VA scores for pupils in your school into the Data Input tab of this file"]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Once you have copied your pupils' VA scores from the Excel file, right click here and select paste"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"To Data Input sheet --->"]

{"sheet":"Data Input","index":3,"n_rows":513,"n_cols":36,"rows_kept":513,"cut":false,"hidden":false,"merged":[[5,2,5,3],[5,13,5,16]]}
[]
[null,null,"DATA INPUT - INDIVIDUAL PUPIL VA SCORES"]
[]
[null,null,"1) Please select from the drop down box below the progress measure for which you would like to calculate a school VA score.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"KS2-4 'School Progress 8 measure'",1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"--Select--"]
[null,null,"Progress 8",null,null,null,null,null,null,null,null,null,null,"To School VA Calculation sheet --->",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Progress 8",1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Progress 8 - English element",2]
[null,null,"2) For the progress measure selected above, please type or paste the VA scores for the pupils in your school under the heading 'Pupil VA Scores' below.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Progress 8 - maths element",3]
[null,null,"Note: please be aware that the 'Pupil Included or Not Included in the measure?' column is automatically completed",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Progress 8 - EBacc element",4]
[null,null,"based on whether a valid number is entered into the 'Pupil VA Scores' column.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Progress 8 - open element",5]
[]
[]
[null,null,"Pupil VA Scores\n(Centred around zero)","Pupil Included or Not Included in the measure?"]
[null,null,null,{"$f":"IF(ISNUMBER(C14),\"Included\",\"Not Included\")","v":"Not Included"}]
[null,null,null,{"$f":"IF(ISNUMBER(C15),\"Included\",\"Not Included\")","v":"Not Included"}]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,{"$f":"IF(ISNUMBER(C79),\"Included\",\"Not Included\")","v":"Not Included"}]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,{"$f":"IF(ISNUMBER(C143),\"Included\",\"Not Included\")","v":"Not Included"}]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,{"$f":"IF(ISNUMBER(C207),\"Included\",\"Not Included\")","v":"Not Included"}]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,{"$f":"IF(ISNUMBER(C271),\"Included\",\"Not Included\")","v":"Not Included"}]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,{"$f":"IF(ISNUMBER(C335),\"Included\",\"Not Included\")","v":"Not Included"}]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,{"$f":"IF(ISNUMBER(C399),\"Included\",\"Not Included\")","v":"Not Included"}]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,{"$f":"IF(ISNUMBER(C463),\"Included\",\"Not Included\")","v":"Not Included"}]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]
[null,null,null,"Not Included"]

{"sheet":"School VA Calculation","index":4,"n_rows":20,"n_cols":12,"rows_kept":20,"cut":false,"hidden":false,"merged":[[19,11,21,13],[3,11,4,15]]}
[]
[null,"CALCULATION OF A SCHOOL VA SCORE"]
[null,null,null,null,null,null,null,null,null,null,null,"Progress Measure:"]
[null,"This sheet explains the steps taken to calculate a school's VA score from the individual pupil VA scores",null,null,null,null,null,null,null,null,null,{"$f":"'Data Input'!C6","v":"Progress 8"}]
[]
[]
[null,"Step 1 - Calculate the average pupil VA score"]
[]
[null,"This step calculates the average of the individual pupil VA scores entered in the 'Data Input' sheet."]
[]
[]
[]
[null,"The sum of all pupils' VA scores for your school         ",null,null,null,"=",{"$f":"ROUND(SUM('Data Input'!$C$14:$C$513),2)","v":0}]
[]
[null,"Number of pupils in the VA calculation for your school ",null,null,null,"=",{"$f":"IF(ISNUMBER(COUNTIF('Data Input'!$D$14:$D$513,\"Included\")),COUNTIF('Data Input'!$D$14:$D$513,\"Included\"),\"-\")","v":0}]
[]
[null,"Step 2 - School VA score"]
[null,"The average of the pupil VA scores is otherwise known as the 'School VA score'."]
[]
[null,null,null,null,"Final school VA score                              ","= ",{"$f":"IF(ISNUMBER(ROUND(AVERAGE('Data Input'!$C$14:$C$513),1)),ROUND(AVERAGE('Data Input'!C14:C513),2),\"-\")","v":"-"},null,null,null,null,"To Interpreting the score sheet --->"]

{"sheet":"Interpreting the score","index":5,"n_rows":48,"n_cols":18,"rows_kept":48,"cut":false,"hidden":false,"merged":[[2,10,4,10],[47,10,49,10],[42,10,44,10],[10,6,11,6],[35,1,37,6],[16,1,17,3],[12,1,13,1],[12,4,13,4]]}
[]
[null,"INTERPRETING CONFIDENCE INTERVALS AROUND A SCHOOL VA SCORE",null,null,null,null,null,null,null,null,"Progress Measure:",null,null,null,null,null,{"$f":"G13","v":"-"},{"$f":"Q2-Q4","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"'Data Input'!C6","v":"Progress 8"},null,null,null,null,null,{"$f":"G17","v":"-"},{"$f":"Q3-Q4","v":{"$error":"#VALUE!"}}]
[null,"To judge a school’s effectiveness, both the school VA score and its associated confidence interval need to be"]
[null,"taken into account. This sheet explains how to interpret a confidence interval around a school VA score.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(R2>0,R3>0),1, IF(AND(R2<0,R3<0),3,2))","v":{"$error":"#VALUE!"}}]
[]
[null,"Step 1 - Calculate the confidence interval around the school Progress 8 score"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Your School's Progress 8 Score is Significantly Above National Average"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Your School's Progress 8 Score is Significantly Below National Average"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Your School's Progress 8 Score is Not Significantly Different From National Average"]
[null,null,null,null,null,null,"Upper confidence limit ="]
[]
[null,"School Progress 8 Score =",null,null,"Confidence \ninterval =",null,{"$f":"IF(ISERROR(B15+E15),\"-\",ROUND(B15+E15,6))","v":"-"}]
[]
[null,{"$f":"IF(ISNUMBER('School VA Calculation'!G20),'School VA Calculation'!G20,\"-\")","v":"-"},null,"+/-",{"$f":"IF(ISERROR(IF($B$15=\"-\",\"-\",Data!F22)),\"-\",IF($B$15=\"-\",\"-\",Data!F22))","v":"-"}]
[null,null,null,null,null,null,"Lower confidence limit ="]
[null,"Number of pupils in the Progress 8 calculation for your school =",null,null,null,null,{"$f":"IF(ISERROR(B15-E15),\"-\",ROUND(B15-E15,6))","v":"-"}]
[null,null,null,null,{"$f":"'School VA Calculation'!$G$15","v":0}]
[]
[]
[null,"Step 2 - Interpreting the Confidence Interval around the School Progress 8 Score"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,{"$f":"IF(ISERROR(IF(R5=1,R8,IF(R5=2,R10,R9))),\"-\",IF(R5=1,R8,IF(R5=2,R10,R9)))","v":"-"}]
[]
[]
[]
[null,"Subject",null,"Progress 8","English element","Maths element","EBacc element","Open element"]
[null,"Standard deviation",null,{"$f":"Data!F5","v":1.2892600000000001},{"$f":"Data!G5","v":1.5381450000000001},{"$f":"Data!H5","v":1.3713340000000001},{"$f":"Data!I5","v":1.5126250000000001},{"$f":"Data!J5","v":1.4782379999999999}]
[]
[null,null,null,null,null,null,null,null,null,null,"Back to School VA Calculation sheet <---"]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Back to Ready Reckoner Guidance <---"]

{"sheet":"Data","index":6,"n_rows":125,"n_cols":11,"rows_kept":125,"cut":false,"hidden":true,"merged":[]}
[]
[null,"UNDERLYING DATA AND CHARTS SHEET"]
[null,null,null,null,null,"SQL Output"]
[null,null,null,null,null,"p8stdev","p8engstdev","p8matstdev","p8ebacstdev","p8openstdev"]
[null,null,null,null,null,1.2892600000000001,1.5381450000000001,1.3713340000000001,1.5126250000000001,1.4782379999999999]
[null,"Key","Measure","Standard Deviation",null,null,-34.849634000000002,3.447346,-3.8552719999999998,-1.8774930000000001,1.5853699999999999]
[null,1,"Progress 8",{"$f":"F5","v":1.2892600000000001},null,null,18.031140000000001,-0.53564599999999996,1.8557900000000001,0.89948600000000001,0.26448899999999997]
[null,2,"Progress 8 - English element",{"$f":"G5","v":1.5381450000000001}]
[null,3,"Progress 8 - maths element",{"$f":"H5","v":1.3713340000000001},null,null,109.312094,1.9139820000000001,1.4023270000000001,0.63715200000000005,0.30158699999999999]
[null,4,"Progress 8 - EBacc element",{"$f":"I5","v":1.5126250000000001},null,null,23.120256000000001,1.3824749999999999,0.818828,0.15153900000000001,2.8316999999999998E-2]
[null,5,"Progress 8 - open element",{"$f":"J5","v":1.4782379999999999}]
[]
[]
[]
[]
[null,null,null,null,"Model Selected",1]
[null,null,null,null,"Stdev =",{"$f":"VLOOKUP(F16,$B$7:$D$11,3,FALSE)","v":1.2892600000000001}]
[]
[null,null,null,null,"CONFIDENCE INTERVAL CHART DATA"]
[]
[null,null,null,null,"Number of Pupils in School","Upper CI","Lower CI"]
[null,null,null,null,{"$f":"'School VA Calculation'!G15","v":0},{"$f":"(1.96*($F17/SQRT($E$22)))","v":{"$error":"#DIV/0!"}},{"$f":"-F22","v":{"$error":"#DIV/0!"}},0,1]
[]
[null,null,null,null,"Number of Pupils","Upper CI","Lower CI"]
[null,null,null,null,0,{"$f":"(1.96*($F$17/SQRT(E25)))","v":{"$error":"#DIV/0!"}},{"$f":"-F25","v":{"$error":"#DIV/0!"}},0]
[null,null,null,null,5,1.1300862162631804,{"$f":"-F26","v":-1.1300862162631804},0]
[null,null,null,null,10,0.79909162684514212,-0.79909162684514212,0]
[null,null,null,null,15,0.65245558116703284,-0.65245558116703284,0]
[null,null,null,null,20,0.5650431081315902,-0.5650431081315902,0]
[null,null,null,null,25,0.50538992000000005,-0.50538992000000005,0]
[null,null,null,null,30,0.46135576586621885,-0.46135576586621885,0]
[null,null,null,null,35,0.42713244118490462,-0.42713244118490462,0]
[null,null,null,null,40,0.39954581342257106,-0.39954581342257106,0]
[null,null,null,null,45,0.37669540542106017,-0.37669540542106017,0]
[null,null,null,null,50,0.35736463957532677,-0.35736463957532677,0]
[null,null,null,null,55,0.34073381455430896,-0.34073381455430896,0]
[null,null,null,null,60,0.32622779058351642,-0.32622779058351642,0]
[null,null,null,null,65,0.31342952295630649,-0.31342952295630649,0]
[null,null,null,null,70,0.30202824562661024,-0.30202824562661024,0]
[null,null,null,null,75,0.29178700635772342,-0.29178700635772342,0]
[null,null,null,null,80,0.2825215540657951,-0.2825215540657951,0]
[null,null,null,null,85,0.27408616680633507,-0.27408616680633507,0]
[null,null,null,null,90,0.26636387561504743,-0.26636387561504743,0]
[null,null,null,null,95,0.25925955864102396,-0.25925955864102396,0]
[null,null,null,null,100,0.25269496000000002,-0.25269496000000002,0]
[null,null,null,null,105,0.2466050298977267,-0.2466050298977267,0]
[null,null,null,null,110,0.24093519085091139,-0.24093519085091139,0]
[null,null,null,null,115,0.23563926521809378,-0.23563926521809378,0]
[null,null,null,null,120,0.23067788293310942,-0.23067788293310942,0]
[null,null,null,null,125,0.22601724325263611,-0.22601724325263611,0]
[null,null,null,null,130,0.221628141106469,-0.221628141106469,0]
[null,null,null,null,135,0.21748519372234432,-0.21748519372234432,0]
[null,null,null,null,140,0.21356622059245231,-0.21356622059245231,0]
[null,null,null,null,145,0.20985174209821628,-0.20985174209821628,0]
[null,null,null,null,150,0.2063245708576685,-0.2063245708576685,0]
[null,null,null,null,155,0.20296947618824379,-0.20296947618824379,0]
[null,null,null,null,160,{"$f":"(1.96*($F$17/SQRT(E57)))","v":0.19977290671128553},-0.19977290671128553,0]
[null,null,null,null,165,0.19672275955493829,-0.19672275955493829,0]
[null,null,null,null,170,0.19380818717818671,-0.19380818717818671,0]
[null,null,null,null,175,0.19101943477697553,-0.19101943477697553,0]
[null,null,null,null,180,0.18834770271053008,-0.18834770271053008,0]
[null,null,null,null,185,0.18578502952140988,-0.18578502952140988,0]
[null,null,null,null,190,0.18332419200249941,-0.18332419200249941,0]
[null,null,null,null,195,0.18095861945079955,-0.18095861945079955,0]
[null,null,null,null,200,0.17868231978766339,-0.17868231978766339,0]
[null,null,null,null,205,0.17648981565228172,-0.17648981565228172,0]
[null,null,null,null,210,0.17437608891539386,-0.17437608891539386,0]
[null,null,null,null,215,0.17233653233271773,-0.17233653233271773,0]
[null,null,null,null,220,0.17036690727715448,-0.17036690727715448,0]
[null,null,null,null,225,0.16846330666666667,-0.16846330666666667,0]
[null,null,null,null,230,0.16662212234952947,-0.16662212234952947,0]
[null,null,null,null,235,0.16484001632711667,-0.16484001632711667,0]
[null,null,null,null,240,0.16311389529175821,-0.16311389529175821,0]
[null,null,null,null,245,0.16144088803759724,-0.16144088803759724,0]
[null,null,null,null,250,0.15981832536902846,-0.15981832536902846,0]
[null,null,null,null,255,0.15824372218679023,-0.15824372218679023,0]
[null,null,null,null,260,0.15671476147815325,-0.15671476147815325,0]
[null,null,null,null,265,0.15522927997655062,-0.15522927997655062,0]
[null,null,null,null,270,0.15378525528873963,-0.15378525528873963,0]
[null,null,null,null,275,0.1523807943152484,-0.1523807943152484,0]
[null,null,null,null,280,0.15101412281330512,-0.15101412281330512,0]
[null,null,null,null,285,0.14968357597137871,-0.14968357597137871,0]
[null,null,null,null,290,0.1483875898814592,-0.1483875898814592,0]
[null,null,null,null,295,0.1471246938097433,-0.1471246938097433,0]
[null,null,null,null,300,0.14589350317886171,-0.14589350317886171,0]
[null,null,null,null,305,0.14469271318550958,-0.14469271318550958,0]
[null,null,null,null,310,0.14352109298658866,-0.14352109298658866,0]
[null,null,null,null,315,0.1423774803949682,-0.1423774803949682,0]
[null,null,null,null,320,{"$f":"(1.96*($F$17/SQRT(E89)))","v":0.14126077703289755},-0.14126077703289755,0]
[null,null,null,null,325,0.14016994389712645,{"$f":"-F90","v":-0.14016994389712645},0]
[null,null,null,null,330,0.13910399729502754,-0.13910399729502754,0]
[null,null,null,null,335,0.13806200511559216,-0.13806200511559216,0]
[null,null,null,null,340,0.13704308340316754,-0.13704308340316754,0]
[null,null,null,null,345,0.13604639320531206,-0.13604639320531206,0]
[null,null,null,null,350,0.1350711376692208,-0.1350711376692208,0]
[null,null,null,null,355,0.1341165593638835,-0.1341165593638835,0]
[null,null,null,null,360,0.13318193780752371,-0.13318193780752371,0]
[null,null,null,null,365,0.13226658718197717,-0.13226658718197717,0]
[null,null,null,null,370,0.13136985421753186,-0.13136985421753186,0]
[null,null,null,null,375,0.13049111623340659,-0.13049111623340659,0]
[null,null,null,null,380,0.12962977932051198,-0.12962977932051198,0]
[null,null,null,null,385,0.12878527665444314,-0.12878527665444314,0]
[null,null,null,null,390,0.12795706692781622,-0.12795706692781622,0]
[null,null,null,null,395,0.12714463289209743,-0.12714463289209743,0]
[null,null,null,null,400,0.12634748000000001,-0.12634748000000001,0]
[null,null,null,null,405,0.12556513514035339,-0.12556513514035339,0]
[null,null,null,null,410,0.12479714545809209,-0.12479714545809209,0]
[null,null,null,null,415,0.1240430772526772,-0.1240430772526772,0]
[null,null,null,null,420,0.12330251494886335,-0.12330251494886335,0]
[null,null,null,null,425,0.12257506013426231,-0.12257506013426231,0]
[null,null,null,null,430,0.12186033065863941,-0.12186033065863941,0]
[null,null,null,null,435,0.1211579597903171,-0.1211579597903171,0]
[null,null,null,null,440,0.1204675954254557,-0.1204675954254557,0]
[null,null,null,null,445,0.11978889934633802,-0.11978889934633802,0]
[null,null,null,null,450,0.11912154652510892,-0.11912154652510892,0]
[null,null,null,null,455,0.11846522446971387,-0.11846522446971387,0]
[null,null,null,null,460,0.11781963260904689,-0.11781963260904689,0]
[null,null,null,null,465,0.1171844817145599,-0.1171844817145599,0]
[null,null,null,null,470,0.1165594933558054,-0.1165594933558054,0]
[null,null,null,null,475,0.1159443993875845,-0.1159443993875845,0]
[null,null,null,null,480,{"$f":"(1.96*($F$17/SQRT(E121)))","v":0.11533894146655471},-0.11533894146655471,0]
[null,null,null,null,485,0.11474287059531822,-0.11474287059531822,0]
[null,null,null,null,490,0.11415594669216318,-0.11415594669216318,0]
[null,null,null,null,495,0.11357793818476965,-0.11357793818476965,0]
[null,null,null,null,500,0.11300862162631806,-0.11300862162631806,0]

{"sheet":"Charts","index":7,"n_rows":2,"n_cols":4,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
[]
[null,null,null,0]