Search results

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

ACARA sample assessment task: years 7-8

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

Text

Literature reviews: what, why and how

This PowerPoint explains the benefits and techniques of literature reviews.

Text

Kim review: Systems thinking

This article explores the types of systems in our world, their characteristics and how our behaviour can initiate and respond to changes in their performance. The author differentiates between systems thinking and a system and elaborates on those factors that contribute to systemic behaviour.

Text

Newsletter – July 2019

This newsletter from the Digital Technologies in Focus project includes information about an On Country staff development day with Leonara District High School, cybersecurity, the Australian Curriculum, and useful resources.

Text

Faith Lutheran College – Project proposal

This PDF outlines Faith Lutheran College's proposal to participate in the Digital Technologies in Focus project.

Text

Digital Technologies in the Australian Curriculum: overview and key links

This PDF gives an overview of the Australian Curriculum: Digital Technologies. It includes key points from the rationale and a step-by-step process for becoming familiar with the structure of the curriculum to assist planning. The document also provides links to key documents and sections of the Australian Curriculum as ...

Text

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

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

Text

Planning an action research project to facilitate implementation of Digital Technologies

This PowerPoint presentation includes ideas for planning and developing action research projects to facilitate implementation of digital technologies.

Text

Curzon & Bell et al. review: Computational thinking

This article explores the concept of computational thinking within computer science learning and in relation to other learning areas. The authors assert that because of its focus on analysis, computational thinking is not only suitable for computation but also the development of systems-based on computation.

Text

Newsletter – December 2018

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

Text

Faith Lutheran College – Timeline

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

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.

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

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

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

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

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

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