VCE Data Analytics - U3O2 - Analysis and Design

1 Data and information 2 Primary and secondary data sources 3 What a research question is 4 Research question feature: clarity 5 Research question feature: measurability of data requirements 6 Research question feature: feasibility 7 Research question feature: originality 8 Refining a weak research question 9 Gantt Charts and Project Management 10 Breaking a project into tasks 11 Gantt chart: sequencing tasks 12 Gantt chart: time allocation 13 Gantt chart: task dependencies 14 Milestones and deadlines 15 Gantt chart: critical path 16 Constructing a Gantt chart for a project 17 Tracking progress with a project log 18 Monitoring progress on a Gantt chart 19 Functional requirements 20 Solution Non-functional Requirements 21 Writing measurable non-functional requirements 22 Data requirements for a research question 23 Constraints on a solution 24 Scope of a solution 25 Listing requirements and constraints for a problem 26 Collecting data with a survey 27 Writing unbiased survey questions 28 Interviews to gather perspectives on a topical issue 29 Writing good interview questions 30 Observing users 31 Recording observations on a structured observation sheet 32 Searching with keywords and search operators 33 What is RADCAB? 34 Open data portals and data licences 35 Searching and filtering a data repository 36 What is a relational database? 37 SQL SELECT and FROM 38 SQL WHERE conditions 39 SQL ORDER BY 40 SQL aggregate functions: COUNT, SUM, AVG, MIN, MAX 41 SQL GROUP BY 42 Foreign key and table relationships 43 SQL JOIN across two tables 44 Text data: character and string 45 Numeric data: integer 46 Numeric data: floating point 47 Date/time data 48 Boolean data 49 Choosing a data type for a value 50 Characteristic of data: structure 51 Organising data in a table with headings 52 One-dimensional arrays 53 Records: grouping fields of different data types 54 Two-dimensional arrays 55 Choosing a data structure 56 Delimited (CSV) files: structure 57 Importing data from a CSV file 58 Quantitative data 59 Qualitative data 60 Purposes of qualitative and quantitative data 61 Suitability of qualitative and quantitative data for visualisation 62 Coding qualitative data: what a code is 63 Building a coding frame for responses 64 Counting coded responses to make quantitative data 65 Building a frequency table with COUNTIF 66 Cleaning data 67 Sorting data 68 Filtering data 69 Finding patterns, trends and outliers 70 Scatter graphs 71 Correlation is not causation 72 Integrity 73 Data quality: accuracy 74 Data integrity: authenticity 75 Data integrity: correctness 76 Data integrity: reasonableness 77 Data quality: relevance 78 Data integrity: timeliness 79 Judging the quality of a dataset 80 Personal data 81 Sensitive information 82 Consent when collecting personal data 83 Participant information statement 84 Consent form 85 Collecting only the data you need 86 Anonymising data 87 De-identifying survey and interview data with participant codes 88 Copyright Act 1968 (Cwlth) 89 Privacy Act 1988 (Cwlth) 90 What the Australian Privacy Principles are 91 APP 3: collecting only what is reasonably necessary 92 APP 4: dealing with unsolicited personal information 93 APP 5: notifying people when collecting data 94 Australian Privacy Principle 6 95 Australian Privacy Principle 11 96 Health Records Act 2001 (Vic) 97 HPP 1: collection of health information 98 Health Privacy Principle 2 99 HPP 4: data security and retention of health information 100 Privacy and Data Protection Act 2014 (Vic) 101 IPP 1: collection of personal information 102 Information Privacy Principle 2 103 Information Privacy Principle 4 104 IPP 10: sensitive information 105 Applying privacy and health laws to a data collection scenario 106 Acknowledging sources and copyright 107 Purpose of APA referencing 108 APA in-text citations 109 APA reference list entry structure 110 APA reference for a web page 111 APA reference for a dataset or report 112 Archiving data 113 Backup strategies 114 Full backup 115 Incremental backup 116 Differential backup 117 Comparing full, incremental and differential backups 118 Secure disposal of files and storage media 119 Ideation Techniques 120 Brainstorming 121 Mind maps 122 Mood boards 123 Sketching a screen layout 124 Annotating an interface design 125 Infographics and dynamic data visualisations 126 Dashboards 127 UI design principle: alignment 128 UI design principle: balance 129 UI design principle: contrast 130 Using images and icons in a visualisation 131 UI design principle: space 132 UI design principle: text formatting 133 Visualisation component: tables 134 UX characteristic: usability 135 Navigation and user flow 136 Interactivity in a dynamic data visualisation 137 Slicers and interactive filters 138 Applying UI design principles to an interface mock-up 139 Design criteria for an interface 140 Writing criteria to evaluate visualisation design ideas 141 Comparing alternative designs with a decision matrix 142 Efficiency of a solution 143 Effectiveness of a solution 144 Judging efficiency and effectiveness of a data visualisation 145 Design Tool - Storyboards 146 Storyboarding the states of a dynamic visualisation 147 Design Tool - Mock-ups 148 Mock-up of a data visualisation 149 Mock-up of a spreadsheet layout 150 Input-process-output (IPO) chart 151 Writing an IPO chart for a spreadsheet or database task 152 Query design 153 Designing a query from a requirement

