Search results

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

Who wants to be a millionaire?

This lesson sequence uses the well-known wheat/rice and chessboard problem as students use spreadsheets to simulate iteration and to solve problems.

Online

COVID 19 Demystified course

At the end of this course, learners should be able to better understand the science and numbers behindCOVID-19 and the SARS-CoV-2 virus that causes it. They should be able to discuss the pandemic with confidence, giving substantiated viewpoints on matters such as public policy with a willingness to accept other viewpoints. ...

Online

Turtles: impact of climate change on Flatback turtle populations

The lesson follows an inquiry process in which students use a dataset to answer relevant questions about the turtle population. They consider how to analyse and display the data in order to effectively examine the impact of rising global temperatures on flatback turtle populations.

Online

Creating my own spreadsheet to convert binary to decimal

A spreadsheet can be used to do calculations quickly using formulas. How can we make a spreadsheet that converts a binary number to a decimal number? This lesson provides some guidance and Excel files for student and teacher use.

Text

Visualising climate change lesson

In this lesson, students explore different approaches to data representation, with the aim of engaging audiences with scientific data. They explore local temperature and rainfall datasets over time and represent trends in innovative ways. Students learn about different ways to visually represent climate change, looking ...

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

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

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

Online

Weather forecast from the stratosphere

This lesson sequence is designed to introduce students to data analysis using a spreadsheet such as MS Excel. The project is based on a real world problem and a real data set from a weather balloon launched in Australia earlier this year. The project consists of 5 lessons of variable length, each with a different focus. ...

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.

Text

Australian Curriculum: Digital Technologies Years 7–10 achievement standards and aligned content descriptions on a page

This PDF presents content descriptions and achievement standards for the Digital Technologies subject in the Australian Curriculum

Text

Booth Sweeney review: Systems literacy

This article explores how children’s innate understanding of systems can be developed through deliberate educational programs that support systems thinking. This can happen by encouraging students to identify patterns, consequences and feedback (loops) associated with social, environmental and economic problems; and by ...

Text

Volmert et al. review: STEM learning

This report examines the similarities and differences in the understandings about STEM education between experts and the general public in some American states. The authors contend that one of the most interesting findings is the role of Science: the general public equates STEM as Science, whereas the experts view all STEM ...

Text

Alyangula Area School

Alyangula Area School is a government school located in Alyangula on Groote Eylandt, in the Northern Territory on the Traditional Lands of the Anindilyakwa People. Martin Levins is one of ACARA’s curriculum officers who works directly with the school to support the implementation of the Australian Curriculum: Digital Technologies. ...

Text

Assessment: Australian Curriculum: Digital Technologies sample Data assessment tasks: years 7-8

Resource description 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 ...

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.

Text

Kelley & Knowles review: STEM integration

This article explores ways of building integrated STEM programs so that students have opportunities to make connections to crosscutting concepts and real-world problems. This is proposed through the lens of a framework.

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 2018

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