Pickles AcademyStart for free

Working with tables – practice for Years 6–8

Sample questions on Working with tables with the right answer and a worked solution, from easy to hard. In the Pickles Academy app a child gets new questions of the same kind every time, so they can't just learn the answers by heart.

Subject
Computing
Year
Years 6–8
Curriculum area
Information systems

Question types: Race results in a table

Rule: Working with tables

With two conditions (“and also”) count only the rows that meet both.

Watch “less than” and “at most”: a value equal to the limit is not “less than” it.

Example: Younger than 12 and a time under 75 s: 11 years and 70 s yes; 11 years and 75 s no; 12 years and 60 s no.

Watch out: Don’t count each condition separately and add: first pick the rows for one condition, then check the other.

Sample questions

  1. Question 1 Easy

    The table shows the results of a race. How many runners have more than 85 points?

    NumberAgeTime (s)Points
    34147640
    30108685
    16146765
    14127790
    21147095
    2812485
    Show the solution
    Answer: 2

    How it works: 14 (90), 21 (95)

  2. Question 2 Normal

    The table shows the results of a race. How many runners are younger than 14 and also have a time under 86 s?

    NumberAgeTime (s)Points
    34147640
    30108685
    16146765
    14127790
    21147095
    2812485
    32134095
    Show the solution
    Answer: 3

    How it works: 14 (12, 77 s), 28 (12, 48 s), 32 (13, 40 s)

  3. Question 3 Hard

    The table shows the results of a race. Sort the runners by time, fastest first. What is the number of the runner in place 5?

    NumberAgeTime (s)Points
    34147640
    30108685
    16146765
    14127790
    21147095
    2812485
    32134095
    36147290
    Show the solution
    Answer: 36

    How it works: 1. 32 (40 s), 2. 28 (48 s), 3. 16 (67 s), 4. 21 (70 s), 5. 36 (72 s), 6. 34 (76 s), 7. 14 (77 s), 8. 30 (86 s)

All Computing topics

Keep practising in the app

In a minute, your child has their own avatar and a first task. Free, no ads, data in the EU.

Start for free