ComputingYears 7–9Digital Literacy

Data, spreadsheets and databases

Learn Data, spreadsheets and databases for Years 7–9 pupils (ages 11–14). Free practice questions, lessons and worked examples — aligned to the UK National Curriculum.

What you'll learn

  1. 1

    A database stores structured data in tables. A record is one row; a field is one column.

  2. 2

    A query asks the database a question — "show all pupils in Year 8 with an attendance above 95%".

  3. 3

    In a database table, what is a record?

  4. 4

    In a spreadsheet, a formula starts with = and calculates from other cells. Change the input and the result updates automatically.

  5. 5

    =SUM(B2:B10) adds a range. =AVERAGE(B2:B10) finds the mean. =IF(B2>50,"Pass","Fail") makes a decision.

  6. 6

    What does a primary key do?

  7. 7

    What does =SUM(A1:A5) do?

Practise Data, spreadsheets and databases with Whizlo

Free AI-tutored lessons, unlimited practice questions, and progress tracking for ages 11–14. Aligned to the UK National Curriculum.

Start free →Sign in