Search results

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

Faith Lutheran College – Timeline

This document presents the milestones in Faith Lutheran College's participation in the Digital Technologies in Focus project.

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.

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

Lockwood & Mooney review: Computational thinking

This article provides a literature review of how computational thinking fits into a school curriculum. The aim of the report is to provide educators with an overview of the current research in this field and the work that is being done in teaching computational thinking.

Video

DTiF Classroom Exploring AI in the Classroom: Teacher debrief

Digital Technologies in Focus curriculum officers discuss a lesson about Artificial Intelligence and curriculum links for teachers

Video

Expert webinar video: Dr Karen Joyce: Map my school

Dr Karen Joyce from STEM education provider She Maps discusses geospatial mapping and methods for teaching underpinning concepts to primary, secondary and tertiary students. Her presentation provides opportunities to think about how we might teach digital systems, data collection and interpretation to our students in context.

Video

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

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

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 – December 2017

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

Text

School stories

This webpage provides users with a menu of schools whose experiences with Digital Technologies are described in detail.

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.

Text

Visualising climate change lesson

In this lesson, students explore different approaches to data representation, with the aim of engaging audiences with scientific data. They explore local temperature and rainfall datasets over time and represent trends in innovative ways. Students learn about different ways to visually represent climate change, looking ...

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

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

Creating my own spreadsheet to convert binary to decimal

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.

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.

Text

Supporting the Implementation of Digital Technologies in Disadvantaged Schools: Case study of impact, outcomes and sustainability (2020)

This PDF is an extensive report on the success of the Digital Technologies in Focus (DTiF) project, with a focus on supporting the Implementation of Digital Technologies in disadvantaged schools. The evaluation gathered qualitative data to create rich case study accounts of six schools' engagement in the project and its ...

Text

Good teaching practice with Digital Technologies

This PDF lists seven characteristics of good teaching practice in the Digital Technologies curriculum.

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

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