OCR F201 style 90 minutes 60 marks Original paper

Data Analytics F201 Paper A: Big Data and Machine Learning

A full length original paper sampling all five topic areas of F201, built around a logistics company instrumenting its fleet and warehouses with sensors.

Exam timer

Sit this to the clock. Working under time pressure is a separate skill from knowing the content, and it is the one most students never practise.

00:00

Instructions

  • Answer every question.
  • The marks tell you how many creditworthy points are wanted.
  • A calculator may be used.
  • Several questions ask you to calculate from a table. Show the substitution as well as the answer, because a wrong final figure with correct working still earns marks and a bare number does not.

Questions

Write a full answer to every question, then mark the whole paper at the end. Marking as you go teaches you far less.

60 marks
1State three characteristics of big data.3 marks
State

Mark scheme0 / 3
  • LOne valid characteristic
  • LA second, different characteristic
  • LA third, different characteristic
Model answer

Volume, velocity and variety.

The marker looks for key phrases. If you said it another way and it is still right, give yourself the mark.
2The company's vehicles each report location, fuel and engine data every second.Explain why this data cannot be handled by the overnight batch process the company uses for its orders.4 marks
Explain

Mark scheme0 / 4
  • LThe data arrives continuously rather than as a daily file
  • LA batch process runs on a schedule, so results are as old as the last run
  • LThe value of the data decays quickly
  • LAn example specific to this scenario
Model answer

Vehicle telemetry arrives continuously rather than as a file that is complete at a known moment, so there is no natural point at which a batch could run over a finished set. A batch process scheduled overnight means every answer is as old as the last run, and for this data that is the whole problem rather than an inconvenience: an engine fault pattern, a refrigeration unit losing temperature or a vehicle leaving its route are all worth knowing within seconds and worth nothing the following morning. The company needs stream processing, where each event is assessed as it arrives and an alert is raised while somebody can still act on it.

The marker looks for key phrases. If you said it another way and it is still right, give yourself the mark.
3Explain the difference between scaling up and scaling out, and state one cost of scaling out.4 marks
Explain

Mark scheme0 / 4
  • LScaling up means a more powerful single machine
  • LScaling out means more machines working together
  • LScaling up has a hard ceiling
  • LA genuine cost of scaling out
Model answer

Scaling up means replacing a machine with a more powerful one: more processors, more memory, more storage in the same box. Scaling out means adding more machines that work together as a cluster, with the data partitioned across them. Scaling up is simpler and it stops, because there is a largest machine available and no budget moves that ceiling, which is precisely where big data begins. The cost of scaling out is consistency: with data replicated across nodes, different replicas can briefly disagree after a write, so many distributed stores offer only eventual consistency, and every application has to be examined to see whether it can tolerate that. A vehicle's live position can; a fuel card balance cannot.

The marker looks for key phrases. If you said it another way and it is still right, give yourself the mark.
4The chart shows the total data the company holds.Describe the trend, estimate the figure for 2027, and give one caution about that estimate.5 marks
Describe
Line chart of data volume held, by yearA line chart of the total data held by one organisation in terabytes, by year. 2021: 12 terabytes. 2022: 19. 2023: 34. 2024: 68. 2025: 141. 2026: 310.Data held by one organisation, terabytesyearterabytes held202120222023202420252026010020030012193468141310

Mark scheme0 / 5
  • LIdentifies the growth as accelerating rather than steady
  • LQuotes figures from the chart
  • LNotes the roughly doubling pattern
  • LGives an estimate consistent with that pattern
  • LA valid caution about extrapolating
Model answer

The growth is accelerating rather than steady: the total roughly doubles each year, from 12 terabytes in 2021 to 19, 34, 68, 141 and 310, so the annual increase itself is growing, which on a linear axis gives the characteristic upward curve shown. Continuing that pattern gives an estimate of roughly 600 to 650 terabytes for 2027. The caution is that this is an extrapolation of a pattern with no stated cause: it assumes the same doubling continues, and growth of this kind usually stops for an ordinary reason, a retention policy, a budget ceiling, a change to what is logged, or simply the end of whatever rollout drove it. The estimate is useful for planning capacity headroom, not as a forecast to commit money against.

