Worked question 12 - Spreadsheets and ICT (Higher)
Compare these two situations, and recommend, with justification, whether each organisation should rely mainly on manual calculation or on ICT/database software to process its data.
Answer and mark scheme
Question 12
| Credit | Answer or working |
|---|---|
| B1 | the club's data set (40 members) is small enough that manual calculation is a reasonable, proportionate option, without the cost or training needed for specialist software |
| B1 | the retailer's data set (about 2 million transactions) is far too large for manual calculation to be practical or accurate within a reasonable time, so ICT/database software is essential |
| B1 | a relevant risk/limitation is identified for at least one case, e.g. a single formula error in the retailer's software could affect an enormous number of records, so results still need to be checked |
| B1 | a clear overall conclusion, e.g. the best method depends on the scale (and nature) of the data, rather than one method always being better |
- Answer: For the club's 40 members, manual calculation is perfectly proportionate and avoids unnecessary software or training costs. For the retailer's roughly 2 million monthly transactions, manual calculation is not feasible in a reasonable time, so ICT/database software is essential, although any formula error could then affect a huge number of records, so results should still be checked. Overall, the best method depends on the scale of the data, rather than one method always being better.













