Search results

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

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

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.

Video

DTiF in conversation with Save the Bilby Fund – Background information on the Save the Bilby Fund

Kevin Bradley, CEO of Save the Bilby Fund, and Cassandra Arkinstall, a researcher and volunteer at Save the Bilby Fund, explain why the bilby is an important indicator of the health of an ecosystem, and how their decline impacts other wildlife. This video gives an overview of what the Save the Bilby Fund does as they work ...

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

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: years 7-8

This PDF provides a line of sight from content descriptions to achievement standards in the Digital Technologies subject in the Australian Curriculum.

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

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

Australian Curriculum: Digital Technologies: years 9-10

This PDF provides a line of sight from content descriptions to achievement standards in the Digital Technologies subject in the Australian Curriculum.

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

Literature reviews: what, why and how

This PowerPoint explains the benefits and techniques of literature reviews.

Video

Expert webinar video: Nathan Alison, Digital Learning and Teaching Victoria (DLTV): Focus on systems thinking. How do we teach it well?

Nathan Alison from Digital Learning and Teaching Victoria (DLTV) explains what systems thinking is and how it is used in the context of Digital Technologies. Nathan explains what we need to consider when teaching digital systems, covering topics such as networks, hardware and software protocols, people and processes.

Text

Supporting Implementation of Digital Technologies: Progress report – Focus on curriculum and pedagogy and learning outcomes (2019)

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

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.