Some useful screen shots to help users register for the UKDS
Sunday, 12 April 2015
Workshop - Making the most of travel flow data
Some useful screen shots to help users register for the UKDS
Saturday, 4 April 2015
Fife Migrants Forum
I visited the Fife Migrants Forum last week to discuss the Census 2011 statistics on migration. Fife Migrants Forum is a not-for- profit organisation that is run by a
committee and provides free help, advice, support, information and
referrals.
The following blog summarises the information on migrants from Census 2011 based on country of birth. This will form the basis of further discussion on how these statistics can be further refined to provide information on specific communities.
There are thirty small areas (2011 datazones) in Fife with over 10% of the population who were born outside the UK. The areas with the highest percentages of non-UK born are in St Andrew's. These are highlighted on a map and listed below.
Table QS801SC from the Census Data Explorer can be used to find more details of the countries of birth and how long the migrants have been in the UK.
The remaining datazones are in Kirkcaldy, Dunfermline and Cupar.
Source: www.scotlandcensus.gov.uk
The Census tables for 2011 datazones are currently only available through Standard Outputs. Downloadable files will soon be available containing all published tables for these geographies.
Details of the datazones were be downloaded from the Scottish Government website
http://www.gov.scot/Topics/Statistics/sns/SNSRef/DZ2011Lookups
and the ONS Open Geography Portal http://www.gov.scot/Topics/Statistics/sns/SNSRef/DZ2011Lookups
The following blog summarises the information on migrants from Census 2011 based on country of birth. This will form the basis of further discussion on how these statistics can be further refined to provide information on specific communities.
There are thirty small areas (2011 datazones) in Fife with over 10% of the population who were born outside the UK. The areas with the highest percentages of non-UK born are in St Andrew's. These are highlighted on a map and listed below.
Table QS801SC from the Census Data Explorer can be used to find more details of the countries of birth and how long the migrants have been in the UK.

The remaining datazones are in Kirkcaldy, Dunfermline and Cupar.
Source: www.scotlandcensus.gov.uk
The Census tables for 2011 datazones are currently only available through Standard Outputs. Downloadable files will soon be available containing all published tables for these geographies.
Details of the datazones were be downloaded from the Scottish Government website
http://www.gov.scot/Topics/Statistics/sns/SNSRef/DZ2011Lookups
and the ONS Open Geography Portal http://www.gov.scot/Topics/Statistics/sns/SNSRef/DZ2011Lookups
Wednesday, 18 February 2015
Introduction to Census data and practical applications - Inverurie 17th February
The following CPD event was organised by the
Aberdeenshire Council and held at Inverurie Academy on 17th February
2015. The session was jointly presented by Celia Macintyre (National
Records of Scotland) and Tom Macintyre (University of Edinburgh).
This course outlines the results from the 2011 Census in Scotland, and demonstrates a number of ways of accessing and using the published resources. The course will focus on the Scottish results published through the Census Data Explorer (www.scotlandscensus.gov.uk), and will use a number of case studies to illustrate how the data can be used to answer specific questions.
Objectives
At the end of the course participants will be able to:
• Explore the Census 2011 results for Scotland
• Download data extracts into a suitable format for analysis
• Generate appropriate summary statistics and create charts and graphs to illustrate findings
Worksheets
The following worksheets lead users through the key features of the Census Data Explorer
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 senior lecturer in teacher education with an interest in '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.
ABERDEENSHIRE
COUNCIL
CPD
Programme 2014–2015
WORKSHOP
Introduction
to Census data and practical applications
Outline This course outlines the results from the 2011 Census in Scotland, and demonstrates a number of ways of accessing and using the published resources. The course will focus on the Scottish results published through the Census Data Explorer (www.scotlandscensus.gov.uk), and will use a number of case studies to illustrate how the data can be used to answer specific questions.
Objectives
At the end of the course participants will be able to:
• Explore the Census 2011 results for Scotland
• Download data extracts into a suitable format for analysis
• Generate appropriate summary statistics and create charts and graphs to illustrate findings
Introduction to Census data and practical applications - Geography Skills Aberdeenshire CPD event 17th February from celiamac58
Worksheets
The following worksheets lead users through the key features of the Census Data Explorer
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 senior lecturer in teacher education with an interest in '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.
Monday, 2 February 2015
Migration patterns in Edinburgh
The Detailed UK Migration Statistics are a release from the 2011 Census
providing information on migration into and within the UK. These tables
provide detailed information about migrants moving into, and out of, a
range of geographical areas from across the UK. More information about this release can be found at the following link
UK migration statistics.
The migration tables are available for a range of geographical areas in Scotland including council areas, electoral wards and intermediate zones.
The following statistics were derived for electoral wards in Edinburgh. Over 40% of the population of the City Centre electoral ward lived at a different address the year before the Census, and 22% had an address outwith the City of Edinburgh. The migration statistics also provide more details on the location of the previous address and the characteristics of the migrants.
City Centre ward - the year before the Census
3336 (14%) had an address in Edinburgh but not in the City Centre ward
2761 (11%) had an address outside Edinburgh but elsewhere in the UK
2553 (11%) had an address outside the UK
Characteristics of these migrant groups can be downloaded from the NOMIS system
Analysis of intermediate zones
These statistics are also produced for smaller areas called intermediate zones, with populations of around 3,500. An alternative way of displaying the statistics above is in a chart below. Given the large number of higher education students in Edinburgh , there are a number of small geographic areas with in excess of 40% people who had changed address in the year before the Census.
The areas of Currie West and Dalkeith Road have halls of residence which have a high number of students who move from outside Edinburgh. The areas of Marchmont and the Meadows also have high numbers of students, but they have relatively high rates of moves from within Edinburgh.
UK migration statistics.
The migration tables are available for a range of geographical areas in Scotland including council areas, electoral wards and intermediate zones.
The following statistics were derived for electoral wards in Edinburgh. Over 40% of the population of the City Centre electoral ward lived at a different address the year before the Census, and 22% had an address outwith the City of Edinburgh. The migration statistics also provide more details on the location of the previous address and the characteristics of the migrants.
City Centre ward - the year before the Census
3336 (14%) had an address in Edinburgh but not in the City Centre ward
2761 (11%) had an address outside Edinburgh but elsewhere in the UK
2553 (11%) had an address outside the UK
Characteristics of these migrant groups can be downloaded from the NOMIS system
Analysis of intermediate zones
These statistics are also produced for smaller areas called intermediate zones, with populations of around 3,500. An alternative way of displaying the statistics above is in a chart below. Given the large number of higher education students in Edinburgh , there are a number of small geographic areas with in excess of 40% people who had changed address in the year before the Census.
The areas of Currie West and Dalkeith Road have halls of residence which have a high number of students who move from outside Edinburgh. The areas of Marchmont and the Meadows also have high numbers of students, but they have relatively high rates of moves from within Edinburgh.
Thursday, 15 January 2015
A few more Census 2011 statistics about car and van availability in Edinburgh City