18

VCE Data Analytics U3O2: Research questions and project planning Students learn to write and refine a strong research question and plan and monitor a project using Gantt charts, milestones and the critical path.

7

VCE Data Analytics U3O2: Requirements, constraints and scope Students learn to define functional and non-functional requirements, data requirements, constraints and scope for a solution that addresses the research question.

18

VCE Data Analytics U3O2: Collecting primary and secondary data Students learn to collect primary data using surveys, interviews and observations and secondary data through online searches, open repositories and database queries.

14

VCE Data Analytics U3O2: Data types and data structures Students learn the characteristics of data types and data structures used to store and manipulate collected data.

14

VCE Data Analytics U3O2: Preparing data for visualisation Students learn how quantitative and qualitative data are manipulated, including coding qualitative data and identifying trends, relationships and patterns.

8

VCE Data Analytics U3O2: Data integrity Students learn the features of data integrity, including accuracy, authenticity, correctness, reasonableness, relevance and timeliness, and how to judge dataset quality.

8

VCE Data Analytics U3O2: Ethical data collection Students learn ethical procedures for collecting primary data, including consent, participant information statements and de-identifying personal data.

18

VCE Data Analytics U3O2: Privacy, health and copyright law Students learn the key legal requirements for protecting intellectual property and for collecting, communicating and securing data under the Copyright, Privacy, Health Records and Privacy and Data Protection Acts.

13

VCE Data Analytics U3O2: APA referencing and data management Students learn to reference secondary sources in APA style and to manage data through archiving, full, incremental and differential backups, and secure disposal.

20

VCE Data Analytics U3O2: Ideation and visualisation design principles Students learn ideation techniques for generating design ideas and the design principles that shape the appearance and functionality of infographics and dynamic data visualisations.

15

VCE Data Analytics U3O2: Evaluating designs and design tools Students learn to write criteria for evaluating design ideas and visualisations, judge efficiency and effectiveness, and use storyboards, mock-ups, IPO charts and query designs to produce solution designs.

✎

VCE Innovative Solutions Crossword: Impact of Emerging Trends in Digital Systems and more (Part 1 of 2) 10 clues · Impact of Emerging Trends in Digital Systems, Characteristics of Creative and Innovative Solutions, Functions and Capabilities of Digital Systems, Ideation Techniques and more

✎

VCE Innovative Solutions Crossword: Gantt Charts and Project Management and more (Part 2 of 2) 10 clues · Gantt Charts and Project Management, Design Tool - Mock-ups, Design Tool - Storyboards, Design Tool - Sitemap and more

🔎

VCE Innovative Solutions Word Search: Impact of Emerging Trends in Digital Systems and more (All modules) 20 words to find · Impact of Emerging Trends in Digital Systems, Characteristics of Creative and Innovative Solutions, Functions and Capabilities of Digital Systems, Ideation Techniques and more

✎

VCE Cyber Security Crossword: Worms to Operating system updates (Modules 31–40) 10 clues · Worms, Ransomware, Denial of service attacks, Improper credential management and more

