School Workforce Data Collection

1
School WorkforceData Collection
Daniel FinnieData ManagerSouthwark LA
Peter OvernellWorkforce Data Officer Southwark
LA
Abdul MuhaiminOperations ManagerWauton Samuel
2
Agenda

• What is being collected in the survey
• Timetable for collection
• Fair Process Notice
• Demonstration of Wauton Samuel software
• Using COLLECT to upload data to DCSF and the LA
• What can I do with this data?

3
What is being collected

• Individual level data is required for teachers
  and support staff in the Census if they are in
  regular service. This is defined as continuous
  service of one month or more, either under a
  specific contract or under a service agreement.

4
What is being collected

• Individual records should not be returned for
  support staff who are not directly employed by
  the school or LA. This includes contracted
  catering and cleaning staff. A headcount is
  required for these staff. (Thank you to the pilot
  schools for this amendment!).

5
What is being collected

• Staff details
• Contracts/Agreements
• Absence
• Curriculum
• Qualifications

6
Staff details

• Teacher Number
• Family Name
• Given Name
• Former Family Names
• NI Number
• Gender
• Disability

• Date of birth
• Ethnic Code
• QT Status
• HLTA Status
• QTS Route
• Absent on Census Day

7
Contracts (page 1)

• Contract/Agreement Type
• Start Date
• End Date
• Post
• Date of Arrival in School
• Pay Scale
• Regional Pay Spine

• Spine Point
• Salary Rate
• Safeguarded Salary
• Daily Rate
• Destination
• Origin

8
Contracts (page 2)

• Role Identifier
• Hours worked per week
• FTE Hours per week
• Weeks per year
• Category of Additional Payment
• Additional Payment Amount

9
Absence

• First Day
• Last Day
• Working Days Lost
• Absence Category
• Payroll Absence Category

10
Curriculum

• Subject Code
• Hours
• NC Year Group

11
Qualifications

• Qualification code
• Class of first degree
• Country of origin
• Subject Code 1
• Subject Code 2
• Date of Award
• Verified

12
Questions?
13
Timetable
14
Timetable

• Distribute Fair Process Notices January 2009
• Enumeration date 15th January 2009
• This is the day absent on census day field will
  be for
• Deadline date 19th January 2009
• For workforce data
• Dont panic!
• This is a test for the system
• We dont expect 100 (but we hope for it!)
• We want something from everyone!

15
Timetable
16
Timetable

• We are still completing the statutory 618g survey
  during this collection
• We are still expecting our analysts to produce
  school profile data from this collection
• Finance are still expecting to receive Upper
  Payscale information from your staffing data
• Other departments such as HR still rely on these
  datasets

17
Fair Process Notice
18
Fair Process Notice

• A legal document which lets staff know their data
  is being shared, with whom, and for what purpose.
• Will be distributed with January mail out, to be
  distributed to staff.
• Recommend that you also use the opportunity for a
  data checking exercise.

19
COLLECTingSchool Workforce
20
COLLECT data transfer website

• Replaces Southwark site for staffing data
• Not only collects the data, but checks it too
• Allows you to add notes to queries where
  necessary (not rude ones!)
• Produces reports, and more can be developed for
  schools

21
Why COLLECT?

• 89 schools to collect
• 6,000 staff
• 48 data items each
• Average of 3 checks per item
• 864,000 checks more phone calls than Peter can
  make!

22
Why COLLECT?

• Errors and queries more quickly to schools
• Complex nature of staffing survey means difficult
  to manage errors/queries centrally
• We do not have staffing data centrally like we do
  pupil data, so nothing to compare to
• This is how the DCSF collects the data from the
  LA better to resolve things early

23
Using COLLECT
24
Select the data collection
25
Upload the return
Not uploaded
0
0
0
26
Note the queries and errors on the front screen
27
Red sections mean queries or errors present.
Numbers against a section mean queries or errors
present
28
3 ways to solve errors/queries

• Sort it on your management information system and
  upload again
• Sort it by looking at all queries and errors
• Sort it by looking at the individual records
  within the each section of the return

29
3 ways to solve errors/queries

• Sort it on your management information system and
  upload again
• Sort it by looking at all queries and errors
• Sort it by looking at the individual records
  within the each section of the return
• (pretend its not there?)

30
Click All Errors to see all queries and errors
31
Click Details to see the query or error
32
You will see red, underlined blocks where there
are errors or queries
33
You can edit the data on the screen, and it will
update
34
Report available giving basic details of staff in
school
35
And its worth checking!
36
Summary

• Import
• Check errors and queries
• Check summary

37
Next Steps
38
Key dates

• January 2009
• Data input for trial of school software
• Staffing spreadsheet return if not 100
• January 2010
• All schools 100