Computer Applications Technology Grade 10 P1 2026 QP (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) MARKS: 120 TIME: 2½ hours This question paper consists of 11 pages, an HTML tag sheet, a page for planning and a separate information sheet. Copyright reserved Please turn over

Computer Applications Technology/P1 2 Hlayiso/Mock 2026 NSC Mock INSTRUCTIONS AND INFORMATION 1. Owing to the nature of this practical examination, it is important to note that, even if you complete the examination early, you will NOT be permitted to leave the examination room until all the administrative tasks associated with the examination have been finalised. During the examination, the standard examination rules regarding leaving the examination room apply. 2. If you are working on the network, or the data files have been preloaded on your system, you must follow the instructions provided by the invigilator/educator. 3. At the end of the examination, you must make sure that ALL your answer files are saved on the network/computer as explained to you by the invigilator/educator. 4. Make absolutely sure that all files can be read. Do NOT save unnecessary files/folders and do NOT hand in duplicate answer files/folders. Do NOT delete any original files that you did not work on. 5. The information sheet that has been provided with the question paper MUST BE COMPLETED AFTER THE TWO-AND-A-HALF-HOUR EXAMINATION SESSION. Hand it to the invigilator at the end of the examination. 6. A copy of the master files will be available from the invigilator. Should there be any problems with a file, you may request another copy from the invigilator. 7. This question paper consists of SIX questions. Answer ALL the questions. 8. Read through each question before answering or solving the problem. Do NOT do more than is required by the question. 9. Ensure that you save each document using the file name given in the question paper. Save your work regularly as a precaution against possible power failures. 10. You may NOT use any resource material. 11. Accuracy will be taken into account, e.g. if a question requires the answer to be in cell F3 in a spreadsheet and you enter the answer in cell G4, it will NOT be marked. 12. Ensure that the regional settings are set to South Africa and that the date and time settings, number settings and currency settings are correctly set. 13. In all questions involving word processing, you should set the language to English (South Africa). The paper size is assumed to be A4 Portrait, unless instructed otherwise. Use centimetres as the unit of measurement. 14. Ensure that the decimal symbol is set as a full stop (’.’) and the list separator is set as a comma (’,’). Copyright reserved Please turn over

Computer Applications Technology/P1 3 Hlayiso/Mock 2026 NSC Mock 15. Formulae and/or functions must be used for ALL calculations in questions involving spreadsheets. Use absolute cell references only where necessary to ensure that formulae are correct when you copy them to other cells in a spreadsheet. NOTE: All formulae and/or functions should be inserted in such a manner that the correct results will still be obtained even if changes are made to the existing data. 16. You may NOT use a word processing program such as Word to answer the HTML question. 17. Borders around images or screenshots in this question paper are intended for clarity. Do NOT insert borders unless you are instructed to do so. 18. The data files that you need to complete this question paper have been provided to you on the disk/CD/DVD/flash disk or on the disk space allocated to you, in a folder called CAT P1 Gr10 Nov 2026 DATA. Do the following: • Copy the folder CAT P1 Gr10 Nov 2026 DATA to the location indicated by the invigilator/educator. • Verify the contents of the folder by opening one or more files. • Once the contents of the files have been verified, rename the folder CAT P1 Gr10 Nov 2026 DATA with your examination number. The following files will be available in the folder: 1Garden Word processing file 1Seedling Image 2Plants Word processing file 3Harvest Spreadsheet 4Survey Spreadsheet 5Garden HTML 6Garden Presentation 6Tomato Image Copyright reserved Please turn over

