Search results

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

Refugees welcome here

This resource embeds the use of online collaboration tools and 21st century learning skills in a student-centered hands-on project designed to welcome refugees into their community. The syllabus outcomes are aligned to NSW Stage 4 English, Geography or Visual Arts but this could be used with older or younger students by ...

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.

Interactive

How does your garden grow?

This Stage 2 resource grew from a conversation between young students questioning why they could still buy grapes if they were out of season. This wondering led to a discussion around when we grow certain fruit and vegetables. The original stimulus was extended to cover planting for the seasons and factors that influence ...

Online

Rubbish recording and reduction: Part 1

In this lesson sequence students survey and collect data concerning what is brought to school each day and subsequently becomes rubbish. They then use Excel to represent that data in a variety of different ways.

Online

Rubbish recording and reduction: Part 2

In this lesson sequence students use Excel to represent data in a variety of ways.

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

Data knowledge and skills tutorial: part 2 - authenticating data

This video demonstrates ways in which data can be authenticated in spreadsheets. It is the second 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

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

ICT Proficiency Teacher self-assessment matrix

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

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

Australian Curriculum: Digital Technologies: years 7-8

This PDF provides a line of sight from content descriptions to achievement standards in the Digital Technologies subject in the Australian Curriculum.

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

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.

Video

DTiF in conversation with Save the Bilby Fund – Background information on the Save the Bilby Fund

Kevin Bradley, CEO of Save the Bilby Fund, and Cassandra Arkinstall, a researcher and volunteer at Save the Bilby Fund, explain why the bilby is an important indicator of the health of an ecosystem, and how their decline impacts other wildlife. This video gives an overview of what the Save the Bilby Fund does as they work ...

Video

Expert webinar video: Martin Richards: AI, AR and VR F–10 and links to the Australian Curriculum: Digital Technologies

Martin Richards manages the Digital Technologies Hub. He discusses the relationship between artificial intelligence and the Australian Curriculum: Digital Technologies. Martin also shows some useful resources for teachers.

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

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.