No. 

Criteria 

Maximum  

Mark

Candidate Mark

1.1 

Font and alignment 

• More than half of document's font size changed to 12 ✔
• More than half of document's alignment changed to  justified ✔

1 

1

2

1.2 

WordArt 

• Heading changed to any WordArt ✔
• Text filled with any green colour ✔ (mark from WordArt  settings, accept green gradient fill)
• Text outline set to 3 pt ✔ (mark from WordArt settings)

1 

1 

1

3

1.3 

Find and replace 

• Symbols '㜀' replaced ✔
• With 'fi' ✔ (ignore quotation marks)
• 9 replacements made ✔

1 

1 

1

3

1.4 

Citation 

• Any citation inserted ✔ on the text 
• Citation refers to website source ✔
• Only the title displayed ✔

1 

1 

1

3

1.5 

Footnote 

• Footnote inserted on text 'soda bread' ✔
• Custom mark is '♣' symbol ✔
• Footnote text entered ✔ ('Bread without yeast')

1 

1 

1

3

1.6 

Bullets 

• Image 1StPat used as bullet ✔
• Bullet position 0.5 cm from margin ✔
• Text indent 2 cm from bullet ✔

1 

1 

1

3

1.7 

Table 

• Table with 2 columns inserted ✔
• First column width changed to 3 cm ✔ (allocate mark for  column instead of table) 
• Paragraph setting 'Keep with next' applied (or first two  rows) ✔ (accept Paragraph setting 'Page break before')

1 

1 

1

3

1.8 

Heading 1 style 

• Font changed to small caps ✔ in green ✔
• Paragraph spacing 'after' set to 12 pt ✔
• All 4 changes automatically applied ✔

2 

1 

1

4

1.9 

Synonym 

• Word 'celebrations' replaced by any word from list  (revels, revelries, merriments, festivities, partying,  carousing, parties, fetes) ✔ 

1

1

1.10 

Linked object 

• Link to 1Luck image file inserted ✔ (Alt+F9, accept  hyperlink)
• Appears as an icon ✔

1 

1

2

1.11 

Date and format 

• Format of date changed to dd MMM yyyy ✔ 

1

1

Total for QUESTION 1 

[28]

No. 

Criteria 

Maximum  

Mark

Candidate Mark

2.1 

Table of contents 

• Automatic table of contents inserted ✔
• Displays only one level ✔ (no Bibliography/Table of  figures)
• Style of second heading changed to 'Heading 1' ✔
• '2. The leaning tower of Pisa, Italy' appears in the table  of contents ✔

1 

1 

1 

1

4

2.2 

Crop and format picture 

• Picture cropped OR colour changed to black ✔
• Any shadow effect added to the picture ✔

1 

1

2

2.3 

Caption and comment (Picture below 6. Selfridges)

• Figure caption added to picture ✔
• Caption text 'Photograph by Nala Rewop' ✔
• Comment deleted ✔

1 

1 

1

3

2.4 

Orientation 

• Any/All pages appear in landscape orientation ✔
• Only selected text in landscape orientation ✔
• Text entered in any footer ✔ ('Table mountain') on specific page only ✔

1 

1 

1 

1

4

2.5 

Bookmark and hyperlink 

• Hyperlink inserted on 'Day' ✔
• Hyperlink linked to bookmark March ✔

1 

1

2

2.6 

Sources and bibliography 

• 'Month Accessed' changed to July ✔ ('History' source)
• Source 'Tourism Ireland announces Global Greening  line-up for St Patrick's Day' removed ✔
• Bibliography updated ✔ (see 'Big Becky')

1 

1 

1

3

2.7 

Table of figures 

• Automatic table of figures inserted ✔
• Labels and figure numbers excluded ✔

1 

1

2

2.8 

NumWords field 

• Number of words field inserted ✔ (NumWords)
• Total number of words shown ✔ 

(Note to marker: Number of words may differ depending  on what was done previously in the question. Accept any  number between 1075 and 1150.)

1 

1

2

Total for QUESTION 2 

[22]

No. 

Criteria 

Maximum  

Mark