Computer Applications Technology/P1 4 Hlayiso/Mock 2026 NSC Mock SCENARIO The Grade 10 learners of Thuto-Lefa Secondary School in Tembisa started the GreenRoots Garden Project. They grow vegetables for the school’s feeding scheme and sell the extra vegetables and seedlings to the community. You have been asked to help with the documents, spreadsheets, web page and presentation of the project. QUESTION 1: WORD PROCESSING Open the 1Garden word processing document that contains an information leaflet about the project. Insert your examination number in the header of the document. 1.1 Change the margins of the document as follows: • Top and bottom: 2 cm • Left and right: 2.5 cm (2) 1.2 Convert the first line of the document, ’GreenRoots Garden Project’, into WordArt (any WordArt style) AND centre it. (2) 1.3 Apply the built-in ’Heading 1’ style to ALL FIVE headings in the document, namely ’Why a school garden?’, ’Tools we use’, ’Vegetables to plant in spring’, ’How to plant seedlings’ and ’Looking after the garden’. (2) 1.4 Find and replace ALL occurrences of the word ’veggies’ with the word ’vegetables’. (2) 1.5 Format the FIRST paragraph below the heading ’Why a school garden?’, starting with ’In 2025 a group …’, as follows: • Alignment: Justified • Line spacing: 1.5 lines • First line indent: 1 cm (3) 1.6 Apply a box border with a width of 1½ pt AND any light green shading to the paragraph that starts with ’Did you know?’. (3) 1.7 Apply bullets to the FIVE tools listed below the heading ’Tools we use’ (from ’Spade and garden fork’ to ’Wheelbarrow’). Use any symbol from the Wingdings font as the bullet. (2) 1.8 Replace the text ’Question/Vraag 1.8’ with the 1Seedling image. • Change the width of the image to 4 cm, keeping the original proportions. • Apply ’Square’ text wrapping and position the image on the right-hand side of the page. (3) 1.9 Format the TWO paragraphs below the heading ’Vegetables to plant in spring’ into TWO columns with a line between the columns. NOTE: The rest of the document must remain in ONE column. (3) 1.10 Insert a page number at the bottom of each page, aligned to the right, in the format ’Page 1 of 2’. (2) Copyright reserved Please turn over

Computer Applications Technology/P1 5 Hlayiso/Mock 2026 NSC Mock 1.11 Insert a footnote on the word ’compost’ (in the paragraph below the heading ’Looking after the garden’) with the text ’Decomposed plant material that is added to the soil’. (2) 1.12 Insert a page break so that the heading ’How to plant seedlings’ starts at the top of a new page. (2) 1.13 Replace the text ’Question/Vraag 1.13’ with an automatic table of contents. Use any built-in table of contents format. (2) Save and close the 1Garden document. [30] Copyright reserved Please turn over

Computer Applications Technology/P1 6 Hlayiso/Mock 2026 NSC Mock QUESTION 2: WORD PROCESSING Open the 2Plants word processing document that contains information about the seedlings that were sold. Insert your examination number in the header of the document. 2.1 Change the orientation of the document to landscape. (1) 2.2 Insert a custom text watermark with the text ’GreenRoots’ in a diagonal layout. (2) 2.3 Insert a formula in the last cell of EACH row of the table (the ’Total’ column) to calculate the total number of trays of each seedling that were sold. (2) 2.4 Sort the table so that the seedlings are listed from the highest to the lowest total. The heading row must remain at the top of the table. (2) 2.5 Insert a new row above the first row of the table. Merge the cells of the new row and type the text ’Seedling trays sold: July to September 2026’ in the merged cell. Centre the text. (3) 2.6 Apply any table style to the table AND AutoFit the table to the window. (2) 2.7 Set ONE tab stop for the THREE lines below ’Contact persons’ so that the names are right aligned at 22 cm with a dotted (……) tab leader, as shown in the example below. Garden coordinator. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Mrs T. Nkosi Seedling sales . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Kagiso Molefe (Grade 10B) (3) Feeding scheme . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Mr S. Mahlangu 2.8 Insert a hyperlink on the text ’our website’ in the first paragraph that links to the web address www.greenroots.org.za. (2) 2.9 Set the hyphenation of the document to automatic. (1) Save and close the 2Plants document. [18] Copyright reserved Please turn over

