Special School Funding Template 2016-17 Input Guidance – At the bottom of the spreadsheet there are a number of tabs. Tab ‘Contents’ This tab is for information only and provides details the purpose of each of the other tabs within the template and hyperlinks to them. Initial Set-up 1’ Tab ‘Year On the 1’ Tab select the school DfE number in cell I2 at the top of the sheet. ‘Year The number can either be typed in directly or selected using the drop-down menu. Tab ‘Pupils’ On the Tab, enter pupil details under the pink shaded columns (Columns A, ‘Pupils’ D, E, G, I and J). Pupil Keys will be generated by the Schools & PVI Team and sent out with Monthly Statements in the new financial year. They are a combination of a DfE number followed by an underscore and an individual 3 digit identifying number for each pupil on roll (e.g. 7070_001). They are only necessary for the operation of the Tab and can be left ‘Reconciliation’ blank until receipt of the first Monthly Statement of the new financial year in April. Pupil Surnames need to be entered in Column D, Forenames in Column E, Need Types in Column G, and start and end dates in Columns I and J respectively. The cells left empty in Column A will turn ORANGE as data is entered in other columns.
Special School Funding Template 2016-17 – Input Guidance At the bottom of the spreadsheet there are a number of tabs. ‘Contents’ Tab This tab is for information only and provides details the purpose of each of the other tabs within the template and hyperlinks to them. Initial Set-up ‘Year 1’ Tab On the ‘Year 1’ Tab select the school DfE number in cell I2 at the top of the sheet. The number can either be typed in directly or selected using the drop-down menu. ‘Pupils’ Tab On the ‘Pupils’ Tab, enter pupil details under the pink shaded columns (Columns A, D, E, G, I and J). Pupil Keys will be generated by the Schools & PVI Team and sent out with Monthly Statements in the new financial year. They are a combination of a DfE number followed by an underscore and an individual 3 digit identifying number for each pupil on roll (e.g. 7070_001). They are only necessary for the operation of the ‘Reconciliation’ Tab and can be left blank until receipt of the first Monthly Statement of the new financial year in April. Pupil Surnames need to be entered in Column D, Forenames in Column E, Need Types in Column G, and start and end dates in Columns I and J respectively. The cells left empty in Column A will turn ORANGE as data is entered in other columns.
2016-17_Special_Schools_Budget_Template_Guidance.docx