The marker looks for key phrases. If you said it another way and it is still right, give yourself the mark.
5Explain what is meant by moving the computation to the data, and why it matters at this scale.4 marks
Explain

Mark scheme0 / 4
  • LThe query is sent to the machines holding the data
  • LEach node processes its own partition in parallel
  • LOnly the small results are returned and combined
  • LBecause moving the data itself would be the bottleneck
Model answer

Instead of pulling a dataset to a machine that will analyse it, the query itself is sent to the machines that already hold the partitions, each one processes its own share locally and in parallel, and only the small partial results travel back to be combined. It matters at this scale because data has weight: moving hundreds of terabytes across a network takes days or weeks, so the transfer, rather than the processing, becomes the limit. Sending a query that is a few kilobytes and receiving a result that is a few kilobytes avoids that entirely, which is the organising idea behind every distributed processing framework.

The marker looks for key phrases. If you said it another way and it is still right, give yourself the mark.
6The company plotted its customers by how often they order and how much they spend, and the groups shown emerged without being specified in advance.Name the technique and the type of learning it is, and describe what the plot shows.5 marks
Name
Scatter plot of customers by visits and basket valueA scatter plot of customers, with visits per month from 0 to 15 along the horizontal axis and average basket value from 0 to 120 pounds up the vertical axis. The points fall into three separate groups with clear space between them: one group of about 24 customers with few visits and a low basket value, one group of about 22 customers with many visits and a low to moderate basket value, and one group of about 18 customers with a moderate number of visits and a high basket value. No group is labelled.Customers plotted by average basket value and visits per monthvisits per monthaverage basket (£)05101504080120

Mark scheme0 / 5
  • LNames the technique as clustering
  • LIdentifies it as unsupervised learning
  • LExplains why it is unsupervised
  • LDescribes the three groups
  • LCharacterises at least one group usefully
Model answer

The technique is clustering, and it is unsupervised learning, because no labels were supplied: nobody told the algorithm which customers belonged in which group, so the structure was discovered in the data rather than predicted against a known answer. The plot shows three clearly separated groups. One has few visits and a low average basket, which is the occasional small customer. One has many visits but still a low to moderate basket, which is the frequent top-up customer. One has a moderate number of visits with a high basket value, which is the smaller group that is probably worth the most per customer. The separation between them is wide enough that the groups are not an artefact of where the boundaries were drawn.

The marker looks for key phrases. If you said it another way and it is still right, give yourself the mark.
7The table shows the results of the company's fraud detection model.Calculate the precision and the recall. Show your working.4 marks
Calculate
Results table: results of the fraud model on 10,000 transactionsA two by two table of results. Of the cases that were actually fraud, 96 were predicted fraud and 24 were predicted genuine. Of the cases that were actually genuine, 304 were predicted fraud and 9,576 were predicted genuine. The total number of cases is 10,000.Results of the fraud model on 10,000 transactionsPREDICTED FRAUDPREDICTED GENUINEACTUALLYFRAUDACTUALLYGENUINE96243049,576Total cases: 10,000

Mark scheme0 / 4
  • LPrecision substitution: 96 / (96 + 304)
  • LPrecision stated as 24%
  • LRecall substitution: 96 / (96 + 24)
  • LRecall stated as 80%
Model answer

Precision is true positives divided by everything predicted positive: 96 / (96 + 304) = 96 / 400 = 0.24, which is 24%. Recall is true positives divided by everything that actually was positive: 96 / (96 + 24) = 96 / 120 = 0.80, which is 80%.

The marker looks for key phrases. If you said it another way and it is still right, give yourself the mark.
8Using your answers, explain what these two figures tell the company about its fraud model.4 marks
Explain

Mark scheme0 / 4
  • LRecall of 80% means most fraud is caught
  • LBut one fifth is still missed
  • LPrecision of 24% means most alerts are false alarms
  • LThe operational consequence of that
Model answer

A recall of 80% means the model finds four fifths of the genuine fraud, which is substantial, though the 24 cases it missed are real losses and the company should know what they have in common. The precision of 24% is the figure that shapes how the model can actually be used: of every hundred transactions it flags, roughly seventy six are perfectly genuine, so the 400 alerts contain 304 false alarms. If each alert blocks a card, the company annoys three honest customers for every fraud it stops; if each is reviewed by a person instead, that is 400 reviews to find 96 cases. Neither is fatal, but it means the model belongs in a review queue rather than wired directly to an automatic block, and raising precision should be the next piece of work.

