|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.|
|Key National Indicators||How to find Key National Indicators on the ABS website and a demonstration of how to access source publications.|
Key National Indicators
Start at the ABS home page. Note the quick links on the left hand navigation menu to access main economic indicators. If you need the latest CPI, Labour Force and National Accounts data, you can access them from here under National Statistics. A good starting point is Key National Indicators.
Key National Indicators present summary tables and graphs on the latest economic and social measures including GDP, CPI, Unemployment and Average Weekly Earnings. The link opens in the Summary tab. You will find tables of key economics and social indicators, and links to the full publication sources of this summary data. Note the summary data includes the latest figures for each indicator, as well as the percentage change from the previous quarter and the percentage change from the corresponding period last year.
Summary tables are a very useful resource for your class as they are easy to find and provide a quick snapshot of the latest key national data. You can switch to 'Graphs' for the same information in graphical form. Similarly, you can access links to source publications from this page. For example, click on the 'Labour Force' hyperlink and then open the publication Labour Force, Australia (cat # 6202.0). As with all ABS publications, it will open on the Summary page.
For more detail go to the Download tab and download the full publication in PDF format or open one of the Excel tables if you’re after a particular dataset. If you would like to view the Glossary, click on the Explanatory Notes tab. In most ABS publications, this is where you will find a brief introduction of the publication as well as a glossary of terms.
|National Accounts||A demonstration of the National Accounts themes page and how to find quarterly and annual GDP data.|