Page 1015 - SUBSEC October 2017_Neat

WEB-BASED DESIGN (10 marks)

Specific Key Skills Mark Maximum
Objective The effectiveness with which the candidate(s) has/have Allocation marks per
used or applied sub-section
S4: SO9 Appropriate design features to create a simple web page (3)
 Inclusion of graphics and text 1
 Appropriate use of text 1
 Appropriate use of graphics 1

S4: SO9 Web page for intended audience (2)
 Layout suitable for intended audience 1
 Mostly suitable for intended audience 1

S4: SO12 Consistent Information on the page specific with (3)
requirements
 Majority of information consistent with requirements 3
 Somewhat consistent with requirements 2
 A few aspects are consistent with requirements 1

S4: SO11 Hyperlinks (2)
The presence of a link for any TWO of the following:
 link to another web page;
 link to a location within the web page;
 link to an email address; and,
 link to user-created files.

SPREADSHEET – 20 marks

Specific The effectiveness with which candidate(s) use(s) or Mark Maximum
Objective manipulate Allocation marks per
sub-section
S5: SO3 Pre-defined systems functions – 1 mark each for correct use (3)
of any THREE functions
 Correct use of any THREE different functions 3

S5: SO4 Arithmetic formulas – 1 mark each for any THREE formulas (3)
 Correct use of any THREE different formulas 3

S5: SO5 Replicate formulas into other cells (2)
 Use of absolute addressing or range names (two 2
different examples)

S5: SO6 Spreadsheet formatting (4)
 Any TWO: Decimal place, currency, comma, 2
percentage features
 Justified, left, right, centre, font or font size 1
 Advanced use such as merging cells, wrap text 1

CXC 30/G/SYLL 17 38