The number of households in the City of Edinburgh reporting 'none' to the question above was 89,034 (40% of all households).
The number of people resident in households with no access to a car or van in City of Edinburgh were 149718 (32% of all people in households).
This percentage varies by age and sex in the following way - lowest rates of no access to car in the age groups 0 to 15, 35 to 49 and 59 to 64.
The first blog in Nov 2013 compares percentage of households without a car or van available by area within Edinburgh
http://www.celiamac58.blogspot.co.uk/2013/11/census-statistics-on-car-ownership-for.html
www.scotlandscensus.gov.uk
Table DC3405SC - Car or van availability by long-term health problem or disability by sex by age |
Wednesday, 14 January 2015
Geography teachers using Census - example of a population pyramid for Ardnamurchan peninsula
Yesterday I ran a session for Edinburgh University students studying for a postgraduate diploma in maths and geography, introducing them to Census Data explorer.
The following was an example which was suggested - relating to a student carrying out a project following a field trip to Ardnamurchan.
I used table LC1117SC (age by sex) to summarise the characteristics of the usual resident population in this area.
The following is the definition of Ardnamurchan included in the website Argyll Online
Ardnamurchan is the landmass stretching from Loch Linnhe in the east and the Atlantic in the west and includes the lands of Morvern, Sunart, Ardnamurchan and Moidart. The last of these has traditionally been in Lochaber rather than Argyll so sadly is beyond the scope of Argyll Online, although we include some useful background information on it.
The geographic area of Ardnamurchan can be estimated using a number of different geographic units including
- civil parishes of Ardnamurchan, Morvern and Ardgour
For the purposes of comparison the following use other geographic area to approximate Ardnamurchan peninsula
- civil parish
- datazones
- LC postcode sectors
- output areas
Having decided on which area to choose the population structure can be illustrated using a population pyramid. The following was created by using a template published on a website for a training organisation - Kurtosis
Population of Ardnamurchan civil parish area
(green - male, orange - female)
The following was an example which was suggested - relating to a student carrying out a project following a field trip to Ardnamurchan.
I used table LC1117SC (age by sex) to summarise the characteristics of the usual resident population in this area.
The following is the definition of Ardnamurchan included in the website Argyll Online
Ardnamurchan is the landmass stretching from Loch Linnhe in the east and the Atlantic in the west and includes the lands of Morvern, Sunart, Ardnamurchan and Moidart. The last of these has traditionally been in Lochaber rather than Argyll so sadly is beyond the scope of Argyll Online, although we include some useful background information on it.
The geographic area of Ardnamurchan can be estimated using a number of different geographic units including
- civil parishes of Ardnamurchan, Morvern and Ardgour
For the purposes of comparison the following use other geographic area to approximate Ardnamurchan peninsula
- civil parish
- datazones
- LC postcode sectors
- output areas
Having decided on which area to choose the population structure can be illustrated using a population pyramid. The following was created by using a template published on a website for a training organisation - Kurtosis
Population of Ardnamurchan civil parish area
(green - male, orange - female)
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.
Subscribe to:
Posts (Atom)