No 

Criteria 

Max 

✔ 

Mark

1.1 

• Left and bottom margins set to 1.5 cm.✔ 

1

1.2 

1.2.1 

• Heading “Save The Sea Turtles” added in the title  control on the cover page. ✔

1

1.2.2 

• AutoShape filled with the image 1_Save The Turtle✔
• Height and width set to exactly 8 cm. ✔✔ 

3

1.3 

• Condensed spacing applied to the heading “BASIC  FACTS ABOUT SEA TURTLES”. ✔ 

∙ Spacing is 1.5 pt. ✔

2

1.4 

∙ Drop Cap effect applied to the highlighted letter “S”  dropped over 4 lines. ✔ 

Distance from the text is 0.5 cm.✔

2

1.5 

Style 

• Yellow font colour applied to the existing style  “Sub Turtle”. ✔ 
• The rest of the text with the existing style is updated  automatically. ✔

2

1.6 

Columns 

•  Highlighted paragraphs placed in 2 columns with a line in  between. ✔
• Column spacing is set to 1.5 cm. ✔
• Applied column break after the first paragraph so that the  other three paragraphs are moved to the second column✔

3

1.7 

• Glow effect applied to the text box. ✔ 

1

1.8 

• Existing footnote changed to an endnote. ✔
• Endnote symbol changed to ‘*’ symbol. ✔

2

1.9 

• Cell spacing of the table changed to 0.5 cm✔
• Count✔
• (Above) ✔ function used 
  (Answer 7 – no marks if the answer is just typed)

3

1.10 

• Multilevel bullets applied to the list under the heading  Glossary (not just as a bullet). ✔
• Bullet 1.jpg used as first level. ✔
• And Bullet 2.jpg as second level respectively. ✔

