Lesson 1: Records, fields and data

Using Top Trumps cards, pupils learn the meanings of records, fields and data when working with databases

Before the lesson

Download classroom resources

Learning objective

  • To understand the terminology around databases

National curriculum

Pupils should be taught to:

  • Select, use and combine a variety of software (including internet services) on a range of digital devices to design and create a range of programs, systems and content that accomplish given goals, including collecting, analysing, evaluating and presenting data and information

Success criteria

Cross-curricular links

Attention grabber

Main event


Pupils needing extra support: Give them values that they can put into their own Top Trumps card instead of having to calculate this themselves. Show Activity: Labelled top trump card as a visual reminder of the terms used in the lesson.


Pupils working at greater depth: Should consider a fair way of choosing a winner when there is no numerical data e.g. compare the position in the alphabet of the starting letter, compare the number of letters etc.

Wrapping up

Assessing pupils' progress and understanding


Created by:
Cat Lamin,  
Computing specialist
Cat was a committed primary school teacher for twelve years. After starting her independent consultancy ‘Crossover Solutions’ she has travelled to Argentina, Brazil and America to share her wealth of knowledge of computer science with other teachers. Her enjoyment for…
Find out more