# Computer Applications Technology Grade 10 P1 2026 Memo (Eng)
> Grade 10 Computer Applications Technology Paper 1 memorandum from the November Mock Exam 2 2026 (English), 10 pages. Read online or download the free PDF.
- Page: https://www.hlayiso.com/library/grade-10-computer-applications-technology-2026-november-mock-exam-2-memorandum-paper-1/15a7a461-3607-4e4f-ac34-986b4f64b1ae
- Updated: 2026-10-29
- Subject: Computer Applications Technology
- Grade: Grade 10
- Language: English
- Document type: Memorandum
- Year: 2026
- Exam period: November Mock Exam 2
- Paper: 1
- Publisher: Hlayiso
- Curriculum: CAPS
- Pages: 10
Breadcrumbs: [Home](https://www.hlayiso.com/) › [Library](https://www.hlayiso.com/library) › [Grade 10](https://www.hlayiso.com/library/grade-10) › [Computer Applications Technology](https://www.hlayiso.com/library/grade-10/computer-applications-technology) › [Computer Applications Technology Grade 10 P1 2026 Memo (Eng)](https://www.hlayiso.com/library/grade-10-computer-applications-technology-2026-november-mock-exam-2-memorandum-paper-1/15a7a461-3607-4e4f-ac34-986b4f64b1ae)
## About this document
Computer Applications Technology · Grade 10 · November Mock Exam 2 · 2026 · English. Memorandum, 10 pages. Read online or download the PDF.
Read it free online on the page above; download the PDF from there.
## Matching paper and memo
- [Grade 10 CAT P1 November 2026 Mock 2](https://www.hlayiso.com/library/grade-10-computer-applications-technology-2026-november-mock-exam-2-question-paper-paper-1/8ef44eee-c55c-40d2-ab74-906bc9951f5f) — QP · 2026 · Eng
## Document text
Text extracted from the PDF. Layout, diagrams and tables may not survive extraction.
### Page 1
Mock
hlayiso mock exams
Practice Series:
Grade 10 Exam Preparation
WWW.HLAYISO.COM
NATIONAL
SENIOR CERTIFICATE
GRADE 10
COMPUTER APPLICATIONS TECHNOLOGY P1
NOVEMBER EXAMINATION 2026 (MOCK)
MARKING GUIDELINES
MARKS: 120
These marking guidelines consist of 10 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 TOTAL
POSSIBLE MARK 30 18 32 10 16 14 120
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 or cells 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 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): 1Library Total Q1: 30
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 First line: ’Reading opens doors’ 2
• Font: Arial Black, 26 pt 3 1
• Text displayed in UPPERCASE by using Change 1
Case (UPPERCASE) or the All caps font effect 3
(Text retyped in capitals: 0 marks for this criterion)
1.2 Drop cap: ’From 9 to 13 November …’ 3
• Drop cap applied to the correct paragraph, position 1
Dropped 3
• Lines to drop: 3 3 1
• Distance from text: 0.3 cm 3 1
1.3 Paragraph: ’Our library has more than …’ 3
• Indentation: Left 1 cm AND Right 1 cm 3 1
• Spacing after: 12 pt 3 1
• Line spacing: Exactly 16 pt 3 1
1.4 Multilevel list: ’Library rules’ 3
• Bullets changed to numbering with the format 1), 2), 1
3), 4) 3
• The TWO ’Grade …’ lines demoted to the second 1
level (indented) 3
• Second level uses the a), b) number format 3 1
(Numbering typed manually: 0 marks)
1.5 Image: 1Books 3
• ’Question/Vraag 1.5’ replaced with the 1Books image 1
AND height 3.5 cm with aspect ratio locked (width
approx. 4.6 cm) 3
• Wrap text: Tight 3 1
• Any picture style applied 3 1
1.6 Table: ’Class reading totals’ 5
• Top row height: Exactly 1 cm 3 1
• Any light shading applied to the top row only 3 1
• Outside border 2½ pt; inside borders unchanged 3 1
• Formula =SUM(ABOVE) in ALL THREE empty cells of 1
the ’Total’ row 3
• ALL the numbers right-aligned 3 1
(Expected totals: Fiction 213; Non-fiction 120;
Magazines 85. Typed values: 0 for the formula
criterion. =SUM(B2:B6) etc. also accepted)
Copyright reserved Please turn over
### Page 4
Computer Applications Technology/P1 4 Hlayiso/Mock 2026
NSC – Marking Guidelines
No. Criteria Maximum Candidate
mark mark
1.7 Find and replace: ’read’ in italics 2
• Find and replace with Replace format: Italic 3 1
• ’Find whole words only’ used: ALL SIX occurrences 1
of ’read’ italic; ’reading’, ’reader’, ’readers’ etc.
unchanged 3
1.8 Paragraph: ’Contact us’ 2
• Non-breaking spaces (Ctrl+Shift+Space) replace 1
BOTH spaces in ’Mrs N. Mokoena’ 3
• Wingdings character 40 (telephone symbol) inserted 1
directly before ’051 447 2390’ 3
1.9 Shape: end of the document 3
• ’Rectangle: Rounded Corners’ shape inserted below 1
the ’Contact us’ paragraph 3
• Text ’Visit the library today!’ typed in the shape 3 1
• Shape fill: any light yellow colour 3 1
1.10 Header: file name field 2
• FileName field inserted in the header (not typed) 3 1
• Aligned to the right 3 1
1.11 Page numbers 2
• Automatic page number in the centre of the footer 3 1
• Format ’- 1 -, - 2 -, - 3 -, …’ (Page Number Format) 3 1
(Hyphens typed around a PAGE field also accepted)
Total for QUESTION 1 [30]
Copyright reserved Please turn over
### Page 5
Computer Applications Technology/P1 5 Hlayiso/Mock 2026
NSC – Marking Guidelines
QUESTION 2 File name(s): 2Swap Total Q2: 18
No. Criteria Maximum Candidate
mark mark
2.1 Page setup 2
• Paper size: A4 (21 cm × 29.7 cm) – the original file is 1
Letter size 3
• ALL FOUR margins: 2 cm 3 1
2.2 Page colour 1
• Any light page colour applied 3 1
2.3 Heading: ’Book Swap Day’ 2
• Font effect: Small caps 3 1
• Character spacing: Expanded by 3 pt 3 1
2.4 Tab stops: ’Swap rules’ 4
• Centre tab at 9 cm 3 1
• Right tab at 16 cm 3 1
• Dotted leader (2 ……) on the right tab only 3 1
• Tabs applied to ALL FIVE lines (from ’Type of book’ to 1
’Children’s books’) 3
2.5 Columns: ’Genres we accept’ 3
• Two columns applied to ONLY the two paragraphs 1
(continuous section breaks) 3
• Spacing between the columns: 1.5 cm 3 1
• Column break before ’Non-fiction:’ so that it starts at 1
the top of column 2 3
(Empty paragraphs (Enter key) used to push the text: 0
for the last criterion)
2.6 Spelling: ’How it works’ 2
• ’libary’ corrected to ’library’ 3 1
• ’recieve’ corrected to ’receive’ 3 1
2.7 Hyphenation 2
• Hyphenation: Automatic 3 1
• Limit consecutive hyphens to: 2 3 1
2.8 Comment 2
• Comment inserted on the text ’13 November’ in the 1
paragraph below ’How it works’ 3
• Comment text: Confirm the date with the principal 3 1
Total for QUESTION 2 [18]
Copyright reserved Please turn over
### Page 6
Computer Applications Technology/P1 6 Hlayiso/Mock 2026
NSC – Marking Guidelines
QUESTION 3 File name(s): 3Loans Total Q3: 32
No. Criteria Maximum Candidate
mark mark
Expected values below are for the data AFTER the
sort in 3.3 (first row: Fourie, 10A). If the sort was not
done, H6 = 302 and J6 = R10.00 – mark the formulae,
not the values.
3.1 Row 1 2
• Cells A1:J1 merged and centred 3 1
• Row height: 28 pt 3 1
3.2 Cells A5:J5 2
• Wrap text applied 3 1
• Orientation: Angle Counterclockwise (45°) 3 1
3.3 Sort: A6:J45 2
• Sorted by Class (column D), A to Z 3 1
• Then by Surname (column B), A to Z; ALL the 1
columns sorted together (rows kept intact) 3
(Expected: first row Fourie (10A); last row Zulu (10E).
Class counts: 10A 6, 10B 8, 10C 3, 10D 10, 10E 13)
3.4 Cells H6:H45 2
=SUM(E6:G6)
• SUM with range E6:G6 3 1
• Function copied to H45 3 1
(=E6+F6+G6 also accepted. Expected: H6 = 379)
3.5 Cells J6:J45 3
=I6*$D$3
• I6 multiplied 3 1
• by D3, which is absolute ($D$3 or D$3) 3 1
• Formula copied to J45 3 1
(Value 2.5 typed in the formula: maximum 1 mark.
Expected: J6 = 0; J7 = 2.50; J8 = 10.00)
3.6 Cell M4 2
=MIN(H6:H45)
• MIN function 3 1
• Range H6:H45 3 1
(Expected answer: 144)
3.7 Cell M5 3
=MAX(H6:H45)-MIN(H6:H45) OR =MAX(H6:H45)-M4
• MAX(H6:H45) 3 1
• MIN(H6:H45) or M4 3 1
• Correct subtraction (highest minus lowest) 3 1
(Expected answer: 292)
Copyright reserved Please turn over
### Page 7
Computer Applications Technology/P1 7 Hlayiso/Mock 2026
NSC – Marking Guidelines
No. Criteria Maximum Candidate
mark mark
3.8 Cell M6 3
=ROUND(AVERAGE(H6:H45),0)
• AVERAGE(H6:H45) 3 1
• ROUND function around the AVERAGE 3 1
• 0 digits 3 1
(Expected answer: 297 (exact average 297.325).
Decimals removed by formatting only: maximum 1
mark)
3.9 Cell M7 2
=COUNTIF(J6:J45,0) OR =COUNTIF(I6:I45,0)
• COUNTIF with range J6:J45 (or I6:I45) 3 1
• Criterion 0 (or "=0") 3 1
(Expected answer: 13)
3.10 Cell M10 3
=COUNTIF(D6:D45,M9)
• COUNTIF function 3 1
• Range D6:D45 3 1
• Criterion: cell reference M9 3 1
(Criterion ”10D” typed: 0 for the last criterion. Expected
answer: 10)
3.11 Cell M11 2
=COUNT(G6:G45)
• COUNT function 3 1
• Range G6:G45 3 1
(=COUNTA(G6:G45) also accepted. Expected answer:
38)
3.12 Cell M12 1
• Range corrected: =SUM(J6:J45) 3 1
(Original =SUM(J6:J44) omits the last learner.
Expected answer: R175.00; the original gave R170.00)
3.13 Cell M13 1
• Custom date format dddd, dd mmmm yyyy (or dddd, 1
d mmmm yyyy) 3
(Displays: Friday, 20 November 2026)
3.14 New worksheet 2
• New worksheet named Prizes 3 1
• Tab colour: any shade of red 3 1
3.15 Page setup: Challenge worksheet 2
• Scaling: Fit to 1 page wide by 1 page tall (or Fit Sheet 1
on One Page) 3
• File Name element (&[File]) in the right section of 1
the footer 3
Total for QUESTION 3 [32]
Copyright reserved Please turn over
### Page 8
Computer Applications Technology/P1 8 Hlayiso/Mock 2026
NSC – Marking Guidelines
QUESTION 4 File name(s): 4Genres Total Q4: 10
No. Criteria Maximum Candidate
mark mark
4.1 Pie chart: Genres worksheet 6
• Pie chart (2-D) created from A3:B9 3 1
• Chart title: Favourite genres of Grade 10 readers 3 1
• Data labels displayed as percentages 3 1
• Legend displayed at the bottom 3 1
• ONLY the Adventure slice exploded (pulled out) 3 1
• Chart placed on the Genres worksheet 3 1
(Expected labels: 30%, 24%, 20%, 13%, 9%, 5%)
4.2 Existing chart: Loans worksheet 4
• Chart type changed to Stacked Column 3 1
• Chart title: Books borrowed per month 3 1
• Vertical axis title: Number of books 3 1
• Chart moved to a new chart sheet called LoansChart 1
3
Total for QUESTION 4 [10]
Copyright reserved Please turn over
### Page 9
Computer Applications Technology/P1 9 Hlayiso/Mock 2026
NSC – Marking Guidelines
QUESTION 5 File name(s): 5Library Total Q5: 16
No. Criteria Maximum Candidate
mark mark
5.1 Title 1
• Masakhane Library inside the 1
head 3
5.2 Body attributes 2
• bgcolor="lavender" 3 1
• text="navy" 3 1
5.3 Heading 2
• changed to …
3 1
• align="center" OR tags 3 1
Masakhane High School
Library
5.4 Font 2
Reading Week: 9
to 13 November 2026
• face="Verdana" 3 1
• size="6" 3 1
(Separate nested … also accepted)
5.5 Underline and italics 2
free of charge
• … 3 1
• … (only around ’free of charge’) 3 1
(… order also accepted)
5.6 Horizontal line 3
• size="6" 3 1
• width="75%" 3 1
• color="blue" (or "#0000ff") 3 1
5.7 Line breaks 2
•
(or
) after ’Opening hours:’ 3 1
•
after ’Monday to Thursday 07:30 to 15:30’ 3 1
5.8 Last paragraph 1
• Book Swap Day is on Friday 13 1
November. 3
Closing tags and nesting 1
• All tags closed AND correctly nested 3 1
Total for QUESTION 5 [16]
Copyright reserved Please turn over
### Page 10
Computer Applications Technology/P1 10 Hlayiso/Mock 2026
NSC – Marking Guidelines
QUESTION 6 File name(s): 6Reading (.pptx, .pdf); 6Week Total Q6: 14
No. Criteria Maximum Candidate
mark mark
Presentation: 6Reading
6.1.1 Footer 2
• Footer text ’Masakhane High School Library’ inserted 1
3
• ’Don’t show on title slide’ selected (slides 2–5 only) 3 1
6.1.2 Layout and image 2
• Layout of ’Our top readers’ changed to Two Content 1
(bullets remain on the left) 3
• 6Reader image inserted in the right-hand content 1
placeholder 3
6.1.3 Speaker notes 2
• Notes added to the slide ’Why read?’ 3 1
• Text: Remind learners to return all books by 13 1
November. 3
6.1.4 Slide order 1
• ’Book Swap Day’ is slide 2 3 1
6.1.5 Properties 1
• Author property changed from ’Library’ to the 1
examination number 3
6Reading (.pdf)
6.2 PDF file 2
• File saved in PDF format 3 1
• Named 6Reading AND contains the changes made in 1
6.1 (e.g. footer, new slide order) 3
6Week
6.3 File management 4
• Folder 6Week created in the examination folder 3 1
• 2Swap AND 5Library copied into 6Week (originals 1
still in the examination folder) 3
• Copy in 6Week renamed to 6Index (extension .html 1
kept) 3
• Compressed (zipped) folder named 6Week.zip that 1
contains 2Swap and 6Index 3
Total for QUESTION 6 [14]
TOTAL: 120
Copyright reserved
## Related documents
- [Grade 10 CAT P2 November 2026 Mock 2](https://www.hlayiso.com/library/grade-10-computer-applications-technology-2026-november-mock-exam-2-question-paper-paper-2/597932a4-9d9e-4683-87c8-6c0fab55765a) — Computer Applications Technology · QP · 2026 · Eng
- [Gr 10 Comp App Tech ATP 2023-24](https://www.hlayiso.com/library/gr-10-comp-app-tech-atp-2023-24/9651c082-21f1-4dfc-9cbc-77e5fa29fe81) — Computer Applications Technology · ATP
## Collection
- [Grade 10 past papers](https://www.hlayiso.com/grade-10/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.