SENIOR CERTIFICATE/

NATIONAL SENIOR CERTIFICATE

GRADE 12

COMPUTER APPLICATIONS TECHNOLOGY P1

NOVEMBER 2020

MARKING GUIDELINES

MARKS: 180

CENTRE NUMBER
FINAL MARK

EXAMINATION
NUMBER

QUESTION 1 2 3 4 5 6 7 TOTAL

POSSIBLE MARK 29 21 27 23 40 20 20 180

MARKER

SM

CM

IM/EM

These marking guidelines consist of 15 pages.

Copyright reserved Please turn over

Computer Applications Technology/P1 2 DBE/November 2020
SC/NSC – Marking Guidelines
EXAMINATION
NUMBER

IGNORE SPELLING IN ALL CASES WHERE IT WOULD NOT HAVE ANY IMPACT ON
THE ANSWER.
QUESTION 1 File name: 1Pyramids Total Q1: 29
Maximum Candidate
No. Criteria
Mark Mark
1.1 Picture 3
 Picture width changed to 21 cm  1
 Picture positioned over top edge and across width of
page  1
 All empty paragraphs below picture removed  1
1.2 Heading 4
 Strikethrough removed from whole heading  1
 Character spacing expanded  by 1.5 pt  2
 Heading horizontally centred  1
1.3 Source 4
 Website source added  1
 Author 'Nina Sen' added  (Accept Sen, Nina OR any 1
variation of Nina Sen)
 Year '2012', Month 'September' OR 09 OR 9, Day '6' 
 Added in the appropriate places  1
1
1.4 Find and replace 2
 Nonbreaking spaces replaced with a single normal
space  (some replacements) 1
 All 14 occurrences of nonbreaking spaces replaced  1
(Find nonbreaking spaces (^s), no occurrences)
1.5 Indent: 'One of …' 3
 First line indent  1
 Left or hanging indent set at 2 cm  1
 Right indent set at exactly 14 cm on ruler  (1.92 cm in 1
dialog box)
1.6 Line and Paragraph spacing: 'The grand …' 3
 Paragraph spacing after changed to 8 pt  1
 Line spacing set to 'Multiple'  1
 At 1.4  1
1.7 Paragraph settings: 'Insert here' 1
 'Page break before' selected on text 'Insert here'  (Do 1
NOT allocate mark for Page Break)

Copyright reserved Please turn over

Computer Applications Technology/P1 3 DBE/November 2020
SC/NSC – Marking Guidelines
EXAMINATION
NUMBER

1.8 File inserted as icon 3

 File 1Structure inserted  (Alt + F9) 1
 As icon  1
 Icon named as 1Structure  1
1.9 Caption 3
 Picture 'cropped' to remove only text below  1
 Caption label changed to Structure  (Alt + F9, {Seq 1
Structure \* alphabetic})
 Caption label numbering changed to a, b, c, …  1
1.10 Watermark 3
 Text watermark inserted  1
 Text 'Ancient'  1
 Watermark displays only on first page  1
Total for QUESTION 1 [29]

Copyright reserved Please turn over

Computer Applications Technology/P1 4 DBE/November 2020
SC/NSC – Marking Guidelines
EXAMINATION
NUMBER

QUESTION 2 File name: 2Building Total Q2: 21

Maximum Candidate
No. Criteria
Mark Mark
2.1 Cover page 2
 Exam number inserted in 'Author' form control  1
 Abstract form control removed  (With or without text) 1
2.2 Page border 1
 Page borders removed from document  1
2.3 Table of Contents {TOC\h\z\t"Heading 1,2,Title,1"} 3

 Two 'Heading 2' style headings changed to 'Heading

1' style headings  1
 Table of Contents inserted  1
 Table of Contents options set to 'Title' style level 1
and 'Heading 1' style level 2  1
2.4 Page numbering 3
 Any automatic page numbering inserted  1
 Page numbers inserted anywhere in the left page
margin  (Accept any format containing 'Page') 1
 Page after Table of Contents page numbered as
'Page 1'  (No page numbers on or before TOC page) 1
2.5 Table to text 5
 Table converted to text  with tabs at 4 cm  2
 Hanging indent set to tab position  1
 Text alignment set to justify  (No mark if table) 1
 Any solid paragraph border inserted  1

2.6 Citation 2
 Citation displays only author  (Year suppressed. 1
Ignore if Title NOT suppressed.)
 Page number 'p. 433' inserted  1

Copyright reserved Please turn over

Computer Applications Technology/P1 5 DBE/November 2020
SC/NSC – Marking Guidelines
EXAMINATION
NUMBER

