Search results

Listed under:  Mathematics  >  Statistics and probability  >  Data representation  >  Spreadsheets
Video

Expert webinar video: Martin Richards: AI, AR and VR F–10 and links to the Australian Curriculum: Digital Technologies

Martin Richards manages the Digital Technologies Hub. He discusses the relationship between artificial intelligence and the Australian Curriculum: Digital Technologies. Martin also shows some useful resources for teachers.

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

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

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

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.

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.

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

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

reSolve: Sport Stats

In this lesson, students examine sporting scores and explore the concept of the average of a set of scores. Students collect sporting scores from real and hypothetical games, use blocks to visualise an even distribution of scores across matches and then explore how to calculate the average of a set of scores. The lesson ...

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

Get connected

This is a unit for Year 7 from the Scope and sequence resources from the DT Hub. The topic of digital systems is organised into four key elements. Use this flow of activities to plan and assess students against the relevant achievement standards. Students develop an understanding of the properties of networked systems and ...

Online

Data: Controlled and secured

This is a unit for Year 10 from the Scope and sequence resources from the DT Hub. The topic of digital systems is organised into four key elements. Use this flow of activities to plan and assess students against the relevant achievement standards. Students explore how data can be secured through various methods such as ...

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

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

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.

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

Rubbish recording and reduction: Part 2

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

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

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