COMPUTER APPLICATIONS TECHNOLOGY PAPER 1
GRADE 12
BACKUP MEMORANDUM
NOVEMBER 2016 
NATIONAL SENIOR CERTIFICATE

EXAMINATION NUMBER
IGNORE SPELLING IN ALL CASES WHERE IT WOULD NOT HAVE ANY IMPACT ON THE ANSWER.

QUESTION 1 File name: 1Gold_Goud Total Q1: 25

No  Criteria  Maximum Mark  Candidate Mark 
1.1 

Page size

  • Page size changed to A4 ✓
 1  
1.2 

Margin

  • Top margin set to 2 cm ✓
  • Gutter position set to left ✓
2  
1.3.1 

Style

  • New style 'Love Gold' created ✓
  • Based on the 'Heading 1' style ✓
  • Text centred horizontally ✓
  • Any border applied ✓
  • New style applied to heading ✓
 5  
1.3.2 

Citation

  • 'Pinn&Co, J' citation inserted after the heading ✓
  • Page number 3 displayed ✓
  • Year (2012) displayed ✓
 3  
1.4.1 

Line spacing

  • First paragraph line spacing set to multiple ✓
  • At 1.2 ✓
 2  
1.4.2 

Spacing

  • First line indent applied to second paragraph ✓
  • Set at 2 cm ✓
 2  
1.5 

Find and replace

  • Text 'nano' replaced with 'NANO' in small caps ✓
  • 4 occurrences of 'nano' replaced ✓
 2  
1.6

Thesaurus

  • 'Alchemist' replaced with word from suggested list: experimenters, transformers, pseudoscientists, etc. ✓
1  
1.7

SmartArt

  • Last shape filled with picture 1Gold_Goud ✓
  • Text added to the last shape ✓ ('Gold Bricks')
  • Layout changed to 'Closed Chevron Process' ✓
  • Automatic caption inserted ✓ ('Processing Gold') (ignore if caption is centred)
4  
1.8

Bibliography

  • Any automatic bibliography inserted ✓
1  
1.9

Watermark

  • Any text watermark added on any page ✓
  • Text changed to 'Love of Gold' ✓ (accept any part of text)
2  
  Total for QUESTION 1 25  


QUESTION 2 File name: 2Resource_Bron Total Q2: 27

No  Criteria  Maximum Mark  Candidate Mark 
2.1 

Table of contents

  • Table of contents updated ('Index' to be included) ✓
  • 2 levels of headings displayed ✓
  • Page number displayed with solid tab leader ✓
  • 'Fancy' format used ✓ (Small caps)
 4  
2.2 

Comment

  • Any comment added to word 'resources' ✓
 1  
2.3 

Cross reference

  • Cross reference on text 'production is slowly declining' added (text does not display) ✓
  • Entire caption is displayed 'Table 1: Year-on-year changes' ✓
 2  
2.4 

Text inserted

  • All the text from 2Trade_Handel inserted ✓
  • Text replaced in the correct position ✓
 2  
2.5 

Image

  • Image cropped correctly ✓
  • Image rotated/flipped ✓ (camel appears on left)
  • Any border with any border width added to image ✓
 3  
2.6 

Edit table

  • Table auto fitted to window ✓
  • Any row height set to 1 cm ✓
  • Cells in first column merged ✓
  • Any content in cells centred vertically and horizontally ✓
  • Argument in MIN function changed to LEFT ✓
 5  
2.7 

Text to table

  • Text added as first row to table ✓
  • Any predefined table style applied ✓
  • Alternative table title text inserted ✓ ('Changes')
    (Note to marker: Check table properties to see if changes were made in Alt Text.)
 3  
2.8

Link

  • Document 2Predict_Voorspel inserted ✓
  • Displays as icon ✓
    (Note to marker: Award one mark only if learner used a hyperlink with no icon.)
2  
2.9

Table of figures

  • Table of figures updated (2 automatic entries) ✓
1  
2.10

Index

  • Index inserted ✓
  • Appears as one column ✓
2  
2.11

Page numbers

  • Automatic page numbers inserted in header/footer ✓
  • Display vertically in left or right margin ✓
2  
  Total for QUESTION 2 [27]  


