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.


Hide details for Video TranscriptVideo Transcript
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.
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.


Show details for Video TranscriptVideo Transcript
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.