Search results

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

Faith Lutheran School

Faith Lutheran College is a secondary co-educational independent school in Plainland, Queensland. It has more than 700 students and was established in 1999. Sarah Atkins is the curriculum officer who works with the school to support implementation of the Australian Curriculum: Digital Technologies. Teachers at the school ...

Video

Expert webinar video: Jennifer Hemer: Tasmanian Smart Seafood Partnership

Jennifer Hemer from Natural Resource Management Tasmania explains what's happening in the seafood industry in her state and how digital technologies are used to make the industry more sustainable.

Online

A spreadsheet's secret weapon

In this lesson sequence, students learn to use pivot tables which have been described as the most powerful tool within spreadsheets.

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

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

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

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

Australian Curriculum: Digital Technologies Years 9-10 Sample Assessment Task: Digital Systems - Activity Guide

The Years 9-10 assessment task focuses on digital systems (integrating Digital Technologies and Science). The digital systems activity guide provides a scaffold to teach about and assess students’ understanding of how digital systems can be used to monitor the school environment. Students learn how to create environmental ...

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

COVID 19 Demystified course

At the end of this course, learners should be able to better understand the science and numbers behindCOVID-19 and the SARS-CoV-2 virus that causes it. They should be able to discuss the pandemic with confidence, giving substantiated viewpoints on matters such as public policy with a willingness to accept other viewpoints. ...

Video

MathXplosion, Ep 33: On the grid

Explore graphs, grids and mapping with a focus on reading and writing location data using coordinate geometry. Grids and maps illustrate the concepts of parallel/perpendicular lines (axes or labelled number lines), ordered pairs and intersection points.

Video

Mixed Up Maths, Ep 8: Strawberry milkshake warrior princess

Super heroes have amazing powers. To avert disaster we need a super hero who has intelligence, strength and speed. Which super hero has the right super units of each super power? Compare the super hero bar graphs. Will it be Mega Muscle Man, Atomic Angel, Keyboard Kid or some other super hero? Watch the clip to find out?

Video

Graphing

Graphs can be used to illustrate the relationship between two variables. Watch this fun animation from NASA to learn the basics of graphing.

Online

Data driven innovation

This is a unit for Year 9 from the Scope and sequence resources from the DT Hub. The topic of data is organised into four key elements. Use this flow of activities to plan and assess students against the relevant achievement standards. Students examine ways data from individuals and connected technologies is used to inform ...

Online

reSolve: Statistics - Licorice Lines

This sequence of two lessons explores the concept of statistical variation. Students make licorice logs both by hand and by using a Play Doh machine. They record and compare the attributes of both types of licorice by plotting their findings and comparing the shapes of the two plots. Students are then challenged to produce ...

Online

reSolve: Authentic Problems: Bottle Flipping

This sequence of four lessons explores fractions and statistical reasoning through conducting a series of fair tests to answer the question 'What fraction of a bottle needs to be filled with water to be the best for bottle flipping?'. The lessons focus on building understanding of fractions and collecting, organising and ...

Online

reSolve: Measurement - Jump!

In this sequence of two lessons, students investigate how far they can jump and explore the jumping distance of a range of animals. Students first estimate the distance they can jump, then undertake an investigation by jumping using a range of techniques. Class data is recorded and displayed and students compare their jumping ...

Online

TIMES Module 22: Number and Algebra: consumer arithmetic - teacher guide

This is a 23-page guide for teachers, providing an introduction to the financial mathematics component of the number and algebra strands for years 9 and 10. A brief history of the concept of money concludes the module.

Online

MoneySmart: Sal's secret

This is a year 3 mathematics unit of work about saving and budgeting for a class party. The unit is intended to take about 10.5 hours of teaching and learning time spread over some months. It consists of nine student activities supported by teacher notes on curriculum, pedagogy and assessment. Student activities include ...