2.7 Picture 3
 Picture background removed  1
 Text wrapping set to 'Tight'/'Through'  1
 Picture moved to approximate correct position  1
2.8 Cross reference 2
 Cross reference to 'ForEver' bookmark inserted  (Alt 1
+ F9, {PAGEREF ForEver \h })
 Only page number displays  1
Total for QUESTION 2 [21]

Copyright reserved Please turn over

Computer Applications Technology/P1 6 DBE/November 2020
SC/NSC – Marking Guidelines
EXAMINATION
NUMBER

QUESTION 3 File name: 3Tourists Total Q3: 27

 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.

Maximum Candidate
No. Criteria
Mark Mark
Data worksheet
3.1 Row 1: 2
 Cells A1:I1 merged and centred  1
 Font size increased to 13 (All text)  1
3.2 Cell C3: 2
=MONTH(A3)

 MONTH function  (A3) 1

 Cell format changed to 'General'/'Text' OR 'Number'
with zero decimals  1
3.3 Cell C4: 3
=AVERAGE(H8:H19)

 AVERAGE function  (Ignore if divided by 5) 1

 Range: H8:H19  1
 Cell formatted to show no decimal places  1
3.4 Cell C5: 3
=SUMIF(B8:B19,"Peak",G8:G19)

 Criteria range: B8:B19  1

 Criteria: "Peak"  1
 Sum range: G8:G19  1

Copyright reserved Please turn over

Computer Applications Technology/P1 7 DBE/November 2020
SC/NSC – Marking Guidelines
EXAMINATION
NUMBER

3.5 Cell I8 (Check for building blocks): 7

=IF(SUM(C8:G8)=H8,"Correct","Error")

OR
=IF(H8=SUM(C8:G8),"Correct","Error")

 =IF function in cell I8  1

 SUM function  1
 Range (C8:G8)  (No mark if absolute cell reference) 1
 =H8 
 Correct output ("Correct") if true  1
 Correct output ("Error") if false  1
 Formula copied to rest of cells  1
1
3.6 Conditional formatting (Check for building blocks) 3
 Conditional formatting applied to range C8:G19  1
 To check for below average  ('Below average' rule 1
OR <752293 OR C8<AVERAGE($C$8:$G$19))
 Filled with any colour  1
Chart_Grafiek worksheet
3.7  Chart type for 2015 data changed  to column  2 7
 Legend series 'Year' changed to '2018'  1
 Legend appears to the right of the chart  1
 1000 separator applied to vertical axis  (Check Axis 1
Options Number setting)
 Markers inserted  on 2019 data only  2

Total for QUESTION 3 [27]

Copyright reserved Please turn over

Computer Applications Technology/P1 8 DBE/November 2020
SC/NSC – Marking Guidelines
EXAMINATION
NUMBER

QUESTION 4 File name: 4Visitors Total Q4: 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.
Maximum Candidate
No. Criteria
Mark Mark
Pyr_Pir worksheet
4.1 Page layout 2
 Page orientation set to landscape  1
 Row 2 set to repeat at top of each page  1
4.2 Cell D3 (Check for building blocks): 5
=RIGHT(C3,LEN(C3)-FIND("@",C3))
OR
=RIGHT(C3,LEN(C3)-SEARCH("@",C3))
OR
=MID(C3,FIND("@",C3)+1,LEN(C3)-FIND("@",C3))
OR
=MID(C3,FIND("@",C3)+1,LEN(C3))
 Determine the position of the @  in cell C3 with 1
FIND/SEARCH function  1
 Determine the length of string  in cell C3 with LEN 1
function
 Extract text AFTER  the "@" with MID/RIGHT 1
function  1
4.3 Cell F4: 5
=VLOOKUP(E4,Code_Kode!$A$2:$C$43,3)
OR
=VLOOKUP(E4,Code_Kode!$A$1:$C$43,3)
OR
=XLOOKUP(E4,Code_Kode!$A$2:$A$43,Code_Kode!$
C$2:$C$43)
 VLOOKUP OR XLOOKUP function  1
 Lookup value: E4  1
 Table array: Code_Kode!A2:C43  (OR 1
Code_Kode!$A$1:$C$43)
 Row index number: 3  1
 Absolute cell referencing  1

Copyright reserved Please turn over

Computer Applications Technology/P1 9 DBE/November 2020
SC/NSC – Marking Guidelines
EXAMINATION
NUMBER

4.4 Cell H5 (Check for building blocks): 6

=ROUNDDOWN(((TODAY()-G5)/365.25),0)

OR
=ROUNDDOWN(DAYS360(G5,TODAY())/360,0)

OR
=ROUNDDOWN(DAYS(TODAY(),G5)/365.25,0)

