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.


Hide details for Video TranscriptVideo Transcript
Mean and Median Function

The mean is one measure we can use to compare one data sample with another. In Excel mean is referred to as average. Before we can compare the questionnaire completion time of males and females in our data sample lets’ create a quick summary table to help organise our findings.

Select cell In D1 and enter the heading Question Time for Boys and Girls. In cell E2 Type, Mean, and in the cell immediately to the right, Median. In cell D3 type, Boys, and directly under this, Girls.

Select all the cells and the ones that will eventually hold data go to format, select cells click outside and inside and click on OK. Our table is ready. We are now ready to use the excel functions to analyse our data.

To find the MEAN, click in the cell we want the mean time for boys to appear. Click on insert, select function. A window called Insert Function should appear. Type mean, in the search for a function box and press go. Select AVERAGE and press OK. Click on the first QTime piece of data for males and Hold mouse down and drag down to last male Q time. Release the button and click on OK. The time it took for boys to complete the questionnaire should now appear in the cell. Repeat this for girls. Remember to place your cursor where you want your answer to go first.

We use the same process; Insert Function, to calculate the Median. However this time we type Median in the Search for a Function box. We can make the Mean time one decimal place by selecting the cells. Click on the format menu. Select cells. Under the category heading of Number, change the number of decimal places to 1. Press OK. We can now examine our question: Are boys faster than girls?

Imagine the debate about statistics that could arise if each student had taken their own sample and came up with a different answer. Why is the mean greater than the median for boys? What if the slowest boy was not there on the day? What if he were very much slower? Can you alter the data in any way to make the median 20? What can you do to make the median greater than the mean?

Many open ended questions can be asked to explore mean and median that would deepen students understanding. This is one example of how Excel can be used as an interactive learning tool. Change the data and see the effect immediately in the table.

With these basic skills you can now use excel to explore the many possibilities of CensusAtSchool data. You could further explore chart wizard function or experiment with other functions and statistical tools available in Excel.
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.