Search results

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

Who wants to be a millionaire?

This lesson sequence uses the well-known wheat/rice and chessboard problem as students use spreadsheets to simulate iteration and to solve problems.

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

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

COVID 19 Demystified course

At the end of this course, learners should be able to better understand the science and numbers behindCOVID-19 and the SARS-CoV-2 virus that causes it. They should be able to discuss the pandemic with confidence, giving substantiated viewpoints on matters such as public policy with a willingness to accept other viewpoints. ...

Text

Easterbrook review: Systems thinking and Computational thinking

This article explores how the relationship between systems thinking and computational thinking would provide a conceptual basis for transformational change – change that considers the social and environmental impact of technology.

Text

Effective DTiF strategies

This PDF lists eight ways in which Digital Technologies in Focus (DTiF) supported the implementation of Digital Technologies in disadvantaged schools.

Text

Newsletter – December 2020

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

Text

Newsletter – April 2019

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

Text

Alyangula Area School

Alyangula Area School is a government school located in Alyangula on Groote Eylandt, in the Northern Territory on the Traditional Lands of the Anindilyakwa People. Martin Levins is one of ACARA’s curriculum officers who works directly with the school to support the implementation of the Australian Curriculum: Digital Technologies. ...

Text

Kelley & Knowles review: STEM integration

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.

Text

Digital Technologies teacher self-assessment matrix

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

Text

Newsletter – October 2020

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

Text

Booth Sweeney review: Systems literacy

This article explores how children’s innate understanding of systems can be developed through deliberate educational programs that support systems thinking. This can happen by encouraging students to identify patterns, consequences and feedback (loops) associated with social, environmental and economic problems; and by ...

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 College – – Final report

This report provides details of Faith Lutheran 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.

Text

Supporting Digital Technologies curriculum in schools

This PDF lists seven ways in which schools can support the Digital Technologies curriculum

Text

Newsletter – October 2019

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

Text

Newsletter – December 2017

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