Sunday 28 December 2014

Introduction to Scottish Government Statistics, Census data and practical applications - Aberdeen 3rd Dec

The following CPD event was organised by the Aberdeen City Council and held at Aberdeen Grammar School on 3rd December.  The session was jointly presented by Celia Macintyre (National Records of Scotland) and Tom Macintyre (University of Edinburgh).



 
ABERDEEN CITY COUNCIL – EDUCATION, CULTURE & SPORT
CPD Programme 2014–2015

Introduction to Scottish Government Statistics, Census data and practical applications

Content:

Awareness of availability of official statistics covering a wide range of topics relevant to delivery of social studies teaching.

Interrogating websites to extract statistics for a geographic area, and using these to create presentations and commentary. This will focus on Scotland’s Census website (www.scotlandscensus.gov.uk)

Awareness of tools to use in analysing statistics,and generating visualisations.

Expected Outcomes:

Confidence in identifying appropriate information for students to use in project work.

Networks and contacts to use in keeping up to date with the latest information.




About the presenters:

Celia Macintyre is a statistician who has worked extensively on the quality assurance of Census 2011.  Recently she has been working with stakeholders to promote use of Census data through running training workshops, publishing analytical reports and information on data quality issues. 

Tom Macintyre is a lecturer in teacher education with an interest in numeracy, and is involved in a project to promote 'numeracy across learning' with a focus on statistical literacy in the Senior Phase and within National Qualifications across the curriculum; social subjects (including geography) provide an obvious context to promote statistical literacy for learners in the Senior Phase of education.


Wednesday 26 November 2014

International Migration to Scotland in the Year Prior to the 2011 Census

The migration flow data from Census 2011 for Scotland has been published through the NOMIS website.  There are now three tables which gives migration flows based on the address on year ago for Scottish residents.

MM01CUK_ALL           - Origin and destination of migrants by age by sex
MM01CUK_NON_UK  - Origin and destination of international migrants by age by sex
MMO2UK                     - Origin and destination of international migrants expanded country

http://www.nomisweb.co.uk/census/2011/origin_destination

Here is a snippet which looks at migrants from overseas into local authorities in Scotland, and identifies the top two countries.

A total of 61,100 residents in Scotland reported that they had an address one year ago which was outside the United Kingdom.  This equated to 1.2% of the resident population.

The top five non-UK countries of previous residence who lived in Scotland in 2011 were China (4,400)  USA (4,400) Poland (4,300), India (4,100) and Australia (3,100).

There were quite different patterns across the local authorities.  

The local authority with the highest rate of migration from outside the UK per head of population was Edinburgh City - in general the high rates were in the area universities.

Areas where Poland and EU accession countries are the commonest international migrants

- North Lanarkshire
- Dumfries and Galloway
- Angus
- West Lothian
- Highland
- Moray
- Argyll & Bute
- Aberdeenshire
- Perth & Kinross



Wednesday 24 September 2014

Travel by bus in and out of Glasgow City - Census 2011

The commuting flow data from Census 2011 is published through the NOMIS website.  This gives a facility to download a subset of data and also visualise the flows as illustrated below for Glasgow bus commuters.

Download and visualise commuter flow by method of travel to work








Visualisations of commuting flows for the UK


ONS have published a number of ways of displaying flow data from Census.  The following interactive tool gives the flows into and out of a local authority area, summarises the resident population of workers and workplace population.











Monday 28 July 2014

Travel to work flows - initial findings for Glasgow Commonwealth Games City

The Office for National Statistics published census tables (published on 25th July 2014) on travel to work flows as part of a release or UK Origin Destination statistics (See footnote for more details)

These tables allow more detailed analysis of the way people travel to work, in particular subdividing workers depending on where they are resident.  The following analysis was carried out for Glasgow City, where workers were subdivided into those living in Glasgow and others living outwith Glasgow in other parts of Scotland.

