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

Refine by resource type

Refine by year level


Refine by learning area


Refine by topic

Main topic Specific topic Related topic
  • No suggestions

Your search returned 130 results

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

Newsletter – April 2019

  • TLF-IDA002308

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

View detailsView resource
Text

ACARA sample assessment task: years 9-10

  • TLF-IDA002172

This resource provides strategies for assessing students' ability to interpret, process, analyse and represent data using spreadsheets, pivot tables, plotting data and scripting activities. A link to a data set from a koala hospital provides extensive data for students to use. The resource includes maps, graphs and charts, ...

View detailsView resource
Online

Seeing the wood for the trees

  • TLF-IDA003375

In this lesson sequence students summarise data using advanced filtering and grouping techniques, for example pivot tables in spreadsheets and aggregation functions in databases.

View detailsView resource
Online

Hot or not?

  • TLF-IDA003379

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.

View detailsView resource
Online

Creating my own spreadsheet to convert binary to decimal

  • TLF-IDA003456

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.

View detailsView resource
Online

Spreadsheets come alive

  • TLF-IDA003394

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

View detailsView resource
Online

Weather forecast from the stratosphere

  • TLF-IDA003396

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

View detailsView resource
Text

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

  • TLF-IDA002211

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

View detailsView resource
Text

ACARA sample assessment task: years 7-8

  • TLF-IDA002171

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 of the places in which ...

View detailsView resource
Text

Digital Technologies in the Australian Curriculum: sequence of content

  • TLF-IDA002195

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

View detailsView resource
Text

A–Z Digital Technologies vocabulary F–6

  • TLF-IDA002201

This PDF assists teachers in thinking about when and how to introduce Digital Technologies discipline-specific vocabulary.

View detailsView resource
Text

ICT Proficiency Teacher self-assessment matrix

  • TLF-IDA002225

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.

View detailsView resource
Text

Kelley & Knowles review: STEM integration

  • TLF-IDA002246

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.

View detailsView resource
Video

DTiF Classroom Exploring AI in the Classroom: Activity discussion

  • TLF-IDA002266

Digital Technologies in Focus curriculum officers discuss a lesson about Artificial Intelligence with Simon Collier and a student.

View detailsView resource
Video

Expert webinar video: Dr Rebecca Vivian - The CSER Digital Technologies Education Program

  • TLF-IDA002281

Dr Rebecca Vivian provides an overview of the CSER Digital Technologies Education Project from The University of Adelaide. The project includes free professional learning, a digital equipment lending library and a range of resources designed to support teachers in the implementation of the Australian Curriculum: Digital ...

View detailsView resource
Video

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

  • TLF-IDA002295

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 second in a series of three.

View detailsView resource
Text

Newsletter – October 2020

  • TLF-IDA002302

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

View detailsView resource
Text

Newsletter – December 2018

  • TLF-IDA002309

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

View detailsView resource
Video

Alyangula Area School – Progress report 2

  • TLF-IDA002317

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

View detailsView resource
Text

St James Catholic College – Timeline

  • TLF-IDA002345

This document presents the milestones in St James Catholic College's participation in the Digital Technologies in Focus project.

View detailsView resource