School Census Summer 2010

Headlines

1

Jim HaywoodProduct Manager for Statutory Returns

Version 1.0

Thursday 20th May 2010 Date used for snapshot information, e.g. Year Taught In

Dates

2

Census Day

31st August Used for determining if certain items of information are

included for pupils, e.g. Attendance

Dates

3

Age at

Attendance: 01/01/2010 – 04/04/2010 Exclusions: 01/09/2009 – 31/12/2009 Learning Aims: 02/10/2009 – 20/05/2010

Dates

4

Continuous Information

Name Phase Type Gender of Sixth Form Gender of Entry Highest NC Year Lowest NC Year Intake

School Level Information

5

Characteristics

Governance Email Telephone Number Special School

Information (Special School only)

Address Information

Pupil Level Information

6

Pupils on-roll on 20/05/2010 - Identifiers

UPN ULN Former UPN Surname Forename

Middle Name Preferred Surname Former Surname Gender DOB

Pupil Level Information

7

Pupils on-roll on 20/05/2010 -

Ethnicity Ethnicity Source Free School Meal

Eligibility

Connexions Assent Language G & T Indicator Hours at Setting

Characteristics

Pupil Level Information

8

Pupils on-roll on 20/05/2010 -

Enrolment Type Type of Class Entry Date

Part Time Boarder NC Year Actual

Status

Pupil Level Information

9

Pupils on-roll on 20/05/2010 -

SEN Provision

SEN

Pupil Level Information

10

Pupils on-roll on 20/05/2010 -

Category Reason Start Date

Number of Sessions In Care SEN Provision

Autumn Term Exclusions

Pupil Level Information

11

Pupils on-roll on 20/05/2010 -

Post Code Quasi BS7666 Format Address

Home Address

Pupil Level Information

12

Pupils on-roll on 20/05/2010 -

Title Surname Forename Middle Name

Relationship Parental Responsibility Address Telephones

Contacts

Pupil Level Information

13

Pupils on-roll on 20/05/2010 -

Possible Sessions Numbers for each type of absence

Spring Term Attendance

Pupil Level Information

14

Pupils on-roll on 20/05/2010 -

QAN Discount Code Start Date

Planned End Date Actual End Date Completion Status

Learning Aims

Pupil Level Information

15

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

Pupil Level Information

16

Pupils who had left by 20/05/2010 but have historic Exclusions, Attendance or Learning Aims information to report -

Ethnicity Ethnicity Source

Language

Characteristics

Pupil Level Information

17

Pupils who had left by 20/05/2010 but have historic Exclusions, Attendance or Learning Aims information to report -

Entry Date Leaving Date

Part Time Boarder

Status

Pupil Level Information

18

Pupils who had left by 20/05/2010 but have historic Exclusions, Attendance or Learning Aims information to report -

Category Reason Start Date

Number of Sessions In Care SEN Provision

Autumn Term Exclusions

Pupil Level Information

19

Pupils who had left by 20/05/2010 but have historic Exclusions, Attendance or Learning Aims information to report -

Possible Sessions Number for each type of absence

Spring Term Attendance

Pupil Level Information

20

Pupils who had left by 20/05/2010 but have historic Exclusions, Attendance or Learning Aims information to report -

QAN Discount Code Start Date

Planned End Date Actual End Date Completion Status

Learning Aims

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

Statutory Return Tools

21

Class Type

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

Statutory Return Tools

22

Hours at Setting

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”

External Files

23

Deployment

Age at date removed as it causes confusion Ages are always worked out for the 31st August

Changes to Panels

24

Census Details

Displays in the same order as DCSF the Summary Report

Changes to Panels

25

School Information

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

Changes to Panels

26

Hours at Setting

Checks for “legal” attendance codes as some schools are still able to change the codes

We now check for “missing marks”

Changes to Panels

27

Attendance

Now learning aims from the Autumn 2009 census are displayed from the internal database rather than the actual xml

Changes to Panels

28

Learning Aims Submitted in Error

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

Create & Validate

29

Running

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

Create & Validate

30

Display

Output is sent to the browser as HTML Print button has become the Report button

Create & Validate

31

Report

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

Changes to Information Collected

32

Parental Contact Details

Information now collected for age range of 12 to 25

Changes to Information Collected

33

Connexions Assent

Term time address is now taken to be the school address

Changes to Information Collected

34

Boarder

This is produced from an XSL file provided by the DCSF Version number displayed

Return File Reports

35

Summary Report

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

Return File Reports

36

Detail Reports

School Census Summer 2010

End of HeadlinesThank you for your time

37

Jim HaywoodProduct Manager for Statutory Returns