|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 - QuickStats
QuickStats is designed to provide users with a summary of key Census statistics for a specific area and basic comparisons to Australian data. Start at the ABS homepage, click on 'Census Data' on the left hand navigation menu. Find 'QuickStats' in the body of the page and choose which year’s Census data you want displayed. You can search for a location by using any of the above tabs. Select a location from a series of lists or choose a location from a map. In this example we will type in ‘Fairfield’. Click on the ‘Search’ button and a list of all the places that include ‘Fairfield’ have come up. Click on the scroll bar and drag down to view all locations for your search.
If you’re having trouble choosing a location, click on the Information icon above your location search results list. This page contains descriptions of all the geographies available, to help you make your selection. Select your area of interest from the list. We will select 'Fairfield Local Government Area'. Once a selection has been made, a map appears to check it is the wanted area. If you are happy with the selection, click on the 'View QuickStats' button. You will see the major characteristics, such as population and country of birth, are displayed for your chosen area. For each characteristic, comparisons are also made to Australia as whole. A descriptive commentary on the characteristics is available at the bottom of each data table. Note the Information Icons against the Census Topics. Clicking on the icon will take you to further information about a particular Census variable.
QuickStats data are available for geography areas as large as Australia as well as local government areas, state suburbs and postal areas. Please note QuickStats only shows selected Census topics and the top 5 results for that topic. If you’re after more detailed data, you may prefer to use Census Tables instead. QuickStats is a great resource when students are studying their local community. Why not ask students to make a fact sheet or profile of their chosen area, using a QuickStats report.
|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.|
|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.|