Pupil resource 1

Data coding explanation sheet

In the spreadsheet the data is arranged in columns. Below is a list of those columns and an explanation of what the numbers within them mean.

Column heading

Gender / M – Male / F – Female
Year group / 3 – age 7 – 8yrs / 4 – age 8 – 9yrs / 5 – age 9 – 10yrs / 6 – age10 – 11yrs / 7 – age 11 – 12yrs / 8 – age12 – 13yrs / 9 – age13 – 14yrs / 10 – age 14 – 15yrs / 11 – age15 – 16yrs
Place of birth / 1 – England / 2 – Wales / 3 – Scotland / 4 – Northern Ireland / 5 – Rep of Ireland / 6 – Other European / 7 – Outside Europe
Football team / 0 – No interest 6 – Blackburn Rovers 21 – Chelsea 45 – Liverpool 49– Man Utd 53– Newcastle Utd. 65– QPR 101 – Motherwell
Mobile / 0 – no mobile phone / 1 – pupil has their own personal mobile phone
Computer / 0 – no access at home / 1 – pupil has access to a computer at home
Internet / 0 – no access at home / 1 – pupil has access to the Internet at home
House type / 1 – House/Bungalow / 2 – Detached house / 3 – Semi – detached / 4 – Terrace / 5 – Flat of any kind / 6 – Other
Household / Total number of people in the household
Favourite subject / 1 – Art / 2 – ICT/ Computing / 3 – English / 4 – Geography / 5 – History
6 – Mathematics / 7 – PE/Sport / 8 – Other / 9 – Foreign Language / 10 – Music
11 – Science / 12 – Design/Technol / 13 – R E / 14 – Irish / 15 – Welsh
Travel type / 1 – Walk / 2 – Bus / 3 – Car / 4 – Cycle / 5 – Train/Tube/Tram/Metro / 6 – Other
Time / Given in minutes, time taken to travel to school
Distance / 1 – less than 1 km / 2 – 1 – 2 km / 3 – 2 – 3 km / 4 – 3 – 5 km / 5 – 5 – 10 km / 6 – 10 – 30 km / 7 – over 30km

This resource is from the CensusAtSchool project at