Search results

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

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

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

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

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

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

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

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.

Text

Planning an action research project to facilitate implementation of Digital Technologies

This PowerPoint presentation includes ideas for planning and developing action research projects to facilitate implementation of 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

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

Asunda review: STEM integration

This article explores the benefits of an interdisciplinary STEM program in the quest for providing students with a holistic approach to problem-solving that reflects real-world practice. This is supported by a conceptual framework that comprises four constructs: systems thinking, situation learning theory, constructivism ...

Text

Supporting the Implementation of Digital Technologies in Disadvantaged Schools: Case study of impact, outcomes and sustainability (2020)

This PDF is an extensive report on the success of the Digital Technologies in Focus (DTiF) project, with a focus on supporting the Implementation of Digital Technologies in disadvantaged schools. The evaluation gathered qualitative data to create rich case study accounts of six schools' engagement in the project and its ...

Text

Newsletter – October 2018

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

Text

St James Catholic College – Project proposal

This PDF outlines St James Catholic College's proposal to participate in the Digital Technologies in Focus project.

Text

St James Catholic College – PL ecosystem

This document illustrates the network of people and resources that make up St James Catholic College's Professional Learning ecosystem.

Text

St James Catholic College – Timeline

This document presents the milestones in St James Catholic College's participation in the Digital Technologies in Focus project.

Text

Newsletter – April 2019

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

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

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