Computer Applications Technology Grade 11 P1 2026 QP (Eng)

Mock hlayiso mock exams Practice Series: Grade 11 Exam Preparation WWW.HLAYISO.COM NATIONAL SENIOR CERTIFICATE GRADE 11 COMPUTER APPLICATIONS TECHNOLOGY P1 NOVEMBER EXAMINATION 2026 (MOCK) MARKS: 150 TIME: 3 hours This question paper consists of 13 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 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 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. Copyright reserved Please turn over

Computer Applications Technology/P1 3 Hlayiso/Mock 2026 NSC Mock 14. Ensure that the Developer tab and Ruler are activated. 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. 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 Gr11 Nov 2026 DATA. Do the following: • Copy the folder CAT P1 Gr11 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 Gr11 Nov 2026 DATA with your examination number. The following files will be available in the folder: 1Bin Image 1Ewaste Word processing file 2Donate Word processing file 3Collect Spreadsheet 4Logo Image 4ReBoot Database 5Laptop Image 5Laptops HTML 6Letter Word processing file 6Schools Spreadsheet 6Volunteers Text file Copyright reserved Please turn over

Computer Applications Technology/P1 4 Hlayiso/Mock 2026 NSC Mock SCENARIO South Africans throw away thousands of tonnes of old computers, cellphones and other electronic devices every year. REBOOT SA is a non-profit organisation in Durban that collects electronic waste (e-waste), repairs devices that can still be used and donates them to schools. Devices that cannot be repaired are recycled safely. QUESTION 1: WORD PROCESSING Open the 1Ewaste word processing document that contains an information leaflet about e-waste. Insert your examination number in the header of the document. 1.1 Apply the built-in ’Title’ style to the first line of the document, ’E-waste: what you need to know’, AND expand the character spacing of this line by 2 pt. (2) 1.2 Modify the ’Heading 1’ style as follows: • Font size: 16 pt • Font effect: Small caps • Spacing before the paragraph: 18 pt (3) 1.3 The word ’e-waste’ was spelt incorrectly as ’ewaste’ in some places in the document. Find and replace ALL occurrences of ’ewaste’ with ’e-waste’ so that the replaced word is displayed in italics. (3) 1.4 Convert the text below the heading ’1.1 Common types of e-waste’, starting with ’Item’ and ending with ’…older backlights’, into a table. • Apply any table style to the table. • AutoFit the table to its contents. • Sort the rows of the table so that the items are listed from the heaviest to the lightest average mass. The heading row must remain at the top of the table. (5) 1.5 Replace the text ’Question/Vraag 1.5’ with the 1Bin image. • Change the height of the image to 3 cm, keeping the original proportions. • Apply ’Tight’ text wrapping to the image. (3) 1.6 Format the TWO paragraphs directly below the heading ’2. Why recycle?’ into TWO columns with a spacing of 1 cm between the columns. NOTE: The rest of the document must remain in ONE column. (3) 1.7 Insert a footnote on the word ’POPIA’ with the text ’Protection of Personal Information Act 4 of 2013’. (2) 1.8 Insert a comment on the word ’landfill’ with the text ’Add a definition’. (2) Copyright reserved Please turn over

Computer Applications Technology/P1 5 Hlayiso/Mock 2026 NSC Mock 1.9 Replace the text ’Question/Vraag 1.9’ with an automatic table of contents as follows: • Display only ONE level (Heading 1 entries). • The page numbers must be right aligned with a dotted (……) tab leader. (3) 1.10 Insert a section break so that the heading ’4. Drop-off points’ and the text that follows it start on a new page with a landscape orientation. NOTE: The rest of the document must remain in portrait orientation. (2) Save and close the 1Ewaste document. [28] Copyright reserved Please turn over

