UK Data Service data catalogue record for:

Millennium Cohort Study: Linked Education Administrative Dataset (KS1), Scotland: Secure Access

Title details

SN: 7414
Title: Millennium Cohort Study: Linked Education Administrative Dataset (KS1), Scotland: Secure Access
Alternative title: MCS1; MCS2; MCS3; MCS4; MCS5
Persistent identifier: 10.5255/UKDA-SN-7414-1
Series: Millennium Cohort Study [Millennium Cohort Study, 2001- : Secure Access]
Depositor: University of London. Institute of Education. Centre for Longitudinal Studies
Depositor: Department for Education
Principal investigator(s): University of London. Institute of Education. Centre for Longitudinal Studies
Data collector(s): National Centre for Social Research
Northern Ireland Statistics and Research Agency. Central Survey Unit
NOP Research Group
Ipsos MORI
Sponsor(s): Economic and Social Research Council
Office for National Statistics
Department for Education
Department for Work and Pensions
Department of Health
Welsh Assembly Government
Scottish Government
Northern Ireland Executive
International Centre for Child Studies
Cabinet Office. Children and Young People's Unit
Birkbeck, University of London. National Evaluation of Sure Start
Department for Transport
United States. Department of Health and Human Services. National Institutes of Health. National Institute on Alcohol Abuse and Alcoholism
Other acknowledgements: The Information Centre, Newcastle, Analytic and Services Branch, Department for Work and Pensions (formerly Department of Social Security) who: identified the main Millennium Cohort Study (MCS) sample from Child Benefit records, and ran an opt-out exercise for MCS1; provided a similar service to enable the inclusion in MCS2 of 'new families' (eligible for inclusion in MCS1 but not identified in the records until after the completion of the first survey); and assisted with tracing families who had moved, for both MCS1 and MCS2.

Members of the Office for National Statistics (ONS) funding consortium provided advice as well as funding.

Individual academic advisers:
Specialist advisers: Julia Brannen, Tim Cole, Leon Feinstein, Charlie Owen.
Members of the Centre for Longitudinal Studies (CLS) internal team: Neville Butler, John Bynner, Elsa Ferri, Ian Plewis, Peter Shepherd and Kate Smith.

Collaborators on the MCS included: Mel Bartley, Helen Bedford, Dermot Bowler, Leslie Davidson, Carol Dezateux, Harvey Goldstein, Kath Kiernan, Yvonne Kelly, Michael Marmot, Barbara Maughan, Alison McFarlane, Catherine Peckham, Chris Power, Ingrid Schoon and Marjorie Smith.

Members of the Millennium Cohort Study Advisory Group, for advice on the form and content of MCS1, MCS2, MCS3, MCS4 and MCS5.

In May 2010 the DfE took over the responsibilities of the Department for Children, Schools and Families, which together with the Department for Innovation, Universities and Skills took over the responsibilities of the Department for Education and Skills (DfES) in June 2007. The DfES contributed funding for the Millennium Cohort Study between 2001 and 2007.


The citation for this study is:

University of London. Institute of Education. Centre for Longitudinal Studies. (2013). Millennium Cohort Study: Linked Education Administrative Dataset (KS1), Scotland: Secure Access. [data collection]. UK Data Service. SN: 7414,

Select the text above to add data citation in your outputs.

Select citation format: 
XML citation formats:  CSL  EndNote

Subject Categories

Child development and child rearing - Social stratification and groupings
Family life and marriage - Social stratification and groupings
Primary, pre-primary and secondary - Education


Abstract copyright UK Data Service and data collection copyright owner.

The MCS is a large-scale, multi-purpose longitudinal dataset providing information about babies born at the beginning of the 21st century, their progress through life, and the families who are bringing them up, for the four countries of the United Kingdom. The original objectives of the first MCS survey, as laid down in the proposal to the Economic and Social Research Council (ESRC) in March 2000, were:
  • to chart the initial conditions of social, economic and health advantages and disadvantages facing children born at the start of the 21st century, capturing information that the research community of the future will require
  • to provide a basis for comparing patterns of development with the preceding cohorts (the National Child Development Study, held at the UK Data Archive under GN 33004, and the 1970 Birth Cohort Study, held under GN 33229)
  • to collect information on previously neglected topics, such as fathers' involvement in children's care and development
  • to focus on parents as the most immediate elements of the children's 'background', charting their experience as mothers and fathers of newborn babies in the year 2000, recording how they (and any other children in the family) adapted to the newcomer, and what their aspirations for her/his future may be
  • to emphasise intergenerational links including those back to the parents' own childhood
  • to investigate the wider social ecology of the family, including social networks, civic engagement and community facilities and services, splicing in geo-coded data when available
