Search results

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

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.

Text

Data knowledge and skills tutorial: part 4 - analysing and visualising data

This video demonstrates ways in which data can be analysed and visualised. It is the final in a series of four.

Text

Data knowledge and skills tutorial: part 2 - authenticating data

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

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

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

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

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.

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

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.

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

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

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.

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

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.

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

Australian Curriculum: Digital Technologies: years 9-10

This PDF provides a line of sight from content descriptions to achievement standards in the Digital Technologies subject in the Australian Curriculum.

Text

Australian Curriculum: Digital Technologies Years 9-10 Sample Assessment Task: Digital Systems - Activity Guide

The Years 9-10 assessment task focuses on digital systems (integrating Digital Technologies and Science). The digital systems activity guide provides a scaffold to teach about and assess students’ understanding of how digital systems can be used to monitor the school environment. Students learn how to create environmental ...

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.