`3

1.11 

Bibliography 

• Month edited and changed to August. ✔ 
• Comment inserted that reads Save Sea Turtles. ✔
  NB: check if it is updated in the bibliography as well.

2

1.12 

Page orientation  

• Orientation of only the last 2 pages changed to landscape.✔

1

1.13 

Table and Image caption 

• Outer table border changed to dashed line.✔
• Thickness is 4½ pt.✔ 
• Caption inserted to the correct image and it reads “Green  Sea Turtle”.✔

3

1.14 

• Inserted section break for the last 2 pages. ✔
• Page numbering applied in any format in the page  header.✔
• Numbering starts from 1 onwards. ✔

3

1.15 

• Hyperlink added to the word TOP OF THE DOCUMENT.✔
• Linked created to the top of the document. ✔ 

2

1.16 

• Watermark inserted only on the cover page (any correct  method can be awarded marks). ✔
• Watermark reads Billion Baby Turtles. ✔

2

No 

Criteria 

Max 

✔ 

Mark

2.1 

• Paragraph shading added to the heading "Sea Turtle  Observation Form”. ✔
• Any shade of green colour. ✔

2

2.2 

Text form field for the heading “How many turtles…”  formatted: 

• To accommodate 2 characters,✔
• with no decimals places displayed. ✔

2

2.3 

• “Select One Below” option added to the existing list. ✔
• That appears as the first option in the list. ✔

2

2.4 

• Date field changed to d MMMM yyyy format.✔ 

1

2.5 

• Image cropped to resemble as follows: ✔
  

1

2.6 

• Help text added to the cell number field.✔
• Text “Please Enter only 10 Digits” entered correctly. ✔

2

2.7 

• 14 cm right aligned tab applied✔
• With solid leader tabs✔
  NB: reduce 1 mark if not done for all the three headings.

2

2.8 

• Screentip for the email address ✔
• To read as “Help Us To Save SEA Turtles” ✔

2

No 

Criteria 

Max 

✔ 

Mark

Info worksheet

3.1 

Cell H1: 

• Date in cell H1 changed to dd mmm YY format. ✔                                    

1

3.2 

• Cells A1:G2 merged and centred. ✔ 

1

3.3 

Cell A3:O3 : 

• Thick cell borders applied. ✔
• Left and right borders of the cells changed. ✔

2  

3.4 

Row 3 freezed✔ 

1

3.5 

Cell A4: 
=CONCATENATE(B4,LEN(E4),"#code") 

OR 

=B4&LEN(E4)& "#code") 

• CONCATENATE function OR & sign✔
• B4 ✔
• LEN ✔ (E4) ✔
• “#code” ✔

5

3.6 

Cell H4: 
=ROUNDUP(($H$1-G4)/365.25,0) 

• ROUNDUP function ✔ 
• Use of correct cells H1 and G4✔
• Minus sign (-) used correctly✔
• Divided by 365.25 (or 365) ✔
• Absolute cell reference used ✔
• Formatted to zero decimal places✔
  (Note to marker: Accept any other suitable method.) 

6

3.7 

Cell N20: 
=(I20)*$I$2+(J20)*$J$2+(K20)*$K$2+(L20)*$L$2+(M20) 
*$M$2 

OR 

=I20*$I$2+J20*$J$2+K20*$K$2+L20*$L$2+M20*$M$2

• Values from I20:M20 correctly multiplied with values in  I2:M2 ✔
• + sign used correctly between the cells✔
• Absolute cell reference used ✔
  (Answer: R200)

3

3.8 

Conditional formatting: 

• Values between 200✔ and 250 shaded✔
• 2 colour shading applied✔

3

3.9 

Cell O4: 
=IF(($P$1-N4)<=0,"Adoption Cert",IF(($P$1-N4)>100,  "Participation Cert","-")) 

• IF function ✔ 
• Condition ($P$1-N4)<=0 and value ✔ 
• Condition ($P$1-N4)>100 and value ✔
• Value if all conditions are false ✔
• Absolute cell reference used ✔
• Correct use of open and closing brackets ✔

6

3.10 

Cell E51: 
=SUMIF(E4:E49,E5,N4:N49) 

OR 

=SUMIF(E4:E49, “Platinum”,N4:N49) 

• SUMIF function ✔
• Range E4:E49 ✔
• Criteria Platinum or any cell number that contains the  value Platinum ✔
• Sum range N4:N49 ✔
  (Answer: R1 640)

4

3.11 

Cell E52: 
=COUNTIF(F4:F49,F6)  

OR 

=COUNTIF(F4:F49, “SEE Turtles”) 

•  COUNTIF function ✔
• Range F4:F49 ✔ 
• Criteria SEE Turtles or any cell number that contains  the value SEE Turtles ✔
  (Answer: 8)

3

3.12 

Cell E53: 
=AVERAGEIF(D4:D49,D33,C4:C49) 

OR 

=AVERAGEIF(D4:D49, “F”,C4:C49) 

• AVERAGEIF function ✔
• Range D4:D49 ✔
• Criteria F or any cell number that contains the value F ✔
• Average range N4:N49 ✔
  (Answer: 17.3)

4

3.13 

Cell E54: 
=COUNTBLANK(J4:J49)+COUNTBLANK(L4:L49)

• COUNTBLANK function ✔ 
• Range J4:J49 and L4:L49✔
• + sign used correctly✔
  (Accept any correct method – answer is 44)

3

Spotted worksheet

3.14 

Cell B2: 
=VLOOKUP(A2,LOOKUP!$A$1:$B$95,2,FALSE)
OR 
=VLOOKUP(A2,LOOKUP!$A:$B,2,FALSE) 

• LOOKUP value: A2✔
• Table array: LOOKUP!$A$1:$B$95✔
• Absolute cell reference used✔
• Column index number: 2✔
• Range_Lookup: FALSE✔

5

Graph worksheet

3.15 

Graph 

• Data set for the year 2014 included in the graph. ✔              
• Series overlapping is set at -50ͦ.✔ 
• X axis name moved to the correct position. ✔
• Data labels displayed on top of each bar. ✔
• Minimum value for y axis set to 5. ✔

5

No 

Criteria 

Max 

✔ 

Mark

Table: Patient Details

4.1.1 

• Row height changed to standard height of 14.25. ✔ 

1

4.1.2 

• Gridlines are changed to red colour. ✔ 

1

4.1.3 

• The list Threatened moved ✔
• To the third position in the list. ✔

2

4.1.4 

• Data type for the diet field changed to MEMO/Long Text  data type.✔

1

4.1.5 

Scientific Name field: 

• Made as the required field ✔
• > symbol added in the format property field ✔

2

4.1.6 

Input mask for Turtle Id field: 
L00\*9a 

• L✔
• 00✔ 
• *✔ 
• 9✔ 
• a ✔

5

Turtle Images table and the frm4_2 form

4.2.1 

• Inserted the image Green sea turtle.jpg in the Turtle  Images table.✔
• Displays in the form frm4_2 correctly.✔

2

4.2.2 

• Turtle images table exported to the exam folder. ✔
• Name of the file changed to Export4_2. ✔

2

Query: qry4_3

4.3

• Criteria
  Total Species field:< 400 ✔ 

OR  

<=399 

• Criteria
  Diet field: Like "*jelly*" ✔And✔ Like "*crabs*"✔ 

(Answer: 3 records)

4

Query: qry4_4

4.4

• Criteria
  Turtle Name field: Between "G*" And "P*"
• Between And function used✔ 
• G* and P* ✔ 
• Sorted in the ascending order of Turtle Name field✔
• Criteria
  Weight in Pounds✔: Round✔
  ([weight(in kg)]/2.2046✔,1✔)
• (Answer: 9 records)

7

Form: frm4_5

4.5 

• Border width of the image changed to 4pt. ✔
• Shadow effect applied to the image.✔
• Command button inserted in the form footer✔ to exit  the form.✔
• Dividing lines are not visible. ✔
• Default form view changed to continuous.✔

6

Report: rpt4_6

4.6 

Report rpt4_6 created based on Classification Table 

• Turtle Name, Tag ID, Colour, Weight (in kg) & Listed  As are the only fields displayed.✔ 
• Report grouped based on Weight (in kg) field. ✔
• Grouping intervals set to 50s.✔
• Page numbering changed as shown below so that it will  not be displayed in the first page of the report. ✔ 
  
•  =Count✔ (IIf✔ ([listed as]="critically  endangered"✔,0✔))
• Proper label given for the calculation.✔

9

No 

Criteria 

Max 

✔ 

Mark

5.1 

Title 
<title> Save Sea Turtles </title> 

• ‘Save Sea Turtle' appears ✔
• In the browser tab ✔

2

5.2 

Horizontal Line Size 
<hr size="3" color="black"/> 

• Size changed to 6 that comes within the heading. ✔

1

5.3 

Image Tag 
<img src="/Baby Turtle.jpg" width="100%" height="45%" 
alt="Baby Turtle"> 

• Image tag added correctly ✔
• Image source is Baby Turtle.jpg✔
• Width is 100%✔
• Height is 45%✔
• Alternate text is Baby Turtle✔

5

5.4 

Bold formatting 
<b>Seven</b> 

• Seven made Bold ✔

1

5.5 

Unordered List Type 
<ul type="square"> 

• Attribute used is type ✔
• Attribute value for type is “square” ✔

2

5.6 

Table Heading 
<tr> 

<th colspan="2"> 

<h1>Most Endangered Sea Turtles In The World</h1> </th> 

</tr> 

• <tr> </tr> new row added ✔
• <th> </th> tag added between the <h1> </h1> tag✔
• Colspan=”2” added as an attribute to the <th> tag✔

3

5.7 

Table Row color and font color: 
<tr bgcolor="green"> 
<th><font color="white">Turtle Name</font></th> <th><font color="white">Scientific Name</font></th> </tr> 

• bgcolor attribute added after the <tr> tag to green✔
• <font> </font> added for both the headings with white  colour attribute. ✔

2

5.8 

Caption tag 
<centered><caption>Table 1:List Of Endangered Turtle  Species</caption></centered> 

• Caption tags used correctly✔
• Aligned to the bottom of the table✔
• Text inserted correctly and centred✔

3

5.9 

Link 
<a href="http://www.SEETURTLES.org"   
target="_blank">SEETurtles.org</a> 

• The hyperlink tag corrected to add the attribute href  before the website link. ✔                      

1

No 

Criteria 

Max 

✔ 

Mark

6.1 

Spotted By & Scientific Info worksheet 

• Worksheets 2 and 3 hidden ✔

1

6.2 

Find and Replace 

• Find and replace option used or any appropriate  method ✔
• turtle changed to TURTLE in uppercase ✔
• (NB: -1 if not done fully)

2

6.3 

Unique name 

• used conditional formatting to find the unique values in  the column✔
• Name of the person is Taylor✔

2

6.4 

Sorting 

• Sorted first based on the Scientific name field in the  descending order ✔
• Then in the ascending order of Spotted By field✔
• Name of the turtle is Black Marsh Turtle ✔

3

6.5 

Password 

• Cells A1:D1 protected✔ 
• With password 2017✔
  (NB: award zero marks if the whole worksheet is protected)

2

7_Certificate (Word processing document)

No 

Criteria 

Max 

✔ 

Mark

7.1 

Mail Merge: 

• Winners worksheet in 7_Winners List spreadsheet  used as the data source. ✔
• Placeholders linked with appropriate fields. ✔
• In correct position✔
• Edited the recipient list to include all the Platinum Members✔ and who achieved an adoption  certificate. ✔
• Saved the merged letter as 7_CertificateMerged in the  exam folder✔
  (4 letters expected)

6