The Fun side of data

1
The Fun side of data!

• Monika Ciurej Katherine Brind
• Management Information Analysis

2
Who wants to be a
DATA AIRE
3
Fastest finger first.Put these words in order
to make a phrase.
4
fun!
can
great
Data
be
5
Data can be great fun!
6
Question 1
7
How many different languages are spoken in
Southwark schools?

• A 26
• B 79
• C 181
• D 363

8
Question 1

• A
• B
• C 181
• D

9
1000
10
Question 2
11
16 of primary pupils nationally are eligible for
free school meals. What is the figure in
Southwark?

• A 15
• B 33
• C 45
• D 67

12
Question 2

• A
• B 33
• C
• D

13
5000
14
Question 3
15
90 of children in England get at least a Level 2
in Maths at Key Stage 1. How many Southwark
schools achieved at least 90?

• A 10
• B 16
• C 25
• D 32

16
Question 3

• A
• B
• C
• D 32

17
10,000
18
Question 4
19
Only 60 of Boys got a Level 4 or higher in what
area at Key Stage 2?

• A English
• B Reading
• C Writing
• D Maths

20
Question 4

• A
• B
• C Writing
• D

21
25,000
22
Question 5
23
What proportion of primary school children say
they always like their school dinners?

• A 5
• B 10
• C 30
• D 66

24
Question 5

• A
• B 10
• C
• D

25
50,000
26
Question 6
27
In Southwark how does the percentage of
unauthorized absence compare to the rest of
country?

• A Its higher
• B Its lower
• C Its at the same level
• D There are no unauthorized absences in Southwark.

28
Question 6

• A Its higher
• B
• C
• D

29
100,000
30
The fun side of data

• All those questions cover data that you should
  be familiar with handling, throughout the school
  year
• Interpreting the data files you send us, and
  turning them into meaningful output is how we in
  the analysis team have fun with data

31
Management information and
Analysis

• The Analysis team
• Monika Ciurej (Principal Management Info.
  Analyst)
• Rana Choudhury Michelle Harris
• Tai Cheng Carly Kling
• Katherine Brind
• We have lots of fun with data!

32
The fun side of data

• Where does the Analysis team get their data from?

• The data we receive will be checked by the data
  collection team for quality and accuracy

33
The fun side of data

• What data are we interested in?
• Census
• Roll figures SEN
• Key Stage 2 and 3 teacher assessments
• Free School meals
• ethnicity pupil voice
• Key Stage 1 assessment Absence
• Staffing data
• Foundation Stage Profile EAL

34
How do we report back?

• As you have already heard, your data returns to
  MIA are crucial
• Examples include
• Producing school budgets
• Tracking children who are potentially missing
  from education
• Tracking vulnerable children
• Verifying free school meals information

35
How do we report back?

• Some of the uses the analysis team
• have for your data are
• Producing school profiles
• Exclusions analysis
• Absence and Attendance analysis
• Calculating Local and Government Performance
  indicators

36
Southwark School Profile

• The Southwark School Profile summarises data from
  the school census, staffing data return,
  Foundation Stage, Key Stage 14, attendance and
  exclusions data, Value Added, and target setting.
• The report is available to you through the secure
  site https//eduonline.southwark.gov.uk/data/

37
Southwark School Profile

• Where available for each bit of summarised data
  there will always be a comparative Southwark
  average and a National average
• The school profile is available to most LA staff
  and school governors
• Most of the data is published earlier than
  nationally produced documents

38
Pupil and school characteristics
39
Staffing Data
40
Attainment data

• Foundation Stage Profile
• Key Stage 1
• (Key Stage 2-4) obtained from other sources
• Match attainment data to pupil characteristics
  (i.e. census), for more in depth analysis
• Calculate value added
• We use the data you provide to produce school
  profiles

41
Foundation Stage
42

• How does this school compare to Southwark and
  National results at Foundation Stage?

43
Key Stage 1
44
Key Stage 1
Percentage of pupils achieving Level 2B and above
- MATHS
45
The fun side of data

• The census data and attainment data that you
  provide to MIA and the DCSF is also used in a
  host of other documents and applications.
• These come out or are updated at different times
  of year but are based on the same national
  dataset

46
The fun side of data

• DCSF School Performance tables
• Available at www.dcsf.gov.uk/performancetables/
• RAISEonline
• Fisher Family Trust

47
DCSF School Performance tables

• Similar to the league tables published in the
  press (but more detailed)
• Along with Ofsted reports and school
  prospectuses, the school performance tables will
  be looked at by parents when considering picking
  a new school
• Provide information from pupil roll numbers to
  attainment data to contextual value added

48
RAISEonline

• RAISEonline is a website that Ofsted maintain.
• The data in it is what inspectors have access to
  before coming to inspect a school
• It contains analysis of both attainment data
  (e.g. Key Stage 1-4) and pupil and school
  characteristics

49
Fischer Family Trust

• Fischer Family Trust (FFT) are an organisation
  that work closely with the DCSF and local
  authorities
• They work with pupil attainment data along with
  pupil and school characteristics data (they
  receive the data centrally)
• Produce a large range of pupil and school level
  analysis. Most commonly used are the school and
  pupil level estimates (target setting)

50
Question 7
51
What is your role in the trainspotting and census
process?

• A Engineer
• B Controller
• C Track Maintenance
• D Driver

52
Question 7

• A
• B
• C
• D Driver

53
200,000
54
Question 8
55
What analysis is not provided in the School
Profiles?

• A Attainment
• B Staffing
• C Budgets
• D Exclusions

56
Question 8

• A
• B
• C Budgets
• D

57
500,000
58
Question 9
59
How much fun does the analysis team have with
data?

• A None
• B Lots
• C Little
• D Minimal

60
Question 9

• A
• B Lots
• C
• D

61
750,000
62
Question 10
63
Was this an interesting and useful data session?

• A Yes
• B Most enjoyable part of conference
• C Best session ever
• D I want to become a DATA AIRE

64
Question 10

• A Yes
• B Most enjoyable part of conference
• C Best session ever
• D I want to become a DATA AIRE

65
1,000,000
66
(No Transcript)
67
DCSF School Performance tables

• This page includes background information from
  the census
• Number of pupils on roll
• Number of pupils with SEN
• Year group size
• Parents can compare your school against others
  nearby

68
DCSF School Performance tables

• This page shows figures for your schools
  contextual value added (CVA)
• CVA is calculated using data you provide
• Key Stage 1 assessments
• KS2 results
• Census details including gender, Date of birth,
  free school meals, SEN, ethnicity
• Parents can compare your school against others
  nearby

69
DCSF School Performance tables

• This page shows figures for your schools
  absence rates
• Parents can compare your school against others
  nearby

70
RAISEonline

• Schools census information compared to National
  results

71
RAISEonline
Table 1.5 The prior attainment of pupils in Key
Stage 2

• Average Key Stage 1 data for each year group in
  school
• At a glance can get an idea of the prior
  attainment

72
RAISEonline
Chart 2.1.22 Progress measures Key Stage 1 to 2

• This analysis uses KS1 and 2 data, and census data

73
Fischer Family Trust

• FFT use complicated statistical models to work
  out estimates for pupils future attainment
• However all analysis is based on the national
  database of census information and attainment
  results from FSP and KS1 through to KS4
• Things like a pupils gender and date of birth,
  or the schools free school meal figures can have
  an effect on their estimated attainment at Key
  Stage 2 or 3.

74
(No Transcript)
75
(No Transcript)