Candidate Mark

Spending worksheet 
NOTE: Sort the worksheet on column B before marking.

3.1 

Cell A1: 

• Data vertically centred ✔ 

1

1

3.2 

Page setup: 

• Left margin set to 2 cm ✔
• Worksheet horizontally centred on page ✔
• Row 2 set to repeat on top of pages ✔

1 

1 

1

3

3.3 

Column A: 

• All or some identifying codes continued ✔ 

1

1

3.4 

Cell H3: 
=G3*$I$1 

• G3 ✔
• * ✔
• I1 ✔ (OR $I$1)
• Displays in South African currency ✔
• Absolute cell reference used ✔

1 

1 

1 

1 

1

5

3.5 

Cell I4: 
=IF(D4="Wear Green", IF(E4="Accessories", "Green"," ")," ") 

OR 

=IF(E4="Accessories", IF(D4="Wear Green",  "Green"," ")," ") 

OR 

=IF(D4<>"Wear Green", " ",  
IF(E4="Accessories","Green"," ")) 

OR 

=IF(AND(D4="Wear Green", 

E4="Accessories"),"Green"," ") 

• Nested IF/IF function used ✔
• Criteria 1: "Wear Green" ✔
• Criteria 2: "Accessories" ✔
• Correct result for both criteria being met: "Green" ✔
• Correct result if either/both criteria not being met: " " ✔ ∙
• ested IF constructed correctly ✔ (OR IF/AND used  correctly)

1 

1 

1 

1 

1 

1

6

3.6 

Cell M3: 
=AVERAGE(G3:G102) OR =AVERAGE (G:G) 

• AVERAGE function ✔
• Range: (G3:G102) ✔

1 

1

2

3.7 

