No.

Criteria

Maximum Mark

1.1.1

Cover Page

• Year changed to 2020 using the text control.

1

1

1.1.2

Cover Page

• And rotated 90 degrees.

1

1

1.2.1

Table of Contents

• Text set to Normal Style
• Only the text not heading changed
• Text not in ToC anymore

1

1

1

3

1.2.2

Style

• Style modified to blue
• Spacing after paragraph set to 12pt

1

1

2

1.3

Find and Replace

• All occurrences of 4th Industrial Revolution replaced by 4IR.
• All occurrences (5 Occurrences)

1

1

2

1.4

Border

• Yellow border applied
• 2pt border
• an Offset Top shadow effect added to the image

1

1

1

3

1.5

Picture

• Picture has been wrapped tight, square or through
• Moved to the right of the paragraph
• Figure 2 has been moved below the picture

1

1

1

3

1.6

Endnote

• Endnote inserted in the correct place
• Text: “Founder and Executive Chairman of the World Economic Forum” typed in

1

1

2

1.7

Citation

1

1

1

3

Journal Article (source) used

Author Klaus Schwab inserted

Year 2020 inserted

1.8

Page setup

• Section breaks inserted before and after page 5

1

3

Page 5 set to landscape

1

All other pages set to remain in portrait

1

1.9

Spell Check

• Labor changed to labour

1

1

1.10

Paragraphs

• Paragraphs sorted
• In ascending order

1

1

2

1.11

Page numbering

1

1

1

1

1

5

Page numbering inserted

In the footer of the document

Centred

First two pages not numbered

Numbering starts on page 3 as page 1

1.12

Watermark

1

1

1

1

4

Watermark inserted

On the last page only

Text 4IR appear

Displaying horizontally

Total for QUESTION 1

[35]

No.

 Criteria

Maximum Mark

2.1

Paper size

• Top and bottom margins set to 1.5 cm
• Size of the page set to 20 cm wide and 28 cm high

1

1

2

2.2

Layout
Three columns created

• Spaces between columns set to 1.1 cm
• Highlighted text appears on top of each column
• Columns are justified

1

1

4

1

1

2.3

Table

• Text is converted into a table with four columns
• Grid Table 4 Accent 2 style applied to the table
• Repeat header rows feature used to set table headings appear on both pages in the table
• All data in table centred, vertically
• and horizontally

1

1

1

5

1

1

2.4

Paragraph

• Shadowed border applied to the paragraph
• Double line border style used

1

1

2

2.5

Date

• Current date inserted in the footer of the document
• Updates automatically

1

1

2

Total for QUESTION 2

[15]

No.

Criteria

Maximum Mark

WardInfo worksheet

3.1.1

Merge and Centre

• Cells A1 to O1 are merged
• and centred

1

1

2

3.1.2

Fill

•  Any fill is applied to merged cells
• Thin diagonal stripe pattern style fill effect applied

(accept any diagonal stripes)

1

1

2

3.1.3

Wrap Text

• Row 3 wrapped

1

1

3.1.4

Panes

• Freeze panes
• Row 3

1

1

2

3.2

Comment

• Comment inserted in cell E4
• Text Unit Price displays

1

1

2

3.3

Text functions (Cell B5)
=CONCATENATE(LEFT(A5;1); RIGHT(A5;2);LOWER(LEFT(C5;1)))

• Correct function used (Concatenate or & function)
• First letter of the Ward Name extracted
• Last two letters of Ward Name
• First letter of location in lower case

1

1

1

1

4

3.4

Cell K5
=SUM(E5:I5)

• Formula: Sum
• Range: (E5:I5)

1

1

2

3.5

Cell L8
=J8-K8

• Correct cells used
• Subtraction sign

1

1

2

3.6

M5
=E5/$E$4

• Correct cells used
• Division sign used
• Absolute cell reference applied to cell E4
• Formula copied to all other cells

1

1

4

1

1

3.7

Cell N6
=E6/K6*100 OR E6/K6

• Correct cells used
• Correct sign used
• Set to a percentage with no decimal places

1

1

3

1

3.8

Conditional formatting

• Conditional formatting used in column L
• Cell value <0
• Green fill with dark green text applied

1

1

3

1

3.9

Cell O5
=IF(L5<0;" ";"Bonus")

• Function: IF
• Condition: L5<0
• Value if true is correct
• Value if false is correct

1

1

4

1

1

3.10

Cell E37
=SUMIF(C5:C34;"Urban";J5:J34)

• Function: Sumif
• Criteria range C5:C34
• Criteria - Urban
• Sum range J5:J34

1

1

4

1

1

3.11

Cell E39

1

1

1

1

4