✎

VCE Cyber Security Crossword: ISM guideline: confidentiality and integrity of wireless traffic and more (Modules 61–74) 10 clues · ISM guideline: confidentiality and integrity of wireless traffic, ISM guideline: wireless network footprint, Privacy Act 1988 (Cwlth), Australian Privacy Principle 1 and more

🔎

VCE Cyber Security Word Search: Local Area Networks (LANs) to Operating system updates (Modules 21–40) 20 words to find · Local Area Networks (LANs), Wide Area Networks (WANs), Wireless Personal Area Networks (WPANs), Global exposure to cyber security threats and more

🔎

VCE Cyber Security Word Search: Software malware updates to Information Privacy Principle 5 (Modules 41–74) 22 words to find · Software malware updates, Staff procedures, Encryption and decryption, Caesar cipher and more

✎

Issues in Technology Crossword: eWaste from hardware upgrades to What is RADCAB? (Part 2 of 2) 10 clues · eWaste from hardware upgrades, Does RAM really matter?, GPU vs CPU - which matters more?, Hardware cost vs performance and more

🔎

Issues in Technology Word Search: Is AI using too much power? to What is RADCAB? (All modules) 22 words to find · Is AI using too much power?, How does an AI actually work?, Compression - losing quality or saving space?, Why file size matters and more

✎

Years 5–6 Data & Information Crossword: Data, information and binary representation (Modules 1–10) 10 clues · Data and information, Types of data: numbers and text, Types of data: images, sound and video, Same data, different representations and more

✎

Years 5–6 Data & Information Crossword: Data, information and binary representation and Acquiring and manipulating data (Modules 11–20) 10 clues · Representing images with pixels, Primary and secondary data sources, Collecting data with a survey, Spreadsheet rows, columns and cells and more

✎

Years 5–6 Data & Information Crossword: Acquiring and manipulating data and Analysing and visualising data (Modules 21–30) 10 clues · Cleaning data, Formulas start with =, Arithmetic operators + - * /, The SUM function and more

✎

Years 5–6 Data & Information Crossword: Analysing and visualising data and Digital footprint and privacy (Modules 31–56) 10 clues · Choosing the right chart, Column and bar charts, Line charts, Pie charts and more

🔎

Years 5–6 Data & Information Word Search: Data, information and binary representation and Acquiring and manipulating data (Modules 1–20) 20 words to find · Data and information, Types of data: numbers and text, Types of data: images, sound and video, Same data, different representations and more

🔎

Years 5–6 Data & Information Word Search: Acquiring and manipulating data to Digital footprint and privacy (Modules 21–56) 20 words to find · Cleaning data, Formulas start with =, Arithmetic operators + - * /, The SUM function and more

✎

Years 5–6 Creating Digital Solutions Crossword: Defining problems and requirements and Designing algorithms with branching and iteration (Modules 1–10) 10 clues · What is a problem a digital system can solve?, User need, Writing a problem statement, Functional requirements and more

✎

Years 5–6 Creating Digital Solutions Crossword: Designing user interfaces (Modules 31–40) 10 clues · Interface element: buttons, Interface elements: text boxes and labels, Interface elements: menus, sliders and checkboxes, Layout and grouping on a screen and more

🔎

Years 5–6 Creating Digital Solutions Word Search: Defining problems and requirements and Designing algorithms with branching and iteration (Modules 1–20) 20 words to find · What is a problem a digital system can solve?, User need, Writing a problem statement, Functional requirements and more

🔎

Years 5–6 Creating Digital Solutions Word Search: Designing algorithms with branching and iteration and Designing user interfaces (Modules 21–40) 20 words to find · Branching inside a loop, Algorithms that use sequence, branching and iteration together, Drawing a sequence in a flowchart, Drawing a decision in a flowchart and more

✎

Years 9–10 Digital Systems Crossword: Controlling and securing access to data (Modules 13–24) 10 clues · Confidentiality, Integrity, Availability, Authentication vs authorisation and more

🔎

