Close message Due to maintenance between 17:00 to 19:00 on Thursday 30th May 2024, Scootle website may face disruption in service. We apologise for any inconvenience caused.

Search results

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

Video

Alyangula Area School – Progress report 2

This video is a summary of a progress report into the implementation of Digital Technologies in the Alyangula Area School.

Text

St James Catholic College – Final report

This report provides details of St James Catholic College's participation in the Digital Technologies in Focus project, including a Research question, criteria for success, data collection, resources, challenges, milestones and next steps.

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

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

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

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

Text

Data knowledge and skills tutorial: part 4 - analysing and visualising data

This video demonstrates ways in which data can be analysed and visualised. It is the final in a series of four.

Video

Data knowledge and skills tutorial: part 1 - gathering data

This video demonstrates ways in which data can be manipulated in spreadsheets. It is the first in a series of four.

Text

ICT Proficiency Teacher self-assessment matrix

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

Video

DTiF in conversation with Kevin Bradley and Cassandra Arkinstall from Save the Bilby Fund – Using Digital Technologies to help save bilbies

Kevin Bradley, CEO of Save the Bilby Fund, and Cassandra Arkinstall, a researcher and volunteer at Save the Bilby Fund explain how important digital technologies are in the campaign to save the bilby from extinction. The video explains how digital systems are used to collect and visualise data and help eradicate threats ...

Video

Activities that promote Digital Technologies concepts and incorporate Numeracy: part 1: Introduction and overview: accessing the Australian Curriculum National Numeracy Learning progression

This video provides an introduction to the ways in which Digital Technologies can be used to develop students' learning in the Numeracy Learning Progression.

Text

Volmert et al. review: STEM learning

This report examines the similarities and differences in the understandings about STEM education between experts and the general public in some American states. The authors contend that one of the most interesting findings is the role of Science: the general public equates STEM as Science, whereas the experts view all STEM ...

Text

Faith Lutheran School

Faith Lutheran College is a secondary co-educational independent school in Plainland, Queensland. It has more than 700 students and was established in 1999. Sarah Atkins is the curriculum officer who works with the school to support implementation of the Australian Curriculum: Digital Technologies. Teachers at the school ...

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

Newsletter – December 2019

This newsletter from the Digital Technologies in Focus project includes information about schools' projects, information for parents and teachers, the Australian Curriculum, and useful 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 ...