Applied Computing (Unit 1/2)
Unit 1: Applied Computing
Areas of Study:
Data analysis
Programming
Topics Studied:
The stages of the problem-solving methodology
Focus on how data can be used within software tools such as databases and spreadsheets to create data visualisations, and the use of an object-oriented programming (OOP) language to develop a working software solution
As an introduction to data analytics, students respond to teacher-provided solution requirements, designs and data to develop data visualisations
Develop a solution that includes a database, spreadsheet(s) and data visualisations
Respond to solution requirements to design and develop a working software solution using an OOP language
Develop techniques for debugging and testing their software solution to ensure that it works as intended.
Unit 2: Applied Computing
Areas of Study:
Innovative solutions
Cyber security
Topics Studied:
Focus on developing an innovative solution to a problem, need or opportunity identified, and develop an understanding of network environments, cyber security risks, threats to networks and strategies to reduce the risks to data and information
Work collaboratively and select a topic of interest involving an emerging trend for further study to create an innovative solution
The innovative solution can be presented as a proof of concept, a prototype or a product
Engage in all areas of the problem-solving methodology while developing this solution
As an introduction to cyber security, investigate networks and the threats, vulnerabilities and risks to data and information
Propose and justify strategies to protect the security of data and information within a network.
Assessment (Covers both Units 1 & 2):
A folio of exercises to demonstrate the learning of database, spreadsheet and data visualisation software tools
A solution including the use of database, spreadsheet and/or data visualisation software tools in response to teacher-provided solution requirements and designs
A personal portfolio to showcase the development of databases, spreadsheets and data visualisations
A folio of exercises to demonstrate the learning of an object-oriented programming language
A software solution that includes the designs, solution and a testing table in response to teacher provided solution requirements
The creation and maintenance of code repositories to track the progression of students’ learning, using platforms such as GitHub
A software solution developed in response to a teacher-provided problem-solving challenge, presented as a hackathon
An innovative solution that includes an analysis, designs, the development of a proof of concept/prototype/product and an evaluation
A presentation (oral, multimedia, visual) of an innovative solution
A written report that documents the development of an innovative solution
An annotated visual report that documents the development of an innovative solution
A teacher-provided case study with structured questions that investigates a cyber security incident and how it could be prevented in the future
A teacher-provided case study with structured questions that investigates a network, its vulnerabilities and how these could be mitigated.
Cost: $ (resources and materials)
---------------------------------
Contact Teacher: Ms Teresa La
Data Analytics (Units 3/4)
Unit 3: Data Analytics
Areas of Study:
Data analytics
Data analytics: analysis and design
Topics Studied:
Apply the problem-solving methodology to analyse data using software tools such as database, spreadsheet and data visualisation software to create data visualisations
Develop an understanding of the analysis, design and development stages of the problem-solving methodology
Respond to teacher-provided solution requirements and designs to develop data visualisations
Apply specific functions of database and spreadsheet software tools to manipulate, cleanse and analyse data
Use a data visualisation software tool to develop data visualisations that present their findings
Propose a research question, prepare a project plan, collect, analyse and prepare data, and design infographics and/or dynamic data visualisations.
Unit 4: Data Analytics
Areas of Study:
Data analytics: development and evaluation
Cyber security: data security
Topics Studied:
Focus on determining the findings of a research question by developing infographics and/or dynamic data visualisations based on large complex data sets, consider data breaches and investigate the security strategies used by an organisation to protect data and information from cyber security threats
Apply the problem-solving stages of development and evaluation to develop their preferred designs into infographics and/or dynamic data visualisations
Evaluate the infographics and/or dynamic data visualisations and assess the project plan
Analyse a case study that investigates the impact of a data breach on an organisation
Examine the cyber security threats to data and information, evaluate security strategies and recommend improved strategies for protecting data and information.
Assessment (Covers both Units 3 & 4):
Extract and reference data from large repositories into a database
Query data using databases and SQL
Use spreadsheet functions to manipulate data
Statistically analyse data in spreadsheets
Develop data visualisations
Structured questions
A report in written format
A report in multimedia format
The case study scenario needs to enable:
An analysis of the breach
An evaluation of the threats
Recommendations to improve security strategies.
Cost: $ (resources and materials)
---------------------------------
Contact Teacher: Ms Teresa La