VCE Spreadsheets, SQL & Visualisation

This is the hands-on half of VCE Applied Computing Unit 1 Outcome 1 — Data analysis: using spreadsheets and databases to manipulate data, and designing data visualisations that communicate what it shows.

This page lists 65 free modules: worksheet naming, header labels and relative and absolute cell references; COUNTIF, SUMIF, IF and XLOOKUP/VLOOKUP; MEDIAN, mean vs median, frequency tables, bins and standard deviation; cleaning text, data validation rules and error alerts, testing formulas, conditional formatting and pivot tables; relational databases, field data types, primary and foreign keys, naming conventions, table design, CREATE TABLE, importing CSV files and validation constraints; SQL SELECT, WHERE, AND/OR, wildcards, ORDER BY, aggregate functions, GROUP BY, JOIN, UPDATE and DELETE; scatter graphs, histograms, trendlines and misleading charts; and the purposes, types, components and design conventions of infographics and dashboards. Each module includes real practice questions and a full answer key.

The theory and design modules for the same outcome — types and quality of data, privacy, ethics, APA referencing, requirements and design tools — are on the VCE Data Analysis page. Teachers can assign the whole journey, or one key knowledge area at a time, with progress tracking, class sprints and badges.

Add this whole curriculum to your class, or just the modules your unit needs — Cloodit tracks who's stuck automatically.

Add to class →

Spreadsheet structure, formulas and functions (7 modules)

Naming worksheets consistently A short, clear worksheet tab name that describes what the sheet holds. Use one consistent style with no spaces, and keep raw data on a separate tab from analysis, such as Summary.

Header labels for rows and columns A label in the first row or column that names the data below or beside it. Use one per column, add units like Height_cm, and keep capitalisation consistent.

Relative and absolute cell references The dollar signs lock a cell reference, so $B$1 stays fixed when a formula is copied. A plain B1 is relative and shifts to match its new position. B$1 locks only the row.

The COUNTIF function Counts how many cells in a range match a value or condition, such as "Yes" or ">10". Example: =COUNTIF(C2:C30,"Yes") counts every Yes in C2 to C30.

The SUMIF function Adds only the numbers in sum_range whose matching cell in range meets the criteria, such as the total of all sales for one category.

The IF function in a spreadsheet Checks a test, like B2>=50. Shows the second value if the test is true and the third if it is false. Text results go in quotes, e.g. =IF(B2>=50,"Pass","Fail").

Looking up values with XLOOKUP or VLOOKUP A lookup function that finds a key in one column and returns the matching value from another column, such as a price for a product code. It can show a message if no match is found.

Just this content description: the Spreadsheet structure, formulas and functions journey · Add Spreadsheet structure, formulas and functions to a class →

Descriptive statistics (6 modules)

The MEDIAN function Returns the middle value of the numbers in B2:B30 once ordered. With an even count it averages the middle two. You do not need to sort the cells first.

Comparing mean and median An outlier drags the mean towards it but barely moves the median. If the two differ a lot, the data is skewed, so the median is usually the fairer typical value to report.

Building a frequency table with COUNTIF Used in a frequency table: list each category in column A, then put this beside it to count how many times that category appears in the data range. Copy it down for every category.

Grouping numbers into bins with COUNTIFS Counts the numbers in a range that are at least the lower limit and less than the upper limit, giving the frequency of one bin. Equal-width bins must not leave gaps or overlap.

The STDEV.S function Returns the sample standard deviation of the numbers in a range, showing how spread out they are. Use STDEV.P if the range is the whole population.

Interpreting standard deviation A measure of how spread out values are around the mean. A small value means the data is clustered close to the mean. A large value means it is widely spread. It uses the same units as the data.

Just this content description: the Descriptive statistics journey · Add Descriptive statistics to a class →

Manipulating, validating and testing spreadsheet data (8 modules)

Cleaning text with TRIM, UPPER and PROPER A text function that returns a tidy copy of the text in A2 with extra spaces removed. UPPER, LOWER and PROPER work the same way to fix capitals, e.g. =PROPER(A2) gives Mia Chen.

What data validation is and why it matters An automatic check that data is reasonable and allowed when it is entered, such as being in range or the right type, so typos and impossible values are caught.

Number range validation in a spreadsheet A rule that only lets a cell accept a number between a minimum and maximum, like age 11 to 14. Numbers outside the range are rejected. Use Decimal for numbers with parts.

Drop-down list validation in a spreadsheet A rule that lets a cell accept only items from a set list, shown as a drop-down. Items can be typed in or taken from a range of cells, which keeps spelling consistent.

Validation messages and error alerts A message that pops up when someone enters data that breaks a validation rule. It can Stop the entry, Warn about it, or give Information, and a good message explains how to fix it.

