|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.|
|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.|
Census Tables are very useful when you need detailed data on a particular Census topic for a particular area. They are sourced from Community Profiles but provide an easier way to look at the tables. Note that Census Tables and Community Profiles are pre-formatted tables and the same list of variables is used for all geographic areas. There are also Census variables with full classification tables available. These tables are more detailed than the standard Census Tables. Types of variables include: Industry of Employment, Occupation, Birthplace and Language spoken at home.
Start at the ABS homepage, and click on 'Census Data' on the left hand navigation menu. Find 'Census Tables' on the page and choose which year’s Census data you want displayed. You can see that unlike other Census products, you have two search options for Census Tables: find data by either topic or location. Let’s search by location and click ‘Next’. Please note you can select different search methods using the tabs above.
Type in your chosen area of interest. In this example we will type in 'Parramatta' and click ‘Search’ to continue. Select a specific location from the search results list. We will choose Parramatta LGA in this example. Once a selection has been made, a map appears to check it is the area you wanted. If it is, click on ‘Select Topic’.
Before choosing a topic, you can choose a count method. In 2006, primary output is based on Place of Usual Residence, which is the default setting. Other count method options are Location on Census night and Place of Employment. When choosing a count method note that Place of usual residence generates all person variables; however, the location on Census night count method generates variables based on dwellings and households. For example – internet and computer usage. We will leave the default setting as our preferred count method. Select a topic from the list. For this example we’ll choose Birthplace and then from the data list we will choose Country of birth by Age and Sex. Click on View Census Table.
To open the Census Table in Excel, go to the ‘Downloads Tab’ and click on the ‘Free Download’ file. You can either choose to Save or Open the file. Save the file if you expect to come back to it again. Otherwise you can open and save the file later. This is what your table will look like in Microsoft Excel: you are presented with a list of countries of birth for the Local Government Area of Parramatta. The table provides a breakdown by Sex and Age. If you want to view a full classification table, go back to the Topics page and select your topic of interest from the list .
To continue with our example we will once again select Birthplace. Then select a full classification table if it’s available from the data list. To continue, click on ‘View Census Table’. To open the Census Table, go to the ‘Downloads' tab and click on the ‘Free Download’ link on the right hand side of the page. Once again you can Save or Open the file. The table has a more detailed list of the countries of birth for people living in Parramatta; however, a breakdown by age is not provided for the full classification 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.|