Australian Bureau of Statistics

Rate the ABS website
CensusAtSchool
ABS @ Facebook ABS @ Twitter ABS RSS ABS Email notification service
CensusAtSchool Australia
 
 
Education Services home page

Teacher Statistical Literacy

Back to Education Services home page

ABS Video Tutorials


These video tutorials will familiarise you with a range of ABS products that are useful in the classroom. You can view video transcripts by clicking on the triangle labelled 'Video Transcripts' below the video description.

On this page:
LinkDescriptionDuration (mins)

General CensusAtSchool

Introducing CensusAtSchoolFormer 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 WorkbookInsert a new sheet into an Excel workbook.00:54

Simplify the DataCopy and paste data from an existing worksheet into a new worksheet.04:12


Working with Data in Microsoft Excel

Create a Summary TableFormat a table used to summarise data.


Show details for Video TranscriptVideo Transcript
01:55

COUNTIF FunctionUse COUNTIF to tally the frequency of a variable.


Show details for Video TranscriptVideo Transcript
02:20

Draw a GraphInsert and format a graph using categorical data.


Show details for Video TranscriptVideo Transcript
03:38

Using the Sort FunctionSort data according to topic and value.


Show details for Video TranscriptVideo Transcript
01:30

Mean and Median FunctionFind the mean and median of numerical data.


Show details for Video TranscriptVideo Transcript
04:31

Using CensusAtSchool in the ClassroomConstruct a scatterplot, remove outliers, add a trend line and remove outliers; and identify possible outliers using conditional formatting.

Show details for Video TranscriptVideo Transcript

09:14


Using ABS Census Data Products

Introductory Video for Census TopicsIntroduction to the Census topics as well as what is not included in the Census product videos.


Show details for Video TranscriptVideo Transcript
00:33

Census Product - QuickStatsThis video demonstrates how you can search for key summary Census data using QuickStats.


Show details for Video TranscriptVideo Transcript
03:34

Census Product - Community ProfilesThis video demonstrates how to find Census data for your area of interest using Community Profiles.


Show details for Video TranscriptVideo Transcript
02:45

Census Product - Census TablesThis video demonstrates how to find detailed Census data for your area of interest and how to download a Census table.


Hide details for Video TranscriptVideo Transcript
Census Tables

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.
04:56


Key ABS Products for Teachers

Australian Social TrendsA description of some of the main features of the Australian Social Trends publication and where to find it on the ABS website.


Show details for Video TranscriptVideo Transcript
03:09

Measures of Australia's ProgressHow to find the Measures of Australia's Progress publication and a brief demonstration of key features.


Show details for Video TranscriptVideo Transcript
03:02

Yearbook AustraliaHow to find the Yearbook Australia series and a brief demonstration of key features.


Show details for Video TranscriptVideo Transcript
01:39

Consumer Price IndexHow to find Consumer Price Index (CPI) on the website and a demonstration of how to access CPI education resources from the ABS Education pages.


Show details for Video TranscriptVideo Transcript
02:41

Key National IndicatorsHow to find Key National Indicators on the ABS website and a demonstration of how to access source publications.


Show details for Video TranscriptVideo Transcript
02:25

National AccountsA demonstration of the National Accounts themes page and how to find quarterly and annual GDP data.


Show details for Video TranscriptVideo Transcript
02:46


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.