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.


Hide details for Video TranscriptVideo Transcript
Draw a Graph

A summary table is one way to summarise data. Another important way is by generating a graph. In Excel a graph is referred to as a chart. The Excel chart wizard assists you in creating a variety of different graphs.

Let’s quickly go through how to create a graph.

Hold down your left mouse button and highlight your summary table. Go to insert, then select chart.
The first screen of the chart wizard should appear and will allow you to select the type of graph you would like to make. After selecting the chart type and chart sub type you can preview the graph by holding down the press and hold to view sample button.

Now you will be able to preview how your data will be represented with various graph types. Select the graph you wish to create. For this example I will select a column graph, more specifically a clustered column graph. Press next. This screen confirms the data range. Press next.

Enter the titles you wish to place on your graph. Notice that as you enter the titles they automatically appear on the preview screen. For this example- I am naming the graph; CensusAtSchool Eye Colour -The x axis; Eye Colour- and the y axis; Number of Students. Press next.

Finally select: Insert Graph as Object In. Press finish and save your work. A graph should now appear next to your data and summary table.

To edit any aspect of your graph simply, click to select the part of the graph you wish to edit.
In this case let’s change the colour of one of the columns. Little black squares should appear around the selected object. Go to format from the menu. Click on selected data point. And then you can edit the colours of your graphs as well as font styles and sizes. There are various other items such as data labels and formatting by using the format option. By generating different kinds of graphs students are in the position to compare and contrast different styles of data representation.

Is a pie chart a better way to show the distribution of eye colour in a class than a column graph?
Is there one graph that can compare two sets of data at the same time?

Show your students how a graph can tell a different story by changing the minimum value of the y- axis of your chart. Click on the y axis, go to format and click select axis. Select the scale tab and change the increments of the scale its minimum values. For this example, change minimum value from 0 to 10 and change the major unit from 2 to 5. Notice the graph will change to reflect the alterations to the scale.

You can now discuss with your students what story the graph is now telling.

This very technique of changing the scale of a graph is often used in media such as newspapers.
Now that we have explored some possible applications of categorical data let’s now look at numerical data.
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.


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.