Computing Unit 2
There are no prerequisites for this unit.
Students focus on data and how the application of computational and design skills and information systems knowledge support the creation of solutions that automate the processing of data.
Areas of Study
Students focus on using a programming or scripting language that can support object-oriented programming to create working software modules.
Students develop skills in interpreting teacher-provided solution requirements and in designing working modules. They apply methods and techniques for completing a series of small discrete tasks or working modules that use features of a programming or scripting language. Students also apply computational and design skills when preparing design specifications and transforming them into working modules.
Data Analysis and Visualisation
Students learn to use software tools to access, select and manipulate authentic data from large data repositories, and to present the key aspects of the data in an appropriate visual form. Once the data has been isolated and checked for its integrity, students create data visualisations that assist in reducing the complexity of data by using designs that illustrate patterns, connections and structure. Appropriate visualisation forms include graphs, charts, spatial relationships, maps, histograms and network diagrams (nodes and edges).
Software: Spreadsheet software to manipulate data and data visualisation software such as online Tableau.
Students use database software to develop and apply knowledge and skills in determining data types required to solve specific problems, and in organising and storing data. They construct query searches and sorts, and apply design principles that contribute to effective and efficient data collection and data manipulation, and the construction of input forms and reports. Students devise a need or opportunity for a solution and collect relevant data for manipulation by database management software.
Software: DBMS for both PC and Mac such as LibreOffice Database Management Software.
|Design working modules in response to solution requirements, and use a programming or scripting language to develop the modules.
||Folio of working software modules.
|Apply the problem-solving methodology and use appropriate software tools to extract relevant data and create a data visualisation that meets a specified user’s needs.
||Extract relevant data from data repository and create a data visualisation to meet a need.
|Apply problem-solving methodology to create a solution using database management software, and explain the personal benefits and risks of interacting with a database.
||Create a solution using database management software, and explain the personal benefits and risks of interacting with a database.
Overall Final Assessment
End of Semester Examination – 1.5 hours.
Information can be obtained from the Victorian Curriculum and Assessment Authority, Victoria, Australia: www.vcaa.vic.edu.au