Style

• Font colour changed to red✓
• Set to Underline

Dropped Cap

• Dropped cap applied on ‘A’ ✓
• Applied over 3 lines ✓
• Spacing set to 0.5 cm from text ✓

Paragraph formatting

• Line spacing set to 1.5 pt ✓
• Paragraph is justified ✓

Hyperlink

• Hyperlink set ✓
• Linked to the heading History of Triathlon in South Africa ✓

Bullets

• 1_Picture.jpg used as a bullet ✓
• List indents set to a space after number ✓

Table

• Text converted to table ✓
• Table has 4 columns✓
• Table style Grid Table 4 Accent 2 applied ✓
• Change row height of all rows ✓
• To exactly 1 cm ✓
• Contents of the table centred vertically ✓

Picture

• 1_Triathlon.png inserted✓
• Correct caption applied ✓
• Table of figures updated ✓

Footnote

• Footnote added ✓
• Footnote added below text ✓
• Footnote text is ‘www.triathlonsa.co.za’ ✓

Numbering

• Automatic numbering applied to References ✓
• Alphabets are used in numbering ✓

Page numbering

• Page numbers inserted in the footer ✓
• Page numbers are centre aligned ✓
• Numbering starts as 1 on the Table of Contents page ✓
• Formatted as Page1 of 1 style✓
• Odd page numbers aligned on the left ✓
• Even page numbers aligned on the right ✓

Watermark

• Picture scale set to 500% ✓
• Washout effect removed ✓

WordArt

• Stop text effect transformation applied ✓
• to the WordArt✓

Picture

• Picture centre aligned ✓
• Picture is the same size as other pictures (3.3cm x 4.4 cm) ✓
• Glow 18 Point Orange picture effect applied ✓
• Picture effect applied to all pictures ✓

Shapes

• Horizontal scroll shape inserted ✓
• with Light 1 outline ✓
• with Orange fill Accent 2✓
• and text ‘It’s a showdown!’ inserted. ✓

Freeze panes

• Freeze pane effect applied ✓
• Correct Row (Row 3)✓

Cell A4
=CONCATENATE (C4,"/", randbetween(1,999),"/",2018)
Or
=CONCATENATE (C4,"/", Q4,"/",2018)

• Function: Concatenate ✓
• Cell C4✓
• / ✓
• Randbetween(1,999) ✓
• Current year 2018 ✓
• Function in Cell A4 copied down✓

(Note to marker: Q4 or any relevant cell used for random values.)

Column K : Conditional Formatting

• Conditional formatting applied to column K ✓
• Bottom criterion used ✓
• Bottom 3 athletes shaded in blue ✓

Cell M5
=VLOOKUP(K5,Table!$A$1:$B$5,2)

• Lookup value: K5 ✓
• Lookup range: Table!$A$1:$B$5✓
• Absolute cell reference on the entire range ✓
• Correct column: 2 ✓