The marker looks for key phrases. If you said it another way and it is still right, give yourself the mark.
9The chart shows the error of a model on its training data and on held-back validation data during training.Identify what is happening and state two things that could be done about it.6 marks
Identify
Training and validation error against epochA line chart of error against training epoch for one model, with two series over twelve epochs. The training set error falls steadily throughout: 0.62, 0.44, 0.33, 0.26, 0.21, 0.17, 0.14, 0.11, 0.09, 0.07, 0.05, 0.04. The validation set error falls at first and then rises: 0.64, 0.48, 0.38, 0.32, 0.29, 0.28, 0.29, 0.32, 0.36, 0.41, 0.47, 0.53.Error against training epoch, one modeltraining epocherror13579110.00.20.40.6training setvalidation set

Mark scheme0 / 6
  • LIdentifies overfitting
  • LSupports it from the chart: training error keeps falling
  • LWhile validation error turns and rises
  • LIdentifies roughly where it begins
  • LOne valid remedy
  • LA second, different valid remedy
Model answer

The model is overfitting. The training error falls continuously across all twelve epochs, from 0.62 down to 0.04, which looks like steady improvement. The validation error tells a different story: it falls to a minimum of about 0.28 at around epoch six and then turns and climbs steadily to 0.53, worse than it was at epoch three. From that turning point the model is no longer learning the pattern, it is learning the particular noise of the training set, and its performance on anything it has not seen is getting worse while its apparent performance improves. Two remedies: use early stopping, halting training at the epoch where validation error bottomed out and keeping that version rather than the final one; and reduce the model's capacity or train on more data, since a simpler model has less room to fit noise and more examples dilute it.

The marker looks for key phrases. If you said it another way and it is still right, give yourself the mark.
10State two sources of bias in a machine learning model.2 marks
State

Mark scheme0 / 2
  • LOne valid source
  • LA second, different source
Model answer

Historic bias, where the training data records past unfair human decisions, and sampling bias, where a group is under-represented in the training data.

The marker looks for key phrases. If you said it another way and it is still right, give yourself the mark.
11The company removes the driver's age and nationality from its model's inputs.Explain why this does not guarantee that the model is free from bias.4 marks
Explain

Mark scheme0 / 4
  • LOther fields act as proxies for the removed attribute
  • LA plausible example of a proxy here
  • LSo the model can still produce unequal outcomes
  • LThe outcome is what the law judges, not the feature list
Model answer

Removing a protected characteristic removes the label, not the information. Other fields in the data correlate with it: a postcode, a depot, years of service, which licence categories somebody holds or what shifts they work can all stand in for age or nationality closely enough for the model to reproduce the same pattern without ever seeing the attribute. The result is a model that discriminates in effect while appearing neutral on inspection, and under the Equality Act 2010 it is the outcome that matters rather than the intent or the feature list. The only way to know is to measure: compare the model's error and selection rates for each group separately, and treat a gap between them as a defect rather than as a statistic.

The marker looks for key phrases. If you said it another way and it is still right, give yourself the mark.
12The table compares the company's two data centres.Calculate the PUE of each site, and identify two changes Site A could make.5 marks
Calculate
Figures for two data centresA table comparing two data centres running the same workload. Total facility power: Site A 2,400 kilowatts, Site B 1,980 kilowatts. Power delivered to IT equipment: Site A 1,500 kilowatts, Site B 1,800 kilowatts. Renewable share of supply: Site A 20 per cent, Site B 85 per cent. Mean inlet temperature: Site A 18 degrees Celsius, Site B 27 degrees Celsius. Hardware refresh cycle: Site A 3 years, Site B 6 years. Idle servers out of 900: Site A 310, Site B 40.Two data centres, same workloadSite ASite BTotal facility power (kW)2,4001,980Power to IT equipment (kW)1,5001,800Renewable share of supply20%85%Mean inlet temperature18 °C27 °CHardware refresh cycle3 years6 yearsIdle servers (of 900)31040