Years 9–10 Digital Systems Word Search: Controlling and securing access to data and Threats and software vulnerabilities (Modules 13–40) 20 words to find · Confidentiality, Integrity, Availability, Authentication vs authorisation and more

✎

VCE Data Analysis Crossword: Types and purposes of data (Modules 3–14) 10 clues · Quantitative data, Qualitative data, Purposes of qualitative and quantitative data, Interviews to gather perspectives on a topical issue and more

✎

VCE Data Analysis Crossword: Types and purposes of data and Data types and data characteristics (Modules 15–24) 10 clues · Open data portals and data licences, Text data: character and string, Numeric data: integer, Numeric data: floating point and more

✎

VCE Data Analysis Crossword: Data types and data characteristics to Privacy and the Australian Privacy Principles (Modules 25–37) 10 clues · Characteristic of data: accessibility, Characteristic of information: clarity, Characteristic of information: context, Data quality: accuracy and more

✎

VCE Data Analysis Crossword: Ethics and APA referencing and Requirements, constraints and scope (Modules 56–67) 10 clues · Acknowledging sources and copyright, Purpose of APA referencing, APA in-text citations, APA reference list entry structure and more

✎

VCE Data Analysis Crossword: Requirements, constraints and scope and Design tools for databases, spreadsheets and visualisations (Modules 68–80) 10 clues · Scope of a solution, Listing requirements and constraints for a problem, Interpreting teacher-provided requirements for a data solution, Input-process-output (IPO) chart and more

🔎

VCE Data Analysis Word Search: Types and purposes of data and Data types and data characteristics (Modules 3–24) 20 words to find · Quantitative data, Qualitative data, Purposes of qualitative and quantitative data, Interviews to gather perspectives on a topical issue and more

🔎

VCE Data Analysis Word Search: Data types and data characteristics to Ethics and APA referencing (Modules 25–54) 20 words to find · Characteristic of data: accessibility, Characteristic of information: clarity, Characteristic of information: context, Data quality: accuracy and more

🔎

VCE Data Analysis Word Search: Ethics and APA referencing to Design tools for databases, spreadsheets and visualisations (Modules 56–80) 22 words to find · Acknowledging sources and copyright, Purpose of APA referencing, APA in-text citations, APA reference list entry structure and more

✎

VCE Spreadsheets, SQL & Visualisation Crossword: Spreadsheet structure, formulas and functions and Descriptive statistics (Modules 4–20) 10 clues · Naming worksheets consistently, Header labels for rows and columns, Relative and absolute cell references, The COUNTIF function and more

✎

VCE Spreadsheets, SQL & Visualisation Crossword: Manipulating, validating and testing spreadsheet data and Relational database structure (Modules 35–44) 10 clues · Pivot tables, What is a relational database?, What a single-table database is, Database field data types and more

✎

VCE Spreadsheets, SQL & Visualisation Crossword: Relational database structure and Querying data with SQL (Modules 45–54) 10 clues · Importing a CSV file into a database table, Validation rules on database fields, SQL constraints for validation, What a database query is and more

✎

VCE Spreadsheets, SQL & Visualisation Crossword: Querying data with SQL to Purposes and types of data visualisations (Modules 55–70) 10 clues · SQL GROUP BY, SQL JOIN across two tables, SQL UPDATE and DELETE, Testing a query against the data and more

✎

VCE Spreadsheets, SQL & Visualisation Crossword: Purposes and types of data visualisations and Visualisation components and design conventions (Modules 71–86) 10 clues · Purpose of a data visualisation: informing, Purpose of a data visualisation: entertaining, Purpose of a data visualisation: persuading, Matching a visualisation to its purpose and audience and more

🔎

VCE Spreadsheets, SQL & Visualisation Word Search: Spreadsheet structure, formulas and functions to Manipulating, validating and testing spreadsheet data (Modules 4–34) 20 words to find · Naming worksheets consistently, Header labels for rows and columns, Relative and absolute cell references, The COUNTIF function and more

🔎

VCE Spreadsheets, SQL & Visualisation Word Search: Manipulating, validating and testing spreadsheet data to Querying data with SQL (Modules 35–54) 20 words to find · Pivot tables, What is a relational database?, What a single-table database is, Database field data types and more

