18.2. Manipulate data
A subsection of Information and Communication Technology, 0417, through 18. Databases
Listing 1 of 1 questions
A computer system is being created to calculate the scores in a diving competition. Every dive by an athlete is awarded a score out of 10 by each judge. The system is being tested using live data. An athlete completes his dive with a difficulty of 3.4 and achieves the following scores, which are displayed in a spreadsheet. Before the overall score is calculated the judges’ scores need to be sorted into ascending order. Describe the steps that would be carried out to sort the data into ascending order. 1 10 Cell B12 contains the formula, ROUND((SUM(B5:B9)*D1),1). Explain what the formula in cell B12 does. The judges’ score column will be tested using normal, abnormal and extreme data. Explain, giving examples of test data which would be used, what is meant by: Abnormal test data Extreme test data [ 1 10
0417_m21_qp_12
THEORY
2021
Paper 1, Variant 2
View
Questions Discovered
1