Mark scheme0 / 5
  • LSite A substitution: 2400 / 1500
  • LSite A PUE stated as 1.6
  • LSite B PUE stated as 1.1
  • LOne valid change
  • LA second, different valid change
Model answer

PUE is total facility power divided by the power delivered to the IT equipment. Site A: 2,400 / 1,500 = 1.6, so 60% is spent on cooling and losses on top of the computing itself. Site B: 1,980 / 1,800 = 1.1, which is close to best practice. Two changes for Site A: raise the inlet temperature towards Site B's 27 degrees, since modern equipment is rated for it and cooling to 18 degrees is where most of that 60% overhead is going; and deal with the 310 idle servers out of 900, by consolidating those workloads through virtualisation and decommissioning the hardware, which removes power drawn for no work at all. Beyond those two, moving from a 20% to a higher renewable share would cut emissions without cutting consumption, and extending the three year refresh cycle would reduce the embodied carbon and e-waste.

The marker looks for key phrases. If you said it another way and it is still right, give yourself the mark.
13The company plans to expand its sensor programme to every vehicle and warehouse, and to use the data to predict breakdowns.Discuss the infrastructure and ethical issues this raises, and what the company should do about them.10 marks
Discuss

Mark scheme0 / 10
  • LThe volume and velocity of the expanded data is quantified or characterised
  • LEdge processing or aggregation is proposed
  • LNetwork bandwidth or connectivity is addressed
  • LA storage approach is named with a reason
  • LProcessing model: streaming for alerts, batch for training
  • LAn ethical issue about monitoring drivers is raised
  • LIt is developed, not just named
  • LModel limitations are addressed
  • LSpecific safeguards or governance are proposed
  • LA judgement about what matters most and why
Model answer

The infrastructure problem is one of rate rather than size. Every vehicle reporting each second produces a continuous stream that no overnight batch can serve, and the volumes compound quickly: the growth chart already shows the company's holdings doubling annually before this expansion. The design should therefore push work to the edge. A unit in each vehicle and warehouse applies threshold rules locally, so a fault raises an alert within milliseconds and keeps doing so when the vehicle is out of coverage, and aggregates the rest into minute level summaries with the mean, minimum, maximum and spread. Full resolution data is buffered and uploaded only around an event, which cuts the transmitted volume by a large factor and matters particularly for vehicles on mobile data, where bandwidth is both limited and metered. Centrally, the summaries belong in a time series store built for timestamped measurements, with the raw event windows in object storage as a lake for model training; alerts run as stream processing because their value decays in seconds, while model retraining runs as batch because it does not. Capacity planning should assume the growth continues, and a retention policy should be written at the start rather than after the bill arrives, since storing everything forever is both an expense and, under storage limitation, a compliance problem. The ethical issues are at least as significant and are easier to get wrong. Telemetry that monitors a vehicle also monitors the person driving it: speed, braking, breaks taken, time at each stop. That is personal data about an identifiable employee, so the company needs a lawful basis, a clear policy saying exactly what is collected and what it will and will not be used for, and it should consult drivers rather than announce it. The difference between a system that predicts a failing alternator and one that scores drivers is a decision about how the same data is used, and if drivers believe it is the second they will work to the measure rather than to the job. Model limitations need stating honestly too: a breakdown predictor will raise false alarms, which cost a wasted inspection, and miss failures, which cost a roadside recovery, so the threshold is a commercial judgement and the output should prompt a maintenance decision rather than automatically take a vehicle off the road. Performance will also drift as the fleet ages and vehicles are replaced, so it must be monitored and the model retrained. Of all of this, the governance of driver data is what the company should get right first. The technical problems are well understood and have standard answers; the trust of the people being measured is the part that cannot be bought back once it is lost, and a workforce that resents the system will find ways to defeat it long before the engineering becomes the limiting factor.

The marker looks for key phrases. If you said it another way and it is still right, give yourself the mark.
Machine mark 0 / 60
About this paper

This is an original paper written to match the structure, question style, command words and mark allocation of the real OCR F201 style assessment. It is not a past paper. Real past papers are the copyright of the exam board and cannot be republished here, so links to the official papers on the board's own site are provided on the exam papers page.