Computer Applications Technology Grade 12 P1 2026 QP (Eng)

Mock hlayiso mock exams Practice Series: Grade 12 NSC Preparation WWW.HLAYISO.COM NATIONAL SENIOR CERTIFICATE GRADE 12 COMPUTER APPLICATIONS TECHNOLOGY P1 MOCK EXAMINATION 2026 MARKS: 150 TIME: 3 hours This question paper consists of 14 pages, an HTML tag sheet, an input mask character sheet, two pages 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 THREE-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 SEVEN 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. 12. Ensure that the regional settings are set to South Africa and 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 Developer tab and Ruler are activated. Copyright reserved Please turn over

Computer Applications Technology/P1 3 Hlayiso/Mock 2026 NSC Mock 15. Ensure that the decimal symbol is set as a full stop (’.’) and the list separator is set as a comma (’,’). 16. 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. 17. You may NOT use a word processing program such as Word to answer the HTML question. 18. Borders around images or screenshots in this question paper are intended for clarity. Do NOT insert borders unless you are instructed to do so. 19. Use the correct settings or features in an application as required by a question. 20. 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 Mock 2026 DATA. Do the following: • Copy the folder CAT P1 Mock 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 Mock 2026 DATA with your examination number. The list of files on the next page will be available in the folder. Copyright reserved Please turn over

Computer Applications Technology/P1 4 Hlayiso/Mock 2026 NSC Mock 1Panel Image 1Power Word processing file 2Meter Image 2Tips Word processing file 3Installs Spreadsheet 4Quotes Spreadsheet 5Langa Database 5Logo Image 6_1Button Image 6_1Solar HTML 6_1Sun Image 6_2Battery HTML 6_2Battery Image 7Clients Spreadsheet 7Letter Word processing file 7Usage Spreadsheet Copyright reserved Please turn over

Computer Applications Technology/P1 5 Hlayiso/Mock 2026 NSC Mock SCENARIO Years of load-shedding and rising electricity prices have led many South African households, schools and businesses to install solar power systems. LANGA SOLAR is a company in Johannesburg that sells and installs solar panels, inverters and batteries. QUESTION 1: WORD PROCESSING Open the 1Power word processing document that contains an information booklet for Langa Solar clients. Insert your examination number in the header of the document. 1.1 Insert the ’Facet’ cover page as follows: • Document title: ’Going Solar’ • Remove the Abstract content control. (3) 1.2 Modify the ’Solar’ style as follows: • Add a 1½ pt bottom border in any orange colour. • Change the spacing after the paragraph to 12 pt. (3) 1.3 Find the text ’Question/Vraag 1.3’ and replace it with the 1Panel image. • Change the width of the image to 6 cm, keeping the original proportions. • Apply ’Square’ text wrapping to the image. (3) 1.4 Find and replace ALL occurrences of the exact word ’inverter’ so that the word is displayed in bold with a double underline. (3) 1.5 Find the table below the heading ’2.1 Typical system costs’ and modify it to appear as shown in the example below. System Size (kW) Price (R) Basic 3 65000 Standard 5 98500 Premium 8 156000 Business 15 289000 Average R152 125 NOTES: • Apply any ’Grid Table 4’ table style. • Use a function to calculate the average price. The result must update if the prices change. • Format the result as currency with NO decimal places. (5) 1.6 Insert a footnote on the word ’NERSA’ as follows: • Footnote text: ’National Energy Regulator of South Africa’ • Apply the ’i, ii, iii, …’ number format. (3) Copyright reserved Please turn over

Computer Applications Technology/P1 6 Hlayiso/Mock 2026 NSC Mock 1.7 Replace the text ’Question/Vraag 1.7’ with an automatic table of contents that displays only TWO levels and uses a dash (- - - -) tab leader. (3) 1.8 Ensure that the heading ’3. Battery storage’ will always start on a new page. (1) Save and close the 1Power document. [24] Copyright reserved Please turn over

