Computer Applications Technology Grade 10 P1 2026 Memo (Eng)

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: 150 These marking guidelines consist of 11 pages. Copyright reserved Please turn over

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 11 pages. Copyright reserved Please turn over

Computer Applications Technology/P1 3 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 4 Hlayiso/Mock 2026 NSC – Marking Guidelines QUESTION 1 File name(s): 1Garden 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 Margins 2 • Top and bottom: 2 cm 3 1 • Left and right: 2.5 cm 3 1 1.2 WordArt: ’GreenRoots Garden Project’ 2 • First line converted to WordArt (any style) 3 1 • WordArt centred 3 1 1.3 Style: Heading 1 2 • ’Heading 1’ style applied to the headings 3 1 • Applied to ALL FIVE headings (and to no other text) 3 1 1.4 Find and replace: ’veggies’ 2 • ’veggies’ replaced with ’vegetables’ 3 1 • ALL THREE occurrences replaced 3 1 1.5 Paragraph: ’In 2025 a group …’ 3 • Alignment: Justified 3 1 • Line spacing: 1.5 lines 3 1 • Indentation: Special – First line by 1 cm 3 1 1.6 Border and shading: ’Did you know? …’ 3 • Box border applied to the paragraph 3 1 • Border width: 1½ pt 3 1 • Any light green shading applied to the paragraph 3 1 1.7 Bullets: tools 2 • Bullets applied to the FIVE tools only 3 1 • Bullet symbol from the Wingdings font 3 1 1.8 Image: 1Seedling 3 • ’Question/Vraag 1.8’ replaced with the 1Seedling 1 image 3 • Width: 4 cm with aspect ratio locked (height approx. 1 4.4 cm) 3 • Wrap text: Square AND image positioned on the right 1 3 1.9 Columns: ’Vegetables to plant in spring’ 3 • Two columns applied 3 1 • Line between the columns 3 1 • ONLY the TWO paragraphs are in columns 1 (continuous section breaks before and after) 3 1.10 Page numbers 2 • Page number inserted at the bottom of the page, right 1 aligned 3 Copyright reserved Please turn over

Computer Applications Technology/P1 5 Hlayiso/Mock 2026 NSC – Marking Guidelines No. Criteria Maximum Candidate mark mark • Format: ’Page X of Y’ (NUMPAGES field used) 3 1 1.11 Footnote: ’compost’ 2 • Footnote inserted on the word compost 3 1 • Footnote text: Decomposed plant material that is 1 added to the soil 3 1.12 Page break 2 • Page break inserted (Ctrl+Enter / Insert, Page Break) 1 3 • Heading ’How to plant seedlings’ starts at the top of a 1 new page 3 (Section break (next page) also accepted. Many empty paragraphs (Enter key) used: 0 marks) 1.13 Table of contents 2 • ’Question/Vraag 1.13’ replaced with an automatic 1 table of contents 3 • TOC displays the FIVE Heading 1 entries (with page 1 numbers) 3 (If 1.3 was not done, the TOC will be empty: award the first mark only) Total for QUESTION 1 [30] Copyright reserved Please turn over

