Worksheet: Making a Pie Chart from the Census
This exercise lets pupils extract information from the Wrockwardine Wood 1851 Census, and use it to work out the predominant occupations in the area. You could vary this exercise to work out information such as the average size of a family, the age range and so on.
- Save the Wrockwardine Wood 1851 Census to the hard drive.
- There are five sample families extracted from the Census. Print out these sheets.
- Give one family to each pupil or group. Repeat until all pupils or groups have a different family to work with. If you need more families, choose some more families from the Census and paste them into the Sample Family Template.
- Get the pupils to go through their family. Beside each name, ask them to put a letter corresponding to the occupation of that person. Ask them to write down the total number of people in their family.
- Collect the sheets.
- Open the Worksheet 'Occupation Summary'.
- Add up the total number of people sampled. Type this number into cell B2.
- Tally up the number of a's, i's and so on from all groups and enter the totals into the appropriate cell in column B.
- You could now highlight cells B3 to B9, and use the Chart Wizard to create a pie chart showing the relative number of people working in industry as compared to the skilled occupations.
- You could then see how the working population Wrockwardine Wood compares with the rest of Shropshire. The 1851 Census for Shropshire shows that 40% of the population were engaged in agriculture, with the industrial workforce making up only 10% of the total.
|
