Key Stage 4 computing · Information technology

GCSE information technology skills: a guide for parents

Information technology is the practical use of computers, software and data to get real jobs done. At Key Stage 4 the National Curriculum expects pupils to evaluate and apply it analytically, including technologies they have never met before. The skill being built is not knowing one program well, but choosing sensibly, using tools accurately and judging whether the result actually solves the problem.

Information technology skills, explained

At Key Stage 4 the statutory curriculum says that pupils should develop their capability, creativity and knowledge in information technology, alongside computer science and digital media. It also says every pupil must have the opportunity to study aspects of information technology and computer science in enough depth to progress to higher study or a professional career. The stated aim is that pupils can evaluate and apply information technology, including new or unfamiliar technologies, analytically to solve problems. Schools choose the qualifications and projects that deliver this, so the detail differs from school to school.

The word “unfamiliar” matters. Software changes quickly, and a tool a child uses in Year 10 may be replaced before they start work. Teachers therefore aim to teach transferable habits: working out what a system is supposed to do, what goes in and what comes out, and which features are relevant. A child who understands how a spreadsheet uses cell references and formulas can pick up a different spreadsheet in an afternoon, and the same goes for databases, presentation tools and collaborative documents.

Much of the work involves data. Children learn to collect data sensibly, store it in a structured way (a table with a column for each type of fact), check that it is valid and sort, search and summarise it. They build formulas and use functions, test them with sample values and spot results that look wrong. They also learn that information is only useful if it is accurate, up to date and presented for the right audience, so they practise choosing a suitable chart or report.

Evaluation is the other half. Children are asked to compare options against criteria, such as cost, ease of use, security, accessibility and reliability, and to say what they would recommend and why. They meet the wider picture too: keeping personal data secure, the legal duty of organisations to look after it, working safely on shared files, the effects of automation on jobs, and the responsible use of new tools such as those that generate text or images. Expect your teenager to be asked for a reasoned judgement, not just a working product.

Words your child will hear

Spreadsheet: A grid of cells that holds data and formulas, recalculating automatically when a value changes.
Cell reference: The label of a cell, such as B4, used in a formula so it follows the data when the data changes.
Database: An organised collection of data, usually in tables, that can be searched and sorted.
Validation: A check that data is sensible, for example a number is within a range. It cannot prove the data is correct.
Criteria: The standards used to judge whether a solution is good enough, such as cost or ease of use.
Data protection: The rules and habits that keep personal information secure and used fairly.
Automation: Using technology to carry out a task with little or no human effort.

What the National Curriculum says

The programme of study for Key Stage 4 says:

All pupils should be taught to develop their capability, creativity and knowledge in computer science, digital media and information technology
All pupils must have the opportunity to study aspects of information technology and computer science at sufficient depth to allow them to progress to higher levels of study or to a professional career.
Aim: pupils can evaluate and apply information technology, including new or unfamiliar technologies, analytically to solve problems.

Objectives from the National Curriculum in England, © Crown copyright, used under the Open Government Licence v3.0.

Try it: choosing and testing a tool for a club

A youth football club has 48 members. Each pays £3.50 per session, and there are 30 sessions in the season. The treasurer keeps paper lists and keeps losing track. Which tool should the club use, and how can your teenager check that it works?

State the problem and the criteria. The club needs to record who has paid, total the money and let a volunteer with little computer experience use it. Criteria: cheap, easy to learn, accurate, and the data must be kept private.
Compare the options against the criteria. Paper is free but hard to total. A shared document of notes is easy to edit but cannot total anything. A simple spreadsheet is free, calculates automatically and can be stored securely with access limited to the people who need it. A full database would work but is more than the club needs. Recommend the spreadsheet.
Design the layout. Put the price per session in one labelled cell, B1, so it can change in one place. From row 4 down, give each member one row: name in column A, sessions attended in column B, money due in column C and amount paid in column D.
Write the formula using cell references rather than typed numbers. In C4, the money due is the price in B1 multiplied by the sessions in B4. The dollar signs fix the reference to B1, so the formula can be copied down every member’s row and still point at the price cell.
```
In C4: =$B$1*B4

One member, 30 sessions:
30 × £3.50 = £105
Whole club: 48 × £105 = £5,040
```
Test with data whose answer is known. Enter 30 sessions for every member: each row should show £105 and the total should be £5,040. Then change one member to 12 sessions: their row should show 12 × £3.50 = £42, and the total should fall by £63 to £4,977. If the spreadsheet agrees, the formula works. Also test unusual entries, such as a blank cell or text instead of a number.
Evaluate. Does it meet the criteria? Add validation, such as only allowing whole numbers from 0 to 30 in the sessions column, restrict who can open the file and keep a backup copy.

A spreadsheet is the best fit: it is free, calculates automatically, and is simple to use. With the price in one cell and the formula =$B$1*B4 copied down, a full season for 48 members comes to £5,040 (48 × 30 × £3.50). The treasurer should test with known figures, add validation and keep the file private and backed up.

Common mistakes and how to help

Typing numbers into formulas instead of using cell references

Typing =3.5*12 gives the right answer today, and children do not see why that matters until a price changes and every formula is wrong.

What helps: Ask “what would you have to change if the price went up?” A single labelled cell for the price makes the point at once.

“If the computer calculated it, it must be right”

Software does exactly what it is told. A mistyped formula or a range that misses a row gives a confident wrong answer.

What helps: Encourage estimating first. Ask whether the answer is the right size, and check one result by hand.

Believing validation makes data correct

A check that an age is between 11 and 16 sounds like a guarantee. It only blocks impossible entries, and typing 14 for a 15-year-old still passes.

What helps: Separate validation (is it sensible?) from verification (is it the right value?). Double entry or checking against a source is verification.

Judging a tool by how impressive it looks

A polished interface or a long feature list feels like quality, but evaluations are marked on fitness for the purpose.

What helps: Make your child name two or three criteria before looking at the options, then score each option against them with evidence.

How to help at home

Run a household spreadsheet. Let your teenager track something real, such as pocket money, a holiday budget or the weekly shop. Ask them to change one price and watch the totals update, which shows why cell references matter.
Ask them to explain a new tool. When your child starts using unfamiliar software, ask what it is for, what goes in and what comes out. Working that out without a tutorial is the exact skill the curriculum is aiming at.
Compare options with criteria. Before a family purchase or choice, such as a phone plan or a storage option, write three criteria together and score the options. It practises evaluation with a real decision.
Check a result by hand. Pick a total from a bill or a spreadsheet and estimate it in your head before checking. Spotting an answer that looks too big or small is a habit that protects against software errors.
Talk about data and privacy. Notice together who holds your family’s information, such as the school, a sports club or a shop, and what a responsible organisation should do with it. It links the curriculum to everyday life.

Everything in Key Stage 4 computing

Updated 20 October 2026.