Downloaded from hlayiso.com
NATIONAL SENIOR
CERTIFICATE
GRADE 12
SEPTEMBER 2020
COMPUTER APPLICATIONS TECHNOLOGY P1
MARKING GUIDELINE
NAME OF CANDIDATE: ____________________ GRADE: _________
SIGNATURE OF EDUCATOR: ____________________
TOTAL Q1 Q2 Q3 Q4 Q5 Q6
MARKS:
180 35 15 56 42 21 11
This marking guideline consists of 12 pages.
Skip to contentAll 2020 papers 



_hlayiso.com_--c01cc76d-6be5-4f8e-b0dd-c7487e06934f/v1-34719e235a0428d8db32/card.webp)

View all





Computer Applications Technology Grade 12 P1 2020 Memo (Eng)
Grade 12 Computer Applications Technology Paper 1 memorandum from the Eastern Cape Mock Exam 2020 (English), 12 pages. Read online or download the free PDF.
Computer Applications Technology · Grade 12 · Eastern Cape Mock Exam · 2020 · English. Memorandum, 12 pages. Read online or download the PDF.
- Subject
- Computer Applications Technology
- Grade
- Grade 12
- Language
- English
- Document type
- Memorandum
- Year
- 2020
- Exam period
- Eastern Cape Mock Exam
- Paper
- 1
- Curriculum
- CAPS
- Pages
- 12
- File size
- 475.4 KB
Free to read online, no sign-up needed
Loading document…
Loading document…
1 of 12
This exam
Eastern Cape Mock Exam 2020
Questions in this paper
Document textSearch extracted text and jump to a page.
Downloaded from hlayiso.com
2 COMPUTER APPLICATIONS TECHNOLOGY P1 (EC/SEPTEMBER 2020)
QUESTION 1 File Name: 1_4th Industrial Revolution Total Q1: 35
Maximum Candidate
No. Criteria Mark Mark
1.1.1 Cover Page
1 1
Year changed to 2020 using the text control.
1.1.2 Cover Page
1 1
And rotated 90 degrees.
1.2.1 Table of Contents
1
Text set to Normal Style
1 3
Only the text not heading changed
1
Text not in ToC anymore
1.2.2 Style
1
Style modified to blue 2
Spacing after paragraph set to 12pt 1
1.3 Find and Replace
1
All occurrences of 4th Industrial Revolution replaced
by 4IR. 2
1
All occurrences (5 Occurrences)
1.4 Border 1
Yellow border applied
2pt border 1 3
an Offset Top shadow effect added to the
1
image
1.5 Picture
1
Picture has been wrapped tight, square or through
Moved to the right of the paragraph 1
Figure 2 has been moved below the picture 3
1
1.6 Endnote
Endnote inserted in the correct place 1
Text: “Founder and Executive Chairman of the 2
World Economic Forum” typed in 1
Copyright reserved Please turn over
Downloaded from hlayiso.com
(EC/SEPTEMBER 2020) COMPUTER APPLICATIONS TECHNOLOGY P1 3
1.7 Citation 1
Journal Article (source) used
1 3
Author Klaus Schwab inserted
Year 2020 inserted
1
1.8 Page setup
1
Section breaks inserted before and after page 5
Page 5 set to landscape 1 3
All other pages set to remain in portrait
1
1.9 Spell Check
Labor changed to labour 1 1
1.10 Paragraphs
1
Paragraphs sorted 2
In ascending order 1
1.11 Page numbering 1
Page numbering inserted
1
In the footer of the document
Centred 1
5
First two pages not numbered
Numbering starts on page 3 as page 1 1
1
1.12 Watermark 1
Watermark inserted
On the last page only 1
Text 4IR appear 4
Displaying horizontally 1
1
Total for QUESTION 1 [35]
Copyright reserved Please turn over
4
Downloaded from hlayiso.com
COMPUTER APPLICATIONS TECHNOLOGY P1 (EC/SEPTEMBER 2020)
QUESTION 2 File Name: 2_ 4IR Research Total Q2: 15
Maximum Candidate
No. Criteria
Mark Mark
2.1 Paper size
Top and bottom margins set to 1.5 cm
1
Size of the page set to 20 cm wide and 28 cm
2
high 1
2.2 Layout 1
Three columns created
Spaces between columns set to 1.1 cm 1
Highlighted text appears on top of each 4
column 1
Columns are justified
1
2.3 Table
Text is converted into a table with four columns 1
Grid Table 4 Accent 2 style applied to the
table 1
Repeat header rows feature used to set table 5
headings appear on both pages in the table 1
All data in table centred, vertically
and horizontally 1
1
2.4 Paragraph
Shadowed border applied to the paragraph 1
2
Double line border style used 1
2.5 Date
Current date inserted in the footer of the 1
document 1 2
Updates automatically
Total for QUESTION 2 [15]
Copyright reserved Please turn over
(EC/SEPTEMBER 2020)
Downloaded from hlayiso.com
COMPUTER APPLICATIONS TECHNOLOGY P1 5
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.
Maximum Candidate
No. Criteria
Mark Mark
WardInfo worksheet
3.1.1 Merge and Centre
Cells A1 to O1 are merged
1
and centred 2
1
3.1.2 Fill
Any fill is applied to merged cells 1
Thin diagonal stripe pattern style fill effect applied 2
(accept any diagonal stripes) 1
3.1.3 Wrap Text
Row 3 wrapped 1 1
3.1.4 Panes
1
Freeze panes
2
Row 3
1
3.2 Comment
1
Comment inserted in cell E4
2
Text Unit Price displays
1
3.3 Text functions (Cell B5)
=CONCATENATE(LEFT(A5;1);
RIGHT(A5;2);LOWER(LEFT(C5;1))) 1
Correct function used (Concatenate or & function)
First letter of the Ward Name extracted 1
4
Last two letters of Ward Name
First letter of location in lower case 1
1
Copyright reserved Please turn over
6
Downloaded from hlayiso.com
COMPUTER APPLICATIONS TECHNOLOGY P1 (EC/SEPTEMBER 2020)
3.4 Cell K5
=SUM(E5:I5)
Formula: Sum 1
2
Range: (E5:I5)
1
3.5 Cell L8
=J8-K8
Correct cells used
Subtraction sign 1
2
1
3.6 M5
1
=E5/$E$4
1
Correct cells used
4
Division sign used
1
Absolute cell reference applied to cell E4
Formula copied to all other cells
1
3.7 Cell N6 1
=E6/K6*100 OR E6/K6
1
3
Correct cells used
Correct sign used 1
Set to a percentage with no decimal places
3.8 Conditional formatting
1
Conditional formatting used in column L
Cell value <0 1 3
Green fill with dark green text applied
1
3.9 Cell O5
=IF(L5<0;" ";"Bonus") 1
Function: IF
1
Condition: L5<0 4
Value if true is correct 1
Value if false is correct
1
3.10 Cell E37
=SUMIF(C5:C34;"Urban";J5:J34) 1
Function: Sumif
1
Criteria range C5:C34 4
Criteria - Urban
1
Sum range J5:J34
1
Copyright reserved Please turn over
EC/SEPTEMBER 2020)
Downloaded from hlayiso.com
COMPUTER APPLICATIONS TECHNOLOGY P1 7
3.11 Cell E39
=IF(AND(C7="Rural";N7>25);"Award";"No 1
Award")
Functions: IF and AND 1 4
Condition (C7="Rural";N7>25);
Value if true is correct 1
Value if false is correct 1
3.12 Cell E41 1
=COUNTIF(C5:C34;"Semi Rural")
1
Function: Countif 3
Range: C5:C34; 1
Criteria: "Semi Rural"
3.13 Cell E43
1
=VLOOKUP(A7;ExtraInfo!A2:C31;3;FALSE)
Function: Vlookup 1
Lookup value : A7
5
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) 1
2
1
Function: COUNTBLANK
Range: (E5:E34)
3.14 Graph Worksheet
Graph title Readiness for 4IR 1
Both series points plotted correctly.
Any Stacked Bar graph used. 1
Vertical axis appears as in graph
1
Centred 7
Legend series added to top of graph
1
Move graph to the worksheet 4IR 1
1
1
Total for QUESTION 3 [56]
Copyright reserved Please turn over
8
Downloaded from hlayiso.com
COMPUTER APPLICATIONS TECHNOLOGY P1 (EC/SEPTEMBER 2020)
QUESTION 4 File Name: 4_4IR Total Q4: 42
Maximum Candidate
No. Criteria
Mark Mark
Table: Wards
4.1.1 Field: WardName
> inserted in Format field property 1 1
4.1.2 Field: WardNumber
1
Required property set to Yes 2
1
Format of field set to 'Fixed' format
4.1.3 Image
Data type of Image field changed to OLE Object/ 1 1
Hyperlink
4.1.4 Validation
<= 2020/06/30 OR < 2020/07/01
OR <=#2020/06/30# OR <#2020/07/01# 1 3
1
Any appropriate validation text that refers to the 1
limitation of the date
4.1.5 Devices Field
1
New field created Devices
1 3
Data type set to lookup value
1
Data on the Info table used
4.2 Form: frm4_2
Form frm4_2 based on WardInfo table and
Columnar layout selected
Selected fields: WardName; WardNumber;
Location; Budget; Expenditure and Balance 1
1
The background of the form header is yellow
1
Font size of heading is 36 pt
1
Heading is centred 1
4_Form.jpg picture inserted 1
10
In form header aligned right 1
Format of Budget field changed to Currency with 1
zero decimal places 1
Button inserted in form footer 1
Shows the next record when button is clicked
Copyright reserved Please turn over
EC/SEPTEMBER 2020)
Downloaded from hlayiso.com
COMPUTER APPLICATIONS TECHNOLOGY P1 9
4.3.1 Qry4_3_1
1
Only Location and Expenditure
Location: Total: Grouped by 1 3
Expenditure: Total: Sum
1
4.3.2 Qry4_3_2
Only Rural 1
and Semi-Rural records show
Total calculated 1 4
Total of Budget field (SUM) 1
1
4.3.3 Qry4_3_3
Loan: 30/100*[Budget] 1
1
Criteria Balance : <0
Loan: 1 5
30/100 1
*[Budget] 1
Loan set to R currency
Report
4.4 1
Report4_4
Report created 1
Grouped according to Location and then
according to Budget 1
Total budget for each Location calculated
in the Location footer = Sum([Budget]) 1
Rural Locations are formatted red
New field Future Projections created . 1 10
Calculation of Future Projections
=10/100 1
*[Budget]
+[Budget] 1
OR =110/100*[Budget]
1
1
1
Total for QUESTION 4 [42]
Copyright reserved Please turn over
10
Downloaded from hlayiso.com
COMPUTER APPLICATIONS TECHNOLOGY P1 (EC/SEPTEMBER 2020)
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.
Maximum Candidate
No Criteria
Mark Mark
5.1 Heading 1
<center><h1><font size="50" face="Century">THE 1
TIME HAS COME</font></h1> </center> 2
Heading is centred 1
Font size set to 50
5.2 Anchor 1
<a name="Top"></a>
Link tags correctly inserted 1 3
On words 'driver distraction'
Correct anchor name 1
5.3 Image
<p align="center"><img src="5Pic.png"
border="5"></p> 2
Extension for the image corrected 1
Image centred 1
5.4 Bulleted list
<ul> </ul>
Ordered list <ul> created. 1 3
<li> </li> tags used correctly 1
Applied to all listed items 1
5.5 Table
Table colour is lightblue 1 2
Width of the table is 80% 1
Copyright reserved Please turn over
EC/SEPTEMBER 2020)
Downloaded from hlayiso.com
COMPUTER APPLICATIONS TECHNOLOGY P1 11
5.6 Table row
<tr>
<th>AR</th>
1
<td>15</td>
<td>34</td> 3
1
</tr>
New row added 1
Correct tags used
Correct data entered
5.7 Table row
<td align="center" colspan="3"><b>Be Ready!!
</b></td> 2
Row merged across three columns 1
1
Text changed bold
5.8 Link
<a href="#Top">Back to top</a>
3
<a href> </a> 1
Link created on the text ‘Back to Top 1
Link moves to the top of website 1
Closing tag(s) or triangular brackets and correct nesting 1 1
correctly used
Total for QUESTION 5 [21]
Copyright reserved Please turn over
Downloaded from hlayiso.com
12 COMPUTER APPLICATIONS TECHNOLOGY P1 (EC/SEPTEMBER 2020)
QUESTION 6 File Name: 6_Calculation, 6_Quote Total Q6: 11
Maximum Candidate
No, Criteria
Mark Mark
6.1.1 Date
1
Today’s date inserted 2
In this format: (2020)(03)(10) 1
6.1.2 Table
1
Table created
3 columns and 2 rows 1
4
Spacing between columns set 1
to 0.3 cm
1
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
Copyright reserved Please turn over
Study this subject
Recommended for this subject

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

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

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

Memorandum
Computer Applications Technology Grade 12 P2 2019 Memo (Eng)
_hlayiso.com_--c01cc76d-6be5-4f8e-b0dd-c7487e06934f/v1-34719e235a0428d8db32/card.webp)
Memorandum
Computer Applications Technology Grade 12 P2 2017 Memo (Eng)

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

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

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

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

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

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

Errata