MEMORANDUM

QUESTION 1                         File Name: 1_4th Industrial Revolution               Total Q1: 35

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

 
No. Criteria Maximum Mark

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]

QUESTION 2                                File Name: 2_ 4IR Research                        Total Q2: 15

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]

QUESTION 3                                    File Name: 3_Resourcing                      Total Q3: 56

  • 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 or cells as '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

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

 
 
 
No. Criteria Maximum Mark

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

   
No. Criteria Maximum Mark

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]

QUESTION 4                                              File Name: 4_4IR                                   Total Q4: 42

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

 
No. Criteria Maximum Mark

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]

QUESTION 5                 File Name: 5_MyWebsite                Total Q5: 21

  • This question should be marked from the HTML code.
  • Numerical attribute values do not need to be in inverted commas.

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]

QUESTION 6                        File Name:    6_Calculation, 6_Quote                            Total Q6: 11

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

Last modified on Tuesday, 22 February 2022 09:27