As expected there is a much percentage of workers travel into Glasgow by car from surrounding areas, than travel from within Glasgow (59% compared with 40%) . Similarly marked differences with those travelling by train 24% compared with 9%.  Bus travel is reported by 14% of workers travelling into Glasgow from outwith, compared with 24% of workers travelling from within the city.




Compared with 2001 , the main changes in the methods of transport used are

i) For those travelling from within Glasgow

3 percent point increase in travel by train
2 percent point decrease in travel by bus
2 percent point decrease in travel by car (driving)
2 percent point decrease in passenger in a car
1 percent point increase in travel by bike

3 percent point increase in travel by foot






ii) For those travelling from outwith Glasgow




6 percent point increase in travel by train
3 percent point decrease in travel by bus
2 percent point decrease in passenger in a car




Footnote: Origin Destination 

Origin destination statistics are census tables which deal with movement/ flow of people; either as migration (from their address one year ago before the census) or travel to work or study (to their workplace address). These flows can be cross-tabulated by other variables of interest (for example, method of travel).

The first batch of this data is now available from NOMIS (published 25th July 2014), and cover the following for Scotland, down to local authority level:

WU01UK: Location of usual residence and place of work by sex
WU02UK: Location of usual residence and place of work by age
WU03UK: Location of usual residence and place of work by method of travel to work

The tables are published here Reference tables

Future releases will cover smaller areas below local authority.  Information on proposed timetables and release details can be found here plans for further releases

Sunday 27 July 2014

Travel to work flows - initial findings for Edinburgh City

The Office for National Statistics published census tables (published on 25th July 2014) on travel to work flows as part of a release or UK Origin Destination statistics (See footnote for more details)

These tables allow more detailed analysis of the way people travel to work, in particular subdividing workers depending on where they are resident.  The following analysis was carried out for Edinburgh City, where workers were subdivided into those living in Edinburgh and others living outwith Edinburgh in other parts of Scotland.

As expected there is a much percentage of workers travel into Edinburgh by car from surrounding areas, than travel from within Edinburgh . (66% compared with 36%) . Similarly marked differences with those travelling by train 17% compared with 1%.







Compared with 2001 , the main changes in the methods of transport used are

i) For those travelling from within Edinburgh

4 percent point increase in travel by bus
6 percent point decrease in travel by car (driving)
2 percent point decrease in passenger in a car
2 percent point increase in both travel by foot and travel by bike




ii) For those travelling from outwith Edinburgh

5 percent point increase in travel by train
2 percent point decrease in travel by bus
1 percent point decrease in travel by car (driving)
3 percent point decrease in passenger in a car



Footnote: Origin Destination 

Origin destination statistics are census tables which deal with movement/ flow of people; either as migration (from their address one year ago before the census) or travel to work or study (to their workplace address). These flows can be cross-tabulated by other variables of interest (for example, method of travel).

The first batch of this data is now available from NOMIS (published 25th July 2014), and cover the following for Scotland, down to local authority level:

WU01UK: Location of usual residence and place of work by sex
WU02UK: Location of usual residence and place of work by age
WU03UK: Location of usual residence and place of work by method of travel to work

The tables are published here Reference tables

Future releases will cover smaller areas below local authority.  Information on proposed timetables and release details can be found here plans for further releases

Wednesday 23 July 2014

Census 2011: Release 3G - Detailed characteristics on Labour Market and Education in Scotland

Release 3G - Detailed characteristics on Labour Market and Education in Scotland published today gives information on patterns of qualifications for different ethnic groups, and by age group. (Table DC5202SC)

Focusing on the percentage of the population (aged 16 and over) who have degree qualification or higher. Compared with the ethnic group White-Scottish , all other groups have higher rates of the population with degree.  For example, 22% of the White-Scottish ethnic group have a degree or higher, compared with 43% of White :Other British and 40% of Caribean or Black ethnic groups.

The rates of degree is highest in the 25-34 age group, with a similar pattern of higher rates in all ethnic groups compared with White Scottish. This reflects the increased update of higher education but also the impact of young people moving to Scotland to study.

