Search results

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

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.

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

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

Newsletter – July 2018

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

Text

Faith Lutheran College – Project proposal

This PDF outlines Faith Lutheran College's proposal to participate in the Digital Technologies in Focus project.

Text

Digital Technologies in the Australian Curriculum: sequence of content

This PDF provides a sequence of content for the Digital Technologies subject in the Australian Curriculum

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

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

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

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

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

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

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

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

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

St James Catholic College

St James Catholic College is a K–10 school located about 50 kilometres south of Hobart, Tasmania on the Traditional Lands of the Mellukurdee Peoples. Peter Lelong is the curriculum officer who works directly with the school to support the implementation of the Digital Technologies curriculum. Teachers at the school have ...

Text

Australian Curriculum: Digital Technologies Years 7–10 achievement standards and aligned content descriptions on a page

This PDF presents content descriptions and achievement standards for the Digital Technologies subject in the Australian Curriculum

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

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