Australian Bureau of Statistics
Rate the ABS website
CensusAtSchool
ABS @ Facebook ABS @ Twitter ABS RSS ABS Email notification service
CensusAtSchool Australia
 

CensusAtSchool home page > Professional Support Materials

Classroom Activities and Support Materials banner

Back to CensusAtSchool home page Videos

These videos provide a step-by-step guide to using CensusAtSchool in the classroom. Videos include a complete overview of CensusAtSchool, instructions on how to generate a random sample and tips on using data effectively in Excel.

When you click on the links below, a new window will open directing you to the TeacherTube website which is external to the Australian Bureau of Statistics.

All of the tutorials use Excel 2003 so some of the functions demonstrated in the videos may be in different locations in later versions of the program.


VideoLink Description
Duration
General CensusAtSchool

1

Introducing CensusAtSchool
Former Australian Statistician, Dennis Trewin, talks about the aims of CensusAtSchool and the structure of the project.


02:12

2




Overview of CensusAtSchool
History and description of CensusAtSchool, including a demonstration of the 2006 Questionnaire and the questionnaire response data.

06:31

3



The 2006 Random Sampler and Samples


Step by step instructions on how to generate a random sample. Preview a random data sample.

03.49
Tailoring the Data to suit your needs

4.1
Make multiple worksheets in a Workbook


Insert a new sheet into an Excel work book

00:54

4.2
Simplify the Data

Copy and paste data from an existing worksheet into a new worksheet.

04:12
Working with Data in Microsoft Excel

5.1
Create a Summary Table


Format a table used to summarise data.

01:55

5.2
COUNTIF Function


Use COUNTIF to tally the frequency of a variable.

02:20

5.3
Draw a Graph


Insert and format a graph using categorical data.

03:38

5.4



Using the Sort Function		Sort data according to topic and value.

01:30

5.5

Mean and Median Function


Find the mean and median of numerical data.

04:31

6

Using CensusAtSchool in the Classroom
Construct a scatterplot, remove outliers, add a trend line and remove outliers; and identify possible outliers using conditional formatting.


09:14


© 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.