Search results

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

Literature reviews: what, why and how

This PowerPoint explains the benefits and techniques of literature reviews.

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

Australian Curriculum: Digital Technologies Years 7–10 achievement standards and aligned content descriptions on a page

This PDF presents content descriptions and achievement standards for the Digital Technologies subject in the Australian Curriculum

Text

Asunda review: STEM integration

This article explores the benefits of an interdisciplinary STEM program in the quest for providing students with a holistic approach to problem-solving that reflects real-world practice. This is supported by a conceptual framework that comprises four constructs: systems thinking, situation learning theory, constructivism ...

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

Assessment: Australian Curriculum: Digital Technologies sample Data assessment tasks: years 7-8

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

Text

Technologies: sequence of achievement in the Australian Curriculum

This Word document provides sequences of achievement standards for the Technologies learning area in the Australian Curriculum

Text

ACARA sample assessment task: years 9-10

This resource provides strategies for assessing students' ability to interpret, process, analyse and represent data using spreadsheets, pivot tables, plotting data and scripting activities. A link to a data set from a koala hospital provides extensive data for students to use. The resource includes maps, graphs and charts, ...

Text

Books for exploring digital technologies concepts

This PDF provides a list of books that are useful for exploring key concepts and ideas in Digital Technologies.

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

St James Catholic College – Project proposal

This PDF outlines St James Catholic College's proposal to participate in the Digital Technologies in Focus project.

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

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

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

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

Australian Curriculum: Digital Technologies key concepts mapping - Years 9 and 10

This PDF uses colour coding to provide a line of sight between key concepts, content descriptions and achievement standards in the Digital Technologies subject in the Australian Curriculum.

Text

Good teaching practice with Digital Technologies

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

Text

Newsletter – December 2019

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.

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.