Search results

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

Alyangula Area School – Progress report 2

This video is a summary of a progress report into the implementation of Digital Technologies in the Alyangula Area School.

Text

St James Catholic College

St James Catholic College is a K–10 school located about 50 kilometres south of Hobart, Tasmania on the Traditional Lands of the Mellukurdee Peoples. Peter Lelong is the curriculum officer who works directly with the school to support the implementation of the Digital Technologies curriculum. Teachers at the school have ...

Text

St James Catholic College – Final report

This report provides details of St James Catholic College's participation in the Digital Technologies in Focus project, including a Research question, criteria for success, data collection, resources, challenges, milestones and next steps.

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

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

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

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

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.

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?

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

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

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

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

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

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

The First Fleet - dataset collections

The dataset provides information about 780 of the convicts transported to Australia on the First Fleet ships 'Alexander', 'Charlotte', 'Lady Penrhyn', 'Friendship', 'Prince of Wales' and 'Scarborough' in 1788. The dataset includes information on items such as the convict's name, occupation, crime, date of trial and term ...