Computer Applications Technology/P1 6 Hlayiso/Mock 2026 NSC – Marking Guidelines QUESTION 2 File name(s): 2Plants Total Q2: 18 No. Criteria Maximum Candidate mark mark 2.1 Orientation 1 • Landscape orientation 3 1 2.2 Watermark 2 • Custom text watermark: GreenRoots 3 1 • Layout: Diagonal 3 1 2.3 Formula: ’Total’ column 2 • Formula =SUM(LEFT) inserted 3 1 • In the ’Total’ cell of ALL SIX seedling rows 3 1 (Typed values: 0 marks. =SUM(B2:D2) etc. also accepted) 2.4 Sort table 2 • Sorted by the ’Total’ column, type Number, 1 descending 3 • Header row excluded from the sort 3 1 Expected order: Spinach (74); Onion (58); Tomato (55); Cabbage (46); Green pepper (35); Beetroot (33) 2.5 New first row 3 • Row inserted above the first row 3 1 • Cells merged 3 1 • Text ’Seedling trays sold: July to September 2026’ 1 typed AND centred 3 2.6 Table style and AutoFit 2 • Any table style applied 3 1 • AutoFit Window 3 1 2.7 Tab stop: contact persons 3 • Right tab 3 1 • At 22 cm 3 1 • Dotted (……) leader, applied to ALL THREE lines 3 1 2.8 Hyperlink: ’our website’ 2 • Hyperlink inserted on the text ’our website’ only 3 1 • Address: www.greenroots.org.za (http:// or https:// 1 may be added) 3 2.9 Hyphenation 1 • Hyphenation set to Automatic 3 1 Total for QUESTION 2 [18] Copyright reserved Please turn over

Computer Applications Technology/P1 7 Hlayiso/Mock 2026 NSC – Marking Guidelines QUESTION 3 File name(s): 3Harvest Total Q3: 32 No. Criteria Maximum Candidate mark mark 3.1 Cells A1:I1 2 • Cells merged and centred across A1:I1 3 1 • Font size: 14 pt 3 1 3.2 Worksheet: Sheet1 2 • Renamed to Sales 3 1 • Tab colour: any shade of green 3 1 3.3 Cells F6:H35 2 • Currency format with the R symbol 3 1 • TWO decimal places (applied to ALL the cells 1 F6:H35) 3 3.4 Cells G6:G35 2 =E6*F6 • E6*F6 (correct cells multiplied) 3 1 • Formula copied to G35 3 1 (Expected: G6 = R375.00; G7 = R216.00; G8 = R400.00) 3.5 Cells H6:H35 3 =G6*$D$3 OR =E6*F6*$D$3 • G6 (or E6*F6) multiplied 3 1 • by D3 3 1 • D3 absolute ($D$3 or D$3) and copied down 3 1 (Value 10% or 0.1 typed in the formula: maximum 1 mark. Expected: H6 = R37.50; total of H6:H35 = R751.70) 3.6 Cell L3 1 • =COUNTA(B6:B35) 3 (Expected answer: 30) 1 (=COUNT(E6:E35) also accepted) 3.7 Cell L4 1 • =MAX(G6:G35) 3 (Expected answer: R540) 1 3.8 Cell L5 2 • =AVERAGE(E6:E35) 3 1 • Displayed with ONE decimal place by using cell 1 formatting (not ROUND) 3 (Expected answer: 13.2) 3.9 Cell L6 1 • =MEDIAN(F6:F35) 3 (Expected answer: 18) 1 3.10 Cell L7 1 • =MODE(E6:E35) 3 (MODE.SNGL also accepted) 1 (Expected answer: 12) 3.11 Cell L8 2 =COUNTBLANK(I6:I35) Copyright reserved Please turn over

Computer Applications Technology/P1 8 Hlayiso/Mock 2026 NSC – Marking Guidelines No. Criteria Maximum Candidate mark mark • COUNTBLANK function 3 1 • Correct range I6:I35 3 1 (Expected answer: 18) 3.12 Cell L9 2 =COUNTIF(B6:B35,"Spinach") • COUNTIF with range B6:B35 3 1 • Criterion "Spinach" 3 1 (Expected answer: 3) 3.13 Cell L10 3 =COUNTIF(G6:G35,">=200") • COUNTIF function 3 1 • Range G6:G35 3 1 • Criterion ">=200" 3 1 (">199" also accepted. Expected answer: 20) 3.14 Range name and cell L11 3 • Range name Income created 3 1 • for the cells G6:G35 3 1 • =SUM(Income) in cell L11 3 1 (Expected answer: R7 517) 3.15 Cell L12 1 • =TODAY() 3 (=NOW() also accepted) 1 3.16 Draw worksheet: cell B3 2 • RANDBETWEEN function 3 1 • Arguments (1,30) 3 1 3.17 Header and footer: Sales worksheet 2 • Examination number in the left section of the header 1 3 • Sheet Name element (&[Tab]) in the centre section of 1 the footer 3 Total for QUESTION 3 [32] Copyright reserved Please turn over

Computer Applications Technology/P1 9 Hlayiso/Mock 2026 NSC – Marking Guidelines QUESTION 4 File name(s): 4Survey Total Q4: 10 No. Criteria Maximum Candidate mark mark 4.1 Column chart: Survey worksheet 6 • Column chart (clustered) created from A3:B9 3 1 • Chart title: Favourite vegetables of Grade 10 learners 1 3 • Horizontal axis title: Vegetable 3 1 • Vertical axis title: Number of learners 3 1 • Data labels displayed 3 1 • No legend AND chart placed on the Survey 1 worksheet 3 4.2 Line chart: Rainfall worksheet 4 • Line chart created from A3:B15 (months on the 1 horizontal axis) 3 • Line with markers 3 1 • Chart title: Monthly rainfall at the garden (mm) 3 1 • Chart moved to a new chart sheet called RainChart 3 1 Total for QUESTION 4 [10] Copyright reserved Please turn over

Computer Applications Technology/P1 10 Hlayiso/Mock 2026 NSC – Marking Guidelines QUESTION 5 File name(s): 5Garden Total Q5: 16 No. Criteria Maximum Candidate mark mark 5.1 Title 1 • <title>GreenRoots</title> inside the head 3 1 5.2 Background colour 1 • <body bgcolor="lightyellow"> 3 1 5.3 Heading 2 • <h1> … </h1> 3 1 • align="center" OR <center> tags 3 1 <h1 align="center">GreenRoots Garden Project</h1> 5.4 Font 3 <font face="Arial" color="green" size="5">Grown by … community</font> • face="Arial" 3 1 • color="green" 3 1 • size="5" 3 1 5.5 Bold and italics 2 <b><i>fresh vegetables</i></b> • <b> … </b> 3 1 • <i> … </i> (only around ’fresh vegetables’) 3 1 5.6 Horizontal line 2 <hr size="4" width="50%"/> • size="4" 3 1 • width="50%" 3 1 5.7 Line breaks 2 • <br/> (or <br>) after ’Spinach R15 a bunch’ 3 1 • <br/> after ’Cabbage R20 each’ 3 1 5.8 Last paragraph 2 • <p align="right"> 3 1 • <u>13:30</u> 3 1 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 11 Hlayiso/Mock 2026 NSC – Marking Guidelines QUESTION 6 File name(s): 6Garden; 2Plants (.pdf); 6Backup Total Q6: 14 No. Criteria Maximum Candidate mark mark Presentation: 6Garden 6.1.1 Design theme 1 • Any design theme applied to ALL FOUR slides 3 1 6.1.2 Slide numbers 2 • Slide numbers inserted 3 1 • ’Don’t show on title slide’ selected (slides 2–4 only) 3 1 6.1.3 Transitions 1 • Any transition applied to ALL FOUR slides 3 1 6.1.4 Image and animation 2 • 6Tomato image inserted on slide 3 3 1 • Any entrance animation applied to the image 3 1 6.1.5 Hyperlink 2 • Hyperlink on the text ’Visit our web page’ on slide 4 3 1 • Links to the 5Garden file 3 1 2Plants (.pdf) 6.2 PDF file 2 • File saved in PDF format 3 1 • Named 2Plants AND contains the work done in 1 QUESTION 2 (e.g. landscape) 3 6Backup 6.3 File management 4 • Folder 6Backup created in the examination folder 3 1 • 1Garden AND 3Harvest copied into 6Backup 1 (originals still in the examination folder) 3 • Compressed (zipped) folder created 3 1 • Named 6Backup.zip AND contains the two files 3 1 Total for QUESTION 6 [14] TOTAL: 120 Copyright reserved