SHSubjectHub

Spreadsheets quiz games for KS3 Computing

4 live games for KS3 Computing, 60 questions. Free for teachers, up to 40 players.

Spreadsheets for KS3 Computing: 4 ready-made live quiz games, 60 questions in all.

The questions cover Charts, Formulas, Sorting and filtering, Cells, rows and columns, Formatting and modelling (what-if) and Functions (SUM, AVERAGE, MAX, MIN, COUNT).

There are 3 practice sets and 1 quickfire round. Question types: 32 true or false, 25 multiple choice and 3 fill the gap.

Pick a set, put the join code on the board and pupils play on their phones. Pupils need no account. Free for teachers, up to 40 players.

The gamesEach set is a fixed list of questions. Open a preview to see a few of them.

Quickfire: Spreadsheets

KS315 questions· Warm-up

Plays in 23 of 23 game modes, including Gold Rush, Big Catch and Speed Blitz.

Host this free
Preview 3 sample questions
  1. 1

    True or false?

    Axes should be labelled.
  2. 2

    True or false?

    Bar charts cannot use numbers.
  3. 3

    What does merging cells do?

    Copies themJoins them into one larger cellDeletes themAdds their values

+ 12 more questions in the game.

Practice

Spreadsheets: Charts

KS315 questions· Core

Plays in 23 of 23 game modes, including Gold Rush, Big Catch and Speed Blitz.

Host this free
Preview 3 sample questions
  1. 1

    What does a chart legend do?

    Adds up the dataExplains what each colour or line meansSorts the dataGives the chart its name
  2. 2

    True or false?

    A pie chart works best with 20 categories.
  3. 3

    True or false?

    Pie chart slices together make up a whole.

+ 12 more questions in the game.

Practice

Spreadsheets: Formulas

KS315 questions· Core

Plays in 23 of 23 game modes, including Gold Rush, Big Catch and Speed Blitz.

Host this free
Preview 3 sample questions
  1. 1

    True or false?

    / is the symbol for divide.
  2. 2

    True or false?

    =SUM(A1:A3) includes both A1 and A3.
  3. 3

    True or false?

    MIN finds the largest value in a range.

+ 12 more questions in the game.

Practice

Spreadsheets: Sorting and filtering

KS315 questions· Core

Plays in 23 of 23 game modes, including Gold Rush, Big Catch and Speed Blitz.

Host this free
Preview 3 sample questions
  1. 1

    What does ascending order mean for numbers?

    Smallest to largestRandom orderLargest to smallestAlphabetical only
  2. 2

    True or false?

    Filtering deletes the rows that do not match.
  3. 3

    True or false?

    Sorting A to Z puts Bella before Zac.

+ 12 more questions in the game.

How hosting works

  1. Pick a set and a game mode. The questions stay the same; the game changes.
  2. Put the join code on the board. Pupils join at subjecthub.co.uk/play on a phone or laptop. They need no account.
  3. Play for 1 to 7 minutes. You choose the length before you start.

Free for teachers: host these sets with up to 40 players. You sign up once as a teacher.

See how each game mode plays →

← All KS3 Computing games · All live games