Computer Applications Technology/P1 7 Hlayiso/Mock 2026 NSC Mock QUESTION 2: WORD PROCESSING Open the 2Tips word processing document that contains tips on how to save electricity. Insert your examination number in the header of the document. 2.1 Format the first letter of the paragraph that starts with ’Load-shedding and higher …’ as a drop cap that is dropped over THREE lines and positioned 0.3 cm from the text. (3) 2.2 Create a link as follows: • Insert a bookmark called ’Tips’ on the heading ’Saving tips’. • Insert a hyperlink on the text ’see the tips’ in the first paragraph that links to the ’Tips’ bookmark. • Add the ScreenTip ’Save power’ to the hyperlink. (3) 2.3 Change the numbered list that starts with ’Install a geyser blanket …’ to a bulleted list using the smiley face symbol (Wingdings: Character code 74). (2) 2.4 Format the text from the heading ’Saving tips’ up to and including the paragraph that ends with ’…during peak hours.’ into TWO columns with a line between the columns. NOTE: The rest of the document must remain in ONE column. (3) 2.5 Insert a caption below the image under the heading ’Measure your usage’ so that it displays as follows: Figure A: Smart meter NOTE: Use the ’A, B, C, …’ numbering format. (3) 2.6 Find the text below the heading ’Contact our branches’ and set a tab stop so that the text displays as shown in the example below. Johannesburg . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 011 555 0141 Pretoria . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 012 555 0177 Polokwane . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 015 555 0123 Mbombela . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 013 555 0190 NOTE: The telephone numbers end at the 15 cm mark on the ruler. (3) 2.7 Insert a custom text watermark as follows: • Text: LANGA • Font: Arial • Layout: Horizontal (3) 2.8 Replace the text ’Question/Vraag 2.8’ with a field that displays the number of words in the document. (1) Save and close the 2Tips document. [21] Copyright reserved Please turn over

Computer Applications Technology/P1 8 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. • Should you need to use building blocks, use the space allocated for this in the spreadsheet data file. Open the 3Installs spreadsheet that contains information about the solar systems that Langa Solar installed from January to June 2026. Work in the Installations worksheet. 3.1 Merge and centre cells A1:L1 and apply the ’Heading 1’ cell style. (2) 3.2 Insert a function in cell D3 to determine the number of installations that included a battery. (2) 3.3 Insert a combination of functions in cell D4 to determine the average cost of a Premium system. Round the answer to TWO decimal places. (4) 3.4 Insert a function in cell L6 to display the full name of the month (e.g. January) in which the system was installed. Copy the function to cell L45. (2) 3.5 Insert a lookup function in cell K6 to determine the number of years of warranty for the system type. Use the information in the Rates worksheet. Copy the function to cell K45. (4) 3.6 Apply a spreadsheet feature to the surnames in cells B6:B45 so that the surnames of clients who still owe more than R10 000 (Balance column) are displayed in a red font. (4) Save and close the 3Installs spreadsheet. [18] Copyright reserved Please turn over

Computer Applications Technology/P1 9 Hlayiso/Mock 2026 NSC Mock QUESTION 4: 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. • Should you need to use building blocks, use the space allocated for this in the spreadsheet data file. Open the 4Quotes spreadsheet that contains the quotes that Langa Solar prepared for clients from January to April 2026. Work in the Quotes worksheet. 4.1 Insert a function in cell C3 to determine the date of the most recent quote. Format the cell to display the date in the format: 22 April 2026 (2) 4.2 Insert a COUNTIFS function in cell C4 to determine the number of quotes for business clients that require more than 20 panels. (4) 4.3 Insert a function in cell C5 to calculate the total number of panels quoted for in March 2026. (4) 4.4 Insert a combination of functions in cell J10 to create a code for the client, as follows: • The first THREE letters of the client name in capital letters, followed by • The last FOUR digits of the cell number Example: MTH2802 (4) 4.5 The discount is calculated on the subtotal as follows: • Schools receive a 10% discount. • Businesses with a subtotal of more than R150 000 receive a 5% discount. • No discount is given in all other cases. Insert a nested IF function in cell H10 to calculate the discount for the client. Copy the function to cell H49. (6) 4.6 Insert a function in cell K10 to determine the rank of the final amount of each quote, where the highest final amount is ranked 1. Copy the function to cell K49. (2) Save and close the 4Quotes spreadsheet. [22] Copyright reserved Please turn over

Computer Applications Technology/P1 10 Hlayiso/Mock 2026 NSC Mock QUESTION 5: DATABASE The database contains details about Langa Solar’s technicians, clients and installations. Open the 5Langa database. 5.1 Open the tbl5_1 table in Design View and edit it as follows: 5.1.1 Set the TechID field as the primary key. (1) 5.1.2 Change the data type of the Qualified field so that a user can only select or clear a check box. (1) 5.1.3 Create an input mask for the EmpCode field so that data is captured as follows: • TWO compulsory letters that are always displayed in capital letters, followed by • A hyphen (-), followed by • THREE compulsory digits Example: LS-042 (3) 5.1.4 Insert a validation rule for the HourlyRate field to make sure that only amounts from R150 to R450 can be entered. Add appropriate validation text. (3) 5.1.5 Ensure that the current date automatically appears in the StartDate field when a new record is added. (1) 5.1.6 Modify the lookup properties of the Branch field so that a user can select ’Johannesburg’, ’Pretoria’ or ’Polokwane’ from a drop-down list. (3) Save and close the tbl5_1 table. 5.2 Create a form called frm5_2 based on the tblClients table as follows: • Display ALL the fields in a columnar layout. • Insert the 5Logo image in the form header. • Change the title of the form to ’Langa Solar Clients’. • Ensure that the data in the ClientID field cannot be edited in Form View. • Change the background colour of the Detail section to any light yellow colour. Save and close the frm5_2 form. (6) 5.3 Create a query called qry5_3 based on the tblInstallations table. Display ONLY the InstallID, ClientID, InstallDate, SystemType and Battery fields of the following installations: • Premium systems installed from 1 January 2026 to 31 March 2026 • Basic systems that include a battery Save and close the qry5_3 query. (5) Copyright reserved Please turn over

