Easier to read with cream paper, a tint, more contrast or larger text? Choose your colours and text, once, for every page.

Preview

AC 3.6: Trees: hierarchy-based storage

This is the first page of the lesson. Read it and have a go at the activities. The rest is in the full lesson.

45 minutes

Who do I ask?

A new analyst asks, "Who looks after the data pipelines?" The answer is on the team chart. The Head of Data is at the top. Under them is the Data engineering lead. Under that is Dee.

Each person has exactly one boss. That shape is called a hierarchy, and a lot of data fits it.

Key words

WordWhat it meansExample
HierarchyItems arranged in levels, each with one item above it.An org chart
RootThe single item at the top.Head of Data
ParentThe item directly above another.Data engineering lead is parent of Dee
ChildAn item directly below another.Dee
BranchA path from one item down to another.Head of Data, Data engineering lead, Dee
TreeAnother word for a hierarchy drawn from top to bottom.A folder tree

The cells students fill in are left blank in this preview.

By the end of this lesson

Note

I can describe a hierarchy and say when it suits data.

Starter: what you already know

Have a go

Starter: what you already know

3 questions
Have a go: your answers are marked here and then forgotten. Sign in if you would like your score kept, and to pick up where you left off.Sign in to keep your score

Your answers are marked here and are not kept. A college account keeps every student’s marks.

A hierarchy has levels and one parent

In a hierarchy, one item at the top is the root. Every other item has exactly one parent above it. An item can have many children below it.

A branch is a route from the top down. A hierarchy is also called a tree. Folders and org charts are both trees.

Check: read the tree

Have a go

Check: read the tree

3 questions
Have a go: your answers are marked here and then forgotten. Sign in if you would like your score kept, and to pick up where you left off.Sign in to keep your score

Your answers are marked here and are not kept. A college account keeps every student’s marks.

The lesson goes on

9 more parts of this lesson are in the full curriculum, with the tasks, the final check and the labs. A college account gives your students all of it.