370 likes | 549 Views
School Census Summer 2010. Jim Haywood Product Manager for Statutory Returns. Version 1.0. Headlines. 1. Dates. Census Day. Thursday 20th May 2010 Date used for snapshot information, e.g. Year Taught In. 2. Dates. Age at. 31st August
E N D
School Census Summer 2010 Jim HaywoodProduct Manager for Statutory Returns Version 1.0 Headlines 1
Dates Census Day • Thursday 20th May 2010 • Date used for snapshot information, e.g. Year Taught In 2
Dates Age at • 31st August • Used for determining if certain items of information are included for pupils, e.g. Attendance 3
Dates Continuous Information • Attendance: 01/01/2010 – 04/04/2010 • Exclusions: 01/09/2009 – 31/12/2009 • Learning Aims: 02/10/2009 – 20/05/2010 4
School Level Information Characteristics • Name • Phase • Type • Gender of Sixth Form • Gender of Entry • Highest NC Year • Lowest NC Year • Intake • Governance • Email • Telephone Number • Special School Information (Special School only) • Address Information 5
Pupil Level Information Pupils on-roll on 20/05/2010 - Identifiers • UPN • ULN • Former UPN • Surname • Forename • Middle Name • Preferred Surname • Former Surname • Gender • DOB 6
Pupil Level Information Pupils on-roll on 20/05/2010 - Characteristics • Ethnicity • Ethnicity Source • Free School Meal Eligibility • Connexions Assent • Language • G & T Indicator • Hours at Setting 7
Pupil Level Information Pupils on-roll on 20/05/2010 - Status • Enrolment Type • Type of Class • Entry Date • Part Time • Boarder • NC Year Actual 8
Pupil Level Information Pupils on-roll on 20/05/2010 - SEN • SEN Provision 9
Pupil Level Information Pupils on-roll on 20/05/2010 - Autumn Term Exclusions • Category • Reason • Start Date • Number of Sessions • In Care • SEN Provision 10
Pupil Level Information Pupils on-roll on 20/05/2010 - Home Address • Post Code • Quasi BS7666 Format Address 11
Pupil Level Information Pupils on-roll on 20/05/2010 - Contacts • Title • Surname • Forename • Middle Name • Relationship • Parental Responsibility • Address • Telephones 12
Pupil Level Information Pupils on-roll on 20/05/2010 - Spring Term Attendance • Possible Sessions • Numbers for each type of absence 13
Pupil Level Information Pupils on-roll on 20/05/2010 - Learning Aims • QAN • Discount Code • Start Date • Planned End Date • Actual End Date • Completion Status 14
Pupil Level Information Pupils who had left by 20/05/2010 but have historic Exclusions, Attendance or Learning Aims information to report - Identifiers • UPN • ULN • Former UPN • Surname • Forename • Middle Name • Preferred Surname • Former Surname • Gender • DOB 15
Pupil Level Information Pupils who had left by 20/05/2010 but have historic Exclusions, Attendance or Learning Aims information to report - • Ethnicity • Ethnicity Source Characteristics • Language 16
Pupil Level Information Pupils who had left by 20/05/2010 but have historic Exclusions, Attendance or Learning Aims information to report - • Entry Date • Leaving Date Status • Part Time • Boarder 17
Pupil Level Information Pupils who had left by 20/05/2010 but have historic Exclusions, Attendance or Learning Aims information to report - • Category • Reason • Start Date Autumn Term Exclusions • Number of Sessions • In Care • SEN Provision 18
Pupil Level Information Pupils who had left by 20/05/2010 but have historic Exclusions, Attendance or Learning Aims information to report - • Possible Sessions Spring Term Attendance • Number for each type of absence 19
Pupil Level Information Pupils who had left by 20/05/2010 but have historic Exclusions, Attendance or Learning Aims information to report - • QAN • Discount Code • Start Date Learning Aims • Planned End Date • Actual End Date • Completion Status 20
Statutory Return Tools Class Type • Update Class Type stores the chosen class type for each pupil for each individual Termly School Census • The default position for class type will be as entered for School Census Spring 2010 • New location - Tools | Statutory Return Tools | Update Class Type 21
Statutory Return Tools Hours at Setting • DCSF changed the name from Funded Hours to Hours at Setting to improve clarity • Hours at setting for 2 year olds is now available in addition to hours for 3 and 4 year olds • New location -Tools | Statutory Return Tools | Update Hours as Setting for 2 year olds - similarly for 3 and 4 year olds 22
External Files Deployment • Late changes to validation and reports are catered for by the External File Deployment mechanism • Revised filesets will be made available on SupportNet • System Manager Permissions required • Downloaded filesets can be imported via Tools |Setups| Import Fileset • On first use of these files a message is now display “Files are being loaded” 23
Changes to Panels Census Details • Age at date removed as it causes confusion • Ages are always worked out for the 31st August 24
Changes to Panels School Information • Displays in the same order as DCSF the Summary Report 25
Changes to Panels Hours at Setting • DCSF changed the name from Funded Hours to Hours at Setting to improve clarity • Hours at setting for 2 year olds is now available in addition to hours for 3 and 4 year olds • Recalculate button added 26
Changes to Panels Attendance • Checks for “legal” attendance codes as some schools are still able to change the codes • We now check for “missing marks” 27
Changes to Panels Learning Aims Submitted in Error • Now learning aims from the Autumn 2009 census are displayed from the internal database rather than the actual xml 28
Create & Validate Running • Activity bar is displayed while Return files are created and validated and now the message changes as the process takes place • Validation is produced from an XSL file provided by the DCSF 29
Create & Validate Display • Header information refers to Queries rather than Warnings • Validation Fileset Version number is now displayed on screen • Filter on display of Errors/Queries • is now separated into Errors or Queries and All (both errors and queries) • is reflected in the report as well as the display • Close button added to validation errors summary • Labels added to explain each part of the display • Hovering over cells displays the full content of the cells 30
Create & Validate Report • Output is sent to the browser as HTML • Print button has become the Report button 31
Changes to Information Collected Parental Contact Details • Telephone numbers with a location of “Other” are not included • The Return will include all of the contact telephone numbers (other than those with location of “Other”) rather than just the one flagged as Main • All Relationship Codes will be included 32
Changes to Information Collected Connexions Assent • Information now collected for age range of 12 to 25 33
Changes to Information Collected Boarder • Term time address is now taken to be the school address 34
Return File Reports Summary Report • This is produced from an XSL file provided by the DCSF • Version number displayed 35
Return File Reports Detail Reports • Still produced by CCS SIMS • User can select as many of the reports as they wish • A security message can be set up and included for each report • Criteria used for report is included in report header • Hours at Setting replaces the Funded Hours report • New Absence report to show persistent absentees 36
School Census Summer 2010 Jim HaywoodProduct Manager for Statutory Returns End of HeadlinesThank you for your time 37