|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.|
|National Accounts||A demonstration of the National Accounts themes page and how to find quarterly and annual GDP data.|
National Accounts presents the latest data on the Australian economy including GDP, international trade, investment, net disposable income and a range of feature articles on selected topics.
Starting at the ABS homepage, click on the 'National Accounts' link under the National Statistics heading. You will be directed to the National Accounts themes page which contains a comprehensive list of National Accounts releases. Scrolling down, you will find a wealth of information papers and an index of National Accounts feature articles.
One of the main economic indicators measured by the ABS is GDP. Estimates of GDP are available on a quarterly and annual basis. Get the quarterly GDP figures in catalogue number 5206.0. Open the publication and you will see the quarterly figures are shown at the top of the page, including the yearly percentage change. Scrolling down, you can see graphs are also provided along with key points for the respective quarter. To access the full publication click on the Downloads tab. Download the full publication in PDF format or to get more detailed data, open one of the Microsoft Excel time series spreadsheets. You will find more than 50 years of time series data for the quarterly GDP estimates.
For annual estimates of GDP, go back to the ABS home page by clicking on the ABS logo in the top left hand corner of the page. Note that you can click this logo at any time to get back to the ABS home page. Select National Accounts from the quick links again. The Australian System of National Accounts, cat. no. 5204.0, provides a more detailed breakdown of various components of National Accounts, including annual GDP. Please note a wealth of economics data is also available via the ABS Theme pages from the top navigation menu. This is just another pathway for finding the data you want.