Search results

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

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

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

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

Organise, visualise and analyse

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

Online

Get connected

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

Online

Data: Controlled and secured

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

Online

Data driven innovation

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

Online

Rubbish recording and reduction: Part 1

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.

Online

Computer chatter 2: Network performance

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.

Online

Rubbish recording and reduction: Part 2

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

Online

Computer chatter 1: Networks and data transmission

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.

Interactive

Refugees welcome here

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