Close message Due to scheduled maintenance on Friday 19th April 2024 between 7:00PM and 9:00PM AEST, the Scootle website may face disruption in service. We apologise for any inconvenience caused.

Search results

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

Newsletter – July 2018

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

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.

Text

Miller & Boix-Mansilla review: Thinking across perspectives and disciplines

This article explores the challenges associated with using knowledge from different domains (and people) to work on a common problem, issue or puzzle. It acknowledges that the differences in how disciplines structure their knowledge raise challenges when working across disciplinary boundaries. The article identifies these ...

Text

Visualising climate change lesson

In this lesson, students explore different approaches to data representation, with the aim of engaging audiences with scientific data. They explore local temperature and rainfall datasets over time and represent trends in innovative ways. Students learn about different ways to visually represent climate change, looking ...

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.

Online

Hot or not?

This lesson sequence focuses on the incremental or Agile approach to development and encourages students to follow the evolution of a temperature conversion tool for a Food Technology teacher. It uses an Excel spreadsheet application as the prototyping tool.

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

Video

Expert webinar video: Dr Rebecca Vivian - The CSER Digital Technologies Education Program

Dr Rebecca Vivian provides an overview of the CSER Digital Technologies Education Project from The University of Adelaide. The project includes free professional learning, a digital equipment lending library and a range of resources designed to support teachers in the implementation of the Australian Curriculum: Digital ...

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

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

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.

Text

Australian Curriculum: Digital Technologies: years 9-10

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

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

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.