Post Graduate Primary class - data handling and social subjects

This is the beginning of a post to provide some background data for students teachers to use in producing and interpreting charts with primary classes.

Here is a chart of household composition in Scotland with comparable figures for England,  Wales

Sources:
Census tables -
QS113SC,QS113EW

At a local level, the following gives the percentage of households in each electoral ward in Edinburgh.  This can be adapted for your own area.

What sorts of areas have the least one person households ?
And what about the areas with lots of one person households?


The chart below compares the percentage of single person households  in these areas, with the percentage of households in an area which are under 35 years(young households).

What does this suggest?

There are a couple of areas which are out of line, with the general trends. The class could investigate if there are any special features of these areas.

• The Meadows ward seems to have an unusually high percentage of young households. 
• The Southside ward has a relatively low percentage of young households.  

These statistics along with other characteristics which might be related to single person households are given in the table below

- the size of the house in terms of rooms
- a measure of underoccupancy (households with 2 or more rooms than required)

Data source here  http://bit.ly/1hmdykc

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