Spreadsheets and ICT (Higher)
Spreadsheets and ICT is the use of computer software, such as a spreadsheet program, to enter, store and process statistical data, applying built-in functions to calculate summary statistics and produce charts automatically. In GCSE Statistics this means knowing formulas such as AVERAGE and MEDIAN, and explaining the advantages and limitations of using ICT compared with calculating by hand.
Before you start
Make sure you're comfortable with these topics first:
Method
- Identify which built-in function calculates the statistic needed, for example AVERAGE for the mean, MEDIAN for the median, STDEV for the standard deviation, or COUNTIF for a frequency.
- Enter the raw data into a single, continuous range of cells (a column or row) so a formula can reference the whole range at once.
- Use a sorting tool, or a function that does this automatically, before finding a median or quartiles by hand.
- Choose an appropriate chart type from the software's chart tool to match the data, for example a bar chart for categorical data or a scatter graph for bivariate data.
- When asked to discuss ICT, give a genuine advantage (speed, accuracy, automatic recalculation, easy to produce charts) or disadvantage (cost of software or training, data entry errors go unnoticed, no human judgement) rather than a vague statement.
- Estimate the expected size of the answer before trusting the software's output, so a data entry or formula mistake is easy to spot.
Worked example
A spreadsheet contains the exam marks of 30 students in cells B2 to B31. State the spreadsheet formula that would calculate the mean mark, and give one advantage of using a spreadsheet rather than a calculator for this task.
- The mean is calculated with the AVERAGE function, applied to the whole range of data.
- Formula: =AVERAGE(B2:B31).
- Advantage: a spreadsheet processes all 30 values instantly and automatically recalculates the mean if any mark is corrected or added, reducing the chance of an arithmetic error.
- Final answer: =AVERAGE(B2:B31); advantage - faster and less error-prone than adding 30 values by hand, and it updates automatically if the data changes.
Practice questions
Try each question, then tap to reveal the answer.
Q1Which spreadsheet function would you use to find the mean of the values in cells A1:A20?Show answer
Answer: =AVERAGE(A1:A20)
Q2Which function counts how many values in the range B2:B50 are equal to 'Yes'?Show answer
Answer: =COUNTIF(B2:B50,"Yes")
Q3A spreadsheet has 40 pieces of data in cells C2:C41. Give the formula to find the median.Show answer
Answer: =MEDIAN(C2:C41)
Q4State one advantage of entering raw data into a spreadsheet rather than calculating statistics by hand.Show answer
Answer: It is much faster and less likely to contain arithmetic errors (accept any valid advantage, e.g. formulas update automatically)
Q5State one disadvantage of relying on ICT and spreadsheets to process statistical data.Show answer
Answer: Errors made when entering the raw data can easily go unnoticed, since the formulas will still calculate an answer (accept any valid disadvantage, e.g. training or software cost)
Q6A spreadsheet has the heights, in cm, of 25 plants in cells D2:D26. Give the formula for the range of heights.Show answer
Answer: =MAX(D2:D26)-MIN(D2:D26)
Exam-style questions
Written in the style of a GCSE Statistics exam paper, with a full mark scheme.
A spreadsheet contains the delivery times, in minutes, of 60 parcels in cells B2 to B61. Write down (a) the spreadsheet function used to find the mean delivery time and (b) the spreadsheet function used to find the standard deviation of the delivery times.
Show mark scheme
Tick each line you got. Your score builds from the marks on the scheme.
Nothing ticked yet - 2 available
Give three reasons why a company might prefer to use a spreadsheet, rather than manual calculation, to process the results of a large customer satisfaction survey.
Show mark scheme
Tick each line you got. Your score builds from the marks on the scheme.
Nothing ticked yet - 3 available
A spreadsheet contains the number of hours 15 employees worked overtime in one week, in cells C2:C16. The formula =AVERAGE(C2:C16) returns 6.4 and the formula =MEDIAN(C2:C16) returns 5. (a) Explain what these two values suggest about the shape of the distribution of overtime hours. (b) State one advantage of using a spreadsheet to find these values rather than calculating them by hand.
Show mark scheme
Tick each line you got. Your score builds from the marks on the scheme.
Nothing ticked yet - 4 available
See real GCSE Statistics past-paper questions, with official mark schemes →
Free printable worksheet
Want more practice on paper? Download the spreadsheets and ict (higher) worksheet pack - 16 pages of exam-style questions with a full mark scheme. One email opens every download in this browser for 14 days - no account, no card. Print it for personal and classroom use.
This topic is chapter 12 of GCSE Statistics Higher Workbook 1, the whole course as one free printable PDF.
Next topics
Not quite what you needed?
Tell us what is missing on spreadsheets and ict (higher), or which topic to write up next. Every request is read, and we reply to every one.
Build a full practice pack.
This topic is one of hundreds in the library - pick the ones a student needs and generate a printable PDF in minutes.