VCE Data Analytics U3O1: Spreadsheet formulas and cleansing data
Students learn to use spreadsheet formulas and functions, sorting and filtering, and cleansing techniques to calculate with data and fix errors in it.
One content description from the full VCE Data Analytics - U3O1 - Data Analytics journey. All 22 modules below are in that journey too, with the same content — add just these to a class, or the whole strand.
Modules (22)
1
Formulas start with =
2
Arithmetic operators + - * /
3
Copying a formula down a column
4
Relative and absolute cell references
5
The SUM function
6
The AVERAGE function
7
The MIN and MAX functions
8
The COUNT function
9
The COUNTIF function
10
The SUMIF function
11
The IF function in a spreadsheet
12
Looking up values with XLOOKUP or VLOOKUP
13
Sorting data
14
Filtering data
15
Cleaning data
16
Cleaning text with TRIM, UPPER and PROPER
17
Removing duplicate rows
18
Handling missing values
19
Converting text to numbers and fixing date formats
20
Splitting and joining text with LEFT, RIGHT and CONCAT
21
Formatting numbers and cells
22
Formula error values and how to fix them
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 →