Additional objectives subsequently included for MCS were:
  • to provide control cases for the national evaluation of Sure Start (a government programme intended to alleviate child poverty and social exclusion)
  • to provide samples of adequate size to analyse and compare the smaller countries of the United Kingdom, and include disadvantaged areas of England
The first sweep (MCS1) interviewed both mothers and (where resident) fathers (or father-figures) of infants included in the sample when the babies were nine months old, and the second sweep (MCS2) was carried out with the same respondents when the children were three years of age. The third sweep (MCS3) was conducted in 2006, when the children were aged five years old, the fourth sweep (MCS4) in 2008, when they were seven years old, the fifth sweep (MCS5) in 2012-2013, when they were eleven years old, and the sixth sweep (MCS6) in 2015, when they were fourteen years old.

End User Licence versions of MCS studies:
The End User Licence (EUL) versions of MCS1, MCS2, MCS3, MCS4, MCS5 and MCS6 are held under UK Data Archive SNs 4683, 5350, 5795, 6411, 7464 and 8156 respectively.

Sub-sample studies:
Some studies based on sub-samples of MCS have also been conducted, including a study of MCS respondent mothers who had received assisted fertility treatment, conducted in 2003 (see EUL SN 5559). Also, birth registration and maternity hospital episodes for the MCS respondents are held as a separate dataset (see EUL SN 5614).

Users should note that the weighting section in the 'Guide to the Datasets' document recommends analysis in Stata, as SPSS is not currently able to weight the data using the survey design factors. The depositor is working on a solution for SPSS, but this is not yet available. A Stata version of the dataset is available for access by Secure Lab members, alongside the SPSS and tab-delimited versions.

MCS web pages:
Further information about the MCS can be found on the Centre for Longitudinal Studies web pages.

How to access genetic and/or bio-medical sample data from a range of longitudinal surveys:
A useful overview of the governance routes for applying for genetic and bio-medical sample data, which are not available through the UK Data Service, can be found at Governance of data and sample access on the METADAC (Managing Ethico-social, Technical and Administrative issues in Data Access) website.

Secure Access datasets:
Secure Access versions of the MCS have more restrictive access conditions than versions available under the standard End User Licence or Special Licence (see 'Access' section below).

Secure Access versions of the MCS include:
  • detailed geographical identifier files which are grouped by sweep held under SN 7758 (MCS1), SN 7759 (MCS2), SN 7760 (MCS3), SN 7761 (MCS4), SN 7762 (MCS5 2001 Census Boundaries), SN 7763 (MCS5 2011 Census Boundaries), SN 8231 (MCS6 2001 Census Boundaries) and SN 8232 (MCS6 2011 Census Boundaries). These files replace previously available files grouped by geography SN 7049 (Ward level), SN 7050 (Lower Super Output Area level), and SN 7051 (Output Area level)
  • linked education administrative datasets for Key Stage 1 held under SN 6862 (England), 7414 (Scotland) and SN 7415 (Wales)
  • linked education administrative dataset for Key Stage 2 for England held under SN 7712 (England))
  • linked Ofsted datasets for MCS3, MCS4 and MCS5 held under SN 8226 and for the MCS4 Teacher Survey held under SN 8227
The linked education administrative datasets held under SNs 6862, 7414, 7415 and 7712 may be ordered alongside the MCS detailed geographical identifier files deposited under SNs 7758, 7759, 7760, 7761, 7762 and 7763 only if sufficient justification is provided in the application. The linked education administrative datasets are not available alongside the Hospital of Birth: Special Licence Access dataset under SN 5724. Users are also only allowed one MCS5 Geographical Identifiers Census Boundaries study, either SN 7762 (2001 Census Boundaries) or SN 7763 (2011 Census Boundaries); the same applies for the MCS6 Geographical Identifiers Census Boundaries studies, users are only allowed either SN 8231 (2001 Census Boundaries) or SN 8232 (2011 Census Boundaries).

Researchers applying for access to the Secure Access MCS datasets should indicate on their ESRC Accredited Researcher application form the EUL dataset(s) that they also wish to access (selected from the MCS list of datasets web page).