=IF(AND(C7="Rural";N7>25);"Award";"No

Award")

Functions: IF and AND

Condition (C7="Rural";N7>25);

Value if true is correct

Value if false is correct

3.12

Cell E41

1

=COUNTIF(C5:C34;"Semi Rural")

• Function: Countif

1

3

Range: C5:C34;

1

Criteria: "Semi Rural"

3.13

Cell E43

5

=VLOOKUP(A7;ExtraInfo!A2:C31;3;FALSE)

1

Function: Vlookup

1

Lookup value : A7

Lookup range : ExtraInfo!A2:C31 (ignore

1

if no absolute cell reference was used)

• Row number : 3

1

• Range lookup : False

1

3.14

Cell E45

=COUNTBLANK(E5:E34)

• Function: COUNTBLANK
• Range: (E5:E34)

1

1

2

3.14

Graph Worksheet

1

1

1

1

1

1

1

7

Graph title Readiness for 4IR

Both series points plotted correctly.

Any Stacked Bar graph used.

Vertical axis appears as in graph

Centred

Legend series added to top of graph

Move graph to the worksheet 4IR

Total for QUESTION 3

[56]

No.

Criteria

Maximum Mark

Table: Wards

4.1.1

Field: WardName

•  > inserted in Format field property

1

1

4.1.2

Field: WardNumber

• Required property set to Yes
• Format of field set to 'Fixed' format

1

1

2

4.1.3

Image

• Data type of Image field changed to OLE Object/ Hyperlink

1

1

4.1.4

Validation

<= 2020/06/30                     OR < 2020/07/01 OR <=#2020/06/30#           OR <#2020/07/01#

• Any appropriate validation text that refers to the limitation of the date

1

1

3

1

4.1.5

Devices Field

• New field created Devices
• Data type set to lookup value
• Data on the Info table used

1

1

1

3

4.2

Form: frm4_2

1

1

1

1

1

1

1

1

1

1

10

Form frm4_2 based on WardInfo table and

Columnar layout selected

Selected fields: WardName; WardNumber;

Location; Budget; Expenditure and Balance

The background of the form header is yellow

Font size of heading is 36 pt

Heading is centred

4_Form.jpg picture inserted

In form header aligned right

Format of Budget field changed to Currency with

zero decimal places

Button inserted in form footer

Shows the next record when button is clicked

4.3.1

Qry4_3_1

• Only Location and Expenditure
• Location: Total: Grouped by
• Expenditure: Total: Sum

1

1

1

3

4.3.2

Qry4_3_2

1

1

1

1

4

Only Rural

and Semi-Rural records show

Total calculated

Total of Budget field  (SUM)

4.3.3

Qry4_3_3

1

1

1

1

1

5

Loan: 30/100*[Budget]

Criteria Balance : <0

Loan:

30/100

*[Budget]

Loan set to R currency

Report

4.4

Report4_4

1

1

1

1

1

1

1

1

1

1

Report created

Grouped according to Location and then

according to Budget

Total budget for each Location calculated

in the Location footer = Sum([Budget])

Rural Locations are formatted red

New field Future Projections created .

10

Calculation of Future Projections

=10/100

*[Budget]

+[Budget]

OR =110/100*[Budget]

Total for QUESTION 4

[42]

No

Criteria

Maximum Mark

5.1

Heading 1
<center><h1><font size="50" face="Century">THE TIME HAS COME</font></h1> </center>

• Heading is centred
• Font size set to 50

1

1

2

5.2

Anchor
<a name="Top"></a>

• Link tags correctly inserted
• On words 'driver distraction'
• Correct anchor name

1

1

1

3

5.3

Image
<p align="center"><img src="/5Pic.png" border="5"></p>

• Extension for the image corrected
• Image centred

1

1

2

5.4

Bulleted list
<ul> </ul>

• Ordered list <ul> created.
• <li> </li> tags used correctly
• Applied to all listed items

1

1

1

3

5.5

Table

• Table colour is lightblue
• Width of the table is 80%

1

1

2

5.6

Table row
<tr>
<th>AR</th>
<td>15</td>
<td>34</td>
</tr>

• New row added
• Correct tags used
• Correct data entered

1

1

1

3

5.7

Table row
<td align="center" colspan="3"><b>Be Ready!!
</b></td>

• Row merged across three columns
• Text changed bold

1

1

2

5.8

Link
<a href="#Top">Back to top</a>

• <a href> </a>
• Link created on the text ‘Back to Top
• Link moves to the top of website

1

1

1

3

Closing tag(s) or triangular brackets and correct nesting correctly used

1

1

Total for QUESTION 5

[21]

No,

Criteria

Maximum Mark

6.1.1

Date

• Today’s date inserted
• In this format: (2020)(03)(10)

1

1

2

6.1.2

Table

1

1

1

1

4

Table created

3 columns and 2 rows

Spacing between columns set

to 0.3 cm

6.2

Mail Merge

Recipients list filtered to send letters

1

to the Wards that have a negative balance <0

1

Insert Ward Names in the Ward Name field

1

5

Mail merge completed

1

Completed letters saved as Letters

1

(Expect 6 Letters)

Total for QUESTION 6

[11]

TOTAL

180