Question 1
1 markLily has a spreadsheet with each student's name in column A and the same student's test mark in column B. She selects only column B and sorts the marks from highest to lowest.
Explain what problem this causes.
Model answer
Only the marks have been sorted, so the marks have moved but the names in column A have not. The marks are no longer next to the students who scored them, so every record may now be wrong. Lily should undo the sort and sort both columns together.
Explanation
Each row of a spreadsheet is one record, and the values in a row must stay together. Sorting one column on its own breaks every record, a common spreadsheet error that is easy to miss because the sorted column looks correct. Data that end up in the wrong order like this must be put right before processing.
Mark scheme
-
1 mark
B1 for the marks have been moved but the names have not, so the marks are no longer next to the correct students (each record has been split up and the data are now in the wrong order)
oe. Accept 'the names and marks no longer match'. B0 for 'the marks are now in order' (that is what she wanted) or 'the data are sorted wrongly' with no reference to the names.