Testing a formula against a hand-calculated answer The answer you work out by hand using a few rows of data. Compare it with the formula's actual result. If they match, the formula works. If not, check the formula and its range.

Conditional formatting A spreadsheet tool that changes a cell's colour or icon automatically when its value meets a rule, so highs, lows and outliers stand out.

Pivot tables A tool that summarises a big table by grouping rows under row and column fields, then working out a sum, count or average for each group. Refresh it when the data changes.

Just this content description: the Manipulating, validating and testing spreadsheet data journey · Add Manipulating, validating and testing spreadsheet data to a class →

Relational database structure (12 modules)

What is a relational database? A database that stores data in separate tables of fields (columns) and records (rows), with tables linked by shared values such as keys.

What a single-table database is A database table stores data in columns called fields and rows called records. A single-table database keeps all its data in this one table.

Database field data types The kind of value a database field accepts, such as text, number, date or yes/no. It stops the wrong kind of data being entered, like words in a number field.

Primary key A field whose value is unique for every record in a table, such as a student ID number, so each record can be identified exactly. Names make poor keys because they can repeat.

Foreign key and table relationships A field in one table that holds the primary key value of a record in another table, linking the two tables together so related data is stored once and not repeated.

Naming a database and its tables A consistent rule for naming a database and its tables, such as a singular noun in lower_case with no spaces or special characters, e.g. student, applied in the same style for every table.

Naming columns, primary keys and foreign keys A key column name in lowercase with an _id suffix. A primary key uses it in its own table, and a foreign key reuses the exact same name in a related table.

Designing a table structure Planning a table by listing a clear field name and data type for each piece of data, with one fact per field, such as FirstName and LastName as two fields.

CREATE TABLE and INSERT INTO SQL command that builds a new table by naming its fields and their data types, such as a PRIMARY KEY. INSERT INTO ... VALUES then adds one record to that table.

Importing a CSV file into a database table Fills a new database table from a CSV file. The first row becomes the field names, and you choose a data type for each field, such as text or number, and check them after the import.

Validation rules on database fields A rule set on a database field that checks each entry, such as a number range, a maximum text length or a drop-down list, and rejects any record that breaks the rule.

SQL constraints for validation A constraint is a rule on a column. This CHECK rejects any record with an age outside 0 to 120. NOT NULL (must have a value) and UNIQUE (no repeats) are constraints too.

Just this content description: the Relational database structure journey · Add Relational database structure to a class →

Querying data with SQL (11 modules)

What a database query is A saved question asked of a table. It shows only the fields and records that answer it, as a new view, and leaves the original table unchanged.

SQL SELECT and FROM SELECT lists the fields to show and FROM names the table. This returns the name and age columns for every record in students. SELECT * shows all columns. End with a semicolon.

SQL WHERE conditions An SQL clause that keeps only the rows meeting a condition, such as WHERE age >= 15 or WHERE town = 'Perth'. Text goes in quotes, and AND or OR can combine conditions.

Combining query criteria with AND and OR AND needs both conditions to be true, like Year = 7 AND Score > 80. OR needs at least one to be true, like Pet = "Cat" OR Pet = "Dog". They let a query match several conditions at once.

Matching part of a text value with wildcards A query criterion where the * wildcard stands for any characters, so it finds text that starts with S. Like "*s" ends with s and Like "*at*" contains at.

SQL ORDER BY Sorts the rows a SELECT query returns by a chosen field. It sorts A to Z or lowest to highest by default (ASC), or the reverse if you add DESC after the field name.

SQL aggregate functions: COUNT, SUM, AVG, MIN, MAX An aggregate function works out one value from many rows. COUNT, SUM, AVG, MIN and MAX give the count, total, mean, lowest and highest. This query returns the mean score.

SQL GROUP BY An SQL clause that sorts rows into groups sharing the same field value, then applies an aggregate like AVG or COUNT to each group, giving one result row per group (e.g. average score per class).

SQL JOIN across two tables Combines rows from two tables where a foreign key matches a primary key, so related data shows in one result. Use table.field names to say which table each field belongs to.

SQL UPDATE and DELETE UPDATE changes field values and DELETE FROM removes records. Always add WHERE so only the chosen records change. Without it, every record in the table is changed or deleted.

Testing a query against the data Predict the rows a query should return from a small sample, run it, then compare the actual result with your prediction. Check row counts, boundary values and JOIN matches.

Just this content description: the Querying data with SQL journey · Add Querying data with SQL to a class →

Charts, graphs and drawing conclusions (5 modules)

Scatter graphs A chart that plots each record as a point using two number columns, one on the x axis and one on the y axis, to show whether two things are related.

