Search results

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

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

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

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

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

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

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

DTiF in conversation with Save the Bilby Fund – Background information on the Save the Bilby Fund

Kevin Bradley, CEO of Save the Bilby Fund, and Cassandra Arkinstall, a researcher and volunteer at Save the Bilby Fund, explain why the bilby is an important indicator of the health of an ecosystem, and how their decline impacts other wildlife. This video gives an overview of what the Save the Bilby Fund does as they work ...

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.

Text

Classroom ideas F-10: Aboriginal and Torres Strait Islander connections to Digital Technologies

This resource provides examples of ways Aboriginal and Torres Strait Islander Histories and Cultures can be integrated into Digital Technologies. Examples include 'classification and sorting data' and 'designing solutions'.

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.

Text

Books for exploring Digital Technologies concepts

This PDF provides a list of suggested books or similar that identify and discuss key concepts, key ideas and related ways of thinking about Digital Technologies.

Text

Board and card games for exploring Digital Technologies concepts

This PDF suggests board and card games that are useful for exploring Digital Technologies key concepts and key ideas.

Text

Australian Curriculum: Digital Technologies key concepts mapping: years 7-8

This PDF uses colour coding to provide a line of sight between key concepts, content descriptions and achievement standards in the Digital Technologies subject in the Australian Curriculum.

Video

Expert webinar video: Jennifer Hemer: Tasmanian Smart Seafood Partnership

Jennifer Hemer from Natural Resource Management Tasmania explains what's happening in the seafood industry in her state and how digital technologies are used to make the industry more sustainable.

Text

Good teaching practice with Digital Technologies

This PDF lists seven characteristics of good teaching practice in the Digital Technologies curriculum.

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 Classroom Exploring AI in the Classroom: Activity discussion

Digital Technologies in Focus curriculum officers discuss a lesson about Artificial Intelligence with Simon Collier and a student.