Computer Applications Technology/P1 6 Hlayiso/Mock 2026 NSC Mock QUESTION 2: WORD PROCESSING Open the 2Donate word processing document that contains a form that donors complete when they donate a device. Insert your examination number in the header of the document. 2.1 Replace the text ’Question/Vraag 2.1’ with a date picker content control that displays the date in the format: 15 March 2026 (2) 2.2 Replace the text ’Question/Vraag 2.2’ with a drop-down list content control as follows: • The list must contain the items Laptop, Desktop, Cellphone and Printer. • The placeholder text must display as ’Select a device’. (3) 2.3 Insert a check box content control in front of EACH of the items ’Data wiped’, ’Charger included’ and ’Original box’. (2) 2.4 Set a tab stop for the lines ’Name:’, ’Cell number:’ and ’E-mail:’ so that the text displays as shown in the example below. Name: Cell number: E-mail: NOTE: The lines end at the 15 cm mark on the ruler. (3) 2.5 Insert a box page border with a width of 3 pt in any green colour. (2) 2.6 Restrict the editing of the document so that a user can ONLY fill in the form. Do NOT add a password. (2) Save and close the 2Donate document. [14] 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. • Should you need to use building blocks, use the space allocated for this in the spreadsheet data file. Open the 3Collect spreadsheet that contains information about the e-waste that ReBoot SA collected from January to June 2026. Work in the Collections worksheet. 3.1 Merge and centre cells A1:L1 and change the font size of the text to 16 pt. (2) 3.2 Use a spreadsheet feature to ensure that rows 1 to 7 always remain visible when you scroll down in the worksheet. (2) 3.3 Format the dates in cells D8:D47 to display as in the following example: 18 Jan 2026 (2) 3.4 Insert a function in cell D3 to determine the number of donations from schools. (2) 3.5 Insert a function in cell D4 to calculate the total mass (in kg) of the e-waste collected from businesses. (3) 3.6 Insert a function in cell D5 to determine the date of the first collection. (1) 3.7 The value of the e-waste is calculated by multiplying the mass by the rate per kg for the device. The rates are given in the Rates worksheet. Insert a function in cell J8 that uses a lookup function to calculate the value of the e-waste. Copy the function to cell J47. (5) 3.8 ReBoot SA charges a collection fee, which is given in cell K3. No fee is charged when the donor is a school OR when the mass of the donation is 50 kg or more. Insert a function in cell K8 to determine the collection fee for each donation. Copy the function to cell K47. (6) 3.9 Insert a combination of functions in cell L8 to create a code for each donation, as follows: • The first TWO letters of the device in capital letters, followed by • The last THREE characters of the reference number (column A) Example: CE001 Copy the function to cell L47. (4) Copyright reserved Please turn over

Computer Applications Technology/P1 8 Hlayiso/Mock 2026 NSC Mock 3.10 Insert a function in cell H48 to calculate the average mass of a donation. Round the answer to ONE decimal place. (3) 3.11 Apply a spreadsheet feature to cells I8:I47 so that ALL the cells that contain the word ’Faulty’ are displayed with a light red fill and dark red text. (3) Work in the Summary worksheet. 3.12 Use the data in cells A1:B7 to create a chart that appears as shown below. NOTE: Move the chart to a new chart sheet called Chart. (5) Save and close the 3Collect spreadsheet. [38] Copyright reserved Please turn over

Computer Applications Technology/P1 9 Hlayiso/Mock 2026 NSC Mock QUESTION 4: DATABASE The database contains details of the volunteers, the partner schools and the devices that ReBoot SA received. Open the 4ReBoot database. 4.1 Open the tblVolunteers table in Design View and edit it as follows: 4.1.1 Set the VolID field as the primary key. (1) 4.1.2 Set a property of the Surname field so that surnames are always displayed in capital letters. (1) 4.1.3 Create an input mask for the VolCode field so that data is captured as follows: • TWO compulsory letters that are always displayed in capital letters, followed by • ONE to THREE digits (the first digit is compulsory) Example: AZ400 (3) 4.1.4 Insert a validation rule for the DateJoined field so that only dates from 1 January 2020 up to and including the current date can be entered. Add appropriate validation text. (3) 4.1.5 Insert a new field called Photo directly below the Surname field. The field must be able to store a picture of the volunteer. (2) 4.1.6 Modify the lookup properties of the Shift field so that a user can select ’Morning’, ’Afternoon’ or ’Saturday’ from a drop-down list. (3) Save and close the tblVolunteers table. 4.2 Create a form called frm4_2 based on the tblSchools table as follows: • Display ALL the fields in a columnar layout. • Insert the 4Logo image in the form header. • Change the title of the form to ’Partner schools’. • Insert a function in the form footer to display the current date. • Insert a button in the form footer that will close the form when it is clicked. Save and close the frm4_2 form. (5) 4.3 Create a query called qry4_3 based on the tblDevices table. • Display ONLY the DeviceID, DeviceType, RAM_GB, DateReceived and Refurbished fields. • Display ONLY the laptops with 8 GB of RAM or more that have been refurbished. • Sort the records from the earliest to the latest date received. Save and close the qry4_3 query. (5) Copyright reserved Please turn over

