VCE Data Analytics U4O1: Manipulating data with software tools
Students use templates, spreadsheet functions, data cleaning tools and AI tools to manipulate data effectively and efficiently.
One content description from the full VCE Data Analytics - U4O1 - Development and Evaluation journey. All 18 modules below are in that journey too, with the same content — add just these to a class, or the whole strand.
Modules (18)
1
Efficiency of a solution
2
Effectiveness of a solution
3
Using a spreadsheet template
4
Cleaning data
5
Cleaning text with TRIM, UPPER and PROPER
6
Sorting data
7
Filtering data
8
Copying a formula down a column
9
Relative and absolute cell references
10
The IF function in a spreadsheet
11
Looking up values with XLOOKUP or VLOOKUP
12
The SUMIF function
13
Pivot tables
14
Conditional formatting
15
Writing a prompt that asks an AI tool to chart or summarise data
16
Data generated by artificial intelligence
17
Checking an AI-made data representation against the source data
18
Using generative AI tools responsibly
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 →