The MCS Linked Education Administrative Dataset (KS1), Scotland: Secure Access (SN 7414) includes a data file containing selected information from the Pupil Census, 2008, the School Meals Survey and attendance and absence records for the year 2008-2009, for those cohort members attending a school in Scotland at the time of MCS4 interview. Also included are anonymised Local Education Authorities (LEA) and anonymised School Numbers, to allow comparison of results across LEA and school. The data were obtained only for children whose parents/carers gave consent to data linkage, and who were successfully matched.

This study only includes data for MCS cohort members attending schools in Scotland. Data for England and Wales are available under SNs 6862 and 7415 respectively.

Main Topics:
The Linked Education Administrative Dataset (KS1), Scotland: Secure Access includes variables relating to:
  • attendance and absence
  • ethnic group
  • eligibility for free school meals
  • level of English
  • Special Education Needs

Coverage, universe, methodology

Dates of fieldwork: MSC1: June 2001 - September 2002; MCS2: September 2003 - April 2005; MCS3: January 2006 - July 2006; MCS4: January 2008 - August 2008; MCS5: January 2012- February 2013.
Country: Scotland
Spatial units: Local Education Authorities
Observation units: Individuals
Kind of data: Numeric data
Alpha/numeric data
Individual (micro) level
Universe: National
All live births in Scotland for 59 weeks from 22 November 2000. For the linked education administrative data, those who participated in MSC4 in 2008 and were attending a school in Scotland.
Time dimensions: Longitudinal/panel/cohort
Five waves have been conducted to date: MCS1 (age 9 months), MCS2 (age 3 years), MCS3 (age 5 years), MCS4 (age 7 years), and MCS5 (age 11 years).
Sampling procedures: Multi-stage stratified random sample
See documentation for further details.
Number of units: 1,406 children in Scotland successfully linked to education administrative records.
Method of data collection: Compilation or synthesis of existing material
Linked to education administrative records
Weighting: For details of weighting for main sample, see MCS documentation.

Thesaurus search on keywords

Administrative and access information

Date of release:
First edition: 31 October 2013
Copyright: Crown copyright held jointly with the Centre for Longitudinal Studies. Crown copyright material is reproduced with the permission of the Controller of HMSO and the Queen's Printer for Scotland.
Access conditions: Registration is required and standard conditions of use apply. The depositor will be informed about usage. Controlled data requirements and conditions also apply. Further information is available from Access to the Secure Lab. In addition, the Service is required to request explicit permission from the data owner prior to providing the researcher with access to the data.
Available to UK HE/FE applicants only.

Please note:
Since these data are more sensitive and/or pose a higher risk of disclosure than data made available under the standard End User Licence or under a Special Licence, they are not available for download but may be accessed through Secure Access. Access requires accreditation as an ESRC Accredited Researcher, completion of face-to-face training, and agreement to the Secure Access User Agreement and the Licence Compliance Policy. This is to ensure that the guarantee of confidentiality given to survey respondents is protected. Applications are screened by the UK Data Archive and the individual or institution having ownership of the data (or their designated authority), and access is only granted to those researchers requiring data for statistical research purposes and who can justify their need for the data. Users who obtain access to these data are also required to read and follow the Microdata Handling and Security: Guide to Good Practice.

Availability: UK Data Service
Contact: Get in touch


Title File Name Size (KB)
UK Data Archive Data Dictionary 7414_ukda_data_dictionary.pdf 156
A Guide to the Linked Education Administrative Datasets, July 2013 mcs4_guide_to_the_education_linkage_dataset_2013.pdf 235
A Guide to the Linked Education Administrative Datasets, April 2015 mcs4_guide_to_the_education_linkage_dataset_2015.pdf 384
Study information and citation UKDA_Study_7414_Information.htm 8
READ File read7414.htm 11


View publications... Hide publications...

By principal investigator(s):
Publications based on the MCS can be found on the Publications page of the Centre for Longitudinal Studies web pages.

Resulting from secondary analysis:
Waldfogel, J. (2004) Social mobility, life chances and the early years, CASEpaper 88, Centre for Analysis of Social Exclusion, London School of Economics.

McKay, S. (2004) 'Charting change in the devolved administrations: assessing the evidence base', Benefits, 12, pp.183-191.

Rowlingson, K. and McKay, S. (2005) 'Lone motherhood and socio-economic disadvantage: insights from quantitative and qualitative evidence', Sociological Review, 53(1), pp. 30-49.

