Search results

Listed under:  Mathematics  >  Statistics and probability  >  Data representation  >  Spreadsheets
Text

Professional learning workshops

This webpage provides details of ten workshops that focus on understanding and implementing the Australian Curriculum: Digital Technologies. The workshops are provided for Digital Technologies in Focus project schools and, where possible, schools not involved in the project.

Audio

Faith Lutheran College – Podcast

This podcast includes information about the aims, challenges, insights and accomplishments of Faith Lutheran College's participation in the Digital Technologies in Focus project.

Online

Protecting dugongs

The Western Australian Marine Science Institution has been collecting data about dugongs off the coast of the Kimberley in Northern WA. We have been provided with the raw data from its sightings trips. In this project students will learn how dugong sightings are conducted, and develop the data-science skills needed to make ...

Online

Seeing the wood for the trees

In this lesson sequence students summarise data using advanced filtering and grouping techniques, for example pivot tables in spreadsheets and aggregation functions in databases.

Online

Hot or not?

This lesson sequence focuses on the incremental or Agile approach to development and encourages students to follow the evolution of a temperature conversion tool for a Food Technology teacher. It uses an Excel spreadsheet application as the prototyping tool.

Online

A spreadsheet's secret weapon

In this lesson sequence, students learn to use pivot tables which have been described as the most powerful tool within spreadsheets.

Online

Spreadsheets come alive

In this lesson sequence use the ‘Odds and evens’ problem as a springboard. Students construct interactive spreadsheets designed to address particular needs. This lesson also demonstrates an approach to programming known as rapid application development (RAD).

Video

Computational thinking in the Australian Curriculum: Digital Technologies

This video provides an overview of computational thinking and how it can be taught in the context of other learning areas.

Text

Archived newsletters

This webpage features archived newsletters from the Digital Technologies in Focus project. The newsletters include information about schools' projects, assessment tasks, the Australian Curriculum and resources.

Audio

St James Catholic College – Podcast

This podcast includes information about the aims, challenges, insights and accomplishments of St James Catholic College's participation in the Digital Technologies in Focus project.

Text

ACARA sample assessment task: years 7-8

This resource provides strategies for assessing students' understanding of the ways in which data can be sourced, organised and represented to maximise options for analysis, evaluation, decomposition and visualisation in order to create digital solutions. The context of the resource is the liveability of the places in which ...

Text

A–Z Digital Technologies vocabulary F–6

This PDF assists teachers in thinking about when and how to introduce Digital Technologies discipline-specific vocabulary.

Video

Supporting implementation of Digital Technologies and the ICT Capability: part 1

This video explains ways in which the Digital Technologies curriculum and the Information and Communication Technology (ICT) General Capability can be implemented in schools. This video is the first in a series of three.

Text

Newsletters

This webpage features newsletters from the Digital Technologies in Focus project. The newsletters include information about schools' projects, assessment tasks, the Australian Curriculum and resources.

Text

Newsletter – October 2020

This newsletter from the Digital Technologies in Focus project includes information about schools' projects, the Australian Curriculum, and useful resources.

Text

Newsletter – October 2019

This newsletter from the Digital Technologies in Focus project includes information about schools' projects, visual programming, the Australian Curriculum, and useful resources.

Text

Newsletter – December 2018

This newsletter from the Digital Technologies in Focus project includes information about schools projects, the Australian Curriculum, and useful resources.

Text

Newsletter – December 2017

This newsletter from the Digital Technologies in Focus project includes information about schools' projects, the Australian Curriculum and useful resources.

Text

School stories

This webpage provides users with a menu of schools whose experiences with Digital Technologies are described in detail.

Video

Alyangula Area School – Progress report 1

This video is a summary of a progress report into the implementation of Digital Technologies in the Alyangula Area School.