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 2

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

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.

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 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: Nathan Alison, Digital Learning and Teaching Victoria (DLTV): Focus on systems thinking. How do we teach it well?

Nathan Alison from Digital Learning and Teaching Victoria (DLTV) explains what systems thinking is and how it is used in the context of Digital Technologies. Nathan explains what we need to consider when teaching digital systems, covering topics such as networks, hardware and software protocols, people and processes.

Text

Supporting Implementation of Digital Technologies: Progress report – Focus on curriculum and pedagogy and learning outcomes (2019)

This PDF is an extensive report on the success of the Digital Technologies in Focus (DTiF) project, with a focus on curriculum and pedagogy and learning outcomes. The evaluation gathered qualitative data to create rich case study accounts of six schools' engagement in the project and its impacts and outcomes.

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.

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 suggested books or similar that identify and discuss key concepts, key ideas and related ways of thinking about 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

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

Kelley & Knowles review: STEM integration

This article explores ways of building integrated STEM programs so that students have opportunities to make connections to crosscutting concepts and real-world problems. This is proposed through the lens of a framework.

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

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.

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

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.