Search results

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

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

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.

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

Weather forecast from the stratosphere

This lesson sequence is designed to introduce students to data analysis using a spreadsheet such as MS Excel. The project is based on a real world problem and a real data set from a weather balloon launched in Australia earlier this year. The project consists of 5 lessons of variable length, each with a different focus. ...

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

MoneySmart: The house of needs and wants

This is a unit of work integrating aspects of the mathematics, English and science curriculums around planning a school breakfast. The unit was written for year 3 and is intended to take about 12 hours. It consists of 11 student activities supported by teacher notes on curriculum, pedagogy and assessment. Student activities ...

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

Computer chatter 2: Network performance

In this lesson sequence students build on and extend their knowledge of networks and discuss an inquiry question about Wi-Fi speeds and handling bulk of data transfer needs.

Online

Computer chatter 1: Networks and data transmission

In this lesson sequence students relate the concept of transportation systems to help them develop an understanding of the properties of networked systems and the underlying techniques used to transmit and validate data.

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

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

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

Determining the probability of a good day for sowing cotton

This activity is a series of three related tasks that support the use of spreadsheets (Excel), Venn diagrams and two-way tables to develop an understanding of conditional probability when used to determine the probability of a farmer being able to sow a cotton crop. The activity is, based on real historical soil and air ...

Online

MoneySmart: Advertising detectives

In ASIC's MoneySmart Teaching Advertising detectives students will become detectives in a bid to help solve an alarming case of advertisements influencing children to buy or want a product. Students will investigate the different gimmicks/tricks used in advertising, how they target children and how their effect can be minimised. ...

Online

Rubbish recording and reduction: Part 2

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

Online

TIMES Module 2: Statistics and Probability: data investigation and interpretation, year 4 - teacher guide

This is a 13-page guide for teachers. It continues the development of probability. An informal consideration of outcomes is undertaken.

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

Organise, visualise and analyse

This is a unit for Year 10 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 use tools to organise data and make sense of complex data to identify patterns ...

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