Scottish Government Statistics, Census data & practical applications - SAGT conference 2015 - Perth

Tom Macintyre and I presented at  the Scottish Association of Geography Teachers Conference.

The presentation outlined a range of official statistics available from Scottish Government and the results from the 2011 Census in Scotland.  

We focused on the Scottish results published through the Census Data Explorer, and used a number of case studies to illustrate how the data can be used to answer specific questions, making links where possible to curricular frameworks for Geography and Numeracy Across Learning. 

The session ended with a discussion on potential use of Census data within Geography National Qualifications.

In the afternoon we took part in the 'Hot Spots' forum  where groups of teachers took part in 10 minute discussion on a range of resources. 

The following are the resources we shared at the event

1) Presentation slides

SAGT Conference 2015 - Scottish Government Stats and teaching from celiamac58

2) Census Data Explorer worksheet

http://www.scotlandscensus.gov.uk/documents/events_workshops/CensusDataExplorer_practicalworksheet.pdf
 
3) Census UK Parliamentary profiles for Scotland

http://www.scotlandscensus.gov.uk/uk-parliamentary-constituency-profiles-scotland











4) Datashine Scotland  - mapping Scotland with an example for health in Ayr

http://bit.ly/1j2urCW









5) Scotland’s Population 2014 Infographic report

http://bit.ly/1H3qKsi











6) Scottish Index of Multiple Deprivation training material and data

Introduction to SIMD Methodology (Notes and Slides) from

http://www.gov.scot/Topics/Statistics/SIMD/training15

Scottish Index of Multiple Deprivation 2012 - Background Data http://www.gov.scot/Topics/Statistics/SIMD/DataAnalysis/Background-Data-2012

SIMD Training Materials for exercises illustrated above http://www.gov.scot/Resource/0048/00485316.pdf

Loanhead Library event - Midlothian Science Festival

A workshop was run in the Loanhead Library to help the locals to interrogate the Census website to find out key stats about the area. 

 

 

 

 

 

The workshop covered 

- use of the Census Data Explorer to get key facts for the Loanhead area

- use of DataShine Scotland to draw thematic maps 

- exploring the UK parliamentary constituency profile for Midlothian

- checking out the latest fashions in baby names!

The following are some key links used along with some illustrations of what the results looked like

 

Standard outputs

-> select the locality of Loanhead

 

 

-> Get Data will display a list of topics

-> Choose the tenure tab under the household topic and repeat for both years

2011

 

2001

 

 

-> Try DataShine Scotland to illustrate

Patterns of people aged 16 and over who are single
 

 

Patterns of social rented households

 

Overviews of constituencies are summarised using graphs

  UK parliamentary constituency profiles for Scotland

 

Baby Names

 

Finally we looked at the population NRS publication on Baby Names,with its associated visualisation.

 

 

 

The Midlothian Science Festival aims are:

• To run enjoyable science activities in Midlothian appealing to a large, diverse audience of all ages and backgrounds, from professionals to novices, from science enthusiasts to the merely curious.
• To provide a non-threatening entry point for local people from a varied demographic area (including rural and deprived areas) to engage with science.
• To provide role models for careers in the form of festival staff, volunteers and presenters who work in STEM in the local area.
• To showcase current and historical science originating within Midlothian.
• To demonstrate Midlothian’s contribution and importance to science and technology at a global level and to broaden the horizons of future generations of scientists.

Cycling in the Outer Hebrides - Isle of Skye

Spent a week cycling from Barra to Lochmaddy, then from Uig in Skye to Mallaig with various journeys on the train and ferry en-route.  As ever pondered what the Census says about this area and have investigated some key demographics of the major islands on the way.

Off to Isle of Skye to battle through wind and rain

Boundary

Population change
 

The usually resident population increased by 762 from 9251 in 2001 to 10013 in 2011.

This change was not spread evenly across age groups which is illustrated in the figure above.

In 2001, 19 per cent of the population was aged 0 to 15 years old.  This decreased to 17 per cent in 2011. There were also a reduction in the percentage of the population aged 30 to 44 from 21 per cent in 2001 to 17 per cent in 2011.

In 2001, 14 per cent of the population was aged between 60 and 74 years old, with a further 9 per cent aged 75 years and over.  In 2011, these had changed to 20 percent aged between 60 and 74 and  8 per cent aged 75 year and over.

In order to understand this change, it is necessary to look at statistics on migration and mortality statistics.

Some other key census 2011 stats on Isle of Skye

There are 4456 occupied households , 841 unoccupied household spaces which are second or holiday home, and 106 unoccupied household spaces which are vacant

20 per cent of people aged 16 and over living in households are single