OR
=ROUNDDOWN(YEARFRAC(G5,TODAY()),0)

OR
=TRUNC(((TODAY()-G5)/365.25),0)

OR
=INT((TODAY()-G5)/365.25)

 ROUNDDOWN ( ,0)  (Allocate mark if INT OR 1

TRUNC was used)
 TODAY()  OR NOW() 1
 - 1
 G5)  1
 Correct order of subtraction  1
 / 365.25  (Accept 365 OR 360 if DAYS360 function 1
was used)
4.5 Cell I14 (Check for building blocks): 5
=IF(H14<60,IF(F14="Giza","Yes","No"),"No")

OR
=IF(H14<=59,IF(F14="Giza","Yes","No"),"No")

OR
=IF(H14>=60,"No",IF(F14="Giza","Yes","No"))

 Criteria 1: check for <60 OR <=59  1

 Criteria 2: check for "Giza"  1
 Correct output ("Yes") if both true  1
 Correct output ("No") if both false  1
 Correct output ("No") if age (<60) is false  1
Total for QUESTION 4 [23]

Copyright reserved Please turn over

Computer Applications Technology/P1 10 DBE/November 2020
SC/NSC – Marking Guidelines
EXAMINATION
NUMBER

QUESTION 5 File name: 5Egypt Total Q5: 40

Maximum Candidate
No. Criteria
Mark Mark
Table: tbl5_1
5.1.1 Field: TSurname 1
 Allow for duplicates  (Yes (Duplicates OK)) 1
5.1.2 Field: TBirthDate 1
 Date displays in 'Short Date' format  1
5.1.3 Field: TAge 1
 Decimal places set to 0  1
5.1.4 Field: EContact 3
 Validation rule: Like *@*
o * 1
o @ 1
o * 1
5.1.5 Field: TType 1
 Field size changed to 4  1
5.1.6 Input Mask: <.LL? OR .<LL? 4
 < 1
 .  (Accept in combination with /, \ or " ") 1
 LL  1
 ? 1
5.1.7 Field: PyramidCode 1
 Text align is set to 'Center'  1
5.1.8 Field: PyramidSite 2
 Combo box created  1
 Row source: tblSites  (14 options in combo box) 1
5.1.9 Field: TPhoto 2
 Any picture inserted for 'Peter Andrews'  1
 5Andrews picture inserted  (Accept linked icon) 1
Form: frm5_2
5.2  Fields are in order TSurname, TName, EContact and 4
TPhoto  1
 Examination number replaces the form heading  1
 Date field inserted in form header  (Do not accept 1
typed date)
 EContact field shaded to any colour  (Accept 1
shadow or shade. Not label)

Copyright reserved Please turn over

Computer Applications Technology/P1 11 DBE/November 2020
SC/NSC – Marking Guidelines
EXAMINATION
NUMBER

Query: qry5_3
5.3  Total row switched on  1 3
 Pyramid: COUNT  1
 Site criteria: "Giza"  1
Query: qry5_4
5.4  Surname field moved to before Name field  1 9
 Criteria in BirthDate field: < #1960/01/01#  1
OR <=#1959/12/31#
OR YEAR([BirthDate])<1960
OR YEAR([BirthDate])<=1959
OR LEFT([BirthDate],4)<=1959
 Criteria in DomainType field: ".org"  OR  ".edu"  3
(Accept "*org" OR "*edu")
 Calculated field:
Payable:[VisitorsCost] - ([VisitorsCost] * 0.15)
Payable:[VisitorsCost] - ([VisitorsCost] * 15/100)
Payable:[VisitorsCost] * 0.85
o Calculated field name: Payable:  1
o Correct field: VisitorsCost  1
o 15% calculated  (*15/100 OR *0.15) 1
o Subtracted from VisitorsCost  (*0.85 OR 1
–[VisitorsCost]) (Accept 0.85 OR 85/100 for last
two marks)

(Expected number of records: 37)

Report: rpt5_5
5.5  Report saved as rpt5_5  based on tblVisitors 1 8
 Pyramid, Name, Surname, VisitorsCost fields
display  1
 Grouping on Pyramid  1
 Function in Pyramid footer  1
=MAX  ([VisitorsCost])  2
 'Maximum Amount' label added for the function  1
 Border appears around 'Maximum Amount' textbox
and appears as currency  (Mark from Print Preview) 1

Total for QUESTION 5 [40]

Copyright reserved Please turn over

Computer Applications Technology/P1 12 DBE/November 2020
SC/NSC – Marking Guidelines
EXAMINATION
NUMBER

