Think of a playlist on a cassette tape versus songs on your phone. On the tape you must wind past every song to reach the one you want; on the phone you tap it and it plays straight away. Computer files work in a similar way. How records are organised in a file decides how they can be accessed, and that decides which applications the file suits.
Build on what you learned in Forms 1–3
These Lower School ICT posts cover the basics of this topic:
- File Management – files, folders and saving your work
- Data and Information – the data that files hold
In this post:
- Records, fields and files (a quick reminder)
- Serial file organisation
- Sequential file organisation
- Direct and random access
- Choosing a file organisation: archiving, payroll and real-time systems
A quick reminder: records and files
A file is a collection of related records. Each record is made up of fields. For example, a school’s student file has one record per student, with fields such as Student ID, Name, Form and Date of birth. A key field (e.g. Student ID) uniquely identifies each record.
Serial file organisation
- Records are stored one after the other in the order they arrive – no sorting.
- To find a record, the computer must read from the start until it finds it (serial access).
- New records are simply added to the end, so writing is quick.
- Example: a shop’s transaction log during the day, recording each sale as it happens.
Sequential file organisation
- Records are stored one after the other in order of a key field (e.g. by Employee ID or alphabetically by name).
- Access is still from the start, record by record, but because the records are sorted, processing all of them in order is efficient.
- Adding a record in the middle means rewriting the file.
- Example: a payroll master file sorted by Employee number.
Magnetic tape can only be accessed serially/sequentially, because the tape must be wound past the earlier data.

Image source: File:Magnetic tape library at USDA.jpg
Direct and random access
- With direct access, the computer can go straight to a record without reading the ones before it. The record’s key is used to work out (or look up in an index) where it is stored.
- Random access means records can be reached in any order, each in about the same time. In everyday use and in most CSEC answers, direct and random access mean much the same thing: jump straight to the record.
- Needs a direct-access storage device such as a hard disk, SSD or flash memory – not tape.
- Example: an airline booking system finding seat 14C on tomorrow’s flight to Barbados instantly.
Video: File Access Methods Explained: Sequential, Direct & Indexed (Beginner's Guide) – https://www.youtube.com/watch?v=q1f2hizy3_M
Choosing a file organisation
| Application | Best organisation / access | Why |
|---|---|---|
| Archiving (long-term storage of old records, e.g. last year’s school records, old bank statements) | Serial or sequential, often on magnetic tape | Records are rarely needed, so slow access is fine; tape is cheap and holds a lot |
| Payroll (paying every employee at the end of the month) | Sequential | Every record is processed, in order, in one batch run – no need to jump around |
| Real-time systems (ATMs, airline/hotel booking, supermarket price look-up) | Direct / random | A single record must be found immediately while the customer waits |
The key question to ask is: “Will I process most of the records at once, or do I need one record quickly?” Most of them at once → sequential. One quickly → direct.
See also Serial, Sequential, Direct (Random) Access and Archive.
Try it: Choose the file organisation
For each application, choose the most suitable way of organising and accessing the file.
| A bank’s ATM checking one customer’s balance | |
| Producing monthly pay slips for all 200 workers in employee-number order | |
| Storing ten-year-old tax records on tape | |
| A hotel checking if room 204 is free tonight | |
| Logging each sale at a cash register as it happens, unsorted |
Related
Related: my class video on serial, sequential and direct (random) access
Paper 1 practice (multiple choice)
Choose the best answer for each question. Try them all before you check.
1. In a sequential file, records are stored
(A) in the order they arrive
(B) in order of a key field
(C) at random positions
(D) in a separate index only
2. Which file organisation is MOST suitable for an airline booking system?
(A) Serial
(B) Sequential
(C) Direct
(D) Archive on tape
3. Which storage medium allows ONLY serial/sequential access?
(A) Hard disk
(B) Magnetic tape
(C) SSD
(D) Flash drive
4. A payroll file is usually processed sequentially because
(A) only one record is needed at a time
(B) all records are processed in order in one run
(C) records are never updated
(D) it is stored on a flash drive
5. Records added to the end of a file in the order they arrive, with no sorting, form a
(A) serial file
(B) sequential file
(C) direct file
(D) index
Show answers
1. B
2. C
3. B
4. B
5. A
Paper 2 practice (structured question)
A credit union keeps records of its members. It uses one file to print a monthly statement for every member and another to let tellers look up a member’s balance while the member waits.
(a) Distinguish between serial and sequential file organisation. (2 marks)
(b) State the most suitable file organisation for printing the monthly statements, and give a reason. (2 marks)
(c) State the most suitable file access method for the tellers’ look-ups, and give a reason. (2 marks)
(d) The credit union keeps old statements for seven years. Suggest a suitable storage medium and file organisation for these records, with a reason. (2 marks)
Total: 8 marks
Show answers
(a) Serial – records stored one after another in the order they are added/unsorted (1); sequential – records stored in order of a key field (1).
(b) Sequential (1) – every member’s record is processed in order in one batch run (1).
(c) Direct/random access (1) – the teller needs one member’s record immediately without reading all the others (1).
(d) Magnetic tape with serial/sequential organisation (1) – records are rarely accessed so slow access is acceptable, and tape is cheap with large capacity (1).
Next: Types of Computer Networks: LAN, MAN, WAN and Mobile Networks
Syllabus link: This post is relevant to the CSEC® Information Technology Syllabus (CXC 30/G/SYLL 17), Section 1: Computer Fundamentals and Information Processing, Specific Objective 15 (“select appropriate file organisation for particular application”).
Attributions to media used in this post:
- Magnetic tape library at USDA.jpg – U.S. Department of Agriculture – Public domain (via Wikimedia Commons)
© 2026 Vedesh Kungebeharry. All rights reserved.