Search results

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

ICT Proficiency Teacher self-assessment matrix

These matrices allow teachers to self-assess their ICT Capability and Digital Technologies proficiency. They include a notes section for teachers to plan future professional learning.

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

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