Page 1016 - SUBSEC October 2017_Neat

Specific The effectiveness with which candidate(s) use(s) or Mark Maximum
Objective manipulate Allocation marks per
sub-section
S5: SO7 Sorting data in the spreadsheet (1)
 Data sorted in ascending/descending order as 1
required

S5: SO7 Extracting data (2)
 Simple filter in place 1
 Evidence of criteria (for example, B3<20) 1

S5:SO7 Pivot Tables (1)
 Use of pivot tables to summarise a large group of 1
data

S5: SO8 Charting operations (3)
 Ability to select required range of adjacent/non- 1
adjacent cell for use in a chart
 Appropriate chart such as bar/column chart, line 1
graph, pie chart
 Appropriate labelling of chart title, chart axes and/or 1
data labels

S5: SO9 Use of two or more sheets (1)
 Linking of cells in different sheets 1

CXC 30/G/SYLL 17 39