Interesting patterns with older age groups. For example, White:Irish and Asian ethnic groups have relatively high rates with degree qualifications in the young age groups, and relatively low rates of degree in the older age groups.  Reflecting different patterns of migration over the 50 years.


Saturday 17 May 2014

Census 2011 Household composition by age and sex

The publication of release 3D tables enable analysis to be done on different age groups and separately for males and females

Children in lone parent families
In 2011, 25% of children aged 0 to 15 years old, live in a lone parent family.  This varies across areas in Scotland with the lowest percentage in Aberdeenshire at 13% and the highest in Glasgow at 38%





Adults living alone

In 2011, 16% of the population aged 16 and over live alone.  This varies by age group and between males and females as shown below.  Between the ages of 25 and 49, males are more likely to live alone than females at 19% and 11% respectively.  Whereas with people 65 and over, just over 40% of females live alone compared with just under 25% of males.
   




Overall 35% of people aged 65 and over live alone.  Comparing local authority areas indicates a wide variation in older people living alone. The local authorities with the smallest percentage of people living alone are East Dunbartonshire and Midlothian at 30% , with the highest percentages in Glasgow City (44%), Dundee City (40%) and West Dunbartonshire and Edinburgh City at 39%.  Some of this will relate to the higher mortality rates resulting in widowhood , but also might relate to variation in partnership formation and older people living with other family members. 




Living in a communal establishment


In 2011, overall 2% of the population of Scotland live in a communal establishment. In age groups 18-19 this rises to 12% with students living in halls of residence.  In the older age groups the percentage living in communals rises as people live in care homes. Females are more likely to live in a communal than males; for example in 90-94 year olds  15% males live in a communal in constrast to 26% of females. It is therefore important to remember to account for this population when looking at older populations.
 
 www.scotlandscensus.gov.uk
DC1104SC  - Residence type by sex by age
DC1109SC - Household composition by sex by age 

Tuesday 13 May 2014

Census 2011 Release 3D - 3E

Scottish Census Releases 3D will be published on 15 May and will consist of the following tables:

                       
Release 3D                Table title
DC1101SC
Marital and civil partnership status by age - Household Reference Persons (HRPs)
DC1102SC
Living arrangements by sex by age - Household Reference Persons (HRPs)
DC1104SC
Residence type by sex by age
DC1106SC
Schoolchildren and full-time students living away from home during term time by sex by age
DC1107SC
Marital and civil partnership status by sex by age
DC1108SC
Living arrangements by sex by age
DC1109SC
Household composition by sex by age
DC1113SC
Age of youngest dependent child by household type
DC1119SC
Age of youngest dependent child by household composition
DC1201SC
Household composition by ethnic group of Household Reference Person (HRP)
DC2408SC
Length of residence in the UK by household size
DC2409SC
Length of residence in the UK by household type
LC1101SC
Marital and civil partnership status by sex by age - Household Reference Persons (HRPs)
LC1107SC
Marital and civil partnership status by age
LC1108SC
Living arrangements by age
LC1109SC
Household composition by age
LC1113SC
Age of youngest dependent child by household type
LC1201SC
Household composition by ethnic group of Household Reference Person (HRP)
LC2213SC
Country of birth by English language skills
LC2408SC
Length of residence in the UK by household size
LC2409SC
Length of residence in the UK by household type


Release 3E will be published on 4 June 2014 and will consist of the following tables:


Release 3E
Table Title

LC1102SC
Living arrangements by age - Household Reference Persons (HRPs)

LC1104SC
Residence type by age

LC1110SC
Family composition by age of Family Reference Person (FRP)

LC1112SC
Dependent children by household type by age

LC1114SC
Dependent children by family type

LC1118SC
Age of youngest dependent child by family type

DC1110SC
Family composition by age of Family Reference Person (FRP)

DC1112SC
Dependent children by household type by sex by age

DC1114SC
Dependent children by family type

DC1116SCca
Marital and civil partnership status by sex by age - People in communal establishments*

DC1118SC
Age of youngest dependent child by family type

DC1120SC
Households with full-time students away from home and age of student by number of students