QUESTION 3 File name: 3Mine_Myn Total Q3: 23

  • 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  Candidate Mark 
3.1

Cells A1:G1:

  • Cells A1:G1 merged and centred ✓
  • Text wrapped ✓
 2  
3.2 

Number formatting (B3:B14):

  • Number formatting used ✓
  • Negative values displayed in red font colour (any number format) ✓
    (Note to marker: Do not award any marks if conditional formatting was used.) 
 2  
3.3 

Conditional formatting:

  • Conditional formatting applied to columns B to F ✓
  • Cells with lowest ten values appear shaded (not font colour) ✓
    (Note to marker: The top '10 negative numbers' will be shaded.)
 2  
3.4 

Cell B15:
=AVERAGE(B3:B14)

  • AVERAGE function ✓
  • Correct range (B3:B14) ✓
 2  
3.5 

Cell B16:
=LARGE(Five,2)

  • LARGE function ✓
  • Named range 'Five' ✓
  • 2 ✓
 3  
3.6 

Cell G3:
=IF(F3>=0,A3,"*")
OR
=IF(F3<0,"*",A3)

  • IF function ✓
  • Test: F3>=0 OR F3<0 ✓
  • "*" displayed if cell F3 is negative ✓
  • Month displayed if cell F3 is positive or 0 ✓
    (Note to marker: Accept if only > or < is used in the condition.) 
 4  
3.7 

Graph/chart:

  • Column graph/chart inserted ✓
  • Correct data =Stats!$A$3:$A$14,Stats!$F$3:$F$14 used ✓
  • Chart title inserted  ('Production 2015') below the chart ✓
  • Data labels  displayed inside ✓ data series
  • Month names (horizontal axis labels) displayed in 8.5 pt font size ✓
  • 'August' series filled with green colour ✓
    (Note to marker: Ignore if the legend appears on the graph/chart.)
 8  
  Total for QUESTION 3 [23]  


QUESTION 4 File name: 4Extra_Ekstra Total Q4: 26

  • 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 answers.
  • Named ranges can be used instead of cell references.
No  Criteria  Maximum Mark  Candidate Mark 
 4_1 worksheet   
4.1 

 Data sort:

  • All data sorted by date of birth (column C) ✓
  • Youngest to oldest ✓ (newest to oldest)
 2  
Shift_Skof worksheet
4.2 

Cell A3:
=CONCATENATE(LEFT(B3,3),RANDBETWEEN(1,250))
OR
=LEFT(B3,3)&INT(RAND()*(250)+1)

  • CONCATENATE OR & ✓
  • LEFT  (B3,3) ✓
  • RANDBETWEEN ✓ (1,250) ✓
    (Note to marker: If RAND was used accept any correctly used function to round off the number, such as INT, TRUNC or ROUND.)
 5  
4.3 

Cell G3:
=F3+H3/24

  • F3 ✓
  • +H3/24 ✓
 2  
 Sum_Ops worksheet  
4.4

Cell D3:
=COUNTIF(Shift_Skof!D3:D252,"AR001")

  • COUNTIF function ✓
  • Criteria range: Shift_Skof!D3:D252 ✓
  • Criteria: "AR001" ✓ (not name or surname) 
 3  
4.5

Cell E4:
=SUMIF(Shift_Skof!D3:D252,"BD002", Shift_Skof!H3:H252)

  • SUMIF function ✓
  • Criteria range: Shift_Skof!D3:D252 ✓
  • Criteria: "BD002" ✓
  • Sum range: Shift_Skof!H3:H252 ✓
    (Note to marker: Allocate marks only if name AND surname columns were correctly used.)
 4  
4.6

Column F:
=VLOOKUP(D3,Scale_Skaal!$A$2:$B$8,2)
OR
=VLOOKUP(D3,Scale_Skaal!A$2:B$8,2)

  • Lookup Value: D3 ✓
  • Table array: Scale_Skaal!$A$2:$B$8✓ OR
  • Table array: Scale_Skaal!A$2:B$8
  • Absolute cell referencing applied correctly ✓
  • Column index number: 2 ✓
  • Copied to other cells ✓
    (Note to marker: Accept A1:B8 as lookup range.)