Cell N6
=IF(M6="Platinum",10000,IF(M6="Gold",8000,IF(M6="Silver
",5000,IF(M6="Bronze",3000,"-"))))

• Nested IF function correctly used ✓
• Condition for Platinum and Gold ✓
• Condition for Silver and Bronze ✓
• Value false ✓

Cell O4
=K4-(G4+I4)

• =K4 Minus sign (-) ✓
• (G4+I4) ✓
• Correct use of brackets ✓

Cell L72
=SUMIF(C4:C70,"ZIM",L4:L70)

• Function: SUMIF ✓
• Criteria range: C4:C72 ✓
• Criteria: "ZIM” ✓
• Sum range: L4:L70 ✓

Cell L74
=(countif(C4:C70, “ZIM”)*1000)-L72

• Function: Countif ✓
• Range: C4:C70 ✓
• Criteria: ZIM ✓
• *1000 ✓
• Minus sign (-)✓
• L72 ✓

(Note to marker : 13000 (13 ZIM athletes X 1000)

Cell L76
=COUNTBLANK(L4:L70)

• Function: Countblank ✓
• Criteria range (L4:L70) ✓

Cell K78
=AVERAGE(K4:K70)

• Average function ✓
• Criteria range (K4:K70) ✓

Cell K80
=MODE.SNGL(K4:K70)

• Mode function ✓
• Criteria range (K4:K70) ✓

Cell K84
=COUNTIFS(F4:F70,"<00:07:00",H4:H70,"<00:22:00")

• Function: COUNTIFS ✓
• Criteria range1: F4:F70 ✓
• Criteria 1: "<00:07:00", ✓
• Criteria range 2: H4:H70 ✓
• Criteria 2: "<00:22:00" ✓

Graph Worksheet

• Chart / Graph title changed to Triathlon

Championships ✓

• Vertical axis title ‘Time’ added ✓
• Horizontal axis rotated to 270 degrees ✓
• Legend series edited ✓
• Gradient Fill applied in the chart area ✓
• Graph moved to a new sheet called Triathlon ✓

Field: Athlete Code

• >LLL000LL;;
• Capital letters: >✓
• LLL – three compulsory letters ✓
• 000 – three compulsory digits✓
• LL – two compulsory letters ✓

Province Field

• ‘ZIM’ added in Row Source ✓
• ‘ZIM’ is first on the list ✓

Last RaceField

• LastRace field set as required ✓
• Validation rule: >#2015/01/01# ✓
• Appropriate validation text added ✓

Form: frm4_2

• Background colour of the form changed to ‘Blue’ ✓
• Title changed to ‘Results Championship’ ✓
• Picture 4_Logo inserted ✓
• Picture aligned on the right ✓
• Action Button added ✓
• Action button closes the form ✓

Qry4_3

• Criteria Age field: Between 20 And 30 ✓
• Criteria Gender field: M ✓
• Criteria Cell number field: 084* ✓
• Fields Gender and Age do not show ✓
• Sorted: Athlete Name field ✓

Qry4_4

• Province / Nationality: Total: Grouped by ✓
• Registration Fee: Total: Sum ✓
• Criteria: ZIM ✓

Qry4_5
Refund: [Registration Fee]*10/100+100

• Calculated field name: Refund ✓
• [Registration Fee] ✓
• * ✓
• 10/100 ✓ or 0.1
• +100 ✓

Report4_6

• Report is created with all the required fields ✓
• Report is grouped according to Province / Nationality field ✓
• Then is grouped according to Gender field✓
• Report sorted according to the Athlete Name field ✓
• Set to landscape ✓
• Calculation on the footer of the Gender field: ✓
• =Sum([Registration Fee]) ✓
• Total amount is in any currency format ✓

Title
<title>Triathlon</title>

• Title tag added ✓
• Triathlon appears on the browser ✓

Heading: Triathlon
<h1 align ="center"><font color = "red">
Triathlon</font></h1>

• Heading centred ✓
• Font colour changed to red ✓

Horizontal line
<hr color = "red" width =50%>

• Size of line changed to 50% ✓
• Line colour changed to red ✓

Bulleted list
<ul type = Square></ul>

• Unordered list <ul> created✓
• Type of bullet set to square ✓

Picture and Border
<p align = "center" ><img src ="5_Picture.jpg" border
="5" alt = "Swimming" height = 200 width = 300></p>

• Correct picture used ✓
• Swimming shows when the picture is not displaying (Alt=Swimming) ✓
• Picture aligned to centred✓
• Border around picture 5 pt ✓

Table

• First row added – <th> ✓
• Correct text added ✓

<tr>
<th>Time</th>
<th>Medal</th>
<th>Prize</th>
</tr>

• Table border set at 1 ✓
• Cellpadding set at 10 ✓

<table border = 1 cellpadding = "10">

• Colspan = “3” ✓

<tr><td colspan ="3" > Good Luck </td></tr>

Link
<a href = "2018 Race.pdf"> another race </a>

• <a href> </a> ✓
• Link created on the text ‘another race’ ✓
• Link opens ‘2018 Race.pdf’ ✓

Date

• Today’s date inserted ✓
• Does not update ✓

Comment

• International changed to National ✓
• Comment deleted ✓

Tabs

• Leader tabs/tab set to approximately 5 cm, 10 cm and 15 cm ✓
• Only left and right tabs used ✓
• Tab leaders added in two cases ✓
• All tabs correctly applied ✓

Mail Merge

• Both Surname and Name merge fields inserted in correct positions ✓
• Filtering applied to athletes who are from RSA ✓
• Letters sorted in alphabetical order according to last name ✓
• Mail Merge is completed and saved as 6_Merged Letters✓

(Note to marker: Expect 06 letters.)

Spell check
Color replaced with colour (Spell Check changed to English South Africa)

Link
Pdf icon on the shape links the file” 7_Nutritional
Requirements of an Athlete.pdf”