Downloaded from hlayiso.com
NATIONAL
SENIOR CERTIFICATE
GRADE 12
COMPUTER APPLICATIONS TECHNOLOGY P1
NOVEMBER 2019
MARKING GUIDELINES
MARKS: 180
CENTRE FINAL MARK
NUMBER
EXAMINATION
NUMBER
QUESTION 1 2 3 4 5 6 7 TOTAL
POSSIBLE MARK 27 23 24 26 40 20 20 180
MARKER
SM
CM
IM/EM
These marking guidelines consist of 15 pages.
DBE Stamp
Copyright reserved Please turn over
Skip to contentAll 2019 papers 





View all





Computer Applications Technology Grade 12 P1 2019 Memo (Eng)
Grade 12 Computer Applications Technology Paper 1 memorandum from the NSC November Exam 2019 (English), 15 pages. Read online or download the free PDF.
Computer Applications Technology · Grade 12 · NSC November Exam · 2019. Memorandum, 15 pages. Read online or download the PDF.
- Subject
- Computer Applications Technology
- Grade
- Grade 12
- Document type
- Memorandum
- Year
- 2019
- Exam period
- NSC November Exam
- Paper
- 1
- Curriculum
- CAPS
- Pages
- 15
- File size
- 523.3 KB
Free to read online, no sign-up needed
Loading document…
Loading document…
1 of 15
This exam
NSC November Exam 2019
Questions in this paper
Document textSearch extracted text and jump to a page.
Downloaded from hlayiso.com
Computer Applications Technology/P1 2 DBE/November 2019
NSC – Marking Guidelines
EXAMINATION
NUMBER
IGNORE SPELLING IN ALL CASES WHERE IT WOULD NOT HAVE ANY IMPACT ON
THE ANSWER.
QUESTION 1 File name: 1Mahal Total Q1: 27
Maximum Candidate
No Criteria
Mark Mark
1.1.1 Text outline 3
• Any red text outline set 1
• Width: 1.5 pt 1
• Applied to 'A Marvel' 1
1.1.2 Picture scale 2
• Height set to 60% (4.73 cm OR 4.74 cm) 1
• Width set to 40% (6.23 cm) 1
1.1.3 Vertical page alignment: First page 1
• Vertical page alignment set to centre 1
1.2 Table of contents (below heading 'Table of Contents') 1
• Any automatic table of contents inserted (ignore if the 1
text 'Contents' OR 'Table of Contents' appear twice)
1.3 Style modified: Heading 1 4
• Any bullet added to heading 1
• Correct bullet 1
• Bullet indent set at 0 (mark from Reveal Formatting) 1
• All occurrences of 'Heading 1' style updated 1
(7 occurrences)
1.4 Drop cap 2
• Dropped cap option applied to 'W' of 'What' 1
• Appears over 4 lines (allocate second mark if appears 1
as example)
1.5 Hyperlink ('Agra') 1
• Hyperlink links to 1Town OR 1town file 1
1.6 Footnote text 1
• Text 'Indian poet' added to original footnote (do not 1
allocate mark if * symbol was changed)
1.7 Pagination options ('Over 20 000 people …') 1
• 'Keep lines together' checked 1
DBE Stamp
Copyright reserved Please turn over
Downloaded from hlayiso.com
Computer Applications Technology/P1 3 DBE/November 2019
NSC – Marking Guidelines
EXAMINATION
NUMBER
1.8 Index subentry ('Taj Mahal Garden') 2
• Subentry added to 'Paradise Garden' (2 entries appear 1
if Show/Hide is switched on {XE "Paradise Garden:
Multiples of 4"}{XE "Paradise Garden Timurid Style"})
• 'Multiples of 4' added as text to subentry
1
1.9 Shape and textbox ('Photos of Taj Mahal') 5
• Left arrow shape added 1
• Fill of shape removed/white 1
• Text 'Splendid workmanship' added 1
• Outline of textbox removed/wrapping applied 1
• Shape and textbox/text appear similar to the
screenshot 1
1.10 Hidden text (font effect) 1
• Text 'Adapted from https://www.holidify.com/' hidden 1
(at the end of the document)
(switch on Show/Hide setting to mark)
1.11 Page footer 3
• Section break/Next Page (break) added on the second
last page 1
• Text 'Taj Mahal' appears in footer 1
• Text appears only on last page 1
Total for QUESTION 1 [27]
DBE Stamp
Copyright reserved Please turn over
Downloaded from hlayiso.com
Computer Applications Technology/P1 4 DBE/November 2019
NSC – Marking Guidelines
EXAMINATION
NUMBER
This page is empty to facilitate accurate marking for side-by-side booklet printout.
DBE Stamp
Copyright reserved Please turn over
Downloaded from hlayiso.com
Computer Applications Technology/P1 5 DBE/November 2019
NSC – Marking Guidelines
EXAMINATION
NUMBER
QUESTION 2 File name: 2Visit Total Q2: 23
Maximum Candidate
No Criteria
Mark Mark
2.1 Line spacing 1
• Line spacing set to Double OR set to 2 1
2.2 Hyphenation 1
• Automatic hyphenation applied 1
2.3 Page numbering 1
• Numbering style changed to any 'Accent Bar' 1
2.4 Cross-reference 2
• Cross reference replace text 'crowds' (Alt+F9 1
{REF_ Ref……… \h})
• Moves to heading 'Tourist influx at Taj Mahal' 1
2.5 Source – Corporate author ('Visit Wonderful India') 2
• 'India Tourism' added to source (anywhere) 1
• As 'Corporate author' 1
2.6 Edit citation 1
• Citation pages '43-49' inserted (pp. 43-49) 1
2.7 Table 4
• First row merged 1
• Fitted across page (preferred width 100%) 1
• Any outside border added 1
• Outside thick-thin border added 1
2.8 Multi-level list 5
• First level number set to 1) 1
• Second number set to a) 1
o Alignment of second level set to 0.7 cm 1
o Text indent of second level set to 1.5 cm 1
• Multi-level list applied 1
2.9 Chart/Graph 4
• Any chart inserted on the last page 1
• Pie chart inserted 1
• Data from 2Time used 1
• Chart title appears: 'Time spent at (the) Taj Mahal' 1
2.10 Page colour/background 2
• Page colour changed (not light yellow) 1
• Picture 2Back used (do not allocate second mark if 1
inserted as a watermark)
Total for QUESTION 2 [23]
DBE Stamp
Copyright reserved Please turn over
Downloaded from hlayiso.com
Computer Applications Technology/P1 6 DBE/November 2019
NSC – Marking Guidelines
EXAMINATION
NUMBER
QUESTION 3 File name: 3Stats Total Q3: 24
• 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, cells or '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
Foreign worksheet
3.1 Cells A1:I3: 2
• Correct cells merged (do not allocate the mark if the 1
heading was centred)
• Font size changed to 26 1
3.2 Foreign tab colour: 1
• Tab colour changed to any purple colour 1
3.3 Cell B17 (Expected answer: R 9 397 276): 2
• =C17/5 1
• Rand currency/Accounting/Custom (ZAR) format
applied 1
3.4 Cell C74 (Expected answer: ₹ 10 030 329 040): 1
=SUM(C9,C15,C33,C42,C52,C63,C73)
• Cell C52 included anywhere in function 1
3.5 Cell D8 (Expected answer: 1 118 983): 2
=D9-D7
OR
E8-(E8*G8/100)
• Correct cells used (D9,D7 OR E8,G8) 1
• Calculated correctly 1
3.6 Conditional formatting: Cells H17:H32 5
• Conditional formatting applied to cells H17:H32 1
• Formula: =H17 > G17 OR H17:H32>G17:G32 2
(ignore the position of the absolute cell reference)
• Absolute cell reference applied to column only OR
removed (=$H17>$G17 OR 1
$H17:$H32>$G17:$G32 OR =H17>G17)
• Cells formatted to green font 1
DBE Stamp
Copyright reserved Please turn over
Downloaded from hlayiso.com
Computer Applications Technology/P1 7 DBE/November 2019
NSC – Marking Guidelines
EXAMINATION
NUMBER
3.7 Cell I7: (CHECK FOR BUILDING BLOCKS) 5
=IF(E7>D7,IF(F7>E7,"Regular","Strong"),"Strong")
OR
=IF(D7>E7,"Strong",IF(E7>F7,"Strong","Regular"))
OR
=IF(D7<E7,IF(E7<F7,"Regular","Strong"),"Strong")
OR
=IF(D7>E7,"Strong",IF(E7<F7,"Regular","Strong"))
OR
=IF(G7>0,IF(H7>0,"Regular","Strong"),"Strong")
OR
=IF(G7<=0,"Strong",IF(H7<=0,"Strong","Regular"))
OR
=IF((E7-D7)<0,"Strong",IF((F7-E7)<0,"Strong",
"Regular"))
Accept
=IF(AND(E7>D7,F7>E7),"Regular","Strong")
OR
=IF(AND(D7<E7,E7<F7),"Regular","Strong")
OR
=IF(AND(G7>0,H7>0),"Regular","Strong")
OR
=IFS(AND(G7>0,H7>0),"Regular",OR(G7<0,
H7<0),"Strong")
• Criteria 1: Check for increase from 2016 to 2017 1
• Criteria 2: Check for increase from 2017 to 2018 1
• Output 1: "Regular" if both conditions true 2
• Output 2: "Strong" for any other combinations 1
Country worksheet
3.8 Chart/Graph 6
• 2017 series deleted 1
• Minor gridlines formatted to 60% transparency 1
• 'Series 1' changed to 2016 1
• 2018 series filled with 3Taj image and stacked 3
Total for QUESTION 3 [24]
DBE Stamp
Copyright reserved Please turn over
Downloaded from hlayiso.com
Computer Applications Technology/P1 8 DBE/November 2019
NSC – Marking Guidelines
EXAMINATION
NUMBER
QUESTION 4 File name: 4Tourists 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, cells or '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
Info worksheet
4.1 Row 6: Wrap text 1
• Column headings wrapped 1
4.2 Cell E2 (Expected answer: 21): 2
=MAX(F7:F206) OR LARGE(F7:F206,1)
• MAX function OR LARGE( ,1) inserted in cell E2 1
• Range: F7:F206 1
4.3 Cell E3 (Expected answer: 193): 2
=COUNTA(J7:J206)
• COUNTA function inserted in cell E3 1
• Range: J7:J206 1
4.4 Cell E4 (Expected answer: 2 971 918.00): 4
=SUMIF(K7:K206,"2",L7:L206)
OR
=SUMIFS(L7:L206,K7:K206,"2")
• SUMIF/S function inserted in cell E4 1
• Criteria range: K7:K206 1
• Criteria: "2" (accept without "") 1
• Sum range: L7:L206 1
4.5 Cell E5 (Expected answer: 3): 5
=COUNTIFS(D7:D206,"Spain",M7:M206,"Yes")
OR
=COUNTIFS(M7:M206,"Yes",D7:D2016,"Spain")
• COUNTIFS function inserted in cell E5 1
• Criteria range 1: D7:D206 1
• Criteria 1: "Spain" 1
• Criteria range 2: M7:M206 1
• Criteria 2: "Yes" 1
DBE Stamp
Copyright reserved Please turn over
Downloaded from hlayiso.com
Computer Applications Technology/P1 9 DBE/November 2019
NSC – Marking Guidelines
EXAMINATION
NUMBER
4.6 Cell I7: 2
=HOUR(H7-G7)
Accept
=HOUR(H7)-HOUR(G7)
• HOUR function used for both values (G7,H7) 1
• Subtracted correctly 1
4.7 Cell L7: 5
=VLOOKUP(D7,Countries!$A$3:$C$65,K7)*F7
OR
=IF(K7=2,VLOOKUP(D7,Countries!$A$3:$C$65,2),
VLOOKUP(D7,Countries!$A$2:$C$65,3)*F7
OR
=VLOOKUP(D7,Countries!$A$3:$C$65,IF(K7=2,2,3))
*F7
• Lookup value: D7 1
• Table array: Countries!$A$3:$C$65 OR 1
Countries!$A$2:$C$65
• Absolute cell referencing (also accept on rows) 1
• Return column: K7 (OR IF(K7=2…)) 1
• * F7 1
4.8 Cell N7: 5
=DATE(YEAR(E7),MONTH(E7)-3,DAY(E7))
OR
=EDATE(E7,-3)
• MONTH function and DAY function (allocate 2 2
marks for EDATE)
• Correct cell reference on MONTH and DAY (E7) 1
• Subtract 1
• 3 months 1
Total for QUESTION 4 [26]
DBE Stamp
Copyright reserved Please turn over
Downloaded from hlayiso.com
Computer Applications Technology/P1 10 DBE/November 2019
NSC – Marking Guidelines
EXAMINATION
NUMBER
QUESTION 5 File name: 5Survey Total Q5: 40
Maximum Candidate
No Criteria
Mark Mark
Table: tblInfo
5.1.1 Field: SurveyNo 1
• Primary key set on SurveyNo field 1
5.1.2 Field: Name 1
• Moved to after Surname field 1
5.1.3 Field: Code 4
Input Mask: >L0000C
All caps
• > 1
Compulsory letter
• L 1
4 compulsory digits
• 0000 1
Optional or required character or space
• C OR & 1
5.1.4 Field: DateIn 2
• Appropriate validation text inserted that refers to
correct dates from 2017/12/31 to 2019/10/10 (do 2
not allocate marks if validation rule was copied)
5.1.5 Field: Days 1
• Order of fields swopped [DateOut]-[DateIn] OR 1
Abs([DateIn]-[DateOut]) OR -([DateIn]-[DateOut])
5.1.6 Field: WillReturn 1
• Format changed to 'True/False' 1
Form: frm5_2
5.2 • Examination number and the original data displays in 7
form header 1
• Show DatePicker set to 'Never' for DateIn 1
• Field inserted 1
o Combo box inserted 1
o Control source: TravellerType field 1
o Row source: tblOptions OR SELECT
[tblOptions].[Options] FROM [tblOptions] 1
• Page header and page footer does not display 1
DBE Stamp
Copyright reserved Please turn over
Downloaded from hlayiso.com
Computer Applications Technology/P1 11 DBE/November 2019
NSC – Marking Guidelines
EXAMINATION
NUMBER
Query: qry5_3
5.3 • EstimateAmount field inserted 1 5
• Rating criteria 5 1
• Total row switched on 1
• EstimatedAmount: Total: AVG and format changed 1
to 'Currency' (2 decimal places) OR 'Fixed' 1
OR 'Standard'
(Note to marker: 3 records expected.)
Query: qry5_4
5.4 • Criteria Code: S????0 OR S*0 5
OR Like "S*" AND Like "*0"
o S 1
o * OR ???? 1
o 0 1
• Criteria Reaction
o <> "Unmoved" 2
OR NOT "Unmoved" OR NOT "Unm*"
OR "Amused" OR "Angry" OR "Excited" OR
"Happy" OR "Sad"
(if Reaction criteria are on separate lines, Code
criteria should be repeated for all lines)
(Note to marker: 3 records expected.)
Query: qry5_5
5.5 • Displays Name, Surname and/or CodeLetter 1 7
• Gender criteria: "Female" OR "F*" 1
• Calculated field: CodeLetter: 1
Left ([Reaction], 1) OR MID([Reaction],1,1) 3
Reaction field appears only in calculated field 1
(Note to marker: 100 records expected.)
Report: rpt5_6
5.6 • EstimateAmount grouping removed 1 6
• Function: =Sum ( [EstimateAmount] ) in 2
TravellerType group footer 1
• Suitable label (must refer to function used) 1
• EstimateAmount field font changed to italics 1
(also accept in calculated field)
Total for QUESTION 5 [40]
DBE Stamp
Copyright reserved Please turn over
Downloaded from hlayiso.com
Computer Applications Technology/P1 12 DBE/November 2019
NSC – Marking Guidelines
EXAMINATION
NUMBER
QUESTION 6 File name: 6_1Wonder, 6_2Tourism Total Q6: 20
• This question should be marked from the HTML code.
• Numerical attribute values and single words do not need to be in inverted commas.
Maximum Candidate
No Criteria
Mark Mark
6_1Wonder
6.1.1 Background colour 1
<body bgcolor="beige">
• Background colour set to beige 1
6.1.2 Font 2
<font size="50" face="Century">Agra</font>
• Font size set to 50 1
• Font type set to 'Century' 1
6.1.3 Line break and picture 5
<br/>
<img src="6City.jpg" height="350" width="600"/>
• Line break/Paragraph tags added before the picture 1
• <img src> tags inserted 1
• 6City.jpg inserted 1
• Height set to 350 1
• Width set to 600 1
6.1.4 Ordered list 1
<ol>
<li>…</li>
<li>...</li>
<li>…</li>
<li>...</li>
</ol>
• Ordered list tags added 1
DBE Stamp
Copyright reserved Please turn over
Downloaded from hlayiso.com
Computer Applications Technology/P1 13 DBE/November 2019
NSC – Marking Guidelines
EXAMINATION
NUMBER
6_2Tourism
6.2 <html> 10
<body>
<h1><i>Foreign Taj Mahal Tourist</i></h1>
<table border="3">
<tr>
<th colspan="3"> 2018
Figures</th>
</tr>
<tr>
<td>Year</td>
<td>Arrival</td>
<td>%</td>
</tr>
<tr>
<td>2018</td>
<td>10.04</td>
<td>14.0</td>
</tr>
</table>
<a href ="www.tajmahal.in">Click for
more information: www.tajmahal.in</a>
</body>
</html>
• Heading
o Heading level 1 OR 2 OR Font size and/or bold 1
o Italics applied to heading 1
• Table
o Table created with any border 2
o Three sets of rows created (accept two rows with 1
first row th or td)
o First row <td> or <th> merged across 3 columns 1
o Three sets of columns created 1
o Table heading OR centred in first row and bold 1
• Hyperlink
o Hyperlink created on text 'Click for more information:
www.tajmahal.in' 1
o Links to 'www.tajmahal.in' (mark from code) 1
Closing tag(s), triangular brackets and nesting 1
correctly used 1
Total for QUESTION 6 [20]
DBE Stamp
Copyright reserved Please turn over
Downloaded from hlayiso.com
Computer Applications Technology/P1 14 DBE/November 2019
NSC – Marking Guidelines
EXAMINATION
NUMBER
QUESTION 7 File names: 7Protect, 7Calculations, 7Numbers Total Q7: 20
Maximum Candidate
No Criteria
Mark Mark
7Protect
7.1.1 Caption 2
• Automatic caption inserted 1
• Caption text 'Unobstructed view of Taj Mahal' 1
(ignore if original text still appears)
7.1.2 Reviewing 2
• At least one change accepted 1
• Only changes made by author ABC accepted 1
((ASI) inserted, fourth paragraph removed. DEF left
unchanged OR rejected (1,000 has a comma).)
7Calculations
7.2.1 Cell B2: (CHECK FOR BUILDING BLOCKS) 7
=IF(FIND("#",A2)<>LEN(A2),"More","One") OR
=IF(FIND("#",A2)=LEN(A2),"One","More") OR
=IF(LEN(A2)>FIND("#",A2),"More","One") OR
=IF(FIND("#",A2)<LEN(A2),"More","One") OR
=IF(MID(A2,FIND("#",A2)+1,LEN(A2)-
FIND("#",A2))="","One","More") OR
=IF(LEN(MID(A2,FIND("#",A2)+1,LEN(A2)-
FIND("#",A2)))>0,"More","One") OR
=IF(LEN(RIGHT(A2,LEN(A2)-FIND("#",A2)))>0, "More","One")
OR
=IF(FIND("#",A2)<LEN(A2),"More","One") OR
=IF(MID(A2,FIND("#",A2)+1,LEN(A2))="","One","More") OR
=IF(LEN(MID(A2,FIND("#",A2)+1,LEN(A2)))>0,"More", "One")
• Determine position of the first # character
o Find # character 2
o In correct cell (cell A2) 1
• Determine if there is text after the # character
o Search for any characters after first # character
(Len(A2)) OR Extract remaining characters OR Find
second # character
o Test (IF and correct logical operator) 1
• Output in correct cell 1
o 'One' displays if only one word
o 'More' displays if more than one word 1
1
DBE Stamp
Copyright reserved Please turn over
Downloaded from hlayiso.com
Computer Applications Technology/P1 15 DBE/November 2019
NSC – Marking Guidelines
EXAMINATION
NUMBER
7.2.2 Subtotal feature (Mark by inspection) 3
• Change added to: Traveller Type_Reisigertipe 1
• Entries counted (SUBTOTAL(3,…)) 1
• Subtotal added to: Gender_Geslag 1
7Numbers
7.3 Importing data from HTML file (table In OR tblOut) 6
• New table created named 'In' 1
• Correct data (7Half) 1
• Appears in database (6 records) 1
• Field names correct (Month, 2016, 2017, 2018) 1
• No primary key created 1
• Month field size changed to acceptable size (8–50) 1
Total for QUESTION 7 [20]
TOTAL 180
DBE Stamp
Copyright reserved
Study this subject
Recommended for this subject

Memorandum
Computer Applications Technology Grade 12 P1 2019 Memo (Afr)

Question paper
Computer Applications Technology Grade 12 P1 2019 QP (Eng)

Memorandum
Computer Applications Technology Grade 12 P2 2019 Memo (Afr)

Memorandum
Computer Applications Technology Grade 12 P1 2019 Memo (Eng)

Memorandum
Computer Applications Technology Grade 12 P1 2019 Memo

Memorandum
Computer Applications Technology Grade 12 P1 2021 Memo (Eng)
More from Grade 12 Computer Applications Technology

Question paper
Computer Applications Technology Grade 12 P1 2025 QP (Afr)

Question paper
Computer Applications Technology Grade 12 P2 2025 QP (Eng)

Question paper
Computer Applications Technology Grade 12 P1 2024 QP (Afr)

Question paper
Computer Applications Technology Grade 12 P1 2024 QP (Eng)

Question paper
Computer Applications Technology Grade 12 P2 2024 QP (Eng)

Question paper