5  
4.7

Cell I5:
=IF(E5>60,"Experienced",IF(H5>20,"Experienced", ""))
OR
=IF(OR(E5>60,H5>20),"Experienced","")
OR
=IF((E5>60)+(H5>20),"Experienced"," ")

  • Syntax of IF function is correct ✓
  • Criteria E5>60 ✓
  • Criteria H5>20 ✓
  • "Experienced" shows if either of the criteria is true ✓
  • " " OR "False" ✓
5  
  Total for QUESTION 4 [26]  


QUESTION 5 File name: 5Work_Werk Total Q5: 39

No  Criteria  Maximum Mark  Candidate Mark 
 Table:tbEmploy   
 5.1.1

Field: Name

  • Field size set to 15 ✓
 1  
5.1.2 

Field: Surname

  • Required set to 'Yes' ✓
 1  
5.1.3 

Field: Gender

  • Default value set to 'Male' OR 'M' ✓
 1  
5.1.4 

Field: YearsEmployed
Validation Rule

  •  >0 ✓ and ✓ <50 ✓
    OR
    >=1 and <=49
    OR
    Between 1 and 49
  • Validation text
    Any suitable message that refers to range between 1 and 49 ✓
 4  
5.1.5 

Field: IDNum
Input Mask: 000000 0000 000 will appear as
000000\ 0000\ 000;
OR
000000\ 0000\ 000
OR
000000" "0000" "000"

  • Correct character 0 ✓
  • Two spaces correctly placed ✓
  • Thirteen valid placeholders ✓
 3  
 Form: frm5_2   
5.2.1 Form properties record source changed to qry5_2 ✓
(Note to marker: Check in Property Sheet (Data) for record source.)
1  
5.2.2 Form header background changed to any colour ✓ 1  
5.2.3

