VCE Applied Computing U1O1: Spreadsheet structure, formulas and functions
Students learn how spreadsheets are structured and named, then build formulas and use common functions to calculate, count, test and look up data.
One content description from the full VCE Applied Computing - U1O1 - Data analysis journey. All 17 modules below are in that journey too, with the same content — add just these to a class, or the whole strand.
Modules (17)
1
Spreadsheet rows, columns and cells
2
Cell references like A1
3
Entering data into cells
4
Naming worksheets consistently
5
Header labels for rows and columns
6
Formulas start with =
7
Arithmetic operators + - * /
8
Copying a formula down a column
9
Relative and absolute cell references
10
The SUM function
11
The AVERAGE function
12
The MIN and MAX functions
13
The COUNT function
14
The COUNTIF function
15
The SUMIF function
16
The IF function in a spreadsheet
17
Looking up values with XLOOKUP or VLOOKUP
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 →