Search results

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

Australian Curriculum: Digital Technologies Years 7-8 Sample Assessment Task: Digital Systems - Student activity guide

The Years 7-8 assessment task focuses on digital systems (integrating Digital Technologies and Science). The digital systems assessment task activity guide can teach and assess students’ understanding of how digital systems can be used to monitor the classroom learning environment. Students will learn how to create environmental ...

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

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

Text

ACARA sample assessment task: years 9-10

This resource provides strategies for assessing students' ability to interpret, process, analyse and represent data using spreadsheets, pivot tables, plotting data and scripting activities. A link to a data set from a koala hospital provides extensive data for students to use. The resource includes maps, graphs and charts, ...

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.

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

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.

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

Text

Technologies: sequence of achievement in the Australian Curriculum

This Word document provides sequences of achievement standards for the Technologies learning area in the Australian Curriculum

Text

Digital Technologies resource types and resource mapping template

This three-page document gives suggestions for selecting and organising Digital Technologies resources, including physical equipment, unplugged activities and online links. It includes a simple template that may be helpful in documenting these.

Text

Books for exploring digital technologies concepts

This PDF provides a list of books that are useful for exploring key concepts and ideas in Digital Technologies.

Video

Data knowledge and skills tutorial: part 1 - gathering data

This video demonstrates ways in which data can be manipulated in spreadsheets. It is the first in a series of four.

Video

Data knowledge and skills tutorial: part 3 - structuring data in a spreadsheet

This video demonstrates ways in which data can be structured in spreadsheets. It is the third in a series of four.

Text

Australian Curriculum: Digital Technologies key concepts mapping - Years 9 and 10

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.

Text

Planning an action research project to facilitate implementation of Digital Technologies

This document includes ideas for planning and developing action research projects to facilitate implementation of digital technologies.

Text

Lockwood & Mooney review: Computational thinking

This article provides a literature review of how computational thinking fits into a school curriculum. The aim of the report is to provide educators with an overview of the current research in this field and the work that is being done in teaching computational thinking.

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

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.