← All Journeys

ACARA Digital Technologies Years 9–10 — Analysing and Visualising Data

Turning data into interactive charts that support a conclusion.

Modules (74)

1 Asking a question the data can answer 2 The data science life cycle 3 Keeping an untouched copy of the raw data 4 Converting a range to a Table (Ctrl+T) 5 Handling missing values 6 Flagging duplicates with a COUNTIF formula 7 Converting text to numbers and fixing date formats 8 Sorting data 9 Filtering data 10 Using sort and filter together to find top and bottom values 11 Absolute cell references with $ 12 The MIN and MAX functions 13 The AVERAGE function 14 The MEDIAN function 15 Comparing mean and median 16 Range of a data set 17 The STDEV.S function 18 Interpreting standard deviation 19 The COUNTA function 20 COUNTIF and SUMIF 21 The AVERAGEIF function 22 COUNTIFS and SUMIFS with several criteria 23 IF with AND and OR 24 The IFERROR function 25 Looking up values with XLOOKUP or VLOOKUP 26 The ROUND function 27 Calculating a percentage of a total 28 Calculating percentage change 29 Column and bar charts 30 Line charts 31 Pie charts 32 Scatter graphs 33 Choosing the right chart 34 Chart titles, axis labels and legends 35 Adding a second data series to compare groups 36 Combination chart with a secondary axis 37 Spotting misleading charts 38 Finding patterns, trends and outliers 39 Finding outliers with QUARTILE and the IQR rule 40 Conditional formatting 41 Deciding what to do with an outlier 42 Trendlines on a chart 43 Smoothing a trend with a moving average 44 Pearson's correlation coefficient (r) with CORREL 45 Interpreting the value of r 46 Correlation is not causation 47 SLOPE and INTERCEPT for a prediction equation 48 Making predictions with FORECAST 49 Limits and reliability of predictions 50 Static, interactive and live data visualisations 51 Pivot tables 52 Building a pivot table from fields 53 Changing a pivot table's value summary 54 Grouping dates and numbers in a pivot table 55 Creating a pivot chart 56 Slicers and interactive filters 57 Inserting a slicer on a pivot table 58 Timeline slicers for dates 59 Connecting one slicer to several pivot charts 60 Referencing a cell on another worksheet 61 Drop-down list validation in a spreadsheet 62 Named ranges 63 A drop-down list as a chart selector 64 Feeding a chart from a selected cell with INDEX and MATCH 65 Option buttons and combo boxes as form controls 66 Scroll bar and spin button form controls 67 A chart title linked to a cell 68 Charting a filtered table 69 Mock-up of a data visualisation 70 Laying out a dashboard sheet 71 Confirming charts and graphs represent the data 72 Describing a trend in a sentence with evidence 73 Drawing conclusions from data 74 Communicating insights to an audience

Smaller journeys, one per content description

The same modules, split up so a class can take just the content description it's working on.

7
ACARA 9-10 Digital Technologies: Planning an investigation and cleaning data — AC9TDI10P01, AC9TDI10P02 Students turn a question into a data investigation and prepare reliable data by keeping a raw copy, using Tables, and fixing blanks, duplicates, text numbers and dates.
11
ACARA 9-10 Digital Technologies: Sorting, filtering and summary statistics — AC9TDI10P02 Students sort and filter tables and use spreadsheet functions to find extremes, averages, spread and standard deviation.
10
ACARA 9-10 Digital Technologies: Conditional and calculation formulas — AC9TDI10P02 Students use counting, conditional, logical and lookup functions plus rounding, percentages and percentage change to analyse groups within a data set.
9
ACARA 9-10 Digital Technologies: Creating and evaluating charts — AC9TDI10P02 Students choose, build and label column, line, pie, scatter and combination charts, and learn to spot misleading ones.
12
ACARA 9-10 Digital Technologies: Trends, outliers and predictions — AC9TDI10P02 Students identify patterns and outliers, measure correlation, and use trendlines, SLOPE, INTERCEPT and FORECAST to make predictions while judging how reliable they are.
10
ACARA 9-10 Digital Technologies: Pivot tables and slicers — AC9TDI10P02 Students summarise large data sets with pivot tables and pivot charts and filter them interactively with slicers and timelines.
15
ACARA 9-10 Digital Technologies: Interactive charts, dashboards and conclusions — AC9TDI10P01, AC9TDI10P02, AC9TDI10P07 Students build formula-driven interactive charts and a dashboard with drop-downs, named ranges and form controls, then check them and communicate evidence-based conclusions.