🔎

VCE Spreadsheets, SQL & Visualisation Word Search: Querying data with SQL to Visualisation components and design conventions (Modules 55–86) 20 words to find · SQL GROUP BY, SQL JOIN across two tables, SQL UPDATE and DELETE, Testing a query against the data and more

✎

VCE Software Development U3O1 Crossword: Pseudocode to Data structures (Modules 72–96) 10 clues · Turning pseudocode into Python, Changing a global variable with the global keyword, Functions calling other functions, Program structure with a main() function and more

✎

VCE Software Development U3O1 Crossword: Data structures and Data sources and files (Modules 98–113) 10 clues · Records: fields with different data types, Accessing a record's fields by name and by field index, Choosing a data structure, Plain text (TXT) files: structure and more

🔎

VCE Software Development U3O1 Word Search: Pseudocode to Data sources and files (Modules 72–113) 21 words to find · Turning pseudocode into Python, Changing a global variable with the global keyword, Functions calling other functions, Program structure with a main() function and more

✎

VCE Software Development U3O2 Crossword: Project reasons and the brief to Needs, requirements, constraints and scope (Modules 12–24) 10 clues · Brief feature: originality, Breaking a project into tasks, Gantt chart: sequencing tasks, Gantt chart: time allocation and more

✎

VCE Software Development U3O2 Crossword: Analytical tools and the software requirements specification and Legal requirements for copyright, ownership and privacy (Modules 52–71) 10 clues · Purpose of a software requirements specification (SRS), SRS content: requirements, constraints and scope, SRS content: user characteristics and technical environment, SRS content: analytical tools depicting existing systems and more

✎

VCE Software Development U3O2 Crossword: Legal requirements for copyright, ownership and privacy to Ideation and evaluating design ideas (Modules 72–85) 10 clues · IPP 10: sensitive information, File naming, shared folders and version history, Version control for software projects, Full backup and more

✎

VCE Software Development U3O2 Crossword: Ideation and evaluating design ideas to User experience and software design (Modules 86–109) 10 clues · Mood boards, Design criteria for an interface, Comparing alternative designs with a decision matrix, Efficiency of a solution and more

✎

VCE Software Development U3O2 Crossword: User experience and software design and User interface design principles (Modules 110–119) 10 clues · Accessibility features, How UX characteristics affect software design, UI design principle: alignment, UI design principle: balance and more

🔎

VCE Software Development U3O2 Word Search: Project reasons and the brief to Needs, requirements, constraints and scope (Modules 2–24) 21 words to find · Stakeholders, Project reason: increasing productivity and efficiency, Project reason: reducing costs, Project reason: addressing gaps in the market and more

🔎

VCE Software Development U3O2 Word Search: Analytical tools and the software requirements specification to Ideation and evaluating design ideas (Modules 52–85) 20 words to find · Purpose of a software requirements specification (SRS), SRS content: requirements, constraints and scope, SRS content: user characteristics and technical environment, SRS content: analytical tools depicting existing systems and more

🔎

VCE Software Development U3O2 Word Search: Ideation and evaluating design ideas to User interface design principles (Modules 86–119) 20 words to find · Mood boards, Design criteria for an interface, Comparing alternative designs with a decision matrix, Efficiency of a solution and more

✎

Crossword: Research questions and project planning to Collecting primary and secondary data (Modules 3–31) 10 clues · What a research question is, Research question feature: clarity, Research question feature: measurability of data requirements, Research question feature: feasibility and more

✎

Crossword: Collecting primary and secondary data to Data integrity (Modules 32–75) 10 clues · Searching with keywords and search operators, Searching and filtering a data repository, One-dimensional arrays, Records: grouping fields of different data types and more

✎

Crossword: Data integrity to Evaluating designs and design tools (Modules 76–146) 10 clues · Data integrity: reasonableness, Data integrity: timeliness, Participant information statement, Consent form and more

🔎

Word Search: Research questions and project planning to Evaluating designs and design tools (Modules 3–146) 21 words to find · What a research question is, Research question feature: clarity, Research question feature: measurability of data requirements, Research question feature: feasibility and more