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 Mock 2 DATA. Do the following: • Copy the folder CAT P1 Gr10 Nov 2026 Mock 2 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 Mock 2 DATA with your examination number. The following files will be available in the folder: 1Library Word processing file 1Books Image 2Swap Word processing file 3Loans Spreadsheet 4Genres Spreadsheet 5Library HTML 6Reading Presentation 6Reader Image Copyright reserved Please turn over

Computer Applications Technology/P1 4 Hlayiso/Mock 2026 NSC Mock SCENARIO The library of Masakhane High School in Mangaung is hosting its first Reading Week from 9 to 13 November 2026. The Grade 10 library monitors are preparing the documents, spreadsheets, web page and presentation for the week, and you have been asked to help them. QUESTION 1: WORD PROCESSING Open the 1Library word processing document that contains information about Reading Week and the library. Insert your examination number in the header of the document. 1.1 Format the first line of the document, ’Reading opens doors’, as follows: • Font: Arial Black, 26 pt • Use a word processing feature to change the text to UPPERCASE. (2) 1.2 Apply a drop cap to the first paragraph below the heading ’Welcome to Reading Week’, starting with ’From 9 to 13 November …’, as follows: • Position: Dropped • Lines to drop: 3 • Distance from text: 0.3 cm (3) 1.3 Format the paragraph that starts with ’Our library has more than …’ as follows: • Indentation: 1 cm on the left AND 1 cm on the right • Spacing after: 12 pt • Line spacing: Exactly 16 pt (3) 1.4 Change the bulleted list below the heading ’Library rules’ so that it appears as shown below. 1) Bring your learner card every time you visit the library. 2) The number of books that you may borrow depends on your grade: a) Grade 8 and 9 learners: two books at a time b) Grade 10 to 12 learners: three books at a time 3) Return books within 14 days or pay a fine for every day that a book is late. 4) Eat and drink only outside the library. NOTE: Use the number format 1), 2), 3) … for the first level and a), b) for the second level. (3) 1.5 Replace the text ’Question/Vraag 1.5’ with the 1Books image. • Change the height of the image to 3.5 cm, keeping the original proportions. • Apply ’Tight’ text wrapping to the image. • Apply any picture style to the image. (3) Copyright reserved Please turn over

Computer Applications Technology/P1 5 Hlayiso/Mock 2026 NSC Mock 1.6 Format the table below the heading ’Class reading totals’ as follows: • Change the height of the top row to exactly 1 cm. • Apply any light shading to the top row. • Change the outside border of the table to a width of 2½ pt. The inside borders must remain unchanged. • Insert a formula in EACH of the three empty cells in the last row (’Total’) to calculate the total number of books in the column. • Right-align ALL the numbers in the table. (5) 1.7 Use a word processing feature to format ALL occurrences of the word ’read’ in the document in italics. NOTE: Words such as ’reading’, ’reader’ and ’readers’ must NOT be changed. (2) 1.8 Do the following in the paragraph below the heading ’Contact us’: • Ensure that the name ’Mrs N. Mokoena’ will always appear on the same line. • Insert a telephone symbol (Wingdings character code 40) directly before the telephone number ’051 447 2390’. (2) 1.9 Insert a ’Rectangle: Rounded Corners’ shape at the end of the document (below the paragraph under ’Contact us’). • Type the text ’Visit the library today!’ in the shape. • Fill the shape with any light yellow colour. (3) 1.10 Insert the file name of the document as a field in the header of the document, aligned to the right. (2) 1.11 Insert page numbers in the centre of the footer of each page in the format ’- 1 -’, ’- 2 -’, … (2) Save and close the 1Library document. [30] Copyright reserved Please turn over

Computer Applications Technology/P1 6 Hlayiso/Mock 2026 NSC Mock QUESTION 2: WORD PROCESSING Open the 2Swap word processing document that contains a notice about Book Swap Day. Insert your examination number in the header of the document. 2.1 Change the page setup of the document as follows: • Paper size: A4 • ALL the margins: 2 cm (2) 2.2 Apply any light page colour to the document. (1) 2.3 Format the heading ’Book Swap Day’ at the top of the document as follows: • Font effect: Small caps • Character spacing: Expanded by 3 pt (2) 2.4 Set tab stops for the FIVE lines below the heading ’Swap rules’ (from ’Type of book’ to ’Children’s books’) so that the text is displayed as shown in the example below. • A centre tab at 9 cm • A right tab at 16 cm with a dotted (……) leader Type of book For learners in . . . . . . . . . . . . . . . . . . . . . Tokens Novels Grades 8–12 . . . . . . . . . . . . . . . . . . . . . . . . . . . 2 Comics and magazines All grades . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1 (4) Study guides Grades 10–12. . . . . . . . . . . . . . . . . . . . . . . . . . .3 Children’s books All grades . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1 2.5 Format the TWO paragraphs below the heading ’Genres we accept’ (starting with ’Fiction:’ and ’Non-fiction:’) into TWO columns as follows: • Spacing between the columns: 1.5 cm • The paragraph starting with ’Non-fiction:’ must start at the top of the second column. NOTE: The rest of the document must remain in ONE column. (3) 2.6 Correct the TWO spelling mistakes in the paragraph below the heading ’How it works’. (2) 2.7 Set the hyphenation of the document to automatic AND limit the number of consecutive hyphens to 2. (2) 2.8 Insert a comment on the text ’13 November’ in the paragraph below the heading ’How it works’ with the text ’Confirm the date with the principal’. (2) Save and close the 2Swap 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 3Loans spreadsheet that contains information about the Grade 10 learners who took part in the three-week Reading Challenge. Work in the Challenge worksheet. 3.1 Merge and centre cells A1:J1 AND change the height of row 1 to 28 pt. (2) 3.2 Format the column headings in cells A5:J5 as follows: • Wrap the text. • Change the orientation of the text to ’Angle Counterclockwise’ (45°). (2) 3.3 Sort the data in cells A6:J45 by class (column D) in ascending order, and then by surname (column B) in ascending order. (2) 3.4 Insert a function in cell H6 to calculate the total number of pages that the learner read in the three weeks. Copy the function to cells H7:H45. (2) 3.5 The fine per day for a book that is returned late is given in cell D3. Insert a formula in cell J6 to calculate the fine that the learner must pay. Copy the formula to cells J7:J45. (3) 3.6 Insert a function in cell M4 to determine the lowest number of total pages read by a learner. (2) 3.7 Insert a formula in cell M5 to calculate the difference between the highest and the lowest number of total pages read by a learner. (3) 3.8 Insert a function in cell M6 to calculate the average number of total pages read by a learner. The function must round the answer to a whole number. (3) 3.9 Insert a function in cell M7 to determine the number of learners who did NOT have to pay a fine. (2) 3.10 Cell M9 contains a class. Insert a function in cell M10 to determine the number of learners in the class that is given in cell M9. NOTE: The answer must change when a different class is typed in cell M9. (3) 3.11 Some learners were absent in Week 3 and have no pages recorded for that week. Insert a function in cell M11 to determine the number of learners who have a number of pages recorded for Week 3. (2) Copyright reserved Please turn over

