QUESTION 1 File name: 1Health Total Q1: 25
No Criteria Maximum Mark Candidate Mark 1.1 Page size
1
1
1.2 Line spacing: 2nd paragraph – The following …
Line spacing set to Multiple, 1.15
1
1
1.3 Find and Replace: (Expect 5 occurrences)
Only exact/lowercase text 'ozone' replaced 'ozone' appears in Arial Narrow font 'ozone' appears in Bold and Italic
1 1 1
3
1.4 Text box: Nitrogen dioxide … from heart disease.
Text box inserted Size: 9 cm high by 8 cm wide All data moved into text box (No mark if copied) Text box top left corner aligned to 'air' (Inspection)
1 1 1 1
4
1.5 Columns: DOES IT MAKE … fuels and vehicles.
Text placed in two columns Width of first column set to 8 cm Width of space between columns 1 cm
1 1 1
β
1.6 Multilevel List: On the road … keeping windows closed. (Note to marker: Mark from ruler)
Multilevel List applied to given text Level 1: Format 1, 2, 3 (No full stop or bracket) Level 1: Aligned at 0 cm text indent at 1 cm Level 2: Format a), b), c) Level 2: Aligned at 1 cm text indent at 2 cm
1 1 2 1 2
7
1.7 Source changed: UK Health Department
1 1
2
1.8 Bibliography
(Any) automatic bibliography inserted
1
1
1.9 Watermark
Picture 1Clean watermark inserted Scale: 150%
1 1
2
1.10 Inspect document
1
1
Total for QUESTION 1 25
Check the accuracy and skill required before awarding a mark throughout. Ignore spelling in all cases where it would not have any impact on the answer. QUESTION 2 File name: 2Marine Total Q2: 20
No Criteria Maximum Mark Candidate Mark 2.1 Small caps: UNESCO: Marine Pollution
Font changed to Small caps 1 1 2.2 TOC
Table of Contents inserted Heading 1 style: 1st heading: 'Marine Pollution' 'Marine Pollution' at top of the next page
1 1 1
2.3 Hyphenation
Hyphenation options: None OR Paragraph formatting exceptions: Don't hyphenate 2.4 Caption: Picture 1: © Malik Naumann | Marine Photobank
Appropriate caption inserted (Alt + F9) Caption is the picture's Alt text: 2.5 Hyperlink: Picture 2: © Chris Deacutis
Hyperlink removed from picture (Right click on image to check if hyperlink is removed) 2.6 Image: Picture 4: © NOAA
Restored to original colour (Not greyscale) 2.7 Cross reference (Accept any picture & page no.)
Linked to (any) picture IOC UNESCO Only page number displays (Alt + F9) 2.8 Footnote
Footnote inserted on 'UNEP' Footnote numbering format set to A, B, C, … Footnote set to 'Restart each page' Footnote text inserted (Environment Programme) 2.9 Field: NumWords (Alt + F9) {NUMWORDS \*MERGEFORMAT}
2.10 Page numbering
Automatic page numbering in Tildes format Page numbering inserted in footer TOC page and cover page not numbered, third page starts as number ~1~ Page numbering continues on all remaining pages Total for QUESTION 2 20
QUESTION 3 File name: 3Projects Total Q3: 21
Mark the questions from the formulae and not the values/answers in the cell. Check against candidate's actual work (Cell references may differ, depending on the candidate's response). Candidate may use multiple formulae, cells or 'building blocks' to reach answers. Named ranges can be used instead of cell references. The answers must still be correct even if changes are made to the existing data. No Criteria Maximum Mark Candidate Mark Missions/Sheet1 worksheet 3.1 Cell A1: Picture
Picture 3Logo inserted Fits cell A1 (Mark by inspection)
1 1
2
3.2
Cell A3: Fill
Pattern fill is the same as cell A2
1
1
3.3
Worksheet renamed
Sheet1 worksheet renamed to Missions
1
1
3.4
Cell F3: =COUNTIF(F6:F55,">55000")
COUNTIF and range: (F6:F55) Criteria: ">55000" OR ">R55000" OR ">R55 000.00"
1 1
2
3.5
Column G: Conditional Formatting = $C6:$C55 ="Air" OR =$C6 = "Air"
Formula: =C6:C55 ="Air" Absolute cell referencing not applied to rows: $C6:$C55 OR C6:C55 Conditional formatting applied to G6:G55 Format: Any fill colour
2 1 1 1
5
3.6
Cell J6: =HLOOKUP(D6,Categories!$B$1:$D$2,2,TRUE) OR =LOOKUP(D6,Categories! $B$1:$D$2) OR =XLOOKUP(D6, Categories! $B$1:$D$1, Categories!$B$2:$D$2,,-1)
LOOKUP function appropriately structured (HLOOKUP OR LOOKUP OR XLOOKUP) Lookup value: D6 Table array: Categories!$B$1:$D$2 OR Categories!$A$1:$D$2 OR Categories!B1:D2 OR Categories!A1:D2 Row index number: 2
1 1 1 1
4
3.7
Cell K6: =IF(E6<TODAY(),"Complete",IF(E6-TODAY()<=60,"Notify","*")) OR =IF(E6>=TODAY(),IF((E6-TODAY())<=60, "Notify","*"),"Complete") OR =IF(E6<TODAY(),"Complete",IF(E6-TODAY()>60, "*","Notify")) OR =IF(DAYS(E6,TODAY())<0,"Complete", IF(DAYS(E6,TODAY())<=60,"Notify","*"))
Function: Nested IF First condition Output for first condition Second condition Output for second condition Output for third condition
1 1 1 1 1 1
6 Total for QUESTION 3 21
QUESTION 4 File name: 4Air Total Q4: 19
Related Items Mark the questions from the formulae and not the values/answers in the cell. Check against candidate's actual work (Cell references may differ, depending on the candidate's response). Candidate may use multiple formulae, cells or 'building blocks' to reach answers. Named ranges can be used instead of cell references. The answers must still be correct even if changes are made to the existing data. No Criteria Maximum Mark Candidate Mark Quality worksheet 4.1 Cell D3: =SMALL(E7:E153,2)
Function: SMALL Cell range: E7:E153 2
1 1 1
3 4.2 Cell B7: Data Validation
Data validation source: $J$7:$J$8
1
1 4.3 Cell G7: Text functions =LEFT($D$4,RIGHT(F7,1)) OR =LEFT($D$4,MID(F7,2,1)) OR =RIGHT($D$4,RIGHT(F7,1)) OR =MID($D$4,RIGHT(F7,1))
Combination of text functions Function: LEFT/RIGHT/MID From the text in cell D4 To extract correct number of characters from cell F7 (Note to marker: Accept other text functions such as REPT and TEXT if used correctly.)
1 1 1 1
4 4.4 Print area
Print area set to cell range: A6:H40
1
1 Graph worksheet 4.5 Cell H10 OR cell H2 =SUMIFS(Quality!H7:H153,Quality!C7:C153,"Eastern Cape",Quality!D7:D153,2018)
Sum range: Quality!H7:H153 Criteria range 1: Quality!C7:C153 Criteria 1: "Eastern Cape" Criteria range 2: Quality!D7:D153 Criteria 2: 2018 OR "2018" (Note to marker: Accept cell A2 or cell A10 if it refers to "Eastern Cape" and cell H1 if it refers to 2018.)
1 1 1 1 1
5 4.6 Chart/Graph
Bar chart/graph created Data selected: =Graph!$A$2:$A$10,Graph!$F$2:$F$10 OR =Graph!$A$1:$A$10,Graph!$F$1:$F$10 Bars display from smallest to largest Chart title: Health incidents in 2016 Data labels appear on outside end of each bar
1 1 1 1 1
5 Total for QUESTION 4 19
QUESTION 5 File name: 5Save Total Q5: 35
No Criteria Maximum Mark Candidate Mark Table: tbl5_1 5.1.1 Field: Coverage
Field size changed to Decimal
1
1
5.1.2 Field: PollutionType
Display control: Combo Box Row Source: 'Air', 'Land', 'Water'
1 1
5.1.3 Field: Level Validation rule: Between 100 And 1000 OR >=100 and <=1000 OR >99 and <1001
100 and above And 1000 and below
1 1 1
5.1.4 Field inserted
Field name: Evidence Field type: Attachment, Hyperlink
1 1
Form: frm5_2 5.2 Form heading changed to 'Survey' Only date appears in form foote Ion theme applied to the form YearBorn field format changed to Medium Date 1 2 1 1 Query: qry5_3 5.3 Group by RecyclingActivity Function AVG in DropOff Average value displays no decimal places 1 1 1 Query: qry5_4 5.4 Only Name, Surname, (YearBorn,) Knowledge, RecyclingActivity, DropOff fields display Sorted by Surname ascending Knowledge field criteria: 'Yes' OR RecyclingActivity field criteria: 'Very Active' AND DropOff field criteria: 15 (Expected number of records: 113) 1 1 1 1 1 1 1 Query: qry5_5 5.5 YearBorn field criteria: >#1990/12/31#OR >=#1991/01/01#OR YEAR([YearBorn])>1990 Calculated field: NewDrop:[DropOff]*10/100+[DropOff]OR [DropOff]*110/100OR [DropOff]*1.1OR [DropOff]+[DropOff]*0.1 NewDrop: [DropOff] * 10/100 + [DropOff] OR 110/100 OR 1.1 (Expected number of records: 58) 1
1 1 1 1
Report: rpt5_6 5.6 DropOff field inserted and moved to correct position Grouping inserted on RecyclingActivit Any colour applied to the page header Sorted by Surname Function inserted in group header =COUNT (*) OR any other field 1 1 1 1 1 2 Total for QUESTION 5 35
QUESTION 6 File name: 6_1Clean, 6_2Pollute Total Q6: 15
This question should be marked from the HTML code. Numerical attribute values and single words do not need to be in inverted commas. No Criteria Maximum Mark Candidate Mark 6_1Clean 6.1.1 Title tags <title>12345678</title>
Title tags Examination number inserted between two tags
1 1
2
6.1.2 Font colour: Heading: The Global Crisis … <h1><font color="red"> The Global Crisis of Plastic Pollution </font></h1>
1
1
6.1.3 Pictu re <img src="/6_1Plastic.jpg" height="200" width="300"/>
Attribute scr changed to src File extension png changed to jpg
1 1
2
6.1.4 Table: rowspan <table border="5" width="300" cellpadding="10"> <tr><td rowspan="3">Tons per year</td> <td>China</td>
Only column inserted <td…>…</td> Text 'Tons per year' inserted in first column Rowspan="3"
1 1 1
3
6_2Pollute 6.2 <body> <br/> <a href="/6_1Clean.html">Home Page</a> <h2>Types of pollution</h2> <hr size="5" color="Black"/> <ol> <li>Air pollution</li><ul type="square"> <li>Ground-level ozone</li> <li>Carbon monoxide</li> <li>Sulphur oxides</li> <li>Nitrogen oxides</li> <li>Lead</li> </ul> <li>Water pollution</li> <li>Light pollution</li> <li>Noise pollution</li> <li>Soil pollution</li> </ol> </body>
Hyperlink Tag for hyperlink correctly inserted Horizontal line Horizontal rule tag size="5" (Accept any size larger than "1") Unordered list <ul>…</ul> tags Type="square" <li>Lead</li>
1 1 1 1 1 1
6 Closing tag(s) or triangular brackets and nesting correctly used. 1 1 Total for QUESTION 6 15
QUESTION 7 File names: 7Letter, 7Merge, 7Date, 7Picture Total Q7: 15
No Criteria Maximum Mark Candidate Mark 7Letter, 7Merge 7.1.1 Form controls
Form field set to Current Date (Alt + F9, Form text Date) '7' and '14' options appear in drop-down form field control
1 1
2
7.1.2 Mail merge (Expect 21 letters)
7Letter linked to 7Company spreadsheet Recipients' list is filtered toLevel = very high Or OR contains 'high' Level = high Merge fields inserted for Company name and Level Mail merge completed (SELECT * from 'Sheet1$' WHERE 'Level'='very high' OR 'Level'='high'/'Level' LIKE '%high%')
1 1 1 1 1 1
6
7Date: Monthly worksheet 7.2 Cell D3: =IF(AND(B3="Low",MONTH(C3)=11),A3," ")
Criteria: Test if the level is low Criteria: Test if the month is 11
1 2
3
7.3 worksheet 7.3 Filter
Filtered on column A: Very High Filtered on column B: 2021 Names sorted alphabetically
1 1 1
3
7Picture 1 1 7.4 7Picture file extracted 15 TOTAL 150