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).
  



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



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.




 

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
Table KS404SC - Car of van availability (table only available currently in data warehouse)

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)





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