QUESTION 6 File names: 6_1NatGeo, 6_2Facts Total Q6: 20

 This question should be marked from the HTML code.

 Numerical attribute values do not need to be in inverted commas.

Maximum Candidate
No. Criteria
Mark Mark
6_1NatGeo
6.1.1 Centre 2
<center>
<h1><font face="Papyrus">PYRAMIDS</font></h1>
<p>The third of … complex mortuary temple.</p>
<p>Each massive pyramid … other features.</p>
</center>

 'Center' OR paragraph and align tags inserted  1

 Text 'PYRAMIDS … other features' (including picture)
is centred  1
6.1.2 Heading 3
<h1><font face="Papyrus">PYRAMIDS</font></h1>

 'Heading 1' tags correctly inserted  1

 Font tags correctly inserted  1
 'Font face' set to "Papyrus"  1
6.1.3 Image 2
<img src="6Group.jpg">

 Image tags inserted <img src …>  1

 Image 6Group.jpg  1
6.1.4 Hyperlink 2
<a href="www.crystal.com"><h2>The Future of the
Pyramids</h2></a>

 Tags for anchor inserted <a …>  1

 To correct web address "www.crystal.com"  1

Copyright reserved Please turn over

Computer Applications Technology/P1 13 DBE/November 2020
SC/NSC – Marking Guidelines
EXAMINATION
NUMBER

6_2Facts
6.2 … 10
<font size="6"><b>TOP 3 Egyptian Pyramid
Facts</b></font>
<hr/>
…
<table bgcolor="Burlywood" border="1">
<tr>
<th>No.</th>
<th>Question</th>
<th>Answer</th>
</tr>
<tr>
<td>1. </td>
<td>Which pyramids are the most well known?
</td>
<td>Ancient Egyptian pyramids</td>
</tr>
…
</table>
<ul type="circle">
<li>Most Ancient Egyptian ...</li>
<li>Saqqara is a ...</li>
<li>For over 3 800 years ...</li>
</ul>

 Tag for horizontal line <hr/> inserted  1

 Table row tags <tr></tr> inserted for table heading  1
 Table heading tags <th></th> inserted  (OR bold 1
and centred)
 Table row tags <tr></tr> inserted twice for table
rows  1
 Cell tags <td></td> inserted  1
 Cell tags <td></td> inserted for two rows  1
 Closing table tag </table> inserted before bulleted
list  1
 Unordered list tags <ul></ul> inserted around the
text  1
 Bullet type is a 'circle'  1
 List item tags <li></li> inserted three times  1
Closing tag(s), triangular brackets and nesting 1
correctly used on both web pages 1
Total for QUESTION 6 [20]

Copyright reserved Please turn over

Computer Applications Technology/P1 14 DBE/November 2020
SC/NSC – Marking Guidelines
EXAMINATION
NUMBER

QUESTION 7 File names: 7Years, 7Invitation, 7Mail, 7InvitationMerged Total Q7: 20

Maximum Candidate
No. Criteria
Mark Mark
7Years
Data worksheet
7.1.1 Transpose 2
 Correct data appears in Data worksheet  1
 Column A is right aligned  1
Chart worksheet
7.1.2 Chart 3
 Only the data series 2017 to 2019 is displayed  1
 Data labels added  1
 Vertical axis major units changed to 0.2  1
7.1.3 Chart saved as image (7Chart.jpg) 2
 Chart saved as a file  1
 Saved as 7Chart.jpg  1
Visitors worksheet
7.1.4 Cell J3: 3
=COUNTIF(AmountSpent,">14000")
 COUNTIF function  1
 Named Range: AmountSpent  (OR cell F2:F194) 1
 Criteria: ">14000"  1
7.1.5 Data validation: Column E 3
 In Validation List
o Option 'ord' changed to 'org'  1
OR
'org' added to list
o Option 'gov' added to list  1
 Validation Rule Source changed to include
amendments in validation list for column E  (OR 1
$M$4:$M$9 OR $M$4:$M$10 OR 'org' added)

Copyright reserved Please turn over

Computer Applications Technology/P1 15 DBE/November 2020
SC/NSC – Marking Guidelines
EXAMINATION
NUMBER

7Invitation/7InvitationMerged
7.2.1 Mail Merge (14 records expected) 6

 7Invitation linked to data source 7Mail  1

 Data source: DomainType criteria = edu  1
 Data source: BirthDate criteria >=1961/01/01  OR 1
>1960/12/31
 <<Name>> replaced with field Name  1
 Any date and time field inserted in the footer  to 1
automatically update  1
7.2.2 Merged Document 1
 Merged document saved as 7InvitationMerge  1
Total for QUESTION 7 [20]
TOTAL 180

Copyright reserved