Computer Applications Technology/P1 7 Hlayiso/Mock 2026 NSC Mock QUESTION 3: SPREADSHEET NOTE: • Use formulae and/or functions for ALL calculations in the spreadsheet. • Use absolute cell references ONLY where necessary to ensure that formulae are correct when you copy it to other cells in a spreadsheet. • Insert formulae and/or functions in such a manner that the correct results will still be obtained even if values are changed in the existing data. Open the 3Harvest spreadsheet that contains information about the vegetables that the learners sold on Fridays during Term 3. Work in the Sheet1 worksheet. 3.1 Merge and centre cells A1:I1 and change the font size of the text to 14 pt. (2) 3.2 Rename the Sheet1 worksheet to Sales AND change the colour of the worksheet tab to any shade of green. (2) 3.3 Format cells F6:H35 to display in currency format with the R symbol and TWO decimal places. (2) 3.4 Insert a formula in cell G6 to calculate the income from the sale (units sold multiplied by the price per unit). Copy the formula to cells G7:G35. (2) 3.5 A percentage of the income from each sale is paid into the garden fund. The percentage is given in cell D3. Insert a formula in cell H6 to calculate the contribution to the garden fund for each sale. Copy the formula to cells H7:H35. (3) 3.6 Insert a function in cell L3 to count the number of sales. Use the data in column B. (1) 3.7 Insert a function in cell L4 to determine the highest income from a single sale. (1) 3.8 Insert a function in cell L5 to calculate the average number of units sold per sale. Use a formatting feature to display the answer with ONE decimal place. (2) 3.9 Insert a function in cell L6 to determine the median price per unit. (1) 3.10 Insert a function in cell L7 to determine the number of units sold that occurs most often. (1) 3.11 Insert a function in cell L8 to determine the number of sales that do NOT have a comment in column I. (2) 3.12 Insert a function in cell L9 to determine the number of times that spinach was sold. (2) 3.13 Insert a function in cell L10 to determine the number of sales with an income of R200 or more. (3) Copyright reserved Please turn over

Computer Applications Technology/P1 8 Hlayiso/Mock 2026 NSC Mock 3.14 Create a range name called Income for cells G6:G35. Use the range name in a function in cell L11 to calculate the total income. (3) 3.15 Insert a function in cell L12 that will always display the current date. (1) 3.16 Work in the Draw worksheet. Insert a function in cell B3 that will generate a random whole number from 1 to 30 to select the winning sale number for a lucky draw. (2) 3.17 Work in the Sales worksheet. Insert your examination number in the left section of the header AND use a header and footer element to insert the name of the worksheet in the centre section of the footer. (2) Save and close the 3Harvest spreadsheet. [32] Copyright reserved Please turn over

Computer Applications Technology/P1 9 Hlayiso/Mock 2026 NSC Mock QUESTION 4: SPREADSHEET – CHARTS Open the 4Survey spreadsheet that contains the results of a survey on the favourite vegetables of Grade 10 learners, as well as the monthly rainfall at the school garden. 4.1 Work in the Survey worksheet. Use the data in cells A3:B9 to create a chart that appears as shown below. NOTE: The chart must be placed on the Survey worksheet. (6) 4.2 Work in the Rainfall worksheet. Use the data in cells A3:B15 to create a line chart with markers as follows: • Chart title: Monthly rainfall at the garden (mm) • Move the chart to a new chart sheet called RainChart. (4) Save and close the 4Survey spreadsheet. [10] Copyright reserved Please turn over

Computer Applications Technology/P1 10 Hlayiso/Mock 2026 NSC Mock QUESTION 5: WEB DESIGN (HTML) NOTE: • You may NOT use a word processing program such as Word to answer the HTML question. • An HTML tag sheet has been attached for reference. • Question numbers appear as comments in the coding to indicate where you should insert the answer(s). Do NOT delete these comments. Open the incomplete 5Garden file in a web browser and also in a text/HTML editor (NOT a word processing program such as Word). Your final web page should look like the example below. 5.1 Insert the title ’GreenRoots’ so that it displays on the tab of the web browser. (1) 5.2 Change the background colour of the web page to ’lightyellow’. (1) 5.3 Change the heading ’GreenRoots Garden Project’ to the largest heading size AND centre the heading. (2) 5.4 Format the text ’Grown by learners, for the community’ as follows: • Font: Arial • Font colour: Green • Font size: 5 (3) 5.5 Format the words ’fresh vegetables’ in the next paragraph so that they are displayed in bold AND italics. (2) 5.6 Format the horizontal line so that it has a size of 4 and a width of 50%. (2) 5.7 Insert line breaks so that EACH vegetable and its price is displayed on a separate line, as shown in the example above. (2) 5.8 Align the last paragraph to the right AND underline the time ’13:30’. (2) Save and close the 5Garden file. ONE mark will be allocated for closing tags and correct nesting. (1) [16] Copyright reserved Please turn over

