Close message Scootle has stopped supporting resources that use the Adobe Flash plug-in from 18 Dec 2020. Learning paths that include these resources will have alerts to notify teachers and students that one or more of the resources will be unavailable. Click here for more info.

# Determining the probability of a good day for sowing cotton

TLF ID M021282

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 temperature data. It provides a detailed teaching feature explaining the use of spreadsheet commands for conditionally formatting data. The resource provides student activities, teacher notes and solutions.

#### Educational details

Educational value
• This teacher resource is highly valuable for a number of content description in the Year 10 strand of Statistics and Probability. It presents a real life context that might confront a cotton farmer and supports students to maniplate the actual data in order to calculate reasonable probabilities.
• This resource is valuable for students to be introduced to a practical application of a number of data representations, classifying variables as either dependent or independent and conditional probability. The first task in the resource introduces how to manipulate data in spreadsheets. The conditional formatting function in Excel is used to support students to identify good days for sowing and spreadsheet formulae are used to count these days. This task also uses scatter graphs) to determine linear trends in data. The second task investigates Venn diagrams and two-way tables and notation used to describe sets of data. The third task requires students to use relative frequency to determine experimental probabilities applying the concept of dependence and independence by using Venn diagrams, two-way tables and tree diagrams.
• It also provides a content for students to build skills in the Digital Technologies curriculum as it relates to analysing and visualise data to model real life outcomes and would provide opportunities to extend findings by creating online data models.
• The resource has strong links to the Food and Fibre elements of the Design and Technologies curriculum and would provide a very valuable resource for students studying agriculture specialisations in Years 10, 11 and 12.
• The resource is also very valuable for the Information and Communication Technology (ICT) capability particularly in relation to investigating with ICT to select and use advanced tools and techniques to generate precise data and information.
Year level

10

Learning area
• Mathematics

#### Other details

Contributors
• Contributor
• Name: Education Services Australia
• Organization: Education Services Australia
• Description: Data manager
• URL: http://www.esa.edu.au/
• Name: Primary Industries Education Foundation
• Organization: Primary Industries Education Foundation
• URL: http://www.primaryindustrieseducation.com.au/
• Publisher
• Name: Primary Industries Education Foundation
• Organization: Primary Industries Education Foundation
• Description: Publisher
• URL: http://www.primaryindustrieseducation.com.au/