In years 9 and 10, students collect, manage and analyse data using Excel, an industry standard spreadsheeting application. This guide has been created to support students in the development of their spreadsheeting skills.

Quick start Excel

Excel makes it easy to crunch numbers. With Excel, you can streamline data entry with AutoFill. Then, get chart recommendations based on your data, and create them with one click. Or, easily spot trends and patterns with data bars, colour coding, and icons.

• Develop techniques for acquiring, storing and validating quantitative and qualitative data from a range of sources, considering privacy and security requirements (ACTDIP036) 
• 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 algorithms represented diagrammatically and in structured English (ACTDIP040)