Computer Applications Technology/P1 10 Hlayiso/Mock 2026 NSC Mock 4.4 Create a query called qry4_4 based on the tblDevices table. Display the DeviceID, DeviceType, DateReceived and Fault fields of ALL the devices that were received in March 2026 OR that have a fault that includes the word ’screen’. Save and close the qry4_4 query. (4) 4.5 ReBoot SA sells some refurbished devices at 60% of the estimated value to raise funds. Create a query called qry4_5 based on the tblDevices table. • Display ONLY the DeviceID, DeviceType and EstValue fields. • Insert a calculated field called SellPrice to calculate the selling price of each device. Format the field as currency. Save and close the qry4_5 query. (4) 4.6 Create a report called rpt4_6 based on the tblDevices table as follows: • Display ONLY the DeviceType, DeviceID, DateReceived and EstValue fields, grouped by DeviceType. • Insert a function in the DeviceType footer to count the number of devices of each type. • Change the report title to ’Devices per type’. Save and close the rpt4_6 report. (5) Save and close the 4ReBoot database. [36] Copyright reserved Please turn over

Computer Applications Technology/P1 11 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 5Laptops 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 ’ReBoot SA’ so that it displays on the tab of the web browser. (1) 5.2 Format the heading ’ReBoot SA’ so that it is centred and displayed in a green font colour. (2) 5.3 Insert the image 5Laptop as follows: • Width: 200 pixels • Aligned to the right of the page, as shown in the example above • Alternative text: Refurbished laptop (4) 5.4 Format the paragraph below the heading ’Old devices, new opportunities’ so that it is displayed in the Verdana font with a font size of 4. (2) 5.5 Format the horizontal line so that it has a size of 4, a width of 60% and the colour 008000. (3) 5.6 Change the list below the heading ’How to donate’ so that it appears as in the example above. (2) Copyright reserved Please turn over

Computer Applications Technology/P1 12 Hlayiso/Mock 2026 NSC Mock 5.7 Format the table as follows: • Add a border with a size of 2. • Add a cell padding of 6. • Change the cells in the first row to table header cells. (3) 5.8 Create an e-mail link on the text ’Contact us’ that opens a new e-mail message addressed to info@rebootsa.org.za. (2) Save and close the 5Laptops file. ONE mark will be allocated for closing tags and correct nesting. (1) [20] Copyright reserved Please turn over

Computer Applications Technology/P1 13 Hlayiso/Mock 2026 NSC Mock QUESTION 6: GENERAL Open the 6Schools spreadsheet that contains the details of schools that applied for refurbished laptops. 6.1 Sort the data so that it is displayed in alphabetical order of province. Schools in the same province must be sorted from the largest to the smallest number of learners. (3) 6.2 Change the page setup settings of the worksheet as follows: • The gridlines must print. • ALL the columns must fit on ONE page when printed. Save the worksheet as a PDF file called 6Schools in your examination folder. (3) Save and close the 6Schools spreadsheet. 6.3 ReBoot SA wants to send a letter to large schools in KwaZulu-Natal. Open the 6Letter document and prepare the letters using mail merge as follows: • Use the 6Schools spreadsheet as the data source. • ONLY schools in KwaZulu-Natal with more than 1 000 learners must receive a letter. • Replace the text <<PRINCIPAL>> with the Principal field and the text <<SCHOOL>> with the SchoolName field. • Save the 6Letter document in your examination folder. • Complete the merge and save the merged document as 6Merged. (5) Close the 6Letter and 6Merged documents. 6.4 The text file 6Volunteers contains the details of ReBoot SA’s volunteers. The fields are separated by commas. Import the data in the 6Volunteers text file into a new spreadsheet so that EACH field appears in a separate column, starting in cell A1. Save the spreadsheet as 6Volunteers in the default spreadsheet format (.xlsx). (3) Close the 6Volunteers spreadsheet. [14] 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 – GRADE 11 – NOVEMBER 2026 (MOCK) 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 1Ewaste 28 2 2Donate 14 3 3Collect 38 4 4ReBoot 36 5 5Laptops 20 6Schools (.xlsx) 6Schools (.pdf) 6 6Letter 14 6Merged 6Volunteers (.xlsx) TOTAL 150 Comment: (for office/marker use only) Copyright reserved