Function:
=(Date() ✓- [Birthdate]) ✓ /365 ✓
OR
=(Now()-[Birthdate])/365.25
OR
=(Year(Now())-Year([Birthdate])

  • Fixed/Standard ✓
  • Age field formatted to zero decimal places ✓
  • Suitable label relating to age inserted ✓
    (Note to marker: Accept the function
    =Round ✓ ((Now()✓-[Birthdate]✓)/365.25✓,0✓) for the first 5 marks.)
6  
5.2.4 Examination number inserted in form footer ✓ 1  
Query: qry5_3
5.3
  • Only Name, Surname and ContactNum fields display ✓
  • Additional fields added (ContactNum, Gender, Permanent) ✓
  • Gender criteria: "F" ✓ and ✓ Permanent criteria: "No" OR FALSE OR 0 ✓
    (Note to marker: 34 records expected.)
5  
Query: qry5_4
5.4
  • New field Salary created ✓
  • Calculation: [Notch] ✓ *1200 ✓
  • Calculated field Salary formatted to currency ✓
4  
Query: qry5_5
5.5
  • Sorted in ascending order according to Surname and Name fields ✓
  • Surname field appears before the Name field ✓
  • Notch criteria 12 ✓
  • OR operator (or separate criteria line) used ✓
  • Birthdate criteria <#01/01/1956# OR <=#31/12/1955# OR YEAR([Birthdate])<1956 ✓(ignore format of year)
    (Note to marker: 9 records expected.)
5  
Report: rpt5_6
5.6
  • 5Mine_Myn picture ✓ inserted in report header ✓
  • Function inserted in the Permanent group footer/header ✓
  • Function: =Count(*) ✓ OR =Count([Name]) or on any other field
  • Average function moved to report footer ✓
  • Replaced AVERAGE with AVG in function ✓
6  
  Total for QUESTION 5 [39]  


QUESTION 6 File name: 6Gold_Goud Total Q6: 21

  • This question should be marked from the HTML code.
  • Numerical attribute values do not need to be in inverted commas.
  • A maximum of 1 mark will be deducted if one or more closing tags are omitted.
No  Criteria  Maximum Mark  Candidate Mark 
6.1 

Heading
<h1 align="center"><font color="yellow">Jewellery Design</font></h1>

  • Heading alignment set to centre ✓
  • Heading font colour changed to yellow ✓
 2  
6.2 

Horizontal line
<hr width="60%" size="8">

  • Horizontal line inserted ✓
  • Line width set to 60% ✓
  • Line size set to 8 ✓
 3  
6.3 

Open lines
<br/><br/>

  • Break tag inserted <br/> ✓
  • Two open lines inserted ✓
 2  
6.4 

Bold
<b>You can buy high quality …</b>

  • Bold tags applied to correct paragraph ✓
 1  
6.5.1 

Image
<img src="/6J.png">

  • 'src' attribute inserted ✓
  • Correct file used "6J" ✓
  • Image displays correctly ✓ (correct extension used) 
 3  
6.5.2 

Alternative text
<img src="/6J.png" alt ="Jewellery">

  • Alternative text tag inserted ✓
  • Correct text inserted "Jewellery" ✓
 2  
6.6 

Table
<table border=5>
     <tr>
           <td>Jewellers use:</td>
           <td>Precious stones</td>
      </tr>
      <tr>
           <td>Jewellers work with:</td>
           <td>
                        <ul>
                        <li>Plastic</li>
                        <li>Enamel</li>
                        <li>Perspex</li>
                        </ul>
          </td>
     </tr>
     <tr>
           <td colspan="2">Jewellers create their own beads and jewellery made from ostrich eggshell, leather and wood</td>
      </tr>
</table>

  • The table consists of three rows and two columns ✓
  • Correct text appears in each cell ✓
  • Unordered list inserted ✓
  • Correct tags identify items in list ✓
  • Last row: cell (colspan) spans 2 columns ✓
 5  
6.7

Hyperlink
<a href="http://www.southafrica.net.za">Go to Jewellery design website</a>

  • Hyperlink tags inserted <a href></a> ✓
  • Tags inserted to link to the correct file "http://www.southafrica.net.za" ✓
  • Hyperlink inserted on correct text 'Go to Jewellery design website' ✓
 3  
  Closing tag(s) or triangular brackets omitted or multiple closing tags in the incorrect order -1  
  Total for QUESTION 6 [21]  


QUESTION 7 Total Q7: 19

File names: 7Statem_Staat, 7Graph_Grafiek, 7Invest_Belê, 7Answ_Antw

No  Criteria  Maximum Mark  Candidate Mark 
 7Statem_Staat   
7.1.1 

Mail Merge

  • Source table Clients linked with 7Statem_Staat ✓
  • Merge fields Initials and Surname added in the correct place (accept if only one field) ✓
  • Space inserted between two fields (do not allocate if only one field inserted) ✓
 3  
7.1.2 

Form controls

  • 'Date' form field set to 'Current date' ✓
  • 'Amount Due' form field set to display in 'Number' and 'Currency'  and default value set to zero ✓
  • 'Cash' option added to drop down form field ✓
 4  
7Graph_Grafiek
7.2 

Insert graph/chart data

  • 'Gold fields' mine name appears ✓
  • Value '211' inserted correctly for Newmont Mining ✓
 2  
7Invest_Belê
7.3.1 

Page orientation

  • Page orientation of only indicated text changed to landscape ✓
 1  
7.3.2 

Header

  • Text 'Choices' inserted in header on any/all pages ✓
  • Applied to landscape pages only ✓ (Link to previous removed) 
 2  
7.4

Line breaks

  • 'Keep lines together' setting applied to all paragraphs in document ✓
 1  
7.5

Hyphenation

  • Automatic hyphenation applied to text ✓
  • Hyphenation limit set to 2 consecutive lines ✓
 2  
7Answ_Antw
7.6.1

What is the size of the spacing AFTER the paragraph in the 'Title' style?

  • Auto ✓ (Accept any paragraph spacing)
 1  
7.6.2

How many times does the EXACT word 'Gold' appear in this document?

  • 8 ✓
 1  
7.6.3

What is the alternative text title of the picture found at the end of the document?

  • Gold Nugget ✓
 1  
7.6.4

What is the name of the artistic effect applied to the picture at the end of the document?

  • Film Grain ✓
1  
  Total for QUESTION 7 [19]  
  TOTAL 180  

  

Last modified on Tuesday, 15 June 2021 12:18