30 per cent of people aged 3 and over can speak Gaelic

17 per cent of people aged 3 and over speak Gaelic at home

5 per cent of people stated their religion as Roman Catholic

50 per cent of people aged 16 to 74 are employed full-time or part-time

14 per cent of people aged 16 to 74 are self-employed

Cycling in the Outer Hebrides - North Uist/Uibhist A Tuath

Spent a week cycling from Barra to Lochmaddy, then from Uig in Skye to Mallaig with various journeys on the train and ferry en-route.  As ever pondered what the Census says about this area and have investigated some key demographics of the major islands on the way.

Ended the day with a tour of North Uist/Uibhist A Tuath

Boundary

Population change
 

The usually resident population decreased by 8 from 1320 in 2001 to 1312 in 2011.

This change was not spread evenly across age groups which is illustrated in the figure above.

In 2001, 20 per cent of the population was aged 0 to 15 years old.  This decreased to 13 per cent in 2011. There were similar reductions in the percentage of the population aged 30 to 44 from 23 per cent in 2001 to 15 per cent in 2011.

In 2001, 17 per cent of the population was aged between 60 and 74 years old, with a further 8 per cent aged 75 years and over.  In 2011, these had increased to 23 percent aged between 60 and 74 and  11 per cent aged 75 year and over.

In order to understand this change, it is necessary to look at statistics on migration and mortality statistics.

Some other key census 2011 stats on Benbecula / Beinn Na Faoghla

There are 629 occupied households , 100 unoccupied household spaces which are second or holiday home, and 16 unoccupied household spaces which are vacant

28 per cent of people aged 16 and over living in households are single

62 per cent of people aged 3 and over can speak Gaelic

49 per cent of people aged 3 and over speak Gaelic at home

5 per cent of people stated their religion as Roman Catholic

53 per cent of people aged 16 to 74 are employed full-time or part-time

12 per cent of people aged 16 to 74 are self-employed

Cycling in the Outer Hebrides - Benbecula / Beinn Na Faoghla

Spent a week cycling from Barra to Lochmaddy, then from Uig in Skye to Mallaig with various journeys on the train and ferry en-route.  As ever pondered what the Census says about this area and have investigated some key demographics of the major islands on the way.

Over the causeway to Benbecula / Beinn Na Faoghla

Boundary 
 

Population change
   

The usually resident population increased by 81 from 1249 in 2001 to 1330 in 2011.

This change was not spread evenly across age groups which is illustrated in the figure below.

In 2001, 17 per cent of the population was aged 16 to 29 years old.  This reduced to 14 per cent in 2011.

In 2001, 12 per cent of the population was aged between 60 and 74 years old, with a further 4 per cent aged 75 years and over.  In 2011, these had increased to 15 percent aged between 60 and 74 and 5 per cent aged 75 year and over.

In order to understand this change, it is necessary to look at statistics on migration and mortality statistics.

Some other key census 2011 stats on Benbecula / Beinn Na Faoghla

There are 587 occupied households , 14 unoccupied household spaces which are second or holiday home, and 21 unoccupied household spaces which are vacant

27 per cent of people aged 16 and over living in households are single

53 per cent of people aged 3 and over can speak Gaelic

37 per cent of people aged 3 and over speak Gaelic at home

39 per cent of people stated their religion as Roman Catholic

64 per cent of people aged 16 to 74 are employed full-time or part-time

8 per cent of people aged 16 to 74 are self-employed

Cycling in the Outer Hebrides - South Uist/Uibhist A Deas

Spent a week cycling from Barra to Lochmaddy, then from Uig in Skye to Mallaig with various journeys on the train and ferry en-route.  As ever pondered what the Census says about this area and have investigated some key demographics of the major islands on the way.

Next on to South Uist/Uibhist A Deas 

Boundary

Population change
  

The usually resident population decreased by 64 from 1818 in 2001 to 1754 in 2011.

This change was not spread evenly across age groups which is illustrated in the figure below.

In 2001, 22 per cent of the population was aged 0 to 15 years old.  This reduced to 19 per cent in 2011. A similar change is seen in the age group  30 to 44 from 21 per cent to 17 per cent.

In 2001, 15 per cent of the population was aged between 60 and 74 years old, with a further 7 per cent aged 75 years and over.  In 2011, these had increased to 19 percent aged between 60 and 74 and 8 per cent aged 75 year and over.

In order to understand this change, it is necessary to look at statistics on migration and mortality statistics.

Some other key census 2011 stats on South Uist/Uibhis A Deas

There are 781 occupied households , 77 unoccupied household spaces which are second or holiday home, and 33 unoccupied household spaces which are vacant

29 per cent of people aged 16 and over living in households are single