Histograms A chart with touching columns showing how many values fall in each numeric bin. Bins go on the x axis, frequency on the y axis. It shows the shape of the data, unlike a bar chart of categories.

Adding a trendline to a chart A straight or curved line fitted to the points on a chart. It shows the overall direction of the data, such as going up or down. Add it with Add Chart Element > Trendline.

Correlation is not causation Two things can rise or fall together without one causing the other. A trend shows a relationship, not the reason, so a hidden third factor may explain both.

Spotting misleading charts A chart whose design, like a cut-off axis, 3D effects or a cherry-picked range, makes the data look different from what it truly shows.

Just this content description: the Charts, graphs and drawing conclusions journey · Add Charts, graphs and drawing conclusions to a class →

Purposes and types of data visualisations (9 modules)

Purpose of a data visualisation: educating A visualisation that helps an audience learn how something works or understand a topic step by step, such as a labelled diagram or a process explained in stages.

Purpose of a data visualisation: informing A visualisation that shows facts and findings clearly and neutrally, with key numbers up front, so the audience can see what the data says and decide for themselves.

Purpose of a data visualisation: entertaining A visualisation that uses humour, bold design or surprising facts to hold attention so the audience enjoys it, for example through playful graphics and fun facts.

Purpose of a data visualisation: persuading A visualisation that selects and emphasises data to move an audience towards a viewpoint or action, using a call to action and design emphasis, while using data ethically.

Matching a visualisation to its purpose and audience The reason a visualisation is made and who will view it. Together they decide the content, level of detail, tone and style, so the same data can look different for different audiences.

Long-form infographic A tall, single-page visualisation that tells one story from start to finish as you scroll down through headed sections of text, graphics and charts.

Series of infographic posters A set of separate infographic posters that share one template and colours, each with one message, linked by a common theme.

Dashboards A single screen that combines charts, tables and key figures so a viewer can monitor data at a glance, such as sales or attendance.

Slicers and interactive filters A set of buttons linked to a table, pivot table or chart. Click a button to filter the data, so a viewer can explore it interactively. Clear the filter to show everything again.

Just this content description: the Purposes and types of data visualisations journey · Add Purposes and types of data visualisations to a class →

Visualisation components and design conventions (7 modules)

Visualisation component: text and graphics Titles, headings, captions and key figures (text) plus shapes, pictures and icons (graphics) that frame and explain the data so viewers know what it shows and what matters.

Visualisation component: tables A visualisation component that shows exact values in rows and columns, used when the audience needs the precise numbers. Clear headers and only the rows that matter keep it readable.

Visualisation component: charts and graphs A visualisation component that turns data into shapes such as bars, lines or slices so patterns can be seen quickly. Use one chart per message and place it near its explanation.

Using colour in a visualisation A small, consistent set of colours where each colour has one meaning. Use the same colour for the same category, and never rely on colour alone, so colour-blind viewers can still read it.

Choosing fonts for a visualisation Using only two or three fonts, with size and weight showing importance from title to heading to body to caption, so a visualisation is easy to read.

Using images and icons in a visualisation A small simple picture that makes a topic quick to recognise. Keep icons relevant and in one style, use them only where they help the data, and credit or get permission for any you borrow.

Consistent layout and style across a visualisation Using the same colours, fonts, alignment and spacing on every part of a dashboard or poster series so it looks unified and is easy to read.

Just this content description: the Visualisation components and design conventions journey · Add Visualisation components and design conventions to a class →

Printable VCE Spreadsheets, SQL & Visualisation Crosswords & Word Searches

Built from the key terms of each block of modules, every one with a full answer key. All free printables →

✎

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

✎

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

✎

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

✎

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

✎

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

✎

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

🔎

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

🔎

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

🔎

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

Journeys using these modules

Or build your own Journey from any of these modules →

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 VCE Spreadsheets, SQL & Visualisation 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.

Cloodit turns curriculum-aligned coding content into journeys students work through one biome at a time.

Students earn collectable badges

Over 100 of them, across seven natural biomes.

Study Buddy

Students build a real study resource

Turns their work into revision material ready for Flash Cards and Exam study.

Diamond Dash — one of Cloodit's live, competitive Sprint games

Students lock in with Sprints

Live, competitive practice for the start of the lesson or a teacher-led lesson finisher.

A Cloodit certificate of achievement, ready to personalise and print

Custom printable certificates

Honour your top performers, or encourage a student who's trying hard — ready to print in seconds.

Add to class →

For Teachers

Set this curriculum for your class and see who needs help, automatically.

Create a free teacher account →

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

For Students

Practice this topic interactively, track progress, and unlock badges.

Start Learning Free →

Have a class code?