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

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

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.

Video

DTiF Classroom Exploring AI in the Classroom: Activity

Simon Collier, Digital Technologies in Focus Curriculum Officer, takes viewers though a lesson from the Digital Technologies Hub exploring how machine learning can be used to organise photographs.

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 in conversation with Kevin Bradley and Cassandra Arkinstall from Save the Bilby Fund – Using Digital Technologies to help save bilbies

Kevin Bradley, CEO of Save the Bilby Fund, and Cassandra Arkinstall, a researcher and volunteer at Save the Bilby Fund explain how important digital technologies are in the campaign to save the bilby from extinction. The video explains how digital systems are used to collect and visualise data and help eradicate threats ...

Text

Digital Technolodgies in Focus: external evaluation - findings on a page

This PDF is a one-page summary of the key findings of an external evalation of the Digital Technologies in Focus project in Australia’s most disadvantaged schools.

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 – 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 – April 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 – Project proposal

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

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

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

Literature reviews: what, why and how

This PowerPoint explains the benefits and techniques of literature reviews.

Video

Expert webinar video: Professor Tim Bell – Computational thinking

In this video, Professor Tim Bell discusses helpful ways of understanding and teaching computational thinking, a key idea of the Australian Curriculum: Technologies.

Text

Classroom ideas F-10: Aboriginal and Torres Strait Islander connections to Digital Technologies

This resource provides examples of ways Aboriginal and Torres Strait Islander Histories and Cultures can be integrated into Digital Technologies. Examples include 'classification and sorting data' and 'designing solutions'.