Gce Model Questions Vol1 2025 Computer Studies Question 10

A school uses a spreadsheet to calculate each pupil's final grade before merging the results into a word‑processing document. The spreadsheet contains the following columns (all scores are out of 100): Test 1, Test 2, Assignment, Project, Extra Credit. The final numeric grade is computed as \[\text{Final}=0.2\times\text{Test1}+0.2\times\text{Test2}+0.1\times\text{Assignment}+0.3\times\text{Project}+5+\text{Extra Credit}.\] If the computed grade exceeds 100 it is capped at 100. The data for five students are: \[\begin{array}{lccccc} \text{Student}&\text{Test1}&\text{Test2}&\text{Assignment}&\text{Project}&\text{Extra Credit}\\\hline A&85&90&78&88&10\\ B&95&92&88&94&20\\ C&70&75&80&85&5\\ D&88&87&90&92&15\\ E&100&98&95&97&25 \end{array}\] How many students will have their final grade capped at 100? Provide the number as an integer.