Cell M4: 
=SUMIF(E3:E102,"Snacks", G3:G102) OR  
=SUMIF(E:E,"Snacks","G:G) OR 
=SUMIFS(G3:G102, E3:E102, "Snacks") 

• SUMIF(S) function ✔
• Criteria range: E3:E102 ✔
• Criteria: "Snacks" ✔
• Sum range:G3:G102 ✔

1 

1 

1 

1

4

3.8 

Cell M5: 
=COUNTIF(D3:D102,"*party*") 

• Criteria: * ✔ party* ✔ 

2

2

Green worksheet

3.9 

Filter and copy to new worksheet 

•  Filtered/sorted on column F ✔
• Filtered/sorted data ('online') displayed in Green  worksheet ✔ (15 items expected)

1 

1

2

Total for QUESTION 3 

[26]

No. 

Criteria 

Maximum  

Mark

Candidate 

Mark

List worksheet

4.1 

Cell E3: 
=D3-C3 OR =DAYS(D3,C3) OR =DAYS360(D3,C3) OR  =DAY(D3)-DAY(C3) 

• D3 OR DAYS OR DAYS360 ✔
• -C3 OR (D3,C3) ✔

1 

1

2

4.2 

Cell H4: 

=VLOOKUP(G4,Codes!$A$2:$B$10,2) 

OR 

=VLOOKUP(G4,Codes!$A$1:$B$10,2) 

OR 

=LOOKUP(G4,Codes!$A$2:$B$10) 

• VLOOKUP/LOOKUP function ✔
• Lookup value: G4 ✔
• Lookup table: Codes!A2:B10 ✔ (ignore absolute cell  referencing)
• Column index number: 2 ✔

1 

1 

1 

1

4

4.3 

Cell I5: 

=LOWER(CONCATENATE(LEFT(B5,1),RIGHT(A5,4), "@stp.co.",H5)) 

OR 

=LOWER(LEFT(B5,1)&RIGHT(A5,4)&"@stp.co."&H5) 

• LOWER ✔ () 
• LEFT ✔ (B5,1) ✔ (accept (B5))
• RIGHT ✔ (A5,4) ✔
• "@stp.co." (no mark as it's already provided) ∙ H5 ✔ 

(Note to marker: Accept any other options that will yield  the correct answer.)

1 

2 

2 

1

6

Summary worksheet

4.4 

Cell C1: 

=IF(SUM(B2:B21)=COUNTA(List!A3:A102),"True",  "False") 

OR 

=SUM(B2:B21)=COUNTA(List!A3:A102) 

• IF statement ✔
• SUM(B2:B21) = COUNTA ✔ (List!A3:A120) ✔ (columns A, B, C, D, F & G can also be used) ∙ Value if condition true: "True" ✔
• Value if condition false: "False" ✔

1 

2 

1 

1

5

4.5 

Cells A23:B43:  

• Duplicates removed ✔ 
  • UK 36
  • South Africa 2
  • USA 11
  • Canada 12
  • Russia 16
  • Italy 8
  • Korea 5
  • Australia 6
  • Japan 4

1

1

4.6 

Chart/Graph: 

• Chart/Graph type changed to bar ✔
• Data selection changed to include only Chicago, New  York and Washington ✔
• Data series gap width set to 40% ✔
• Data series fill set to vary colours by point ✔
• Data labels displayed ✔ with dash style border ✔ (Note to marker: If a new chart/graph was created do  not allocate the first two marks.)

1 

1 

1 

1 

2

6

Total for QUESTION 4 

[24]

No. 

Criteria 

Maximum  

Mark

Candidate Mark

Table: tbGroups

5.1.1 

Field: GroupId 

• Field ID renamed to GroupID ✔ 

1

1

5.1.2 

Field: Artist 

• Combo box/List box added ✔
• Row source: Soloist, Group, Band ✔

1 

1

2

5.1.3 

Field: Manager 

• Format set to uppercase: > ✔ 

1

1

5.1.4 

Field: CellNo 

Input Mask: "+27"00\ 0000000 

• "+27" ✔
• 00 and space ✔ (do not accept 9)
• 0000000 ✔ (allocate this mark if 9 was used)

1 

1 

1

3

5.1.5 

Field: Available 

•  Format changed to Yes/No ✔ 

1

1

5.1.6 

Field: DateBooked 

• Validation rule: Between #2018/03/14# ✔ AND ✔ #2018/03/17# ✔ (format of the date may differ) OR >=#3/14/2018# AND <=#3/17/2018#
  OR >#3/13/2018# AND <#3/18/2018#
  OR Between "2018/03/14" AND "2018/03/17" OR Between DateSerial(2018,03,14) AND  DateSerial(2018,03,17)
• Required property set to 'Yes' ✔

2 

1 

1

4

Form: frm5_2

5.2 

• Artist field displays in bold ✔
• Label inserted next to ReleaseDate field ✔ with help  for date format MMM-yy ✔ (allocate second mark if in  'ControlTip Text')
• NoOfCDsInShop field AND label deleted ✔

1 

1 

1 

1

4

Query: qry5_3

5.3 

• Sorted by Title field ✔ in ascending order ✔
• ReleaseDate criteria: Is Null ✔
• OR operator ✔
• NoOfCDsInShop criteria: 0 OR <1 ✔ 

(Note to marker: 36 records expected.)

2 

1 

1 

1

5

Query: qry5_4

5.4 

•  Displays Artist, CountOfTitle and LastOfReleaseDate fields ✔
• Artist field: Group By selected in Total row ✔
• Title field: COUNT selected in Total row ✔ and criteria  set to >1 ✔
• ReleaseDate field: LAST selected in Total row ✔ (Note to marker: 14 records expected.)

1 

1 

1 

1 

1

5

Query: qry5_5

5.5 

• Fields displayed: Title, Format, Price ✔
• Format field criteria: Tape ✔ OR ✔ DVD ✔
• Total row ✔ included in datasheet view
• Displayed as SUM ✔ 

(Note to marker: 8 records expected.)

1 

3 

1 

1

6

Report: rpt5_6

5.6 

• Data source changed to qry5_6 ✔
• ZARPrice field inserted ✔ in Detail section ✔
• Label ('ZARPrice') added to the page header ✔
• Grouping on Artist field ✔
• Function in Artist group footer/group header ✔ =Count ✔ ([Title]) ✔ OR Count(*)

1 

2 

1 

1 

1 

2

8

Total for QUESTION 5 

[40]

No. 

Criteria 

Maximum  

Mark

Candidate 

Mark

6.1 

Heading font and size: 

<h1 align = "center"><font face = "forte" size = "10">St  Patrick's Day</font></h1> 

• Font changed to 'Forte' ✔
• Font size set to 10 ✔
• Font tags correctly used ✔

1 

1 

1

3

6.2 

Table: Merge and alignment 
<tr Height = "80"> <!--Row-->  
 <td colspan="4" valign="top"><h2 align="center"> 

• Row 1 vertically aligned to the top ✔
• Row 1 merged over 4 columns ✔

1 

1

2

6.3 

Table row: Shading 
<tr bgcolor="white"> 

• Row 2 background colour changed ✔
• To white ✔

1 

1

2

6.4 

Bullets and type 
<td> 
<ol type="A"> 
<li>It's the day St Patrick was born</li> 
<li>It's the day St Patrick drove snakes out of  Ireland</li> 
<li>It's the day St Patrick died</li></ol> 
</td> 

• Ordered list tags inserted ✔
• Numbered type: A, B ✔

1 

1

2

6.5 

Tag copied 
<td><input type="text"></td> 

• Correct tag ✔
• Inserted in fourth column for question 1 (row 3) ✔

1 

1

2

6.6 

Link 
<a href="/6Rip.png">Look</a> 

• Hyperlink tags correctly inserted ✔ 

1

1

6.7 

Bold and italic 
<td><b>Where was St. Patrick born?</b></td> 

• <i> and </i> tags removed ✔
• <b> and </b> tags inserted ✔

1 

1

2

6.8 

Image 
<td><img src="/6Lep.png" Width="120" height="60" > </td> 

• src inserted ✔
• File extension .png added ✔

1 

1

2

6.9 

Table: column tags 
<td><b>6. According to legend, what should you never do  if you catch a leprechaun?</b></td> 
<td><ul> 
<li>Kiss him</li> 
<li>Take your eyes of him</li> 
<li>Tell your friends</li></ul></td> 
<td><input type = "text"></td> 
<td><img src="/6Eye.jpg" Width="120" height="60" > </td> 

• Opening column tags <td> included ✔
• Sixth question displays correctly ✔

1 

1

2

6.10 

Image editing 
<button style="background:green" type="submit"><img  src="/6Button.jpg" Width="30" Height="30"> SUBMIT</button>

• Width="30" ✔ (OR 30) 
• Height="30" ✔ (OR 30)

1 

1

2

Closing tag(s) or triangular brackets omitted or tags  incorrectly nested

-1

Total for QUESTION 6 

[20]

Mark 

Mark

7St

7.1.1 

Track changes 

• All track changes rejected ✔ (See Irish (not bold) and  heading 5)

1

1

7.1.2 

Comment 

• Comment inserted on word 'Biography' ✔
• Comment reads 'See source' ✔

1 

1

2

7.1.3 

Edit picture 

• Images ungrouped ✔ (allocate mark even if seventh image appears but the picture is ungrouped, allocate  mark if six images grouped)
• Seventh image removed from document ✔ (if seventh  image is not removed, but is not grouped with the six  images, allocate first two marks)
• Regroup remaining images ✔ (only six images)
• Seventh image saved as an image file ✔ (Saint)

1 

1 

1 

1

4

7.1.4 

Form controls 

• Text form field maximum length set to 30 ✔
• Drop-down form field: Dance added ✔ and list  displays in alphabetical order ✔
• Check box default changed to unchecked ✔
• Text form field inserted ✔ and type set to date ✔

1 

2 

1 

1 

1

6

7New

7.2 

Import 

• tbDanceArticles table imported ✔ to 7New ✔ (accept if new database was created)

1 

1

2

7Top

7.3 

Sort/Filter and delete table data 

• Gender: only females ✔
• Age: under 30 ✔
• Sorted according to amount ✔ in descending order of  amounts ✔
• Displays only top 10 records ✔

1 

1 

1 

1 

1

5

Total for QUESTION 7 

[20]

TOTAL 

180