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.


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.


Hide details for Video TranscriptVideo Transcript
Measures of Australia's Progress

Measures of Australia’s Progress came out of the growing interest in assessing whether life in Australia was getting better. One outcome of measuring and reporting on progress is to make sense of the world we live in. Students can use this publication as a rich information source for assignments in a range of subject areas, with a focus on longitudinal analysis. A class discussion could arise about the potential indicators of a country’s progress and the approach taken by ABS to measure progress in Australia.

The Measures of Australia’s Progress publication is found on the left-hand menu of the ABS homepage, under Key Products. The publication opens on the home page to present the latest articles on selected indicators. On the left hand menu under the Summary tab there are links to chapters and all available feature articles. In the 2009 issue, you can also access a 10 year summary for selected indicators. Here, the annual rate of change for selected summary indicators is displayed on a graph. Please note, although publication layouts may vary from year to year, the left hand navigation menu will always provide links to core information available in the publication.

We will go back to the home page via the Summary tab, and click on a topic of interest. There are time series graphs displayed with accompanying commentary. Scroll down to find related publications of interest. A list of all related publications is also found under the Related Information tab. If you would like to access the source data for use with your students, click on the Downloads tab and then click on the Excel icon. The data cube will open in a Microsoft Excel spreadsheet on the contents pages. Table topics covered in the PDF publication will be included in this spreadsheet. Open a table from one of the worksheets below. You can also open a table from the body of the page. Simply click on the table number to open the time series data you want. This table is displaying life expectancy for the ten year period 1997 to 2007.
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.