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: Files and folders for datasets

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

40 minutes

Where did the survey go?

A data team saves every survey result as a file in one big place. After a year there are 9,000 files with names like new1 and final2.

Nobody can find anything. The team then sorts them into folders by year and month. The files are the same, but now they are easy to find.

Key words

WordWhat it meansExample
File-based storageEach set of data lives in its own file that a program opens and saves.sales.csv
Directory-based storageFiles are put in folders inside folders, found by a path.surveys/2026/09/canteen.csv
DirectoryA folder that holds files and other folders.surveys
PathThe route through folders to a file.surveys/2026/09
StructureThe way data is organised.Folders by year
CSVA text file with one record per line and commas between fields.sales.csv
Naming conventionA rule for how files are named.canteen.csv

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

By the end of this lesson

Note

I can tell file-based storage from directory-based storage and say when to use each.

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.

File-based: one file per set

In file-based storage, each set of data lives in its own file. A program opens the file, reads it and saves it back.

It is simple and cheap. It suits one person or one small job, such as a single sales list in a spreadsheet.

It struggles when many people need the same data. Copies drift apart and two people can overwrite each other.

Directory-based: files in folders

In directory-based storage, files go in a directory, a folder. Folders sit inside other folders, and a path names the way to a file.

It keeps related files together and lets you set who may open each folder. It suits a team with many files, such as survey results by year and month.

Worked example: sales lists

QuestionFile-basedDirectory-based
Examplesales.csvdata/sales/2026/north.csv
Finding a fileOpen the one fileFollow the path
Good forOne small listMany files and many people
WeaknessCopies drift apartNeeds a naming convention

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

Check: which storage?

Have a go

Check: which storage?

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

6 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.