Spreadsheets and ICT (Foundation) - Worksheets, Questions and Revision
60 original exam-style questions - 38 pages of questions with a full mark scheme - free printable PDF.
Spreadsheets and ICT (Foundation) revision guideMore GCSE Statistics practiceMock exams
This topic is chapter 3 of GCSE Statistics Foundation Topic Workbook 2 and chapter 11 of GCSE Statistics Foundation 10-Minute Tests 1.
2.1 Spreadsheets and ICT (Foundation)
Give one advantage of using a spreadsheet, rather than doing the calculation by hand, to keep a record of her sales.
| Sport | Number of pupils |
|---|---|
| Football | 12 |
| Swimming | 6 |
| Athletics | 5 |
| Rugby | 7 |
She highlights this data and uses the spreadsheet's chart tool to produce a chart.
| Item | Price before VAT (£) |
|---|---|
| Kettle | 25.00 |
| Toaster | 18.00 |
| Blender | 32.00 |
(Kettle is in row 2, Toaster in row 3, Blender in row 4.)
Comment on this statement, giving reasons for and against it.
| Runner | Time (seconds) |
|---|---|
| Priya | 13.9 |
| Omar | 14.5 |
| Sam | 12.8 |
| Tia | 15.2 |
| Leo | 13.1 |
| Noor | 14.0 |
Recommend whether the charity should collect responses using a paper questionnaire or an online survey tool. Use the statistical enquiry cycle to justify your answer, referring to at least two stages (for example plan, collect, process or interpret).
| Row (A) | B: Hours | C: Rate |
|---|---|---|
| 2: Lemons | 20 | 3 |
| 3: Pears | 5 | 2 |
| 4: Melons | 8 | 13 |
| 5: Cherries | 17 | 15 |
| 6: Plums | 20 | 5 |
Work out the value produced by each formula.
(a) =SUM(C2:C6)
(b) =COUNTIF(B2:B6,">9")
(c) =AVERAGE(B2:B6)
12, 7, 6, 4, 999, 11, 8, 9, 11
(a) Write down the invalid values.
(b) Work out the mean of all 9 values, to 1 decimal place if needed.
(c) Work out the mean after the invalid values are removed, to 1 decimal place if needed.
| Row (A) | B: Hours | C: Rate |
|---|---|---|
| 2: Lemons | 14 | 13 |
| 3: Melons | 7 | 15 |
| 4: Apples | 15 | 12 |
| 5: Plums | 17 | 7 |
| 6: Cherries | 20 | 4 |
Work out the value produced by each formula.
(a) =MAX(C2:C6)
(b) =B3+C3
(c) =MAX(B2:B6)-MIN(B2:B6)
| Row (A) | B: Mark 1 | C: Mark 2 |
|---|---|---|
| 2: Melons | 11 | 13 |
| 3: Cherries | 18 | 13 |
| 4: Apples | 20 | 9 |
| 5: Pears | 8 | 7 |
| 6: Grapes | 6 | 9 |
Work out the value produced by each formula.
(a) =MIN(C2:C6)
(b) =SUM(C2:C6)
(c) =SUM(B2:B6)
11, 17, 12, 17, 17, 14, 17, 999, 0, 13
(a) Write down the invalid values.
(b) Work out the mean of all 10 values, to 1 decimal place if needed.
(c) Work out the mean after the invalid values are removed, to 1 decimal place if needed.
| Row (A) | B: Week 1 | C: Week 2 |
|---|---|---|
| 2: Cherries | 20 | 9 |
| 3: Grapes | 15 | 8 |
| 4: Limes | 7 | 8 |
| 5: Melons | 16 | 6 |
| 6: Plums | 20 | 11 |
Work out the value produced by each formula.
(a) =B2*C2
(b) =COUNTIF(B2:B6,">8")
(c) =AVERAGE(B2:B6)
| Row (A) | B: Mark 1 | C: Mark 2 |
|---|---|---|
| 2: Lemons | 15 | 6 |
| 3: Cherries | 8 | 14 |
| 4: Plums | 14 | 15 |
| 5: Grapes | 6 | 2 |
| 6: Limes | 13 | 12 |
Work out the value produced by each formula.
(a) =MAX(B2:B6)-MIN(B2:B6)
(b) =AVERAGE(B2:B6)
(c) =MAX(C2:C6)
120, 5, 8, 9, 1, 10, 3, 9, 8, 8
(a) Write down the invalid values.
(b) Work out the mean of all 10 values, to 1 decimal place if needed.
(c) Work out the mean after the invalid values are removed, to 1 decimal place if needed.
| Row (A) | B: Mark 1 | C: Mark 2 |
|---|---|---|
| 2: Limes | 13 | 2 |
| 3: Plums | 16 | 12 |
| 4: Grapes | 11 | 3 |
| 5: Melons | 20 | 2 |
| 6: Cherries | 9 | 5 |
Work out the value produced by each formula.
(a) =MIN(C2:C6)
(b) =AVERAGE(B2:B6)
(c) =B3+C3
| Row (A) | B: Week 1 | C: Week 2 |
|---|---|---|
| 2: Pears | 3 | 15 |
| 3: Melons | 8 | 14 |
| 4: Apples | 5 | 14 |
| 5: Cherries | 4 | 6 |
| 6: Limes | 15 | 3 |
Work out the value produced by each formula.
(a) =SUM(B2:B6)
(b) =B3+C3
(c) =MIN(C2:C6)
153, 1900, 172, 170, 147, 134, 999, 186, 190, 169
(a) Write down the invalid values.
(b) Work out the mean of all 10 values, to 1 decimal place if needed.
(c) Work out the mean after the invalid values are removed, to 1 decimal place if needed.
| Row (A) | B: Mark 1 | C: Mark 2 |
|---|---|---|
| 2: Lemons | 18 | 14 |
| 3: Plums | 8 | 11 |
| 4: Grapes | 8 | 7 |
| 5: Apples | 17 | 5 |
| 6: Cherries | 7 | 12 |
Work out the value produced by each formula.
(a) =COUNTIF(B2:B6,">11")
(b) =MAX(B2:B6)-MIN(B2:B6)
(c) =AVERAGE(B2:B6)
| Row (A) | B: Week 1 | C: Week 2 |
|---|---|---|
| 2: Cherries | 15 | 12 |
| 3: Pears | 13 | 12 |
| 4: Plums | 5 | 3 |
| 5: Lemons | 3 | 3 |
| 6: Apples | 11 | 10 |
Work out the value produced by each formula.
(a) =SUM(C2:C6)
(b) =AVERAGE(B2:B6)
(c) =MAX(C2:C6)
3, 5, 10, 5, 9, 9, 120, 8, 11, 9
(a) Write down the invalid values.
(b) Work out the mean of all 10 values, to 1 decimal place if needed.
(c) Work out the mean after the invalid values are removed, to 1 decimal place if needed.
| Row (A) | B: Hours | C: Rate |
|---|---|---|
| 2: Melons | 18 | 10 |
| 3: Pears | 14 | 11 |
| 4: Limes | 6 | 9 |
| 5: Apples | 4 | 7 |
| 6: Grapes | 9 | 5 |
Work out the value produced by each formula.
(a) =COUNTIF(B2:B6,">11")
(b) =AVERAGE(B2:B6)
(c) =B6*C6
| Row (A) | B: Price (pounds) | C: Quantity |
|---|---|---|
| 2: Melons | 16 | 10 |
| 3: Lemons | 5 | 15 |
| 4: Cherries | 4 | 12 |
| 5: Pears | 13 | 9 |
| 6: Plums | 20 | 4 |
Work out the value produced by each formula.
(a) =COUNTIF(B2:B6,">10")
(b) =MAX(B2:B6)-MIN(B2:B6)
(c) =SUM(C2:C6)
0, 15, 14, 12, 16, 15, 11, 13, 17, 15
(a) Write down the invalid values.
(b) Work out the mean of all 10 values, to 1 decimal place if needed.
(c) Work out the mean after the invalid values are removed, to 1 decimal place if needed.
| Row (A) | B: Price (pounds) | C: Quantity |
|---|---|---|
| 2: Grapes | 9 | 9 |
| 3: Limes | 19 | 14 |
| 4: Pears | 8 | 5 |
| 5: Lemons | 7 | 2 |
| 6: Apples | 16 | 13 |
Work out the value produced by each formula.
(a) =MAX(C2:C6)
(b) =COUNTIF(B2:B6,">12")
(c) =AVERAGE(B2:B6)
| Row (A) | B: Week 1 | C: Week 2 |
|---|---|---|
| 2: Pears | 12 | 2 |
| 3: Lemons | 15 | 6 |
| 4: Plums | 20 | 7 |
| 5: Melons | 18 | 4 |
| 6: Cherries | 17 | 12 |
Work out the value produced by each formula.
(a) =AVERAGE(B2:B6)
(b) =SUM(C2:C6)
(c) =SUM(B2:B6)
999, 9, 11, 6, 10, 12, 6, 7
(a) Write down the invalid values.
(b) Work out the mean of all 8 values, to 1 decimal place if needed.
(c) Work out the mean after the invalid values are removed, to 1 decimal place if needed.
| Row (A) | B: Price (pounds) | C: Quantity |
|---|---|---|
| 2: Lemons | 2 | 14 |
| 3: Pears | 12 | 7 |
| 4: Cherries | 15 | 12 |
| 5: Apples | 18 | 13 |
| 6: Limes | 14 | 2 |
Work out the value produced by each formula.
(a) =COUNTIF(B2:B6,">12")
(b) =SUM(B2:B6)
(c) =MAX(B2:B6)-MIN(B2:B6)
11, -1, 14, 17, 3, 17, 16, 13, 11, 17
(a) Write down the invalid values.
(b) Work out the mean of all 10 values, to 1 decimal place if needed.
(c) Work out the mean after the invalid values are removed, to 1 decimal place if needed.
| Row (A) | B: Mark 1 | C: Mark 2 |
|---|---|---|
| 2: Apples | 14 | 7 |
| 3: Plums | 18 | 2 |
| 4: Lemons | 10 | 11 |
| 5: Cherries | 8 | 13 |
| 6: Limes | 2 | 8 |
Work out the value produced by each formula.
(a) =MIN(C2:C6)
(b) =COUNTIF(B2:B6,">8")
(c) =AVERAGE(B2:B6)
12, 11, 3, -1, 11, 3, 3, 12
(a) Write down the invalid values.
(b) Work out the mean of all 8 values, to 1 decimal place if needed.
(c) Work out the mean after the invalid values are removed, to 1 decimal place if needed.
| Row (A) | B: Hours | C: Rate |
|---|---|---|
| 2: Pears | 13 | 2 |
| 3: Lemons | 6 | 9 |
| 4: Plums | 16 | 14 |
| 5: Melons | 8 | 9 |
| 6: Apples | 5 | 10 |
Work out the value produced by each formula.
(a) =B2*C2
(b) =AVERAGE(B2:B6)
(c) =MIN(C2:C6)
| Row (A) | B: Mark 1 | C: Mark 2 |
|---|---|---|
| 2: Grapes | 4 | 7 |
| 3: Plums | 10 | 4 |
| 4: Melons | 15 | 2 |
| 5: Lemons | 20 | 15 |
| 6: Cherries | 10 | 11 |
Work out the value produced by each formula.
(a) =B6*C6
(b) =B2*C2
(c) =COUNTIF(B2:B6,">10")
12, 6, 12, 4, 120, 6, 7, 0
(a) Write down the invalid values.
(b) Work out the mean of all 8 values, to 1 decimal place if needed.
(c) Work out the mean after the invalid values are removed, to 1 decimal place if needed.
| Row (A) | B: Hours | C: Rate |
|---|---|---|
| 2: Cherries | 18 | 8 |
| 3: Plums | 13 | 11 |
| 4: Limes | 3 | 13 |
| 5: Lemons | 11 | 8 |
| 6: Apples | 8 | 13 |
Work out the value produced by each formula.
(a) =B6*C6
(b) =B3+C3
(c) =B2*C2
| Row (A) | B: Price (pounds) | C: Quantity |
|---|---|---|
| 2: Melons | 19 | 3 |
| 3: Apples | 13 | 5 |
| 4: Pears | 9 | 3 |
| 5: Plums | 18 | 15 |
| 6: Grapes | 13 | 13 |
Work out the value produced by each formula.
(a) =B2*C2
(b) =SUM(C2:C6)
(c) =MAX(B2:B6)-MIN(B2:B6)
10, 120, 4, 12, 3, 8, -1, 9, 9, 12
(a) Write down the invalid values.
(b) Work out the mean of all 10 values, to 1 decimal place if needed.
(c) Work out the mean after the invalid values are removed, to 1 decimal place if needed.
| Row (A) | B: Mark 1 | C: Mark 2 |
|---|---|---|
| 2: Plums | 17 | 2 |
| 3: Grapes | 2 | 3 |
| 4: Cherries | 15 | 5 |
| 5: Pears | 13 | 5 |
| 6: Melons | 16 | 12 |
Work out the value produced by each formula.
(a) =COUNTIF(B2:B6,">12")
(b) =SUM(B2:B6)
(c) =MAX(C2:C6)
| Row (A) | B: Hours | C: Rate |
|---|---|---|
| 2: Apples | 14 | 15 |
| 3: Grapes | 17 | 5 |
| 4: Cherries | 15 | 10 |
| 5: Melons | 2 | 14 |
| 6: Pears | 14 | 3 |
Work out the value produced by each formula.
(a) =B3+C3
(b) =COUNTIF(B2:B6,">7")
(c) =SUM(B2:B6)
13, 14, 17, 14, 14, 11, 17, 170, 16, 11
(a) Write down the invalid values.
(b) Work out the mean of all 10 values, to 1 decimal place if needed.
(c) Work out the mean after the invalid values are removed, to 1 decimal place if needed.
| Row (A) | B: Hours | C: Rate |
|---|---|---|
| 2: Pears | 13 | 6 |
| 3: Limes | 6 | 4 |
| 4: Grapes | 13 | 4 |
| 5: Apples | 19 | 6 |
| 6: Plums | 17 | 11 |
Work out the value produced by each formula.
(a) =B2*C2
(b) =COUNTIF(B2:B6,">7")
(c) =SUM(C2:C6)
15, 11, 17, 17, 15, 3, 15, 999, 17
(a) Write down the invalid values.
(b) Work out the mean of all 9 values, to 1 decimal place if needed.
(c) Work out the mean after the invalid values are removed, to 1 decimal place if needed.
| Row (A) | B: Hours | C: Rate |
|---|---|---|
| 2: Limes | 10 | 11 |
| 3: Pears | 20 | 6 |
| 4: Melons | 18 | 4 |
| 5: Plums | 19 | 12 |
| 6: Grapes | 15 | 6 |
Work out the value produced by each formula.
(a) =MIN(C2:C6)
(b) =AVERAGE(B2:B6)
(c) =B2*C2
8, 11, 4, 5, 6, 11, 5, 1
(a) Write down the invalid values.
(b) Work out the mean of all 8 values, to 1 decimal place if needed.
(c) Work out the mean after the invalid values are removed, to 1 decimal place if needed.
| Row (A) | B: Mark 1 | C: Mark 2 |
|---|---|---|
| 2: Pears | 13 | 8 |
| 3: Plums | 19 | 11 |
| 4: Cherries | 17 | 2 |
| 5: Grapes | 15 | 5 |
| 6: Melons | 19 | 11 |
Work out the value produced by each formula.
(a) =B3+C3
(b) =SUM(B2:B6)
(c) =B2*C2
| Row (A) | B: Mark 1 | C: Mark 2 |
|---|---|---|
| 2: Grapes | 13 | 10 |
| 3: Melons | 14 | 14 |
| 4: Pears | 9 | 11 |
| 5: Cherries | 7 | 3 |
| 6: Apples | 11 | 2 |
Work out the value produced by each formula.
(a) =B6*C6
(b) =MIN(C2:C6)
(c) =B2*C2
| Row (A) | B: Price (pounds) | C: Quantity |
|---|---|---|
| 2: Grapes | 10 | 10 |
| 3: Cherries | 6 | 3 |
| 4: Plums | 18 | 5 |
| 5: Lemons | 12 | 15 |
| 6: Apples | 15 | 13 |
Work out the value produced by each formula.
(a) =MAX(C2:C6)
(b) =COUNTIF(B2:B6,">11")
(c) =MIN(C2:C6)
| Row (A) | B: Price (pounds) | C: Quantity |
|---|---|---|
| 2: Cherries | 6 | 7 |
| 3: Lemons | 6 | 5 |
| 4: Apples | 3 | 9 |
| 5: Grapes | 4 | 14 |
| 6: Melons | 12 | 7 |
Work out the value produced by each formula.
(a) =COUNTIF(B2:B6,">10")
(b) =MIN(C2:C6)
(c) =MAX(B2:B6)-MIN(B2:B6)
| Row (A) | B: Price (pounds) | C: Quantity |
|---|---|---|
| 2: Grapes | 10 | 3 |
| 3: Melons | 12 | 3 |
| 4: Cherries | 19 | 14 |
| 5: Apples | 6 | 8 |
| 6: Plums | 6 | 9 |
Work out the value produced by each formula.
(a) =B2*C2
(b) =AVERAGE(B2:B6)
(c) =B3+C3
Question 1
- (a) 0.85 oe (£0.85) caoB1
- (a) Answer: 0.85
- (b) C4 caoB1
- (b) Answer: C4
- (c) Apple caoB1
- (c) Answer: Apple
Question 2
- (i) True caoB1
- (i) Answer: True
- (ii) False caoB1
- (ii) Answer: False
Question 3
- any valid advantage, e.g. it recalculates totals automatically when a value changes, oe it is faster, oe it reduces the chance of an arithmetic errorB1
- Answer: A spreadsheet updates every total automatically when a number is changed, so there is less chance of making an arithmetic error.
Question 4
- (a) =B2*C2 oe (accept =C2*B2)B1
- (a) Answer: =B2*C2
- (b) 0.60 x 40, oeM1
- (b) 24 or 24.00 caoA1
- (b) Answer: 24.00
- (c) 21.25 ft (0.85 x 25)B1
- (c) Answer: 21.25
Question 5
- (a) SUM used as a named function, e.g. =SUM(...)B1
- (a) correct range B2:B8B1
- (a) Answer: =SUM(B2:B8)
- (b) 28 (mm) caoB1
- (b) Answer: 28
Question 6
- (a) AVERAGE used as a named function, e.g. =AVERAGE(...)B1
- (a) correct range B2:B8B1
- (a) Answer: =AVERAGE(B2:B8)
- (b) 28 / 7, oeM1
- (b) 4 (mm) caoA1
- (b) Answer: 4
Question 7
- (a) Chen caoB1
- (a) Answer: Chen
- (b) Dana caoB1
- (b) Answer: Dana
- (c) 14 caoB1
- (c) Answer: 14
Question 8
- (a) Beth and Dana identified (scores of 18 and 20, both at least 15)B1
- (a) Farah also identified, with Amir, Chen and Ewan correctly excludedB1
- (a) Answer: Beth, Dana, Farah
- (b) any valid advantage, e.g. it is quicker, oe it is less likely that a qualifying pupil is missed or an error is madeB1
- (b) Answer: It is quicker and less likely that a pupil who qualifies is accidentally missed.
Question 9
- (a) bar chart caoB1
- (a) Answer: Bar chart
- (b) valid reason, e.g. the sports are categories, not points in time or paired numerical values, so a line graph or scatter graph would not be suitableB1
- (b) Answer: A line graph is for data collected over time and a scatter graph is for pairs of numerical values, but sport is a category, so neither would be suitable here.
- (c) Yes, with a valid reason, e.g. the data is categorical and the frequencies add up to a total (30 pupils), so a pie chart can show each sport's share of that totalB1
- (c) Answer: Yes. Because the sports are categories that add up to a total of 30 pupils, a pie chart can show each sport's share of the whole group.
Question 10
- (a) the cell references adjust/change automatically as the formula is copied downB1
- (a) correctly states the copied formula becomes =B3*C3B1
- (a) Answer: The references shift down a row with the formula, so the copy in D3 becomes =B3*C3.
- (b) G1 stays the same in every copyB1
- (b) named as an absolute cell reference oe (fixed by the $ signs)B1
- (b) Answer: G1 stays the same in every copy; this is called an absolute cell reference.
Question 11
- (a) any valid use, e.g. an online survey/questionnaire gathers responses directly into a spreadsheet or databaseB1
- (a) Answer: An online questionnaire could collect people's answers directly into a spreadsheet.
- (b) any valid use, e.g. a named function such as SUM or AVERAGE calculates a total or the mean number of journeysB1
- (b) Answer: A spreadsheet function such as AVERAGE could calculate the mean number of journeys per person.
- (c) any valid use, e.g. a chart/graph produced from the spreadsheet data helps to identify patterns or trendsB1
- (c) Answer: A chart produced from the spreadsheet data could help show which age groups use public transport most.
- (d) any valid limitation, e.g. data entered wrongly or a formula containing an error could lead to a wrong conclusion if nobody checks itB1
- (d) Answer: If the data is typed in wrongly, or a formula has an error, the conclusions could be wrong unless someone checks the results.
Question 12
- (a) any valid advantage, e.g. responses are collected and stored automatically, so results do not need to be entered by hand and can be processed much fasterB1
- (a) Answer: Responses go straight into a spreadsheet or database, so nobody has to type up 500 paper forms by hand, which saves a lot of time.
- (b) any valid disadvantage, e.g. customers without internet access or a suitable device cannot take part, so the sample might not be representativeB1
- (b) Answer: Customers who do not use the internet cannot respond, so the results might not represent all 500 customers fairly.
- (c) any valid reason, e.g. a database can store, search and organise a much larger amount of data more efficiently, or allows several people to access and update records at the same timeB1
- (c) Answer: A database is built to store and search through large numbers of records efficiently, and can let several people update it at once.
Question 13
- (a) =B2*C2 oeB1
- (a) Answer: =B2*C2
- (b) 15 x 12, oeM1
- (b) 180 caoA1
- (b) Answer: 180
- (c) SUM used as a named function, e.g. =SUM(...)B1
- (c) correct range D2:D6B1
- (c) Answer: =SUM(D2:D6)
- (d) 636 caoB1
- (d) Answer: 636
Question 14
- (a) any valid disadvantage, e.g. if the formula contains an error (such as the wrong cell reference), every value calculated from it will also be wrong, and this might not be noticedB1
- (a) Answer: If a formula has a mistake in it, such as the wrong cell reference, every total it produces will be wrong, and this could easily go unnoticed.
- (b) any valid check, e.g. calculate one member's total by hand and compare it with the spreadsheet's answerB1
- (b) Answer: Work out one member's total by hand and check that it matches the value the spreadsheet gives.
Question 15
- (a) correct structure, e.g. =B2*(1+F1) oe (accept =B2+B2*F1)B1
- (a) the reference to F1 is written as an absolute reference, $F$1B1
- (a) Answer: =B2*(1+$F$1)
- (b) without $ signs, the reference would change/shift when copied down, e.g. to F2 then F3B1
- (b) F2 and F3 are empty, so the copied formulas would give the wrong answer (e.g. zero VAT) instead of using the rate in F1B1
- (b) Answer: Without the $ signs, the reference would shift down to F2 and then F3 as the formula is copied, and those cells are empty, so the toaster and blender would be given the wrong price instead of using the VAT rate in F1.
- (c) 32 x 1.2, oeM1
- (c) 38.40 cao (accept 38.4)A1
- (c) Answer: 38.40
Question 16
- a clear judgement is given (e.g. partly agree/it depends), rather than a simple yes or no with no commentB1
- a reason supporting the statement, e.g. the spreadsheet plots values exactly as entered, avoiding the plotting/measuring errors that can happen when a chart is drawn by handB1
- a reason against the statement, e.g. the chart is only as accurate as the data or formulas entered, so wrong data or a formula error still produces a wrong (but neatly drawn) chartB1
- Answer: It depends. A spreadsheet chart avoids hand-drawing errors because it plots the exact values entered, but it is only as reliable as the data and formulas behind it, so a mistake when entering the data would still produce an inaccurate chart.
Question 17
- (a) Priya caoB1
- (a) Answer: Priya
- (b) Sam and Leo identified (12.8 and 13.1, both under 14 seconds)B1
- (b) Priya also identified, with Noor, Omar and Tia correctly excluded (Noor's 14.0 is not under 14)B1
- (b) Answer: Sam, Leo, Priya
Question 18
- a clear recommendation is given (online survey tool, for a group this size)B1
- a justified point linked to one stage of the enquiry cycle, e.g. at the collect stage an online tool gathers 10 000 responses directly into a spreadsheet/database without anyone re-typing paper formsB1
- a justified point linked to a second stage of the enquiry cycle, e.g. at the process/interpret stage the same spreadsheet functions and charts can be reused each year, making year-on-year comparison quicker and more consistentB1
- Answer: An online survey tool. At the collect stage it gathers all 10 000 responses directly into a spreadsheet or database without anyone re-typing paper forms, and at the process/interpret stage the same formulas and charts can be reused each year, making year-on-year comparison quicker and more consistent.
Question 19
- 38 caoB1
- 3 caoB1
- 14 caoB1
- Answer: (a) 38; (b) 3; (c) 14
Question 20
- invalid values 999B1
- sum of all values divided by 9M1
- 118.6 caoA1
- sum of valid values divided by 8M1
- 8.5 caoA1
- Answer: (a) 999; (b) 118.6; (c) 8.5
Question 21
- 15 caoB1
- 22 caoB1
- 13 caoB1
- Answer: (a) 15; (b) 22; (c) 13
Question 22
- 7 caoB1
- 51 caoB1
- 63 caoB1
- Answer: (a) 7; (b) 51; (c) 63
Question 23
- invalid values 999, 0B1
- sum of all values divided by 10M1
- 111.7 caoA1
- sum of valid values divided by 8M1
- 14.8 caoA1
- Answer: (a) 999, 0; (b) 111.7; (c) 14.8
Question 24
- 180 caoB1
- 4 caoB1
- 15.6 caoB1
- Answer: (a) 180; (b) 4; (c) 15.6
Question 25
- 9 caoB1
- 11.2 caoB1
- 15 caoB1
- Answer: (a) 9; (b) 11.2; (c) 15
Question 26
- invalid values 120, 1B1
- sum of all values divided by 10M1
- 18.1 caoA1
- sum of valid values divided by 8M1
- 7.5 caoA1
- Answer: (a) 120, 1; (b) 18.1; (c) 7.5
Question 27
- 2 caoB1
- 13.8 caoB1
- 28 caoB1
- Answer: (a) 2; (b) 13.8; (c) 28
Question 28
- 35 caoB1
- 22 caoB1
- 3 caoB1
- Answer: (a) 35; (b) 22; (c) 3
Question 29
- invalid values 1900, 999B1
- sum of all values divided by 10M1
- 422 caoA1
- sum of valid values divided by 8M1
- 165.1 caoA1
- Answer: (a) 1900, 999; (b) 422; (c) 165.1
Question 30
- 2 caoB1
- 11 caoB1
- 11.6 caoB1
- Answer: (a) 2; (b) 11; (c) 11.6
Question 31
- 40 caoB1
- 9.4 caoB1
- 12 caoB1
- Answer: (a) 40; (b) 9.4; (c) 12
Question 32
- invalid values 120B1
- sum of all values divided by 10M1
- 18.9 caoA1
- sum of valid values divided by 9M1
- 7.7 caoA1
- Answer: (a) 120; (b) 18.9; (c) 7.7
Question 33
- 2 caoB1
- 10.2 caoB1
- 45 caoB1
- Answer: (a) 2; (b) 10.2; (c) 45
Question 34
- 3 caoB1
- 16 caoB1
- 50 caoB1
- Answer: (a) 3; (b) 16; (c) 50
Question 35
- invalid values 0B1
- sum of all values divided by 10M1
- 12.8 caoA1
- sum of valid values divided by 9M1
- 14.2 caoA1
- Answer: (a) 0; (b) 12.8; (c) 14.2
Question 36
- 14 caoB1
- 2 caoB1
- 11.8 caoB1
- Answer: (a) 14; (b) 2; (c) 11.8
Question 37
- 16.4 caoB1
- 31 caoB1
- 82 caoB1
- Answer: (a) 16.4; (b) 31; (c) 82
Question 38
- invalid values 999B1
- sum of all values divided by 8M1
- 132.5 caoA1
- sum of valid values divided by 7M1
- 8.7 caoA1
- Answer: (a) 999; (b) 132.5; (c) 8.7
Question 39
- 3 caoB1
- 61 caoB1
- 16 caoB1
- Answer: (a) 3; (b) 61; (c) 16
Question 40
- invalid values -1, 3B1
- sum of all values divided by 10M1
- 11.8 caoA1
- sum of valid values divided by 8M1
- 14.5 caoA1
- Answer: (a) -1, 3; (b) 11.8; (c) 14.5
Question 41
- 2 caoB1
- 3 caoB1
- 10.4 caoB1
- Answer: (a) 2; (b) 3; (c) 10.4
Question 42
- invalid values -1B1
- sum of all values divided by 8M1
- 6.8 caoA1
- sum of valid values divided by 7M1
- 7.9 caoA1
- Answer: (a) -1; (b) 6.8; (c) 7.9
Question 43
- 26 caoB1
- 9.6 caoB1
- 2 caoB1
- Answer: (a) 26; (b) 9.6; (c) 2
Question 44
- 110 caoB1
- 28 caoB1
- 2 caoB1
- Answer: (a) 110; (b) 28; (c) 2
Question 45
- invalid values 120, 0B1
- sum of all values divided by 8M1
- 20.9 caoA1
- sum of valid values divided by 6M1
- 7.8 caoA1
- Answer: (a) 120, 0; (b) 20.9; (c) 7.8
Question 46
- 104 caoB1
- 24 caoB1
- 144 caoB1
- Answer: (a) 104; (b) 24; (c) 144
Question 47
- 57 caoB1
- 39 caoB1
- 10 caoB1
- Answer: (a) 57; (b) 39; (c) 10
Question 48
- invalid values 120, -1B1
- sum of all values divided by 10M1
- 18.6 caoA1
- sum of valid values divided by 8M1
- 8.4 caoA1
- Answer: (a) 120, -1; (b) 18.6; (c) 8.4
Question 49
- 4 caoB1
- 63 caoB1
- 12 caoB1
- Answer: (a) 4; (b) 63; (c) 12
Question 50
- 22 caoB1
- 4 caoB1
- 62 caoB1
- Answer: (a) 22; (b) 4; (c) 62
Question 51
- invalid values 170B1
- sum of all values divided by 10M1
- 29.7 caoA1
- sum of valid values divided by 9M1
- 14.1 caoA1
- Answer: (a) 170; (b) 29.7; (c) 14.1
Question 52
- 78 caoB1
- 4 caoB1
- 31 caoB1
- Answer: (a) 78; (b) 4; (c) 31
Question 53
- invalid values 3, 999B1
- sum of all values divided by 9M1
- 123.2 caoA1
- sum of valid values divided by 7M1
- 15.3 caoA1
- Answer: (a) 3, 999; (b) 123.2; (c) 15.3
Question 54
- 4 caoB1
- 16.4 caoB1
- 110 caoB1
- Answer: (a) 4; (b) 16.4; (c) 110
Question 55
- invalid values 1B1
- sum of all values divided by 8M1
- 6.4 caoA1
- sum of valid values divided by 7M1
- 7.1 caoA1
- Answer: (a) 1; (b) 6.4; (c) 7.1
Question 56
- 30 caoB1
- 83 caoB1
- 104 caoB1
- Answer: (a) 30; (b) 83; (c) 104
Question 57
- 22 caoB1
- 2 caoB1
- 130 caoB1
- Answer: (a) 22; (b) 2; (c) 130
Question 58
- 15 caoB1
- 3 caoB1
- Answer: (a) 15; (b) 3; (c) 3
Question 59
- 1 caoB1
- 5 caoB1
- 9 caoB1
- Answer: (a) 1; (b) 5; (c) 9
Question 60
- 30 caoB1
- 10.6 caoB1
- 15 caoB1
- Answer: (a) 30; (b) 10.6; (c) 15
Mark your answers
Check answers without an account. Some answers can be checked automatically; use the mark scheme to mark the rest.