|Introducing CensusAtSchool||Former 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 Workbook||Insert a new sheet into an Excel workbook.||00:54|
|Simplify the Data||Copy and paste data from an existing worksheet into a new worksheet.||04:12|
|Working with Data in Microsoft Excel|
|Create a Summary Table||Format a table used to summarise data.|
|COUNTIF Function||Use COUNTIF to tally the frequency of a variable.|
|Draw a Graph||Insert and format a graph using categorical data.|
|Using the Sort Function||Sort data according to topic and value.|
|Mean and Median Function||Find the mean and median of numerical data.|
|Using CensusAtSchool in the Classroom||Construct a scatterplot, remove outliers, add a trend line and remove outliers; and identify possible outliers using conditional formatting.
|Using ABS Census Data Products|
|Introductory Video for Census Topics||Introduction to the Census topics as well as what is not included in the Census product videos.|
|Census Product - QuickStats||This video demonstrates how you can search for key summary Census data using QuickStats.|
|Census Product - Community Profiles||This video demonstrates how to find Census data for your area of interest using Community Profiles.|
|Census Product - Census Tables||This video demonstrates how to find detailed Census data for your area of interest and how to download a Census table.|
|Key ABS Products for Teachers|
|Australian Social Trends||A description of some of the main features of the Australian Social Trends publication and where to find it on the ABS website.|
|Measures of Australia's Progress||How to find the Measures of Australia's Progress publication and a brief demonstration of key features.|
|Yearbook Australia||How to find the Yearbook Australia series and a brief demonstration of key features.|
|Consumer Price Index||How to find Consumer Price Index (CPI) on the website and a demonstration of how to access CPI education resources from the ABS Education pages.|
Consumer Price Index
From the quick links on the left hand navigation menu of the ABS home page, you can find the Consumer Price Index quarterly publication. The publication opens on the Summary tab to present the latest key data for all industry groups including the latest quarterly change in the CPI and movements over a 12 month period. Scroll down to see the key points and overview of CPI movements for the latest quarter. To access previous CPI data, click on the Past and Future Releases tab. This lists all previous issues of the CPI publication, as well as the next expected release date. We will now go back to the Summary tab.
Note other options from the left hand menu include a 'Capital Cities Comparison' and 'Main Contributors to Change'. If you click on 'Main Contributors to Change', you'll be presented with a discussion on each of the CPI groups. All the important information is here, but your students will not be overwhelmed or confused with too much data. You can easily find more detailed data to inform your teaching by going to the Downloads tab. From here you can download the full publication in PDF or view time series data in an Excel spreadsheet. Click on the table you want to view.
For more information about the Consumer Price Index, please view the slideshow ‘CPI: Reality beyond the Textbook’. This is a valuable education resource for the senior economics classroom that was delivered by ABS CPI expert, William Milne. To find the presentation, start from the ABS homepage, click on the ‘Education’ link located on the top navigation menu. You will be taken to the ABS Education Services entry page. Go via the Teacher Area, select ‘Resources for the Classroom’ and then click on ‘Senior Curriculum Resources’. The presentation was delivered at the ABS as part of the 2008 VCTA Comview Conference.
|Key National Indicators||How to find Key National Indicators on the ABS website and a demonstration of how to access source publications.|
|National Accounts||A demonstration of the National Accounts themes page and how to find quarterly and annual GDP data.|