Teacher guide 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


Other details

  • Contributor
  • Name: Education Services Australia
  • Organization: Education Services Australia
  • Description: Data manager
  • Address: VIC, AUSTRALIA
  • URL: http://www.esa.edu.au/
  • Copyright Holder
  • 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/
  • Resource metadata contributed by
  • Name: Education Services Australia Ltd
  • Organisation: Education Services Australia Ltd
  • Address: AUSTRALIA
  • URL: www.esa.edu.au
Access profile
  • Unknown
Learning Resource Type
  • Online
  • Text
  • © Primary Industries Education Foundation 2016, except where indicated otherwise. This work is licensed under a Creative Commons Attribution 3.0 Australia license https://creativecommons.org/licenses/by/3.0/au/deed.en Under this license the material is available for free use and adaptation. Educators may use, adapt, communicate and re-publish material from the resource.