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

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

Newsletter – December 2019

  • TLF-IDA002305

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.

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

A spreadsheet's secret weapon

  • TLF-IDA003391

In this lesson sequence, students learn to use pivot tables which have been described as the most powerful tool within spreadsheets.

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
Online

Get connected

  • TLF-IDM021744

This is a unit for Year 7 from the Scope and sequence resources from the DT Hub. The topic of digital systems is organised into four key elements. Use this flow of activities to plan and assess students against the relevant achievement standards. Students develop an understanding of the properties of networked systems and ...

View detailsView resource
Online

Data: Controlled and secured

  • TLF-IDM021750

This is a unit for Year 10 from the Scope and sequence resources from the DT Hub. The topic of digital systems is organised into four key elements. Use this flow of activities to plan and assess students against the relevant achievement standards. Students explore how data can be secured through various methods such as ...

View detailsView resource
Online

Data driven innovation

  • TLF-IDM021751

This is a unit for Year 9 from the Scope and sequence resources from the DT Hub. The topic of data is organised into four key elements. Use this flow of activities to plan and assess students against the relevant achievement standards. Students examine ways data from individuals and connected technologies is used to inform ...

View detailsView resource
Online

Rubbish recording and reduction: Part 1

  • TLF-IDM021017

In this lesson sequence students survey and collect data concerning what is brought to school each day and subsequently becomes rubbish. They then use Excel to represent that data in a variety of different ways.

View detailsView resource
Online

Computer chatter 1: Networks and data transmission

  • TLF-IDM021030

In this lesson sequence students relate the concept of transportation systems to help them develop an understanding of the properties of networked systems and the underlying techniques used to transmit and validate data.

View detailsView resource
Online

Rubbish recording and reduction: Part 2

  • TLF-IDM021018

In this lesson sequence students use Excel to represent data in a variety of ways.

View detailsView resource
Online

Organise, visualise and analyse

  • TLF-IDM021752

This is a unit for Year 10 from the Scope and sequence resources from the DT Hub. The topic of data is organised into four key elements. Use this flow of activities to plan and assess students against the relevant achievement standards. Students use tools to organise data and make sense of complex data to identify patterns ...

View detailsView resource
Online

Computer chatter 2: Network performance

  • TLF-IDM021031

In this lesson sequence students build on and extend their knowledge of networks and discuss an inquiry question about Wi-Fi speeds and handling bulk of data transfer needs.

View detailsView resource
Interactive

Refugees welcome here

  • TLF-IDM021183

This resource embeds the use of online collaboration tools and 21st century learning skills in a student-centered hands-on project designed to welcome refugees into their community. The syllabus outcomes are aligned to NSW Stage 4 English, Geography or Visual Arts but this could be used with older or younger students by ...

View detailsView resource