Printables for this journey

Every module above has its own free printable worksheet with an answer key. These crosswords and word searches cover the same terms:

✎
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
✎
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: 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: Descriptive statistics and Manipulating, validating and testing spreadsheet data (Modules 21–34) 10 clues · Grouping numbers into bins with COUNTIFS, The STDEV.S function, Interpreting standard deviation, Cleaning text with TRIM, UPPER and PROPER 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: 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 Data Analytics U3O1 Crossword: Sourcing, validating and referencing data to Statistical analysis of data (Modules 50–91) 10 clues · Setting spreadsheet data validation rules, Removing duplicate rows, Handling missing values, Converting text to numbers and fixing date formats and more
✎
VCE Data Analytics U3O1 Crossword: Statistical analysis of data to Designing data visualisations (Modules 94–128) 10 clues · The shape of a data distribution, Skew in data, Purpose of a data visualisation: exploratory data analysis, Purpose of a data visualisation: presentation of information and more
✎
VCE Data Analytics U3O1 Crossword: Artificial intelligence trends in data analytics and Testing databases, spreadsheets and visualisations (Modules 130–148) 10 clues · Artificial intelligence features in software tools, Writing a prompt to generate a data visualisation, Refining a visualisation prompt, Checking an AI-generated visualisation against the data and more
🔎
VCE Data Analytics U3O1 Word Search: Data types and relational databases to Statistical analysis of data (Modules 17–91) 20 words to find · Field sizes, SQL column data types and sizes, One-to-many relationships between tables, Boolean operators AND, OR and NOT in a WHERE clause and more
🔎
VCE Data Analytics U3O1 Word Search: Statistical analysis of data to Testing databases, spreadsheets and visualisations (Modules 94–148) 20 words to find · The shape of a data distribution, Skew in data, Purpose of a data visualisation: exploratory data analysis, Purpose of a data visualisation: presentation of information and more
✎
Years 7–8 Data & Information Crossword: Representing data with binary and Acquiring, storing and validating data (Modules 9–45) 10 clues · 8-bit binary numbers and the range 0 to 255, Converting a larger decimal number to binary, How many values n bits can store, Looking up characters in the ASCII table and more
🔎
Years 7–8 Data & Information Word Search: Representing data with binary to Using digital tools and conventions (Modules 9–80) 22 words to find · 8-bit binary numbers and the range 0 to 255, Converting a larger decimal number to binary, How many values n bits can store, Looking up characters in the ASCII table and more
✎
Years 9–10 Data & Information Crossword: Data compression to Acquiring, storing and validating data (Modules 17–51) 10 clues · Choosing a compression format for a task, Content, structure and presentation of a document, Restyling one document with a different stylesheet, Why separating content, structure and presentation matters and more
🔎
Years 9–10 Data & Information Word Search: Data compression to Data privacy and the Australian Privacy Principles (Modules 6–132) 21 words to find · Redundancy: repeated data that can be shortened, Lossless compression, Lossy compression, Run-length encoding: encoding text and more
✎
ACARA Digital Technologies Years 7–8 Crossword: Acquiring and Storing Data and Analysing and Visualising Data (Modules 261–300) 10 clues · Keeping an untouched copy of the raw data, Flagging duplicates with a COUNTIF formula, Flagging out-of-range values with IF and OR, Fixing spelling variations with Find and Replace and more
✎
ACARA Digital Technologies Years 7–8 Crossword: Analysing and Visualising Data (Modules 302–324) 10 clues · Checking a result with the status bar summary, Number filters: greater than and between, Using sort and filter together to find top and bottom values, Calculating a percentage of a total and more
✎
ACARA Digital Technologies Years 7–8 Crossword: Analysing and Visualising Data and Structured Data and Queries (Modules 331–360) 10 clues · Describing a trend in a sentence with evidence, Investigating a dataset from question to conclusion, Attributes of an object, Attributes of an event and more
🔎
ACARA Digital Technologies Years 7–8 Word Search: Acquiring and Storing Data and Analysing and Visualising Data (Modules 261–324) 20 words to find · Keeping an untouched copy of the raw data, Flagging duplicates with a COUNTIF formula, Flagging out-of-range values with IF and OR, Fixing spelling variations with Find and Replace and more
🔎
ACARA Digital Technologies Years 7–8 Word Search: Analysing and Visualising Data to Algorithms, Flowcharts and Pseudocode (Modules 331–411) 21 words to find · Describing a trend in a sentence with evidence, Investigating a dataset from question to conclusion, Attributes of an object, Attributes of an event and more
✎
Crossword: Data Compression and Acquiring and Validating Data (Modules 226–254) 10 clues · Exporting audio at different quality levels in Audacity, How video compression reuses unchanged parts of frames, Streaming media and adjusting bitrate, Common compressed file formats and what they are used for and more
✎
Crossword: Acquiring and Validating Data and Analysing and Visualising Data (Modules 333–377) 10 clues · Finding duplicates with COUNTIF, Splitting one column into several with Text to Columns, Deciding what to do with an outlier, Keeping a cleaning log and more
✎
Crossword: Analysing and Visualising Data (Modules 378–412) 10 clues · The IFERROR function, Combination chart with a secondary axis, Finding outliers with QUARTILE and the IQR rule, SLOPE and INTERCEPT for a prediction equation and more
✎
Crossword: Analysing and Visualising Data (Modules 413–424) 10 clues · Connecting one slicer to several pivot charts, Referencing a cell on another worksheet, Named ranges, A drop-down list as a chart selector and more
🔎
Word Search: Data Compression and Acquiring and Validating Data (Modules 226–329) 20 words to find · Exporting audio at different quality levels in Audacity, How video compression reuses unchanged parts of frames, Streaming media and adjusting bitrate, Common compressed file formats and what they are used for and more
🔎
Word Search: Acquiring and Validating Data and Analysing and Visualising Data (Modules 333–412) 20 words to find · Finding duplicates with COUNTIF, Splitting one column into several with Text to Columns, Deciding what to do with an outlier, Keeping a cleaning log and more
🔎
Word Search: Analysing and Visualising Data and Entities, Relationships and Queries (Modules 413–451) 21 words to find · Connecting one slicer to several pivot charts, Referencing a cell on another worksheet, Named ranges, A drop-down list as a chart selector and more

