Australian Bureau of Statistics

Rate the ABS website
ABS Home
ABS @ Facebook ABS @ Twitter ABS RSS ABS Email notification service
CensusAtSchool Australia
 


Education Services home page > CensusAtSchool home page > Year 5 Resources

Resources

Back to CensusAtSchool home page CaSQ 12C - Pie Chart of Eye Colour Using COUNTIF in Excel

You can download this activity as a rich text file (RTF) using the link at the bottom of the page.

How to: Get a Random Sample from CensusAtSchool

Go to the CensusAtSchool Random Sampler to download a sample.

Reference year: (select year) Sample size: 96 students

Select questions: Eye colour

Location: Select location Year level: (select a range of year levels)

To protect privacy there is a rule built into the sampler that the requested sample size cannot exceed 10% of the respondents for the parameters entered.


Task One: Organising your data

In the CensusAtSchool random sample find data for eye colour.




Task Two: Creating a Pie Chart






Download the full activity:


    Commonwealth of Australia 2008

    Unless otherwise noted, content on this website is licensed under a Creative Commons Attribution 2.5 Australia Licence together with any terms, conditions and exclusions as set out in the website Copyright notice. For permission to do anything beyond the scope of this licence and copyright terms contact us.