Kiernan, K. (2005) Non-residential fatherhood and child involvement: evidence from the Millennium Cohort Study, CASEpaper 100, STICERD, Centre for Analysis of Social Exclusion, London School of Economics.

Kiernan, K. and Pickett, K. (2006) 'Marital status disparities in maternal smoking during pregnancy, breastfeeding and maternal depression', Social Science and Medicine, 63, pp.335-346.

Kiernan, K.E. and Huerta, M.C. (2008) 'Economic deprivation, maternal depression, parenting and children's cognitive and emotional development in early childhood' British Journal of Sociology, December, 59(4), pp.781-806.

Kiernan, K.E. and Mensah, F.K. (2009) 'Poverty, maternal depression, family status and children's cognitive and behavioural development in early childhood: a longitudinal study', Journal of Social Policy, 38(4) pp.569-588.

Pollet, T.V., Nelissen, M. and Nettle, D. (2009) 'Lineage based differences in grandparental investment: evidence from a large British cohort study', Journal of Biosocial Science, 41, pp.353-379.

Mensah, F.K and Kiernan, K.E. (2010) 'Gender differences in educational attainment: influences of the family environment', British Journal of Educational Research, 36(2), pp.239-260.

Emerson, E., Graham, H., McCulloch, A., Blacher, J., Hatton, C., and Llewellyn, G. (2009) 'The social context of parenting three year old children with developmental delay in the UK', Child: Health, Care, Development, 35(1), pp.63-70.

Emerson, E., and Einfeld, S. (2010) 'Emotional and behavioural difficulties in young children with and without developmental delay: a bi-national perspective' Journal of Child Psychology and Psychiatry and Allied Disciplines, 51, pp.583-93.

Emerson, E., McCulloch, A., Graham, H., Blacher, J., Llewellyn, G., and Hatton, C. (2010) 'Socio-economic circumstances and risk of common psychiatric disorders among parents of young children with and without early cognitive delay in the UK', American Journal on Intellectual and Developmental Disability, 115, pp.30-42.

Hatton, C., Emerson, E., Graham, H., Blacher, J., and Llewellyn, G. (2010) 'Changes in family composition and marital status in families with a young child with cognitive delay', Journal of Applied Research in Intellectual Disabilities, 23, pp.14-26.

Jones, M., Blackaby, D. and Murphy, P. (2010) An investigation into regional differences in child health and cognitive function, report for the Welsh Assembly Government Economic Research Unit, Cardiff: Welsh Assembly Government.

Kiernan, K.E. and Mensah, F.K. (2010) 'Unmarried parenthood, family trajectories, parent and child well-being', in K. Hansen, H. Joshi and S. Dex (eds.) Children of the 21st century: from birth to age 5, London: Policy Press, Chapter 5, pp.75-92.

Mensah, F.K. and Kiernan, K.E. (2010) 'Parents' mental health and children's cognitive and social development', Social Psychiatry and Psychiatric Epidemiology, 45(11), pp.1023-1035.

Nikiema, B., Spencer, N. and Seguin L. (2010) 'Poverty and chronic illness in early childhood: a comparison between the United Kingdom and Quebec', Pediatrics, originally published online Feb 1, 2010 (2010;125;e499-e507;). DOI: 10.1542/peds.2009-0701.

Totsika, V., Hastings, R.P., Emerson, E, Berridge, D.M., and Lancaster, G.A. (2011) 'Behavior problems at five years of age and maternal mental health in autism and intellectual disability', Journal of Abnormal Child Psychology, 39, pp.1137-47.

Totsika, V., Hastings, R.P., Emerson, E., Lancaster, G.A. and Berridge, D M. (2011) 'A population-based investigation of behavioural and emotional problems and maternal mental health: associations with autism spectrum disorder and intellectual disability', Journal of Child Psychology and Psychiatry and Allied Disciplines, 52, pp.91-99.

Tunstall, R., Lupton, R., Kneale, D. and Jenkins, A. (2011) Growing up in social housing in the New Millennium: housing, neighbourhoods and early outcomes for children born in 2000, CASEpaper 143, Centre for Analysis of Social Exclusion, London School of Economics.

Mensah, F.K. and Kiernan, K.E. (2011) 'Maternal general health and children's cognitive development and behaviour in the early years: findings from the Millennium Cohort Study', Child Care, Health and Development, 37, pp.44-54.

