# Computer Applications Technology Grade 12 P1 2021 Memo (Eng)
> Grade 12 Computer Applications Technology Paper 1 memorandum from the Eastern Cape Mock Exam 2021 (English), 12 pages. Read online or download the free PDF.
- Page: https://www.hlayiso.com/library/cat-p1-memo-gr12-sept-2021-eng-d/1b3ca7d1-9908-4164-be1b-cb607c6c21e1
- Updated: 2026-09-27
- Subject: Computer Applications Technology
- Grade: Grade 12
- Document type: Memorandum
- Year: 2021
- Exam period: Eastern Cape Mock Exam
- Paper: 1
- Curriculum: CAPS
- Pages: 12
Breadcrumbs: [Home](https://www.hlayiso.com/) › [Library](https://www.hlayiso.com/library) › [Grade 12](https://www.hlayiso.com/library/grade-12) › [Computer Applications Technology](https://www.hlayiso.com/library/grade-12/computer-applications-technology) › [Computer Applications Technology Grade 12 P1 2021 Memo (Eng)](https://www.hlayiso.com/library/cat-p1-memo-gr12-sept-2021-eng-d/1b3ca7d1-9908-4164-be1b-cb607c6c21e1)
## About this document
Computer Applications Technology · Grade 12 · Eastern Cape Mock Exam · 2021. Memorandum, 12 pages. Read online or download the PDF.
Read it free online on the page above; download the PDF from there.
## Document text
Text extracted from the PDF. Layout, diagrams and tables may not survive extraction.
### Page 1
Downloaded from hlayiso.com
NATIONAL
SENIOR CERTIFICATE
GRADE 12
SEPTEMBER 2021
COMPUTER APPLICATIONS TECHNOLOGY P1
MARKING GUIDELINE
NAME OF CANDIDATE: GRADE:
SIGNATURE OF EDUCATOR:
TOTAL Q1 Q2 Q3 Q4 Q5 Q6
MARKS: 150 27 17 46 35 17 08
This marking guideline consists of 12 pages.
### Page 2
Downloaded from hlayiso.com
2 COMPUTER APPLICATIONS TECHNOLOGY P1 (EC/SEPTEMBER 2021)
QUESTION 1 File Name: 1_World Literacy Day Total Q1: 27
Maximum Candidate
No. Criteria
Mark Mark
1.1.1 Cover Page
1
x Filigree cover page style selected. 9 1
1.1.2 Cover Page
x Document name and date field typed. 9 1 2
x All other fields deleted. 9 1
1.2. Table of Contents
x Heading 2 levels activated. 9 1 2
x Table of contents updated. 9 1
1.3 Page Numbering
x Section breaks applied on the second page. 9 1
x First two pages not numbered. 9 1 3
x Numbering starts on page 3 at number 1. 9 1
1.4 Shading
x Green Accent 6 shading applied 9 1 2
x to the whole paragraph. 9 1
1.5 Footnotes
x Footnote inserted 9 1
x with explanation ‘America’s most trusted online
dictionary for English word definitions, meanings
1 3
and pronunciation.’ 9
x Footnote inserted below text. 9 1
1.6 Picture formatting
x Picture wrapped to tight or through. 9 1
x Picture right aligned. 9 1 3
x Picture set to height 3.5 cm and width 7.5 cm. 9 1
1.7 References
x Placeholder 1 edited with a book source. 9 1
Book title: Practical guide to functional
1 3
literacy: a method of training for
development. 9 1
x Published in 1973. 9
1.8 Find and Replace
x Word ‘Literacy’ made bold. 9
1
x Only those occurrences in lower case are 2
changed. 9 1
(Only 5 changes)
Copyright reserved Please turn over
### Page 3
Downloaded from hlayiso.com
(EC/SEPTEMBER 2021) COMPUTER APPLICATIONS TECHNOLOGY P1 3
1.9 Page Orientation
x Section breaks applied. 9 1 2
x Only second last page in landscape. 9 1
1.10 Table Styles
x Table style applied 9 1
x Table style Grid Table 4 Accent 6 9 1 3
x Text aligned both horizontally and vertically 9 1
1.11 Word Count
x Words counted. 9 1 1
Total for QUESTION 1 [27]
Copyright reserved Please turn over
### Page 4
Downloaded from hlayiso.com
4 COMPUTER APPLICATIONS TECHNOLOGY P1 (EC/SEPTEMBER 2021)
QUESTION 2 File Name: 2_Registration Form Total Q2: 17
Candidate
No. Criteria Maximum Mark
Mark
2.1 Margins
x Top and bottom margins set. 9 1 1
2.2 Page
x Double line page border 9 1 1
2.3 Picture
x Picture centred 9 1 2
x A soft edge oval picture style applied. 9 1
2.4 Legacy Form tools
x Field set to maximum length of 4. 9 1 2
x Text format set to uppercase. 9 1
2.5 Dropdown field
x Male and Female options added. 9 1
x Help message inserted. 9 1 3
x Text “For accommodation purposes”. 9 1
2.6 Smart Art
x A shape called Advanced added to Digital Literacy
Course. 9
3
x Two shapes Coding and Internet added to 1
Advanced shape. 9 1
x Correct naming of shapes. 9 1
2.7 Linked Documents
x The pdf file ‘Benefits-digital-literacy.pdf’ has been
inserted 9 1 3
x as an embedded file. 9 1
x Shows as an icon. 9 1
2.8 Footer
x The text, ‘Registration Form’ added in the footer. 9 1 2
x Text right aligned in the footer. 9 1
Total for QUESTION 2 [17]
Copyright reserved Please turn over
### Page 5
Downloaded from hlayiso.com
(EC/SEPTEMBER 2021) COMPUTER APPLICATIONS TECHNOLOGY P1 5
QUESTION 3 File Name: Attendees Total Q3: 46
Maximum Candidate
No. Criteria
Mark Mark
Attendee_Info worksheet
3.1.1 Cell formatting
x Row merged from Cell A1 to X2. 9 1 1
3.1.2 Text Alignment
x Headings aligned horizontally and vertically. 9 1 1
3.1.3 Freeze Panes
x Rows 1 to 8 frozen 9 1 1
3.2 Date
x =Today() 9 1 2
x Custom formatted to yyyy-mmmm-dd 9 1
3.3 B9
=IF(F9="M","Mr.","Ms.")
1
x Function: IF 9 3
1
x Argument set correctly 9
x Both true and false values are correct 9 1
3.4 S10
=COUNTIF(H10:R10,"X")
x Function: Countif 9 1
3
x Range: H10:R10 9 1
x Criteria: ‘X’ 9
1
3.5 U11 Calculation
=$V$7*S11
1
x Correct cells used 9 3
x Multiplication sign used 9 1
x Absolute cell reference applied correctly 9 1
3.6 V13 Calculation
=U13*75/100 or U13 * 0.75
1 2
x U13 Correct cell used 9
x Correct calculation of a percentage 9 1
3.7 Conditional formatting
Formula =$T9="No"
Range =$D$9:$D$108
1
x Formula: =$T9="No" 9 OR =T9="No" 9
x Absolute cell reference applied to the range 9 1 3
x Range: =D9:D108 9 1
(Accept if column doesn’t have Absolute cell reference)
Copyright reserved Please turn over
### Page 6
Downloaded from hlayiso.com
6 COMPUTER APPLICATIONS TECHNOLOGY P1 (EC/SEPTEMBER 2021)
Maximum Candidate
No. Criteria
Mark Mark
3.8 W9
=IF(S9<=5, "Greens", IF(S9<=8, "Blues", IF(S9<=10,
"Reds","Yellows")))
1
x Function: Nested IF 9
4
x Correct criteria: 9 1
x Value true and false set correctly 9 1
x Answer copied to other cells 9
1
3.9 X9
=IF(AND(T9="Yes",V9>=50), "Discount"," ")
1
x Function: IF and AND 9
x First criteria: T9= "Yes"9 1 4
x Second criteria: V9>=50 9 1
x True and False Value: "Discount"," " 9
1
3.10 G111 Date
= YEAR(TODAY())-YEAR(G108)
1
x YEAR(TODAY()) 9 3
x - minus sign 9 1
x YEAR(G108) 9 1
3.11 G113
=HLOOKUP(Statistics!F1,Statistics!A1:K2,2,False)
x Function: HLOOKUP 9 1
x Lookup_value: Statistics!F1 9 1
x Table_array: Statistics!$A$1:$K$2 9 5
x Row_index_num: 2, 9 1
x Range_lookup: False 9 1
(Ignore if Absolute cell reference was not used)
1
3.12 G115
=SUMIF(T10:T108,"Yes",U9:U108)
1
x Function: Sumif 9
x Range: T10:T108 9 1 4
x Criteria: “Yes” 9 1
x Sum range: U9:U108 9
1
Copyright reserved Please turn over
### Page 7
Downloaded from hlayiso.com
(EC/SEPTEMBER 2021) COMPUTER APPLICATIONS TECHNOLOGY P1 7
3.13 Graph
x Chart area formatted with a background picture
1
3Digital Literacy 9
x Transparency set to 50% 9 1
x Budget and Typing a letter removed 9 1
x Using a filter 9 7
x A data callout label added 9 1
x To the most popular course (Know your smart 1
phone) 9
x Graph moved to a new worksheet Graph 9 1
1
Total for QUESTION 3 [46]
Copyright reserved Please turn over
### Page 8
Downloaded from hlayiso.com
8 COMPUTER APPLICATIONS TECHNOLOGY P1 (EC/SEPTEMBER 2021)
QUESTION 4 File Name: 4_Digital literacy Total Q4: 35
Candidate
No Criteria Maximum Mark
Mark
Table: Personal Information
4.1.1 Field: Date of Birth
1
3
x <9= 9 Now () 9 1
1
4.1.2 Course Code: Input Mask
x > 9 1
x 999 9 1
x -9 4
1
x LLL 9 1
4.1.3 Field: Courses
x Lookup wizard used as data type 9 1
x Database table used 9 3
1
x Course information 9
1
4.2 Form: Attendee Information
=(Date()-[Date of Birth])/365
x Functions added to details section 9 1
x =(Date() - 9 1
x [Date of Birth]) 9 1
1 6
x /365 9
x Date changed to Fixed/Standard format with no 1
decimal places 9 1
x Suitable label added 9
QUERIES
4.3.1 Qry4_3_1
Field: Date of Birth
x Between Date() 9 1
3
x And #2003/01/01# 9 1
x Sorted in descending of Level of Literacy 9 1
Copyright reserved Please turn over
### Page 9
Downloaded from hlayiso.com
(EC/SEPTEMBER 2021) COMPUTER APPLICATIONS TECHNOLOGY P1 9
4.3.2 Qry4_3_2
Data: [No of days to attend] *30
Field: Data Bundle <>Vodacom
x <>Vodacom 9 1
x Calculated Field: Data: 9 1
x [No of days to attend] 9 1 6
x *30 9 1
x Total calculated in datasheet view 9 1
x Total function used to calculate the total amount. 9 1
REPORT
4.4 Report4_4
x Report created. 9
x Only show the Last Name, Date of Birth, Gender,
No of Courses, Level of Literacy and No of days to
attend fields. 9 1
x Grouped according to Gender. 9 1
x Grouped again according to Level of Literacy. 9 1
1 10
x Report set to Landscape. 9 1
x =Count 9 ([gender]) 9 OR =Count 9 (*) 9 1
1
x Appropriate descriptive label added. 9 1
1
x All data displays fully. 9
1
x Report saved as rpt4_4. 9
Total for QUESTION 4 [35]
Copyright reserved Please turn over
### Page 10
Downloaded from hlayiso.com
10 COMPUTER APPLICATIONS TECHNOLOGY P1 (EC/SEPTEMBER 2021)
QUESTION 5 File Name: 5_Digital Literacy Total Q5: 17
x This question should be marked from the HTML code.
x Numerical attribute values do not need to be in inverted commas.
Maximum Candidate
No Criteria
Mark Mark
5.1 Background Colour
x Tag bgcolor used 9 2
1
x Colour cream applied to whole website 9 1
5.2 Image
x Img scr corrected to img src 9 1 3
x Jpg corrected to png 9 1
x Center tag used to centre the picture. 9 1
5.3 Unordered Lists
1 2
x tags used 9
1
x Type = square used correctly 9
5.4 Table
< td align = "center" colspan = "3"> Let us be digital
literate
x Table border set to “5 pt” 9 1
x Table width set to 70% 9 1
6
1
x Row 7 merged 9 1
x Across 3 columns9 1
1
x Text aligned centre and in 9
x bold 9
Copyright reserved Please turn over
### Page 11
Downloaded from hlayiso.com
(EC/SEPTEMBER 2021) COMPUTER APPLICATIONS TECHNOLOGY P1 11
5.5 Links
For further digital literacy training,
Click here for the
brochure
3
x Link created