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.


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.


Hide details for Video TranscriptVideo Transcript
Australian Social Trends

Australian Social Trends is a great source of information articles written by ABS experts on issues of social relevance to Australian society. It will provide you and your students with a wide range of data and analysis of social topics. It aims to provide a snapshot of particular aspects of Australian society and how these have changed over time. The publication was issued annually from 1994 to 2008 but became a quarterly on-line publication in March 2009.

From the ABS homepage, click on the 'Australian Social Trends' link from the left hand navigation menu. Like all ABS publications, the Australian Social Trends link opens in the Summary tab. In the body of the Summary page you will find quick links to the latest articles as well as national and state summary tables. On the left hand menu you have access to a list of all Social Trends articles dating back to 1994. You can scroll down to view the list of articles or click on the topic hyperlinks at the top of the page. Alternatively click on the Past & Future Releases tab to access the full suite of AST publications.

There is also a link to the Australian Social Trends Seminar series. Throughout the year a series of seminars will be presented and the slides will be made available on this web page. To access articles in PDF version, click on the Downloads tab. You can download the entire publication or just choose individual articles that interest you.

The data cubes contain source tables featured in the PDF version of the publication. These can be useful and interesting datasets for students. To open the data cube, click on the Excel icon and ‘Open’ the document. The file should open in the Contents worksheet, which links to all the tables available in the data cube. Tables can also be accessed by opening any of the worksheets at the bottom of the page. Note the link to ‘Definitions’, as well as a list of publications from which the data was sourced. You can also get back to the Australian Social Trends homepage from within the spreadsheet by clicking on the link in the body of the Contents page.
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.