IT knowledge and skills covered in this module

  • Reviewing spreadsheet use
  • Working with multiple worksheets
  • Working with lists and sorting
  • Using the subtotal
  • Filtering and function types
  • Pivot tables

Suggested further uses across the curriculum

  • Mathematics (for a range of applications across the maths curriculum).
  • Economics and Business (for organising data). Gather relevant and reliable data and information from a range of digital, online and print sources (ACHES056).
  • Civics and Citizenship (organising information). Identify, gather and sort information and ideas from a range of sources and reference as appropriate (ACHCS096).

Alignment with the Australian Curriculum

ICT Capability elements covered
  • Investigating with ICT
    • define and plan information searches
  • Creating with ICT
  • Communicating with ICT
    • collaborate, share and exchange
    • understand computer mediated communications
  • Managing and operating ICT
Other general capabilities covered
  • Literacy
  • Numeracy
  • Critical and creative thinking
  • Personal and social capability
Digital Technologies curriculum content in this module
Processes and production skills
  • Analyse and visualise data to create information and address complex problems, and model processes, entities and their relationships using structured data (ACTDIP037)
  • Define and decompose real-world problems precisely, taking into account functional and non-functional requirements and including interviewing stakeholders to identify needs (ACTDIP038)
  • Design the user experience of a digital system by evaluating alternative designs against criteria including functionality, accessibility, usability, and aesthetics (ACTDIP039)
  • Evaluate critically how student solutions and existing information systems and policies, take account of future risks and sustainability and provide opportunities for innovation and enterprise (ACTDIP042)

© Australian Curriculum, Assessment and Reporting Authority (ACARA)