Computer Applications Technology/P1 11 Hlayiso/Mock 2026 NSC Mock 5.4 Create a query called qry5_4 based on the tblInstallations table. • Display the InstallID, SystemType, Panels and Cost fields. • Insert a calculated field called CostPerPanel to calculate the cost per panel for each installation. Format the field as currency. • Sort the records so that the installation with the highest cost per panel appears first. Save and close the qry5_4 query. (4) 5.5 Create a query called qry5_5 based on the tblInstallations table to display the number of installations AND the total cost of the installations for EACH system type. Sort the query from the highest total cost to the lowest total cost. Save and close the qry5_5 query. (4) 5.6 Create a report called rpt5_6 based on the tblInstallations table as follows: • Display the Area, InstallID, SystemType and Cost fields, grouped by Area. • Insert a function in the Area footer to calculate the total cost per area. • Change the page orientation to landscape. • Change the report title to ’Installations per area’. Save and close the rpt5_6 report. (4) Save and close the 5Langa database. [35] Copyright reserved Please turn over

Computer Applications Technology/P1 12 Hlayiso/Mock 2026 NSC Mock QUESTION 6: WEB DESIGN (HTML) NOTE: • You may NOT use a word processing program such as Word to answer the HTML questions. • An HTML tag sheet has been attached for reference. • All files needed to complete this question can be found in the examination folder. A web page was created to advertise the solar packages of Langa Solar. 6.1 Open the incomplete 6_1Solar 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. NOTE: • Use the example above as a guideline when answering this question. • Question numbers appear as comments in the coding to indicate where you should insert the answer(s). DO NOT delete these comments. 6.1.1 Insert your examination number as a comment in the web page. (1) 6.1.2 Insert the image 6_1Sun with a width of 150 pixels so that it appears as in the example above. (3) 6.1.3 Format the heading ’Langa Solar’ so that it is centred and displayed in a DarkOrange font colour. (2) 6.1.4 Format the table as follows: • Add a border with a size of 2. • Ensure that the text ’Our packages’ spans across all the columns of the table. (3) Copyright reserved Please turn over

Computer Applications Technology/P1 13 Hlayiso/Mock 2026 NSC Mock 6.1.5 Change the list below the heading ’Why choose us?’ so that it appears as in the example above. (2) Save and close the 6_1Solar file. 6.2 Open the incomplete 6_2Battery file in a web browser and also in a text/HTML editor (NOT a word processing program such as Word). Modify the existing HTML code so that your final web page displays like the example below. NOTE: The text ’Back to home page’ must open the 6_1Solar web page when it is clicked. Save and close the 6_2Battery file. (3) ONE mark will be allocated for closing tags and correct nesting in both the web pages. (1) [15] Copyright reserved Please turn over

Computer Applications Technology/P1 14 Hlayiso/Mock 2026 NSC Mock QUESTION 7: GENERAL Open the 7Letter document. 7.1 Langa Solar wants to send a letter to clients in Pretoria whose solar systems do NOT have a battery. Prepare the letters using mail merge as follows: • Use the 7Clients spreadsheet as the data source for the 7Letter document. • Only clients in Pretoria without a battery must receive a letter. • Replace the text <<NAME>> with the FirstName field. • Save the 7Letter document in your examination folder, but do NOT close it. • Complete the merge and save the merged document as 7Merged. (5) Close the 7Letter and 7Merged documents. Open the 7Usage spreadsheet and work in the Usage worksheet. 7.2 Create a chart to appear as shown below. NOTE: Move the chart to a new chart sheet called Chart. (5) Work in the Payments worksheet. 7.3 Apply a data validation rule to cells C2:C61 so that a user can only select ’Cash’, ’EFT’ or ’Card’ from a drop-down list. Display the error message ’Choose from the list’ when invalid data is entered. (3) 7.4 Change the page setup settings of the worksheet as follows: • Ensure that row 1 is repeated at the top of every printed page. • Fit ALL the columns on one page when the worksheet is printed. (2) Save and close the 7Usage spreadsheet. [15] TOTAL: 150 Copyright reserved Please turn over

