Search results

Listed under:  Mathematics  >  Statistics and probability  >  Data representation  >  Spreadsheets
Text

Supporting Digital Technologies curriculum in schools

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

Text

Newsletter – April 2020

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

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

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.

Text

Digital Technologies resource types and resource mapping template

This three-page document gives suggestions for selecting and organising Digital Technologies resources, including physical equipment, unplugged activities and online links. It includes a simple template that may be helpful in documenting these.

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

Easterbrook review: Systems thinking and Computational thinking

This article explores how the relationship between systems thinking and computational thinking would provide a conceptual basis for transformational change – change that considers the social and environmental impact of technology.

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

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

Faith Lutheran College – Project proposal

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

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.

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

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.

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

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

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.

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.