Kiernan, K.E. and Mensah, F.K. (2011) 'Poverty, family resources and children's educational attainment: the mediating role of parenting', British Journal of Educational Research, 37(2), pp.317-336.

Pollet, T.V., Nelissen, M. and Nettle D. (2012) 'A 'gendered need' explanation does not fully explain lineage based differences in grandparental investment found in a
large british cohort study', Journal of Biosocial Science, 44, pp.377-381.

Holford, A. (July 2012) Take-up of free school meals: price effects and peer effects, ISER Working Paper Series, No.2012-12.

Lakshman R., Zhang, J., Zhang, J., Koch, F.S., Marcus, C., Ludvigsson, J., Ong, K.K. and Sobko, T. (2012) 'Higher maternal education is associated with favourable growth of young children in different countries', Journal of Epidemiology and Community Health, published online first: doi:10.1136/jech-2012-202021

Jackson, M., Mclanahan, S. and Kiernan, K. (2012) 'Nativity differences in mothers' health behaviors: a cross-national and longitudinal lens', The Annals of the American Academy of Political and Social Sciences, 642(1), pp.192-218.

Jackson, M., Kiernan, K. and Mclanahan, S. (2012) 'Immigrant-native differences in child health: does maternal education narrow or widen the gap?', Journal of Child Development, 83(5), pp.1501-1509.

Prady, S.L., Kiernan, K., Bloor, K. and Pickett, K.E. (2012) 'Do risk factors for post-partum smoking vary according to marital status?', Maternal and Child Health, 16(7), pp.1364-1373.

Taulbut, M. and Walsh, D. (2013) Poverty, parenting and poor health: comparing early years' experiences in Scotland, England and three city regions, Glasgow Centre for Population Health, February.

Crawford, C., Dearden, L. and Greaves, E. (2013) When you are born matters: evidence for England, IFS Reports, R80, London: Institute for Fiscal Studies. doi: 10.1920/re.ifs.2013.0080. Retrieved August 19, 2013 from

Crawford, C., Dearden, L. and Greaves, E. (2013) Identifying the drivers of month of birth differences in educational attainment, IFS Working Papers, W13/09, May. London: Institute for Fiscal Studies. doi: 10.1920/wp.ifs.2013.1309. Retrieved August 19, 2013 from

Greaves, E. (2013) 'Parents' preferences for school attributes: a discrete choice model incorporating unobserved heterogeneity', paper presented at CMPO conference, London, Thursday 23 May 2013.

Greaves, E. (2013) 'Parents' preferences for school attributes: a discrete choice model incorporating unobserved heterogeneity', paper presented at ESPE conference, Aarhus, Denmark, Thursday 13 June 2013.

Greaves, E. (2013) 'Marriage, cohabitation and child outcomes', paper presented at Understanding Society conference, University of Essex, Thursday 25 July 2013.

Prady, S.L. and Kiernan, K.E. (2013) 'The effect of post-natal mental distress amongst Indian and Pakistani mothers living in England on children's behavioural outcomes', Child Care, Health and Development, 39(5), pp.710-721.

Holmes, J. and Kiernan, K. (2013) 'Persistent poverty and children's development in the early years of childhood', Policy and Politics, 41(1), pp.19-42. doi:10.1332/030557312x645810

Sellers, R., Maughan, B., Pickles, A., Thapar, A. and Collishaw, S. (2014) 'Trends in parent- and teacher-rated emotional, conduct and ADHD problems and their impact in prepubertal children in Great Britain: 1999-2008', Journal of Child Psychology and Psychiatry, doi: 10.1111/jcpp.12273.

Chiorri, C., Day, T. and Malmberg, L-E. (2014) 'An approximate measurement invariance approach to within-couple relationship quality', Frontiers in Quantitative Psychology and Measurement, (special issue edited by R. Van De Schoot, P. Schmidt and A. De Beuckelaer), 19 September. doi: 10.3389/fpsyg.2014.00983. Retrieved October 21, 2014 from


No previously uploaded files

  (login required)

Upload syntax/code file

Millennium Cohort Study: Linked Education Administrative Dataset (KS1), Scotland: Secure Access

I agree to the terms and conditions *

Confirm new syntax/code file version

A previous version of syntax file "" has already been uploaded and approved.

If you continue with this upload, the previous version of the syntax file will be overwritten with this new version.

This new version of the syntax file will be subject to the UK Data Service approval process before it becomes available for download.

Do you want to continue?


Back to top