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

Rubbish recording and reduction: Part 1

In this lesson sequence students survey and collect data concerning what is brought to school each day and subsequently becomes rubbish. They then use Excel to represent that data in a variety of different ways.

Online

Rubbish recording and reduction: Part 2

In this lesson sequence students use Excel to represent data in a variety of ways.

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

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

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

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

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

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.

Text

Supporting Digital Technologies curriculum in schools

This PDF lists seven ways in which schools can support the Digital Technologies curriculum

Text

Digital Technologies teacher self-assessment matrix

These matrices allow teachers to self-assess their proficiency with Digital Technologies. They include a notes section for teachers to plan future professional learning.

Text

Newsletter – June 2021

This newsletter from the Digital Technologies in Focus project includes information about schools' projects, assessment tasks, artifical intelligence (AI), the Australian Curriculum, useful links, and resources.

Text

Newsletter – October 2019

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

Text

Newsletter – December 2018

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

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.

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

Faith Lutheran College – Timeline

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

Text

Newsletters

This webpage features newsletters from the Digital Technologies in Focus project. The newsletters include information about schools' projects, assessment tasks, the Australian Curriculum and resources.

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

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.