Search results

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

St James Catholic College – PL ecosystem

This document illustrates the network of people and resources that make up St James Catholic College's Professional Learning ecosystem.

Online

Turtles: impact of climate change on Flatback turtle populations

The lesson follows an inquiry process in which students use a dataset to answer relevant questions about the turtle population. They consider how to analyse and display the data in order to effectively examine the impact of rising global temperatures on flatback turtle populations.

Text

Australian Curriculum: Digital Technologies key concepts mapping: years 7-8

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.

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.

Video

Supporting implementation of Digital Technologies and the ICT Capability: part 2

This video explains ways in which the Digital Technologies curriculum and the Information and Communication Technology (ICT) General Capability can be implemented in schools. This video is the second in a series of three.

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.

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

Digital Technologies in the Australian Curriculum: sequence of content

This PDF provides a sequence of content for the Digital Technologies subject in the Australian Curriculum

Text

Board and card games for exploring Digital Technologies concepts

This PDF suggests board and card games that are useful for exploring Digital Technologies key concepts and key ideas.

Video

Data knowledge and skills tutorial: part 3 - structuring data in a spreadsheet

This video demonstrates ways in which data can be structured in spreadsheets. It is the third in a series of four.

Text

Planning an action research project to facilitate implementation of Digital Technologies

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

Text

Literature reviews: what, why and how

This PowerPoint explains the benefits and techniques of literature reviews.

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: Andrew Harris - Lead Teacher, Agricultural Education, Hagley Farm Primary School

Andrew Harris from the Hagley Farm School in Tasmania shares ways in which the school is teaching Digital Technologies and its meaningful use in agriculture . For example, Andrew provides examples of ways students learn about digital systems and data collection.

Text

Good teaching practice with Digital Technologies

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

Text

Newsletters

This webpage features newsletters from the Digital Technologies in Focus project. The newsletters include information about schools' projects, assessment tasks, the Australian Curriculum and resources.

Text

Newsletter – April 2020

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