Search results

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

Expert webinar video: Jennifer Hemer: Tasmanian Smart Seafood Partnership

Jennifer Hemer from Natural Resource Management Tasmania explains what's happening in the seafood industry in her state and how digital technologies are used to make the industry more sustainable.

Text

Digital Technolodgies in Focus: external evaluation - findings on a page

This PDF is a one-page summary of the key findings of an external evalation of the Digital Technologies in Focus project in Australia’s most disadvantaged schools.

Video

Supporting implementation of Digital Technologies and the ICT Capability: part 1

This video explains ways in which the Digital Technologies curriculum and the Information and Communication Technology (ICT) General Capability can be implemented in schools. This video is the first in a series of three.

Text

Archived newsletters

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

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 – December 2018

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

Text

School stories

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

Text

Professional learning workshops

This webpage provides details of ten workshops that focus on understanding and implementing the Australian Curriculum: Digital Technologies. The workshops are provided for Digital Technologies in Focus project schools and, where possible, schools not involved in the project.

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.

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

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

Online

Turtles: impact of climate change on Flatback turtle populations

The lesson follows an inquiry process in which students use a dataset to answer relevant questions about the turtle population. They consider how to analyse and display the data in order to effectively examine the impact of rising global temperatures on flatback turtle populations.

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.

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

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

Literature reviews: what, why and how

This PowerPoint explains the benefits and techniques of literature reviews.

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.

Video

Expert webinar video: Andrew Harris - Lead Teacher, Agricultural Education, Hagley Farm Primary School

Andrew Harris from the Hagley Farm School in Tasmania shares ways in which the school is teaching Digital Technologies and its meaningful use in agriculture . For example, Andrew provides examples of ways students learn about digital systems and data collection.

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.