Search results

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

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

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

School stories

This webpage provides users with a menu of schools whose experiences with Digital Technologies are described in detail.

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

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

Video

Expert webinar video: Dr Rebecca Vivian - The CSER Digital Technologies Education Program

Dr Rebecca Vivian provides an overview of the CSER Digital Technologies Education Project from The University of Adelaide. The project includes free professional learning, a digital equipment lending library and a range of resources designed to support teachers in the implementation of the Australian Curriculum: Digital ...

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

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.

Text

Kelley & Knowles review: STEM integration

This article explores ways of building integrated STEM programs so that students have opportunities to make connections to crosscutting concepts and real-world problems. This is proposed through the lens of a framework.

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

Literature reviews: what, why and how

This PowerPoint explains the benefits and techniques of literature reviews.

Text

Newsletter – July 2019

This newsletter from the Digital Technologies in Focus project includes information about an On Country staff development day with Leonara District High School, cybersecurity, the Australian Curriculum, and useful resources.

Text

Faith Lutheran College – Timeline

This document presents the milestones in Faith Lutheran College's participation in the Digital Technologies in Focus project.

Text

St James Catholic College – Final report

This report provides details of St James Catholic College's participation in the Digital Technologies in Focus project, including a Research question, criteria for success, data collection, resources, challenges, milestones and next steps.

Text

Effective DTiF strategies

This PDF lists eight ways in which Digital Technologies in Focus (DTiF) supported the implementation of Digital Technologies in disadvantaged schools.

Text

Faith Lutheran College – PL ecosystem

This document illustrates the network of people and resources that make up Faith Lutheran College's Professional Learning ecosystem.