← VCE Spreadsheets, SQL & Visualisation

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.

Part of: VCE Applied Computing - U1O1 - Data analysis — Module 5, ACARA Digital Technologies Years 7–8 — Acquiring and Storing Data — Module 34, ACARA Digital Technologies Years 7–8 — Analysing and Visualising Data — Module 7, ACARA Digital Technologies Years 9–10 — Acquiring and Validating Data — Module 54

Understanding Header labels for rows and columns in VCE Spreadsheets, SQL & Visualisation

What it does: Weight_kg names the data (Weight) and its unit (kg) in the header label. Every header uses the same style (capital first letters with underscores), which makes the sheet look tidy and easier to read. Height_cm says what the data is and includes the unit. 'Numbers' does not say what is measured. One header per column tells anyone reading the sheet what the data below it means. Adding the unit (C) makes it clear how the values were measured. 'Temp' leaves the reader guessing. Headers sit at the top of a column so they are the first thing a reader sees, and sorting and filtering tools treat them as labels.

Common mistakes: The header Height does not say what unit the numbers are in. It should include the unit, like Height_cm. The other headers use a capital letter at the start of each word. This one is all lowercase, so the capitalisation is inconsistent. It should be Score_Pct.

Class: _____________________  ·  Name: _____________________  ·  Date: _________

Free printable worksheet with full answer key — or add this module to a class and your students practise it interactively.

🖨 Print worksheet + answer key Add Header labels for rows and columns to a class →

This module's key terms are also in a printable crossword (Modules 4–20) and word search (Modules 4–34).

Take this worksheet further — free with Cloodit

Each concept is reinforced from every angle — learned, then applied, then tested.

Learning
Duo
Which is the better header for a column of student heights?
NumbersHeight_cm
Matches
A1: Data, B1: Data, C1: Data
↓
The headers are vague and repeated, so they do not say what each column holds. Each column needs its own clear header such as Name, Age or Score.
Applying
Meanings
Term
header label
Meaning
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.
Practice
Student,Height_cm,Weight_kg,Age_years
Testing
Gaps
B1:
Check Answer
Spots
1A1: Student
2B1: Height

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

The 'Sea Turtle' badge — Scope Navigator, one of Cloodit's 106 collectible badges
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 →

Quick Questions

1. Which is the better header for a column of student heights?
A. Height_cm ✓
B. Numbers
Height_cm says what the data is and includes the unit. 'Numbers' does not say what is measured.
2. True or false: Each column should have its own header label in the first row.
A. False
B. True ✓
One header per column tells anyone reading the sheet what the data below it means.
3. Which header set uses consistent capitalisation?
A. name, AGE_years, Score_Percent
B. Name, Age_years, Score_percent ✓
Pick one style and use it for every header. Mixed styles look messy and are easy to mistype in formulas and queries.
4. Which header should you use for a column of temperatures measured in degrees Celsius?
A. Temperature_C ✓
B. Temp
Adding the unit (C) makes it clear how the values were measured. 'Temp' leaves the reader guessing.
5. Where should the header label for a column go?
A. In the first row, above the data ✓
B. In the last row, below the data
Headers sit at the top of a column so they are the first thing a reader sees, and sorting and filtering tools treat them as labels.

Match the Pairs

Height_cm → A header label that names the data and includes its unit (centimetres)
A1: Name, B1: Age, C1: Score → One clear header label per column in the first row
Include the unit in a header so readers know how the numbers are measured → Weight_kg
Keep header capitalisation consistent across all columns → Name, Year_Level, Test_Score
A1: Data, B1: Data, C1: Data → The headers are vague and repeated, so they do not say what each column holds. Each column needs its own clear header such as Name, Age or Score.
A1: height_cm, B1: WEIGHT_KG, C1: Age → The capitalisation is inconsistent (lowercase, all capitals and capitalised first letter). Use one style such as Height_cm, Weight_kg and Age.

Key Term

header label
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.

Fill in the Blanks

1. A1: Name B1: Height_cm B2: 172
Hint: Type the header for the height column, with the unit cm added after an underscore.
2. A1: Name A2: Mia A3: Jack
Hint: Type the cell reference of the top-left cell, where the header for column A goes.
3. B1: Temp_C B2: 21.5 B3: 19.0
Hint: Type the header for a temperature column, with the Celsius unit symbol after an underscore.
4. A1: Name B1: Age C1: Team
Hint: Type the cell reference of the header for the second column in the first row.
5. C1: Time_min C2: 45 C3: 30
Hint: Type the header for a time column, with the unit for minutes after an underscore.

Spot the Error

Question 1
A A1: Student
B B1: Height
C C1: Mass_kg
Line B — The header Height does not say what unit the numbers are in. It should include the unit, like Height_cm.
Question 2
A A1: Student_Name
B B1: Age_Years
C C1: score_pct
Line C — The other headers use a capital letter at the start of each word. This one is all lowercase, so the capitalisation is inconsistent. It should be Score_Pct.
Question 3
A A1: Name
B B1: Height_cm
C C1: Mass_kg
D D1: Age_years, Year_born
Line D — Each column should have only one header. This cell names two things. Year_born needs its own column and header, so D1 should be just Age_years.
Question 4
A A1: Date
B B1: Max_Temp_C
C C1: Min_Temp_C
D D1: (blank)
Line D — Every column needs a header label in the first row. A blank header does not say what the data is. It should be Rainfall_mm.
Question 5
A Item,,Stock_count
B Pen,2.50,40
C Book,8.00,15
Line A — The Price column has no header, so nobody knows what the numbers mean. The first row should say Price_AUD, with its unit.

Student with a class code? Join your class →