Computer Applications Technology/P1 11 Hlayiso/Mock 2026 NSC Mock QUESTION 6: GENERAL 6.1 Open the 6Garden presentation that will be shown at the school’s prize-giving evening. 6.1.1 Apply any design theme to ALL the slides. (1) 6.1.2 Insert slide numbers on ALL the slides, except the title slide. (2) 6.1.3 Apply any transition to ALL the slides. (1) 6.1.4 Insert the 6Tomato image on slide 3 AND apply any entrance animation to the image. (2) 6.1.5 Insert a hyperlink on the text ’Visit our web page’ on slide 4 that links to the 5Garden file in your examination folder. (2) Save and close the 6Garden presentation. 6.2 Open the 2Plants document that you saved in QUESTION 2. Save the document as a PDF file called 2Plants in your examination folder. Close the 2Plants document. (2) 6.3 Do the following in your examination folder: • Create a new folder called 6Backup. • Copy the 1Garden and 3Harvest files into the 6Backup folder. • Compress the 6Backup folder to a compressed (zipped) folder called 6Backup. (4) [14] TOTAL: 120 Copyright reserved Please turn over

Computer Applications Technology/P1 Hlayiso/Mock 2026 NSC Mock HTML TAG SHEET Basic Tags Tag Description <html></html> Creates an HTML document – starts and ends a web page <head></head> Contains information about the web page <title></title> Defines a title for the web page <body></body> Defines the body of the web page <body bgcolor="pink"> Sets the background colour of the web page <body text="black"> Sets the colour of the body text <br/> Inserts a line break <!-- --> Comment Text Tags <h1></h1> Creates the largest heading <h6></h6> Creates the smallest heading <b></b> Creates bold text <i></i> Creates italic text <u></u> Creates underlined text <font size="3"></font> Sets size of font, from ”1” to ”7” <font color="green"></font> Sets font colour <font face="Times New Sets font type Roman"></font> Formatting Tags <p></p> Creates a new paragraph <p align="left"> Aligns a paragraph to the ”left” (default), can also be ”right” or ”center” <h1 align="center"> Aligns a heading, can also be ”left” or ”right” <center></center> Horizontally centres text or a section <hr/> Inserts a horizontal line <hr size="3"/> Sets size (height) of a line <hr width="80%"/> Sets the width of a line, in percentage or absolute value <hr color="ff0000"/> Sets the colour of the line Copyright reserved

Computer Applications Technology/P1 Hlayiso/Mock 2026 NSC Mock YOU MAY USE THIS PAGE FOR ANY PLANNING PURPOSES. Copyright reserved

Computer Applications Technology/P1 Hlayiso/Mock 2026 NSC Mock Examination sticker 120 CAT P1 – GRADE 10 – NOVEMBER 2026 (MOCK) INFORMATION SHEET (to be completed by the candidate AFTER the 2½-hour session) CENTRE NUMBER EXAMINATION NUMBER WORK STATION NUMBER SUITE USED Microsoft Microsoft Microsoft Office 365 (Mark appropriate box Office 2016 Office 2019 Office 2021 with a cross (X)) WEB BROWSER Mozilla Google Microsoft Opera Other USED Firefox Chrome Edge (Specify) (Mark appropriate box with a cross (X)) FOLDER NAME Candidate must enter the file name(s) used for each answer. Tick if saved and/or attempted. Question File name Saved Attempted Maximum Mark Marker number (3) (3) mark achieved initial 1 1Garden 30 2 2Plants 18 3 3Harvest 32 4 4Survey 10 5 5Garden 16 6Garden (.pptx) 2Plants (.pdf) 6 14 6Backup (folder) 6Backup (.zip) TOTAL 120 Comment: (for office/marker use only) Copyright reserved