65 per cent of people aged 3 and over can speak Gaelic

56 per cent of people aged 3 and over speak Gaelic at home

64 per cent of people stated their religion as Roman Catholic

53 per cent of people aged 16 to 74 are employed full-time or part-time

11 per cent of people aged 16 to 74 are self-employed

Cycling in the Outer Hebrides - Barra/Barraigh

Spent a week cycling from Barra to Lochmaddy, then from Uig in Skye to Mallaig with various journeys on the train and ferry en-route.  As ever pondered what the Census says about this area and have investigated some key demographics of the major islands on the way.

Starting with Barra / Barraigh 

Boundaries - check

The boundaries of the islands were reviewed as part of the processing of producing output areas for 2011.  There are unlikely to be many substantial differences in the island areas but worth checking by reviewing the outputs on the CDE.  In the case of Barra they look very similar.

2001 boundary

2011 boundary

Population change
  

The usually resident population increased by 96 from 1078 in 2001 to 1174 in 2011.

This change was not spread evenly across age groups which is illustrated in the figure below.

In 2001, 22 per cent of the population was aged 0 to 15 years old.  This reduced to 20 per cent in 2011. A similar change is seen in the age group 16 to 29 years old.

In 2001, 17 per cent of the population was aged between 60 and 74 years old, with a further 6 per cent aged 75 years and over.  In 2011, these had increased to 20 percent aged between 60 and 74 and 8 per cent aged 75 year and over.

In order to understand this change, it is necessary to look at statistics on migration and mortality statistics.

Some other key census 2011 stats on Barra/Barraigh

There are 549 occupied households , 117 unoccupied household spaces which are second or holiday home, and 18 unoccupied household spaces which are vacant

27 per cent of people aged 16 and over living in households are single

63 per cent of people aged 3 and over can speak Gaelic

51 per cent of people aged 3 and over speak Gaelic at home

68 per cent of people stated their religion as Catholic

53 per cent of people aged 16 to 74 are employed full-time or part-time

12 per cent of people aged 16 to 74 are self-employed


 

Downloading a table of workplace flows for Inverclyde

<- Art work from the Port Glasgow station underpass . Produced as part of an NHS Mental Health Group project. 




1 -  www.nomisweb.co.uk












2 -  Move down page to 2011 CENSUS STATISTICS
 

3 - Select Origin-Destination Data (Also Known as Flow Data)

4 - Select table WU03UK from the list of 20 tables 

5 - Select 'Explore in detail' from left hand side of screen

6 - Make selections of each of the headings in the next screen

7

 - Method of travel 

8 - Place of work 

- choose Scotland then Inverclyde, Renfrewshire and Glasgow for example

9 - Usual residence


Choose Scotland then Inverclyde


10 - Finally - Download Data

So 
- 19,352 residents of Inverclyde travel to work within Inverclyde, 11,463 travelling by car.
- 4,235 residents of Inverclyde travel to work in Glasgow City, 1,269 by train.
- 3,152 residents of Inverclyde travel to work in Renfrewshire, 359 as passengers in a car.

Migration Flows in and out of Inverclyde

 <- Art work from the Port Glasgow station underpass. Produced as part of an NHS Mental Health Group project.












1 -  www.nomisweb.co.uk



2 -  Move down page to 2011 Census Data on Nomis 
      
(http://www.nomisweb.co.uk/census/2011)
 

3 - Select Origin-Destination Data (Also Known as Flow Data)

4 - Select table MM01CUK_ALL: Origin and destination of migrants by age (broad grouped) by sex, from the list of 20 tables 

5 - Choose Inverclyde as the area for 'Interactive Visualisation' 
      [Start typing Inverclyde]

   and View data


6  - The visualisation illustrates the numbers of people moving in or out of the Inverclyde area during the year before Census.  Hover over the arrows to see the numbers.

Exploring Scotland's Census in Port Glasgow

This course was organised following an enquiry from a team leader in the Quality & Development Service of  Inverclyde CHCP.  It was attended by people from a range of services in the council and a voluntary sector rep - who was the only one without meetings that day.

The course followed the usual format with an introduction to Census 2011 results, and then a demo of the Census Data Explorer.  The participants had a range of experience using websites and so the practical gave them experiences to explore aspects of the website which were most relevant.

Material published here on NRS website.
http://www.scotlandscensus.gov.uk/events-and-workshops

The final section of the course covered accessing flow data and migration tables - a bit rushed so the following posts include some screen shots of what was covered.  I will upload some additional slides covering this material.


Questions included
- sources of information available using datazones (2011)
- ongoing work to develop localities for community planning partnership
- ability to produce maps at local level using Census data

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