add cart choropleth column cross cube error file folder geo help home lock obs poi rdf remove search slice spreadsheet success table unlock warning

[this is a data cube dataset] A data cube dataset in folders : Scottish Government, Education, Skills and Training

Schools - Attainment by Deprivation

The average total tariff score, and percentage of school leavers by Scottish Index of Multiple Deprivation (SIMD) Quintile

View as a spreadsheet
Dimensions
Dimension
Value
Measure Type
  1. Average Total Tariff Score
  2. Percent
Reference Period
  1. Academic year 2015-16
  2. Academic year 2016-17
  3. Academic year 2017-18
  4. Academic year 2018-19
  5. Academic year 2019-20
  6. Academic year 2020-21
  7. Academic year 2021-22
  8. Academic year 2022-23
School Comparator
  1. Real Establishment
  2. Virtual Comparator
Simd Quintiles
  1. 1 - most deprived
  2. 2
  3. 3
  4. 4
  5. 5 - least deprived
Reference Establishment
(showing types of organisation available in these data)
  1. Educational Establishment Groups
  2. Educational Establishments
Download
Entire dataset
Note: These may be large files.
CSVN-Triples
About the Dataset
Contact
Publisher
Scottish Government
Creator
Scottish Government
In folders
License
Issued
24/04/2018
Modified
17/04/2024
Next update due
April 2025
Description

Attainment is the measurable progress which children and young people make as they advance through and beyond school, and the development of the range of skills, knowledge and attributes needed to succeed in learning, life and work.

In this dataset, attainment is measured as the average total tariff score of school leavers. The number and level of qualifications a young person gains by the point they leave school provides a tariff score. These figures are brought together to provide an average total tariff score for the school. Only the latest and best awards in each subject are counted in the tariff score. For example if someone has an award at National 4 and National 5 in English, it is only the National 5 award that will count towards this measure.

Average total tariff score for each school is broken down by Scottish Index of Multiple Deprivation (SIMD) Quintile, based on the home postcode of each school leaver.

The SIMD enables schools to map their performance against the social context in which they operate. The SIMD identifies small area concentrations of multiple deprivation across Scotland. It is based on data zones (small area geographical units) and provides an assessment of multiple deprivation based on income, employment, health, education, housing, access to services and levels of crime in the area. It provides a relative measure of deprivation which means that the data zones can be ranked from most to least deprived and cut offs can be applied to identify different levels of deprivation.

The calculation of quintiles means that the data zones have been ranked and split into five equal parts with quintile 1 being the most deprived 20% and quintile 5 being the least deprived 20%. Based on the postcode of the school leaver from the Pupil Census, it is possible to identify which data zone the school leaver lives in and therefore which deprivation decile. This allows us to look at attainment across the school by level of deprivation.

Data is for senior phase (S4-S6) leavers from publicly funded secondary and grant aided secondary schools. This includes a small number of pupils who are on the roll of the school but attend full-time courses or further education outside of the school.

For some data points, a special character is provided instead of a number. These have the meaning:

  • 'NA' - data not available
  • '*' - the value has been hidden for disclosure reasons
  • '#' - data not available because the school is a junior high school with no year S5 or S6
Details
Confidentiality Policy

The presentation of school level data here ensures that individual children cannot be identified. Where data is missing from tables in this dataset, it has been omitted to preserve the confidentiality of individuals.

Quality Management

In a very small number of cases, pupil postcodes were missing or invalid, and in these cases the postcode of the school has been used instead.

Accuracy and Reliability
Not supplied
Coherence and Comparability

Using data for individual schools as league tables implies that the schools at the top of the table are the best in Scotland and those at the bottom, the worst. This is misleading because schools often operate in very different circumstances, such as different numbers of children with additional support needs, or different job opportunites for school leavers depending on location. The context of a school should be taken into account when considering how well a school is doing.

The best way to judge the performance of a school when using this dataset is to compare a school to its 'virtual comparator'. The 'virtu​al comparator' is a sample group of pupils from other parts of Scotland who have the same characteristics as the young people in the corresponding school. This is fairer than comparing one school directly with another.

Accessibility and Clarity

A comprehensive glossary of terms associated with education can be found on the Parentzone Scotland website

