# Computer Applications Technology Grade 12 P1 2026 Memo (Eng)
> Grade 12 Computer Applications Technology Paper 1 memorandum from the NSC November Mock Exam 2026 (English), 12 pages. Read online or download the free PDF.
- Page: https://www.hlayiso.com/library/grade-12-computer-applications-technology-2026-nsc-november-mock-exam-memorandum-paper-1/904605c9-43e9-4157-96e3-9b1d31c1f8f8
- Updated: 2026-10-29
- Subject: Computer Applications Technology
- Grade: Grade 12
- Language: English
- Document type: Memorandum
- Year: 2026
- Exam period: NSC November Mock Exam
- Paper: 1
- Publisher: Hlayiso
- 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 2026 Memo (Eng)](https://www.hlayiso.com/library/grade-12-computer-applications-technology-2026-nsc-november-mock-exam-memorandum-paper-1/904605c9-43e9-4157-96e3-9b1d31c1f8f8)
## About this document
Computer Applications Technology · Grade 12 · NSC November Mock Exam · 2026 · English. 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
hlayiso mock exams
Practice Series:
Grade 12 NSC Preparation
WWW.HLAYISO.COM
NATIONAL
SENIOR CERTIFICATE
GRADE 12
COMPUTER APPLICATIONS TECHNOLOGY P1
MOCK EXAMINATION 2026
MARKING GUIDELINES
MARKS: 150
These marking guidelines consist of 12 pages.
Copyright reserved Please turn over
### Page 2
Computer Applications Technology/P1 2 Hlayiso/Mock 2026
NSC – Marking Guidelines
CENTRE NUMBER
EXAMINATION
NUMBER
QUESTION 1 2 3 4 5 6 7 TOTAL
POSSIBLE MARK 24 21 18 22 35 15 15 150
CANDIDATE MARK
MARKER CODE/
SIGNATURE
MODERATED
MARK
GENERAL NOTES TO MARKERS
• Check the accuracy and skill required before awarding a mark throughout.
• Mark the spreadsheet questions from the formulae and NOT from the values/answers in
the cells. Cell references may differ, depending on the candidate’s response.
• Candidates may use multiple formulae, cells or ’building blocks’ to reach answers. Named
ranges may be used instead of cell references. The answers must still be correct if changes
are made to the existing data.
• Mark the HTML question from the code. Numerical attribute values and single words do
not need to be in inverted commas.
• Expected values/record counts are given as a guide; they are calculated on the original
data files.
Copyright reserved Please turn over
### Page 3
Computer Applications Technology/P1 3 Hlayiso/Mock 2026
NSC – Marking Guidelines
QUESTION 1 File name(s): 1Power Total Q1: 24
No. Criteria Maximum Candidate
mark mark
Examination number in the header –
(Note to marker: Not marked separately, but required
to identify the work.)
1.1 Cover page 3
• Facet cover page inserted 3 1
• Document title: Going Solar 3 1
• Abstract content control removed 3 1
1.2 Style modified: Solar 3
• Border: Bottom border only 3 1
• Width 1½ pt AND any orange colour 3 1
• Spacing: After: 12 pt 3 1
(Style must be modified, not direct formatting on the
paragraphs)
1.3 Image: 1Panel 3
• ’Question/Vraag 1.3’ replaced with 1Panel image 3 1
• Width: 6 cm with aspect ratio locked (height approx. 4 1
cm) 3
• Wrap text: Square 3 1
1.4 Find and replace: ’inverter’ 3
• Font: Bold 3 1
• Underline style: Double 3 1
• 10 replacements made (Find whole words only – 1
’inverters’ NOT changed) 3
1.5 Table below ’2.1 Typical system costs’ 5
• Table style: Any Grid Table 4 style 3 1
• Price (R) column: Right aligned 3 1
• Formula field inserted in the last cell of the Average 1
row 3
• Function: =AVERAGE(ABOVE) 3 OR 1
=AVERAGE(C2:C5)
• Number format: Currency with no decimals, e.g. 1
R#,##0 (displays R152 125) 3
Alt+F9: { =AVERAGE(ABOVE) \# "R#,##0" }
1.6 Footnote: ’NERSA’ 3
• Footnote inserted on the word NERSA 3 1
• Number format: i, ii, iii, … 3 1
• Footnote text: National Energy Regulator of South 1
Africa 3
1.7 Table of contents 3
• Automatic table of contents replaced ’Question/Vraag 1
1.7’ 3
Copyright reserved Please turn over
### Page 4
Computer Applications Technology/P1 4 Hlayiso/Mock 2026
NSC – Marking Guidelines
No. Criteria Maximum Candidate
mark mark
• Show levels: 2 (only Heading 1 and Heading 2 1
entries) 3
• Tab leader: Dash (- - - -) 3 1
Alt+F9: { TOC \o "1-2" \h \z \u }
1.8 Pagination: ’3. Battery storage’ 1
• Page break before 3 (OR manual page break 1
inserted before the heading)
Total for QUESTION 1 [24]
Copyright reserved Please turn over
### Page 5
Computer Applications Technology/P1 5 Hlayiso/Mock 2026
NSC – Marking Guidelines
QUESTION 2 File name(s): 2Tips Total Q2: 21
No. Criteria Maximum Candidate
mark mark
2.1 Drop cap: ’Load-shedding and higher …’ 3
• Position: Dropped 3 1
• Lines to drop: 3 3 1
• Distance from text: 0.3 cm 3 1
2.2 Bookmark and hyperlink 3
• Bookmark ’Tips’ inserted on the heading ’Saving tips’ 1
3
• Hyperlink on ’see the tips’ to the Tips bookmark 3 1
• ScreenTip: Save power 3 1
Alt+F9: { HYPERLINK \l "Tips" \o "Save power" }
2.3 Bullets: ’Install a geyser blanket …’ 2
• Numbered list changed to a bulleted list (all FIVE 1
items) 3
• Symbol: Wingdings character code 74 (smiley face) 3 1
2.4 Columns 3
• Two columns applied 3 1
• Line between 3 1
• Only the text from ’Saving tips’ to ’…during peak 1
hours.’ is in columns (continuous section breaks) 3
2.5 Caption: Image below ’Measure your usage’ 3
• Caption inserted below the image, Label: Figure 3 1
• Numbering format: A, B, C, … 3 1
• Caption text: ’: Smart meter’ 3 (displays Figure A: 1
Smart meter)
2.6 Tab stop: Text below ’Contact our branches’ 3
• Tab stop applied to all FOUR lines 3 1
• Position 15 cm AND Alignment: Right 3 1
• Leader: 2 (dots) …… 3 1
2.7 Watermark 3
• Custom text watermark: LANGA 3 1
• Font: Arial 3 1
• Layout: Horizontal 3 1
2.8 Field: Number of words 1
• NumWords field replaced ’Question/Vraag 2.8’ 3 1
(Alt+F9: { NUMWORDS })
Total for QUESTION 2 [21]
Copyright reserved Please turn over
### Page 6
Computer Applications Technology/P1 6 Hlayiso/Mock 2026
NSC – Marking Guidelines
QUESTION 3 File name(s): 3Installs Total Q3: 18
No. Criteria Maximum Candidate
mark mark
3.1 Cells A1:L1 2
• A1:L1 merged and centred 3 1
• Cell style: Heading 1 3 1
3.2 Cell D3 2
=COUNTIF(G6:G45,"Yes")
• Function: COUNTIF(G6:G45, …) 3 1
• Criteria: ”Yes” 3 1
(Expected answer: 18)
3.3 Cell D4 4
=ROUND(AVERAGEIF(E6:E45,"Premium",H6:H45),2)
• Function: ROUND( …,2) 3 1
• Function: AVERAGEIF 3 (OR 1
AVERAGEIFS(H6:H45,E6:E45,”Premium”))
• Range: E6:E45 AND Criteria: ”Premium” 3 1
• Average range: H6:H45 3 1
(Expected answer: R157 812.50)
3.4 Cells L6:L45 2
=TEXT(D6,"mmmm")
• Function: TEXT(D6, …) 3 1
• Format: ”mmmm” AND copied to L45 3 1
(Expected L6: January)
3.5 Cells K6:K45 4
=VLOOKUP(E6,Rates!$A$2:$C$4,3,FALSE)
OR
=XLOOKUP(E6,Rates!$A$2:$A$4,Rates!$C$2:$C$4)
• Function: VLOOKUP with lookup value E6 3 1
• Table array: Rates!$A$2:$C$4 (absolute; 1
Rates!$A$1:$C$4 also accepted) 3
• Column index: 3 3 1
• Range lookup: FALSE OR 0 (table is NOT sorted) 3 1
(XLOOKUP: lookup value 1, lookup array 1, return
array 1, absolute references 1. Expected K6: 10)
3.6 Conditional formatting: B6:B45 4
• Conditional formatting applied to B6:B45 only 3 1
• Rule: Use a formula: =$J6 3 1
• Condition: >10000 3 1
• Format: Font colour red 3 1
(Rule: =$J6>10000 OR =J6>10000. 19 surnames
display in red, e.g. Zulu in B6)
Total for QUESTION 3 [18]
Copyright reserved Please turn over
### Page 7
Computer Applications Technology/P1 7 Hlayiso/Mock 2026
NSC – Marking Guidelines
QUESTION 4 File name(s): 4Quotes Total Q4: 22
No. Criteria Maximum Candidate
mark mark
4.1 Cell C3 2
=MAX(D10:D49)
• Function: MAX(D10:D49) 3 (OR 1
LARGE(D10:D49,1))
• Format: d mmmm yyyy (Long Date, displays 22 April 1
2026) 3
4.2 Cell C4 4
=COUNTIFS(E10:E49,"Business",F10:F49,">20")
• Criteria range 1: E10:E49 3 1
• Criteria 1: ”Business” 3 1
• Criteria range 2: F10:F49 3 1
• Criteria 2: ”>20” 3 1
(Expected answer: 6)
4.3 Cell C5 4
=SUMIFS(F10:F49,D10:D49,">=2026/03/01",
D10:D49,"<=2026/03/31")
OR
=SUMIFS(F10:F49,D10:D49,">="&DATE(2026,3,1),
D10:D49,"<"&DATE(2026,4,1))
OR =SUMPRODUCT((MONTH(D10:D49)=3)*F10:F49)
• Function: SUMIFS with sum range F10:F49 3 1
• Criteria range: D10:D49 3 1
• Criteria: >= 1 March 2026 3 1
• Criteria: <= 31 March 2026 (OR < 1 April 2026) 3 1
(SUMPRODUCT: MONTH 1, D10:D49 = 3 1, multiplied
by F10:F49 1, SUMPRODUCT 1. Expected answer:
190)
4.4 Cell J10 4
=UPPER(LEFT(B10,3))&RIGHT(C10,4)
OR =CONCAT(UPPER(LEFT(B10,3)),RIGHT(C10,4))
• Function: UPPER 3 1
• Function: LEFT(B10,3) 3 (OR MID(B10,1,3)) 1
• Function: RIGHT(C10,4) 3 1
• Joined with & OR CONCAT/CONCATENATE 3 1
(Expected answer: MTH2802)
4.5 Cells H10:H49 6
=IF(E10="School",G10*10%,
IF(AND(E10="Business",G10>150000),G10*5%,0))
OR
=IF(E10="School",G10*0.1,IF(E10="Business",
IF(G10>150000,G10*0.05,0),0))
• Correct nested IF syntax/logic and copied to H49 3 1
Copyright reserved Please turn over
### Page 8
Computer Applications Technology/P1 8 Hlayiso/Mock 2026
NSC – Marking Guidelines
No. Criteria Maximum Candidate
mark mark
• Criteria: E10=”School” 3 1
• Value if TRUE: G10*10% (OR *0.1 OR *10/100) 3 1
• Criteria: AND( …) OR nested IF 3 1
• E10=”Business” AND G10>150000 3 1
• Value if TRUE: G10*5% AND value if FALSE: 0 3 1
(Expected: H10 = R0.00; H11 = R22 200.00; total
discount for H10:H49 = R279 907.50)
4.6 Cells K10:K49 2
=RANK(I10,$I$10:$I$49) OR
=RANK.EQ(I10,$I$10:$I$49,0)
• Function: RANK OR RANK.EQ with I10 3 1
• Range: $I$10:$I$49 (absolute) 3 1
(Expected K10: 22 when the discounts in 4.5 are
correct)
Total for QUESTION 4 [22]
Copyright reserved Please turn over
### Page 9
Computer Applications Technology/P1 9 Hlayiso/Mock 2026
NSC – Marking Guidelines
QUESTION 5 File name(s): 5Langa Total Q5: 35
No. Criteria Maximum Candidate
mark mark
Table: tbl5_1
5.1.1 Primary key 1
• TechID set as primary key 3 1
5.1.2 Field: Qualified 1
• Data type: Yes/No 3 1
5.1.3 Field: EmpCode – Input mask 3
>LL-000 OR >LL\-000 OR >LL"-"000 (;;_ / ;0;
may be added)
• Upper case: > 3 1
• Two compulsory letters: LL 3 1
• Hyphen followed by THREE compulsory digits: -000 1
3
5.1.4 Field: HourlyRate – Validation 3
>=150 And <=450 OR Between 150 And 450
• >=150 3 1
• And <=450 3 1
• Validation text: Any appropriate text that refers to the 1
rule 3
5.1.5 Field: StartDate 1
• Default value: Date() 3 (OR Now()) 1
5.1.6 Field: Branch – Lookup 3
• Display control: Combo box (OR List box) 3 1
• Row source type: Value list 3 1
• Row source: ”Johannesburg”;”Pretoria”;”Polokwane” 1
3
(Lookup wizard used: award the marks if the three
values display in the drop-down list)
Form: frm5_2
5.2 Form based on tblClients 6
• Form frm5_2 created with ALL six fields in a columnar 1
layout 3
• Saved as frm5_2 3 1
• 5Logo image inserted in the form header 3 1
• Title: Langa Solar Clients 3 1
• ClientID field: Locked: Yes 3 (OR Enabled: No) 1
• Detail section: Back colour any light yellow 3 1
Query: qry5_3
5.3 Query based on tblInstallations 5
• ONLY InstallID, ClientID, InstallDate, SystemType 1
and Battery displayed 3
• SystemType criteria (row 1): ”Premium” 3 1
Copyright reserved Please turn over
### Page 10
Computer Applications Technology/P1 10 Hlayiso/Mock 2026
NSC – Marking Guidelines
No. Criteria Maximum Candidate
mark mark
• InstallDate criteria (same row): Between 1
#2026/01/01# And #2026/03/31# 3
• SystemType criteria (OR row): ”Basic” 3 1
• Battery criteria (same OR row): Yes OR True OR -1 3 1
(Expected records: 10)
Query: qry5_4
5.4 Calculated field 4
CostPerPanel: [Cost]/[Panels]
• Field name: CostPerPanel 3 1
• Calculation: [Cost]/[Panels] 3 1
• Format property: Currency 3 1
• Sorted: Descending on CostPerPanel 3 1
(Expected first record: I043 – R11 416.67; last record:
I028 – R7 683.33)
Query: qry5_5
5.5 Totals query 4
• SystemType: Group By 3 1
• InstallID (or any field): Count 3 1
• Cost: Sum 3 1
• SumOfCost sorted Descending 3 1
Expected:
SystemType CountOfInstallID SumOfCost
Standard 21 R2 132 300.00
Premium 10 R1 606 800.00
Basic 14 R915 300.00
Report: rpt5_6
5.6 Report based on tblInstallations 4
• Area, InstallID, SystemType and Cost fields displayed 1
and grouped by Area 3
• Area footer: =Sum([Cost]) 3 1
• Page orientation: Landscape 3 1
• Report title: Installations per area 3 1
(Expected totals, e.g. Soweto R996 700.00; Centurion
R750 400.00; Sandton R158 600.00)
Total for QUESTION 5 [35]
Copyright reserved Please turn over
### Page 11
Computer Applications Technology/P1 11 Hlayiso/Mock 2026
NSC – Marking Guidelines
QUESTION 6 File name(s): 6_1Solar; 6_2Battery Total Q6: 15
No. Criteria Maximum Candidate
mark mark
6.1.1 Comment 1
• Examination number inserted as a comment 3 1
6.1.2 Image: 6_1Sun 3
• Image tag with src=”6_1Sun.png” 3 1
• Attribute: align=”right” 3 1
• Attribute: width=”150” 3 1
6.1.3 Heading 2
Langa Solar
OR tags around the heading
• Centred: align=”center” OR 3 1
• Font colour: 3 1
6.1.4 Table 3
| Our
packages |
• Attribute: border=”2” 3 1
• Attribute: colspan 3 1
• Value: 3 3 1
6.1.5 List 2
…
• changed to (opening AND closing tags) 3 1
• Attribute: type=”i” 3 1
6.2 6_2Battery 3
Did you know? … evening.
Back to home
page
• Image: align=”left” 3 1
• Italic tags around the ’Did you know? …’ text 3 1
• Link: … on ’Back to 1
home page’ 3
Closing tags and nesting 1
• Closing tags/triangular brackets and nesting correctly 1
used in BOTH web pages 3
Total for QUESTION 6 [15]
Copyright reserved Please turn over
### Page 12
Computer Applications Technology/P1 12 Hlayiso/Mock 2026
NSC – Marking Guidelines
QUESTION 7 File name(s): 7Letter; 7Merged; 7Usage Total Q7: 15
No. Criteria Maximum Candidate
mark mark
7Letter; 7Merged
7.1 Mail merge 5
• 7Clients linked as the data source of 7Letter 3 1
• Filter: City equal to Pretoria 3 1
• Filter: Battery equal to No 3 1
• <> replaced with the <> 1
merge field 3
• Merge completed and saved as 7Merged 3 1
(Expected: 8 letters in 7Merged)
7Usage – Usage worksheet
7.2 Chart 5
• Correct data used: A1:D13 (months, Generated, 1
Consumed and Savings) 3
• Generated and Consumed as clustered columns 3 1
• Savings as a line on the secondary axis 3 1
• Chart title: Energy usage 2025 3 1
• Chart moved to a new chart sheet named Chart 3 1
7Usage – Payments worksheet
7.3 Data validation: C2:C61 3
• Data validation applied to C2:C61, Allow: List 3 1
• Source: Cash,EFT,Card 3 1
• Error alert message: Choose from the list 3 1
7.4 Page setup 2
• Print titles: Rows to repeat at top: $1:$1 3 1
• Scaling: Fit All Columns on One Page (Fit to 1 page 1
wide) 3
Total for QUESTION 7 [15]
TOTAL: 150
Copyright reserved
## Related documents
- [CAT P1 GR12 MEMO SEPT 2020 English](https://www.hlayiso.com/library/cat-p1-gr12-memo-sept-2020-english/fe852a1d-d162-4072-a9a0-fa24c6d26774) — Computer Applications Technology · Memo · 2020 · Eng
- [CAT P1 GR12 MEMO SEPT 2019 English](https://www.hlayiso.com/library/cat-p1-gr12-memo-sept-2019-english/ef2df5b1-6950-4769-9979-f22d14b986c1) — Computer Applications Technology · Memo · 2019 · Eng
- [CAT P1 QP GR12 SEPT 2024 English](https://www.hlayiso.com/library/cat-p1-qp-gr12-sept-2024-english/bf2518c3-ae79-4251-8145-1b062895b12f) — Computer Applications Technology · QP · 2024 · Eng
- [CAT P1 QP GR12 SEPT 2022 English](https://www.hlayiso.com/library/cat-p1-qp-gr12-sept-2022-english/2c41f16c-52dc-4d98-a4a4-e3296512bace) — Computer Applications Technology · QP · 2022 · Eng
- [CAT P1 GR12 QP SEPT 2020 English](https://www.hlayiso.com/library/cat-p1-gr12-qp-sept-2020-english/6e7f27db-454b-4095-a4e8-522ceffa7412) — Computer Applications Technology · QP · 2020 · Eng
- [CAT P2 GR12 MEMO SEPT2019 English](https://www.hlayiso.com/library/cat-p2-gr12-memo-sept2019-english/be90bdf5-3d2f-40b0-8dfd-16e7142e74e6) — Computer Applications Technology · Memo · 2019 · Eng
## More from Grade 12 Computer Applications Technology
- [CAT P2 GR12 QP September 2025 ENG watermark](https://www.hlayiso.com/library/cat-p2-gr12-qp-september-2025-eng-watermark/fd63d968-a454-409d-9293-0862b56232b1) — QP · 2025 · Eng
- [CAT P2 GR12 QP SEPT 2024 English](https://www.hlayiso.com/library/cat-p2-gr12-qp-sept-2024-english/b8b0a9f3-f8c6-4f0a-8ddf-30b58008b603) — QP · 2024 · Eng
- [Computer Applications Technology P1 Nov 2024 Afr](https://www.hlayiso.com/library/computer-applications-technology-p1-nov-2024-afr/502fe6df-4d11-41d1-8e23-b219565e715b) — QP · 2024 · Afr
- [Computer Applications Technology P1 Nov 2023 Eng](https://www.hlayiso.com/library/computer-applications-technology-p1-nov-2023-eng/60311585-04c7-46dc-bcf6-87da09dc1ea5) — QP · 2023 · Eng
- [ERRATA CAT P1](https://www.hlayiso.com/library/errata-cat-p1/363f4b7e-98be-46d4-9d47-fcfea8705198) — Errata · 2022
- [CAT P2 GR12 SEPT2022 English deaf](https://www.hlayiso.com/library/cat-p2-gr12-sept2022-english-deaf/54bb9db8-ddb8-49da-98d3-9305d3e38697) — QP · 2022 · Eng
## Collection
- [Grade 12 past papers](https://www.hlayiso.com/grade-12/past-papers)
---
Hlayiso: free CAPS and IEB past papers, memos, notes and study guides for South African learners. When citing, link the page URL above, not a PDF or /api/ URL.