Frequently Asked Questions

Are these worksheets free?

Yes — every worksheet and its answer key is free to view, download, and print, with no account required to access any individual module.

Do I need an account?

No account is needed to view or print a worksheet. A free teacher account adds extras like assigning modules to a class and tracking progress automatically — it takes under three minutes to set up and doesn't need a credit card.

What year level is this for?

This curriculum is aligned to the Australian Curriculum (ACARA) and Victorian Curriculum, spanning roughly Years 3 to 10 — from first sequencing and variables through to object-oriented programming and advanced data structures. Start wherever matches your class's current level; each module builds on the last.

Can I print them?

Yes — every module has a one-click Print Worksheet button that generates a printable page with the practice questions and a full answer key.

Is this aligned to a curriculum?

Yes — the module sequence is mapped to the Australian Curriculum (ACARA) and Victorian Curriculum, and a class's progress is reported back against those curriculum bands (e.g. ACARA Years 5–6 sequencing and iteration, Years 7–8 functions and data structures), not just a generic difficulty scale.

Can students use this without a teacher?

Yes — students can start any module and practice directly, no class or account required. Joining a teacher's class with a class code adds progress tracking, class badges, and live Sprints, but isn't needed to work through the worksheets or modules solo.

Do I need to know ACARA Digital Technologies Years 9–10 myself to teach this?

No — every module comes with a full worked answer key, and Cloodit tracks who's stuck automatically, so you don't need to solve each exercise yourself before assigning it or be able to debug a student's work line by line.

Add to class →
For Teachers

Add this journey to your class and track every student in real time.

Create a free teacher account →

No credit card. No setup fee. Make a class and invite students in under three minutes.

For Students

Start this journey on Cloodit — track progress, earn badges, and play live sprints with your class.

Start Learning Free →

Have a class code?