DC4211SCca
Communal establishment management and type by ethnic group by sex*

DC4414SCca
Communal establishment management type by type of resident by sex by age*







 *these tables will be published at Scotland and Council Area level, only.


Release 3F will be published on 25 June 2014 and will consist of tables from the Health topic. 

Thursday 3 April 2014

Finding out about Leith Scottish Parliamentary Constituency

The Area Profiles section of Scotland's Census website gives a snapshot of the data for an area, and enables comparisons with another area.

Here is an example comparing households composition in Edinburgh Northern and Leith with neighbouring Edinburgh Eastern Scottish Parliamentary Constituency.

 Single person households under 65

Edinburgh Northern and Leith -   34.8%

Edinburgh Eastern                  -    25.5%








Tuesday 1 April 2014

Scottish Census migration data released as part of European Commission Census Regulation Stats

Census statistics appeared today on Eurostat census hub. This draws census statistics together statistics in a common format, and releases them down to NUTS3 regions.

https://ec.europa.eu/CensusHub2/query.do?step=selectHyperCube&qhc=false&countrycode=en-gb

There is also a release on the ONS website which includes 12 reference tables

http://www.ons.gov.uk/ons/rel/census/2011-census/european-commission-census-regulation-statistics/index.html

This release includes a table of migration (based on change of address since year prior to Census).  The following charts illustrate some of the patterns in this data for Scotland.



The areas where the highest percentage of residents have changed address include the cities of Edinburgh, Glsgow, and Aberdeen City - all areas with universities which attract migrants.

There is a very distinctive pattern of migration which results in a high percentage of people to have changed address for age groups 20-24 and 25-29 years.  There is also a high rate for children before school age.  Illustrated in chart below.  



The effect of student migration can be seen by comparing the levels of change of residence between areas with different numbers of students. Edinburgh with  Inverclyde, Renfrewshire and East Renfrewshire









Tuesday 25 March 2014

Post Graduate Primary class - data handling and social subjects

This is the beginning of a post to provide some background data for students teachers to use in producing and interpreting charts with primary classes.

Here is a chart of household composition in Scotland with comparable figures for England,  Wales



Sources:
Census tables -
QS113SC,QS113EW

At a local level, the following gives the percentage of households in each electoral ward in Edinburgh.  This can be adapted for your own area.


What sorts of areas have the least one person households ?
And what about the areas with lots of one person households?


The chart below compares the percentage of single person households  in these areas, with the percentage of households in an area which are under 35 years(young households).



What does this suggest?

There are a couple of areas which are out of line, with the general trends. The class could investigate if there are any special features of these areas.
  • The Meadows ward seems to have an unusually high percentage of young households. 
  • The Southside ward has a relatively low percentage of young households.  
These statistics along with other characteristics which might be related to single person households are given in the table below

- the size of the house in terms of rooms
- a measure of underoccupancy (households with 2 or more rooms than required)




Data source here  http://bit.ly/1hmdykc


Tuesday 18 March 2014

Census 2011 - more products on topic of ethnicity, language, religion and identity

Release 3B - Scottish Census 2011 tables 
- to be published 19th March

Details of all new tables planned
  - LC tables are produced for small areas including output areas and data zones



All the data contained in this release can be accessed through the Census Data Explorer on the Scotland’s Census website ( http://www.scotlandscensus.gov.uk  ).




Overview of Equality Results from the 2011 Census Release 2 
- to be published 21st March

The Scottish Government have analysed equality data from the 2011 Census Release 2 and will publish an overview paper drawing upon data from other already published sources.  It will focus primarily on ethnicity, religion and disability.
























.

Sunday 9 March 2014

SMC Conference session on using Census Data in Schools

I attended the Scottish Mathematical Council Conference in Stirling University on Saturday 8th March and ran a session to introduce maths teachers to Census data.  The session was a brief introduction to the Census process, but mostly a hands on session to use the Census Data Explorer

Seemed to go down well and discussions at the end point to creating an online guide to using the website - maybe a demo of the stages to interrogate the data and then creating charts using it.  Now off to explore free software tools to do this. Slides available on Past Conference Presentations section of the SMC conference website  http://bit.ly/MZfoK6

Stages of the workshop

1) Area profiles - compare characteristics of two areas with Scotland