Relevance
Not supplied
Timeliness and Punctuality
Not supplied
Revisions
Not supplied
URI

This is a linked data resource: it has a permanent unique uri at which both humans and machines can find it on the Internet, and which can be used an identifier in queries on our SPARQL endpoint.

http://statistics.gov.scot/data/attainment-by-deprivation-quintile
Dimensions Linked Data

A linked data-orientated view of dimensions and values

Dimension Locked Value
Reference Establishment
http://statistics.gov.scot/def/education/refEstablishment
(not locked to a value)
Reference Period
http://purl.org/linked-data/sdmx/2009/dimension#refPeriod
(not locked to a value)
Simd Quintiles
http://statistics.gov.scot/def/dimension/simdQuintiles
(not locked to a value)
School Comparator
http://statistics.gov.scot/def/dimension/comparator
(not locked to a value)
Measure Type
http://purl.org/linked-data/cube#measureType
(not locked to a value)
Graphs

Linked Data is stored in graphs. We keep dataset contents (the data) separately from the metadata, to make it easier for you to find exactly what you need.

The data in this dataset are stored in the graph: http://statistics.gov.scot/graph/attainment-by-deprivation-quintile

The data structure definition for this data cube dataset is stored in the same graph as the data: http://statistics.gov.scot/graph/attainment-by-deprivation-quintile

All other metadata about this dataset are stored in the graph: http://statistics.gov.scot/graph/attainment-by-deprivation-quintile/metadata

Linked Data Resources

A breakdown by type of the 57,544 resources in this dataset's data graph.

