Sunday, 12 April 2015

Workshop - Making the most of travel flow data





The aim of the workshop is to provide information to users on the methods for accessing the wealth of travel flow data which has been published from Scotland's Census. In addition, we will provide opportunities for users to discuss their requirements , and give advice on how these can be met. This will cover discussion on procedures for application, geographic areas, and classifications of characteristics used in Census and statistical disclosure control.


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

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.