Search results

Listed under:  Mathematics  >  Statistics and probability  >  Data representation  >  Spreadsheets
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

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

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

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.

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

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

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

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

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

Video

DTiF Classroom Exploring AI in the Classroom: Activity

Simon Collier, Digital Technologies in Focus Curriculum Officer, takes viewers though a lesson from the Digital Technologies Hub exploring how machine learning can be used to organise photographs.

Video

DTiF in conversation with Kevin Bradley and Cassandra Arkinstall from Save the Bilby Fund – Using Digital Technologies to help save bilbies

Kevin Bradley, CEO of Save the Bilby Fund, and Cassandra Arkinstall, a researcher and volunteer at Save the Bilby Fund explain how important digital technologies are in the campaign to save the bilby from extinction. The video explains how digital systems are used to collect and visualise data and help eradicate threats ...

Text

Faith Lutheran College – Project proposal

This PDF outlines Faith Lutheran College's proposal to participate in the Digital Technologies in Focus project.

Video

Expert webinar video: Professor Tim Bell – Computational thinking

In this video, Professor Tim Bell discusses helpful ways of understanding and teaching computational thinking, a key idea of the Australian Curriculum: Technologies.

Video

Expert webinar video: Andrew Harris - Lead Teacher, Agricultural Education, Hagley Farm Primary School

Andrew Harris from the Hagley Farm School in Tasmania shares ways in which the school is teaching Digital Technologies and its meaningful use in agriculture . For example, Andrew provides examples of ways students learn about digital systems and data collection.

Video

DTiF Classroom Exploring AI in the Classroom: Teacher debrief

Digital Technologies in Focus curriculum officers discuss a lesson about Artificial Intelligence and curriculum links for teachers

Video

Expert webinar video: Dr Karen Joyce: Map my school

Dr Karen Joyce from STEM education provider She Maps discusses geospatial mapping and methods for teaching underpinning concepts to primary, secondary and tertiary students. Her presentation provides opportunities to think about how we might teach digital systems, data collection and interpretation to our students in context.

Video

Expert webinar video: Nathan Alison, Digital Learning and Teaching Victoria (DLTV): Focus on systems thinking. How do we teach it well?

Nathan Alison from Digital Learning and Teaching Victoria (DLTV) explains what systems thinking is and how it is used in the context of Digital Technologies. Nathan explains what we need to consider when teaching digital systems, covering topics such as networks, hardware and software protocols, people and processes.

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.