Comparison of responses to identity question in
Scottish Parliamentary Constituencies of Falkirk East and Linlithgow





2) Standard Maps 
 Screen shot of percentage of local authority responding Scottish Identity only
[Apologies Shetland seems to be off the map]




3) Standard Charts
Screen shot of chart of percentage reporting Scottish Identity only - sorted by council from Edinburgh City to West Dunbartonshire




4) Standard Outputs
Screen shot of method of selecting areas using map function




5) Downloaded tables of national identity by religion



Friday 28 February 2014

Census 2011 - more details on topic of ethnicity, language, religion and identity

Scottish Census 2011 tables published on 27 February

http://www.scotlandscensus.gov.uk/news/census-2011-detailed-characteristics-ethnicity-identity-language-and-religion-scotland-–

This release includes a number of tables which gives the age/sex distribution of population groups.  This means that you can produce population pyramids.Population pyramids for a few of the larger ethnic group categories.

Further analysis will be added to look at how the profiles have changed since 2001.  May be slightly tricky given the question on ethnicity changed.


White: Scottish




White: Other British




  White: Polish





 
White: Other White


Asian











Details of all new tables

Table Number Table name
DC1117SC Age by sex
DC2101SC Ethnic group by sex by age
DC2102SC National identity by sex by age
DC2105SC Proficiency in English by sex by age
DC2107SC Religion by sex by age
DC2121SC Scots language skills by sex by age
DC2201SC Ethnic group by religion
DC2202SC National identity by ethnic group 
DC2204SC National identity by religion
DC2205SC Country of birth by ethnic group 

All the data contained in this release can be accessed through the Census Data Explorer on the Scotland’s Census website ( http://www.scotlandscensus.gov.uk  ).


Acknowledgement: The population pyramids were created using the tool used by National Records for Scotland to show the changing population profiles over time.  


Sunday 23 February 2014

England and Wales Census 2011 - tables on ethnicity and age

Next set of Scottish Census 2011 tables due on 27 February - more tables from the Ethnicity, Identity, Language and Religion topics. Outputs Prospectus





Table Number Table name
DC1117SC Age by sex
DC2101SC Ethnic group by sex by age
DC2102SC National identity by sex by age
DC2105SC Proficiency in English by sex by age
DC2107SC Religion by sex by age
DC2121SC Scots language skills by sex by age
DC2201SC Ethnic group by religion
DC2202SC National identity by ethnic group 
DC2204SC National identity by religion
DC2205SC Country of birth by ethnic group 

Here are some results based on the England and Wales tables of Ethnic group by sex by age (DC2010EW) which were published last year.  When the Scottish data are published, results for Scotland will be published alongside these.

The different population groups exhibit very different age/sex patterns.
  • The White:Irish population is predominantly older people.  
  • The mixed ethnicity population are predominantly younger, presumably children of parents of different ethnic groups

The Economic and Social Research Council's Centre on Dynamics of Ethnicity (CoDE) has prepared briefing documents on the 'Dynamics of diversity: evidence from the 2011 Census' based on the data from England and Wales.  This explores the different characteristics of ethnic populations and also explore the drivers of changes.
http://www.ethnicity.ac.uk/census/



England and Wales Census 2011 Population Pyramids for a range of ethnic groups
- Males (Blue), Females (Red), Vertical Axis (Age groups)


White: English/Scottish/Welsh/Northern Irish/British



White:Irish



White: Gypsy Traveller


 White: Other White




Mixed Ethnic Groups

Asian/Asian British


Black/African/Caribbean/Black British



Acknowledgement: The population pyramids were created using the tool used by National Records for Scotland to show the changing population profiles over time.  http://www.gro-scotland.gov.uk/statistics/theme/population/projections/scotland/population-pyramids.html