Resource type Number of resources
Collection 4
Component specification 8
Data set 1
Data structure definition 1
Observation 57,530
All metadata
In Graph http://statistics.gov.scot/graph/attainment-by-deprivation-quintile/metadata
Accessibility and Clarity http://statistics.gov.scot/def/statistical-quality/accessibility-and-clarity
A comprehensive glossary of terms associated with education can be found on the [Parentzone Scotland website](https://education.gov.scot/parentzone/my-school/education-glossary/) xsd:string
Comment rdfs:comment http://www.w3.org/2000/01/rdf-schema#comment
The average total tariff score, and percentage of school leavers by Scottish Index of Multiple Deprivation (SIMD) Quintile xsd:string
Comparability and Coherence http://statistics.gov.scot/def/statistical-quality/comparability-and-coherence
Using data for individual schools as league tables implies that the schools at the top of the table are the best in Scotland and those at the bottom, the worst. This is misleading because schools often operate in very different circumstances, such as different numbers of children with additional support needs, or different job opportunites for school leavers depending on location. The context of a school should be taken into account when considering how well a school is doing. The best way to judge the performance of a school when using this dataset is to compare a school to its 'virtual comparator'. The 'virtu​al comparator' is a sample group of pupils from other parts of Scotland who have the same characteristics as the young people in the corresponding school. This is fairer than comparing one school directly with another. xsd:string
Confidentiality http://statistics.gov.scot/def/statistical-quality/confidentiality
The presentation of school level data here ensures that individual children cannot be identified. Where data is missing from tables in this dataset, it has been omitted to preserve the confidentiality of individuals. xsd:string
Contact email http://publishmydata.com/def/dataset#contactEmail
mailto:Insight@gov.scot
Creator dcterms:creator http://purl.org/dc/terms/creator
Scottish Government http://statistics.gov.scot/id/organisation/scottish-government
Date Issued dcterms:issued http://purl.org/dc/terms/issued
April 24, 2018 15:17 xsd:dateTime
Date Modified dcterms:modified http://purl.org/dc/terms/modified
April 17, 2024 14:31 xsd:dateTime
Description dcterms:description http://purl.org/dc/terms/description
Attainment is the measurable progress which children and young people make as they advance through and beyond school, and the development of the range of skills, knowledge and attributes needed to succeed in learning, life and work. In this dataset, attainment is measured as the average total tariff score of school leavers. The number and level of qualifications a young person gains by the point they leave school provides a [tariff score](https://education.gov.scot/parentzone/my-school/education-glossary/). These figures are brought together to provide an average total tariff score for the school. Only the latest and best awards in each subject are counted in the tariff score. For example if someone has an award at National 4 and National 5 in English, it is only the National 5 award that will count towards this measure. Average total tariff score for each school is broken down by Scottish Index of Multiple Deprivation (SIMD) Quintile, based on the home postcode of each school leaver. The SIMD enables schools to map their performance against the social context in which they operate. The SIMD identifies small area concentrations of multiple deprivation across Scotland. It is based on data zones (small area geographical units) and provides an assessment of multiple deprivation based on income, employment, health, education, housing, access to services and levels of crime in the area. It provides a relative measure of deprivation which means that the data zones can be ranked from most to least deprived and cut offs can be applied to identify different levels of deprivation. The calculation of quintiles means that the data zones have been ranked and split into five equal parts with quintile 1 being the most deprived 20% and quintile 5 being the least deprived 20%. Based on the postcode of the school leaver from the Pupil Census, it is possible to identify which data zone the school leaver lives in and therefore which deprivation decile. This allows us to look at attainment across the school by level of deprivation. Data is for senior phase (S4-S6) leavers from publicly funded secondary and grant aided secondary schools. This includes a small number of pupils who are on the roll of the school but attend full-time courses or further education outside of the school. For some data points, a special character is provided instead of a number. These have the meaning: * 'NA' - data not available * '*' - the value has been hidden for disclosure reasons * '#' - data not available because the school is a junior high school with no year S5 or S6 xsd:string
Graph http://publishmydata.com/def/dataset#graph
http://statistics.gov.scot/graph/attainment-by-deprivation-quintile
Has a SPARQL endpoint at void:sparqlEndpoint http://rdfs.org/ns/void#sparqlEndpoint
http://statistics.gov.scot/sparql
http://publishmydata.com/def/dataset#nextUpdateDue http://publishmydata.com/def/dataset#nextUpdateDue
April 2025 xsd:string
In folder http://publishmydata.com/def/ontology/folder/inFolder
Scottish Government http://statistics.gov.scot/def/concept/folders/organisations/scottish-government
Education, Skills and Training http://statistics.gov.scot/def/concept/folders/themes/education-skills-and-training
Label rdfs:label http://www.w3.org/2000/01/rdf-schema#label
Schools - Attainment by Deprivation xsd:string
License dcterms:license http://purl.org/dc/terms/license
http://www.nationalarchives.gov.uk/doc/open-government-licence/version/3/
Publisher dcterms:publisher http://purl.org/dc/terms/publisher
Scottish Government http://statistics.gov.scot/id/organisation/scottish-government
Quality Management http://statistics.gov.scot/def/statistical-quality/quality-management
In a very small number of cases, pupil postcodes were missing or invalid, and in these cases the postcode of the school has been used instead. xsd:string
References dcterms:references http://purl.org/dc/terms/references
http://statistics.gov.scot/help http://statistics.gov.scot/help
Theme dcat:theme http://www.w3.org/ns/dcat#theme
Scottish Government http://statistics.gov.scot/def/concept/folders/organisations/scottish-government
Education, Skills and Training http://statistics.gov.scot/def/concept/folders/themes/education-skills-and-training
Title dcterms:title http://purl.org/dc/terms/title
Schools - Attainment by Deprivation xsd:string
Type rdf:type http://www.w3.org/1999/02/22-rdf-syntax-ns#type
Data set http://purl.org/linked-data/cube#DataSet
Dataset http://publishmydata.com/def/dataset#Dataset
http://publishmydata.com/def/dataset#LinkedDataset
In Graph http://statistics.gov.scot/graph/attainment-by-deprivation-quintile
Structure qb:structure http://purl.org/linked-data/cube#structure
http://statistics.gov.scot/data/structure/attainment-by-deprivation-quintile http://statistics.gov.scot/data/structure/attainment-by-deprivation-quintile
Type rdf:type http://www.w3.org/1999/02/22-rdf-syntax-ns#type
Data set http://purl.org/linked-data/cube#DataSet
Machine-readable formats

In addition to this bookmarkable html page, this dataset metadata is also available for our robot customers in the following machine-readable formats. Please refer to the API documentation for more details.

dataset metadata JSON RDF/XML Turtle N-Triples Atom