

Year 12 Applied Computing: Data Analytics Units 3 and 4
Overview
In Unit 3 you will access, select and extract authentic data from large repositories. You will manipulate the data to present findings as data visualisations in response to solution requirements and designs. You will then develop software solutions using database, spreadsheet and data visualisation software tools to solve problems in the development stages of manipulation, validation and testing.
The software solutions involve importing data from files to a database to identify patterns and relationships. You will then import data into a spreadsheet for further refinement before presenting your findings as data visualisations.
In Unit 4 you will propose a research question, formulate a project plan, and collect and analyse data. You will then generate alternative design ideas and represent the preferred design for creating infographics or dynamic data visualisations.
Who is it for?
If you are interested in database development and design, and data visualisations, this subject is for you.
What do you do?
You will create a database and use software to create data visualisations from the database information. You will also study Cyber security.
What skills do you need?
While there are no specified criteria to enrol in this subject, you will need to have good mathematics skills, and you should be able to use and apply logic, as well as being self-motivated and resourceful.
Database software, such as Microsoft ACCESS and Excel, are helpful.
What skills do you develop?
You will develop your skills to identify, select and extract relevant data from large repositories and design data visualisations.
Requirements
You must have access to the Internet in order to access this course. All weekly work will be viewed through VSV online and then submitted online.
A computer device with Windows 10 or macOS 10.14 or greater is required. A user account with administrator privileges is needed to install software. Note: iOS, Android, and Chromebook devices are not suitable for the variety of applications employed in this course.
The following textbooks are recommended:
VCE Data Analytics Units 3 and 4, Seventh edition, Nelson Cengage, (2019)
Please note that this is a new course in 2020 and previous texts may not cover the new course
Things to think about
There are no prerequisites but an interest in Information Technology and databases is helpful.
Things you can do now
You can start by getting an understanding of Microsoft Access and Excel. Search for any Beginner Tutorial on Google.
Go to the VCAA website for more information about this subject.