Computer Applications Technology/P1 Hlayiso/Mock 2026 NSC Mock HTML TAG SHEET Basic Tags Formatting Tags continued Tag Description Tag Description <body></body> Defines the body of the web page <li></li> Inserted before each list item, <body bgcolor="pink"> Sets the background colour of the and adds a number or symbol web page depending on the type of list <body text="black"> Sets the colour of the body text selected <head></head> Contains information about the <img src="name"/> Adds an image web page <img src="name" Aligns an image: can be ”right”, <html></html> Creates an HTML document – align="left"/> ”bottom”, ”top” starts and ends a web page <p align="center"><img Aligns an image in the ”center”, <title></title> Defines a title for the web page src="name"/></p> can also be ”middle” <br/> Inserts a line break <img src="name" Sets the size of the border around border="1"/> an image <!-- --> Comment <img src="name" Sets the height and width of an Text Tags width="200" image <h1></h1> Creates the largest heading height="200"/> <h6></h6> Creates the smallest heading <img src="name" Displays alternative text when the <b></b> Creates bold text alt="alternative text"/> mouse hovers over the image or <i></i> Creates italic text when the image is not found <u></u> Creates underlined text <hr/> Inserts a horizontal line <font size="3"></font> Sets size of font, from ”1” to ”7” <hr size="3"/> Sets size (height) of a line <font color="green"> Sets font colour <hr width="80%"/> Sets the width of a line, in </font> percentage or absolute value <font face="Times New Sets font type <hr color="ff0000"/> Sets the colour of the line Roman"></font> Table Tags Links Tags <table></table> Creates a table <a href="URL"></a> Creates a hyperlink <tr></tr> Creates a row in a table <a href="URL"><img Creates an image link <td></td> Creates a cell in a table src="name"></a> <th></th> Creates a table header (a cell <a name="NAME"></a> Creates a target location in the with bold, centred text) document <table width="50"> Sets the width of the table <a href="#NAME"></a> Links to a target location created <table border="1"> Sets the width of the border somewhere else in the document around the table cells <a href= Links to an e-mail address <table cellspacing="1"> Sets the space between the table "mailto:#NAME"></a> cells Formatting Tags <table cellpadding="1"> Sets the space between a cell <p></p> Creates a new paragraph border and its contents <p align="left"> Aligns a paragraph to the ”left” <tr align="left"> Sets the alignment for cell(s) (default), can also be ”right” or (”left”, can also be ”center” or ”center” ”right”) <center></center> Horizontally centres text, a <tr valign="top"> Sets the vertical alignment for section, table or an image cell(s) (”top”, can also be ”middle” <ol></ol> Creates a numbered list or ”bottom”) <ol type="A","a", Defines the type of numbering <td colspan="2"> Sets the number of columns a cell "I","i","1"></ol> used should span <ul></ul> Creates a bulleted list <td rowspan="4"> Sets the number of rows a cell <ul type="disc", Defines the type of bullets used should span "square","circle"></ul> Copyright reserved

Computer Applications Technology/P1 Hlayiso/Mock 2026 NSC Mock INPUT MASK CHARACTER SHEET CHARACTER DESCRIPTION 0 Digit (0 to 9, entry required, plus [+] and minus [–] signs not allowed) 9 Digit or space (entry not required, plus [+] and minus [–] signs not allowed) # Digit or space (entry not required; spaces are displayed as blanks while in Edit mode, but blanks are removed when data is saved; plus [+] and minus [–] signs allowed) L Letter (A to Z, entry required) ? Letter (A to Z, entry optional) A Letter or digit (entry required) a Letter or digit (entry optional) & Any character or a space (entry required) C Any character or a space (entry optional) .,:;-/ Decimal placeholder and thousand, date and time separators (The actual character used depends on the settings in the Regional Settings Properties dialog box in the Windows Control Panel.) < Causes all characters to be converted to lower case > Causes all characters to be converted to upper case ! Causes the input mask to display from right to left, rather than from left to right. Characters typed into the mask always fill it from left to right. You can include the exclamation mark anywhere in the input mask. \ Causes the character that follows to be displayed as the literal character (e.g. \A is displayed as just A) 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 YOU MAY USE THIS PAGE FOR ANY PLANNING PURPOSES. Copyright reserved

Computer Applications Technology/P1 Hlayiso/Mock 2026 NSC Mock Examination sticker 150 COMPUTER APPLICATIONS TECHNOLOGY P1 – MOCK EXAMINATION 2026 INFORMATION SHEET (to be completed by the candidate AFTER the 3-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 1Power 24 2 2Tips 21 3 3Installs 18 4 4Quotes 22 5 5Langa 35 6_1Solar 6 15 6_2Battery 7Letter 7 7Merged 15 7Usage TOTAL 150 Comment: (for office/marker use only) Copyright reserved