|Introducing CensusAtSchool||Former Australian Statistician, Dennis Trewin, talks about the aims of CensusAtSchool and the structure of the project.||02:12|
|Tailoring the Data to Suit Your Needs|
|Making Multiple Worksheets in a Workbook||Insert a new sheet into an Excel workbook.||00:54|
|Simplify the Data||Copy and paste data from an existing worksheet into a new worksheet.||04:12|
|Working with Data in Microsoft Excel|
|Create a Summary Table||Format a table used to summarise data.|
|COUNTIF Function||Use COUNTIF to tally the frequency of a variable.|
|Draw a Graph||Insert and format a graph using categorical data.|
|Using the Sort Function||Sort data according to topic and value.|
|Mean and Median Function||Find the mean and median of numerical data.|
|Using CensusAtSchool in the Classroom||Construct a scatterplot, remove outliers, add a trend line and remove outliers; and identify possible outliers using conditional formatting.
|Using ABS Census Data Products|
|Introductory Video for Census Topics||Introduction to the Census topics as well as what is not included in the Census product videos.|
|Census Product - QuickStats||This video demonstrates how you can search for key summary Census data using QuickStats.|
|Census Product - Community Profiles||This video demonstrates how to find Census data for your area of interest using Community Profiles.|
Community Profiles allow you to investigate a diverse range of Census topics from six different perspectives. Each profile looks at a different population or respondent location and presents a comprehensive statistical picture of a particular area.
Start at the ABS website homepage and click on 'Census Data' on the left hand navigation menu. Find 'Community Profiles' in the body of the page and choose which year’s Census data you want displayed. As with QuickStats and MapStats, search for a geographic area by using one of the above tabs. In this example we will type in a keyword to search for our area of interest. Select a specific location from the results list. Scroll down to view all locations for your search. Let’s select Wyndham Local Government Area.
Once a selection has been made, a map of the chosen area appears. Check it is the wanted area. If it is, click on ‘View Community Profiles’. Depending on the area you select, there may be up to 6 types of Community Profiles available: the Basic Community Profile, the Indigenous profile, Time Series profile, Place of Enumeration profile which refers to the location of respondents on Census night, the Expanded Community profile which provides more detailed data than the Basic Community profile, and the Working Population profile.
Click on the Downloads tab to find the downloadable files for each profile. Open the profile you want to explore by clicking on the 'Free Download' link. You can choose to save the file to a specified location or simply ‘Open’ the file and save it later. The community profile will open in an Excel spreadsheet with a list of Tables. The tabs at the bottom provide links to further table topics, concepts and definition and individual tables. If you want to know more about this Census product, a separate tutorial on Community Profiles is available from the ABS suite of self-directed learning videos.
|Census Product - Census Tables||This video demonstrates how to find detailed Census data for your area of interest and how to download a Census table.|
|Key ABS Products for Teachers|
|Australian Social Trends||A description of some of the main features of the Australian Social Trends publication and where to find it on the ABS website.|
|Measures of Australia's Progress||How to find the Measures of Australia's Progress publication and a brief demonstration of key features.|
|Yearbook Australia||How to find the Yearbook Australia series and a brief demonstration of key features.|
|Consumer Price Index||How to find Consumer Price Index (CPI) on the website and a demonstration of how to access CPI education resources from the ABS Education pages.|
|Key National Indicators||How to find Key National Indicators on the ABS website and a demonstration of how to access source publications.|
|National Accounts||A demonstration of the National Accounts themes page and how to find quarterly and annual GDP data.|