Computer Applications Technology Grade 10 P1 2026 Memo (Eng)

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

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

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

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

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

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

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

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

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 • <title>Masakhane Library</title> inside the 1 head 3 5.2 Body attributes 2 <body bgcolor="lavender" text="navy"> • bgcolor="lavender" 3 1 • text="navy" 3 1 5.3 Heading 2 • <h4> changed to <h2> … </h2> 3 1 • align="center" OR <center> tags 3 1 <h2 align="center">Masakhane High School Library</h2> 5.4 Font 2 <font face="Verdana" size="6">Reading Week: 9 to 13 November 2026</font> • face="Verdana" 3 1 • size="6" 3 1 (Separate nested <font face="Verdana"><font size="6">…</font></font> also accepted) 5.5 Underline and italics 2 <u><i>free of charge</i></u> • <u> … </u> 3 1 • <i> … </i> (only around ’free of charge’) 3 1 (<i><u>…</u></i> order also accepted) 5.6 Horizontal line 3 <hr size="6" width="75%" color="blue"/> • size="6" 3 1 • width="75%" 3 1 • color="blue" (or "#0000ff") 3 1 5.7 Line breaks 2 • <br/> (or <br>) after ’Opening hours:’ 3 1 • <br/> after ’Monday to Thursday 07:30 to 15:30’ 3 1 5.8 Last paragraph 1 • <b>Book Swap Day is on Friday 13 1 November.</b> 3 Closing tags and nesting 1 • All tags closed AND correctly nested 3 1 Total for QUESTION 5 [16] Copyright reserved Please turn over

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