Computer Applications Technology/P1 8 Hlayiso/Mock 2026 NSC Mock 3.12 The function in cell M12 should calculate the total of ALL the fines, but it gives an incorrect answer. Correct the function in cell M12. (1) 3.13 Format cell M13 to display the date as shown in the example: Friday, 20 November 2026. (1) 3.14 Insert a new worksheet called Prizes AND change the colour of its worksheet tab to any shade of red. (2) 3.15 Work in the Challenge worksheet. Change the page setup so that the worksheet will print on ONE page AND insert the file name in the right section of the footer. (2) Save and close the 3Loans spreadsheet. [32] Copyright reserved Please turn over

Computer Applications Technology/P1 9 Hlayiso/Mock 2026 NSC Mock QUESTION 4: SPREADSHEET – CHARTS Open the 4Genres spreadsheet that contains the results of a survey on the favourite genres (types of books) of Grade 10 learners, as well as the number of books that were borrowed each month. 4.1 Work in the Genres worksheet. Use the data in cells A3:B9 to create a chart that appears as shown below. NOTE: • The ’Adventure’ slice must be pulled out (exploded) from the rest of the chart. • The chart must be placed on the Genres worksheet. (6) 4.2 Work in the Loans worksheet. Change the existing chart as follows: • Change the chart type to a stacked column chart. • Insert the chart title ’Books borrowed per month’. • Insert the vertical axis title ’Number of books’. • Move the chart to a new chart sheet called LoansChart. (4) Save and close the 4Genres 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 5Library 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 ’Masakhane Library’ so that it displays on the tab of the web browser. (1) 5.2 Change the background colour of the web page to ’lavender’ AND the colour of the text to ’navy’. (2) 5.3 Change the heading ’Masakhane High School Library’ to the second-largest heading size AND centre the heading. (2) 5.4 Format the text ’Reading Week: 9 to 13 November 2026’ so that it is displayed in the Verdana font AND in font size 6. (2) 5.5 Format the words ’free of charge’ in the next paragraph so that they are displayed underlined AND in italics. (2) 5.6 Format the horizontal line so that it has a size of 6, a width of 75% AND a blue colour. (3) 5.7 Insert line breaks so that the opening hours are displayed on separate lines, as shown in the example above. (2) 5.8 Display the last paragraph, ’Book Swap Day is on Friday 13 November.’, in bold. (1) Save and close the 5Library 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 6Reading presentation that will be shown in the school hall during Reading Week. 6.1.1 Insert the footer text ’Masakhane High School Library’ on ALL the slides, except the title slide. (2) 6.1.2 Change the layout of the slide with the title ’Our top readers’ to ’Two Content’ AND insert the 6Reader image in the right-hand content placeholder. (2) 6.1.3 Add the following speaker notes to the slide with the title ’Why read?’: ’Remind learners to return all books by 13 November.’ (2) 6.1.4 Move the slide with the title ’Book Swap Day’ so that it becomes the second slide of the presentation. (1) 6.1.5 Change the Author property of the presentation to your examination number. (1) Save the 6Reading presentation. 6.2 Save the 6Reading presentation as a PDF file called 6Reading in your examination folder. Close the 6Reading presentation. (2) 6.3 Do the following in your examination folder: • Create a new folder called 6Week. • Copy the 2Swap and 5Library files into the 6Week folder. • Rename the copy of the 5Library file in the 6Week folder to 6Index. • Compress the 6Week folder to a compressed (zipped) folder called 6Week. (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 1Library 30 2 2Swap 18 3 3Loans 32 4 4Genres 10 5 5Library 16 6Reading (.pptx) 6Reading (.pdf) 6 14 6Week (folder) 6Week (.zip) TOTAL 120 Comment: (for office/marker use only) Copyright reserved