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

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

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

Census dataexplorer practicalworksheet_150217 from celiamac58

 

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.

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.

Geography Skills Aberdeen City CPD event 3rd dec from celiamac58

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.

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.


.

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