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 Mock 2 DATA. Do the following: • Copy the folder CAT P1 Gr11 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 Gr11 Nov 2026 Mock 2 DATA with your examination number. The following files will be available in the folder: 1Athletics Word processing file 1Runner Image 2Entry Word processing file 3Results Spreadsheet 4TrackStars Database 5Meet HTML 5Track Image 6Certificate Word processing file 6Coaches Spreadsheet 6Report Word processing file 6Winners Spreadsheet Copyright reserved Please turn over

Computer Applications Technology/P1 4 Hlayiso/Mock 2026 NSC Mock SCENARIO TRACKSTARS LIMPOPO is a non-profit athletics development programme in Polokwane. Volunteer coaches train learners from rural and township schools every Saturday. At the end of the year TrackStars hosts the Capricorn Schools Championship, where learners from six partner schools compete in track and field events. QUESTION 1: WORD PROCESSING Open the 1Athletics word processing document that contains a guide for young athletes. Insert your examination number in the header of the document. 1.1 Insert any built-in cover page at the beginning of the document. Type ’TrackStars Limpopo’ in the title content control AND ’Athlete guide 2026’ in the subtitle content control. NOTE: Delete any other content controls on the cover page that you do not use. (2) 1.2 Create a new paragraph style called TrackSub as follows: • Base the style on the ’Heading 2’ style. • Font colour: Any orange colour • Spacing after the paragraph: 6 pt • Apply the TrackSub style to ALL FOUR sub-headings that are numbered 1.1, 2.1, 3.1 and 4.1. (3) 1.3 The name of the programme has been typed incorrectly as ’Track Stars’ (two words) in the body of the document. Replace ALL occurrences of ’Track Stars’ with ’TrackStars’ (one word) so that the replaced word is displayed in bold. (3) 1.4 Change the bulleted list below the heading ’3.1 What to pack’ as follows: • Use the Wingdings symbol with character code 252 (4) as the bullet. • The text must start 1 cm from the bullet. (3) 1.5 Replace the text ’Question/Vraag 1.5’ with the 1Runner 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.6 Insert a caption below the 1Runner image with the text ’Figure 1: Sprinting technique’. Use the label ’Figure’. Replace the text ’Question/Vraag 1.6’ (below ’List of figures’ at the end of the document) with an automatic table of figures. (3) 1.7 Insert an endnote on the word ’hydration’ (under the heading ’3. Nutrition and recovery’) with the text ’Drink small amounts of water often.’ The endnote number must use the 1, 2, 3 … number format. (2) Copyright reserved Please turn over

Computer Applications Technology/P1 5 Hlayiso/Mock 2026 NSC Mock 1.8 Insert a citation at the end of the text that is highlighted in yellow under the heading ’2. Training for young athletes’. Create a new source with the following details: Type of source: Book Author: Ngobeni, Tiyani Title: Coaching the young sprinter Year: 2024 City: Polokwane Publisher: Bushveld Press Replace the text ’Question/Vraag 1.8’ (below ’References’) with an automatic bibliography. (4) 1.9 Insert automatic page numbers in the footer of the document as follows: • Odd pages and even pages must have different footers. • The page numbers on odd pages must be right aligned and the page numbers on even pages must be left aligned. (3) 1.10 Insert a custom text watermark with the text ’DRAFT’ in a diagonal layout. (2) Save and close the 1Athletics document. [28] Copyright reserved Please turn over

Computer Applications Technology/P1 6 Hlayiso/Mock 2026 NSC Mock QUESTION 2: WORD PROCESSING Open the 2Entry word processing document that contains the entry form for the championship. Insert your examination number in the header of the document. 2.1 Replace the text ’Question/Vraag 2.1’ with a legacy text form field that has a maximum length of 30 characters and displays the text in uppercase. (2) 2.2 Replace the text ’Question/Vraag 2.2’ with a drop-down list content control as follows: • The list must contain ONLY the items 100 m, 200 m, 400 m, 800 m and Long jump. • The item ’Choose an item.’ must NOT appear in the list. (3) 2.3 Insert a legacy check box form field in front of the text ’I have the consent of my parent or guardian to take part.’ The check box must be exactly 12 pt in size AND must be checked by default. (2) 2.4 Do the following: • Insert the Wingdings symbol with character code 40 (%) in front of the text ’Contact number:’. • Replace the text ’Question/Vraag 2.4’ with a date field that displays the current date in the format 2026/11/28 and that updates automatically. (3) 2.5 Change the page colour of the document to a gradient fill effect that uses TWO colours of your choice with a horizontal shading style. (2) 2.6 Apply ANY outer shadow text effect AND ANY glow text effect to the heading ’TRACKSTARS ENTRY FORM’. (2) Save and close the 2Entry 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 3Results spreadsheet that contains the details of the learners who entered the 100 m sprint at the championship. Work in the Entries worksheet. 3.1 Format the merged cells A1:M1 as follows: • Apply a two-colour gradient fill (any two colours). • Centre the text vertically in the cell. (2) 3.2 Use a spreadsheet feature to ensure that rows 1 to 6 AND columns A and B always remain visible when you scroll down or to the right in the worksheet. (2) 3.3 Insert a function in cell D2 to determine the number of girls (F) who entered. (2) 3.4 Insert a function in cell D3 to calculate the total amount paid by athletes from Thabakgolo High School. (3) 3.5 Insert a function in cell D4 to determine the third fastest (third lowest) heat time. (2) 3.6 Insert a combination of functions in cell D5 to calculate the average heat time of the girls. Round the answer to TWO decimal places. (3) 3.7 Insert a function in cell J7 to calculate the age of the athlete, in completed years, on the date of the meet given in cell J2. Copy the function to cell J46. (4) 3.8 The age category of an athlete is determined as follows: • Younger than 14 years: U14 • 14 or 15 years: U16 • 16 years or older: U19 Insert a function in cell K7 to determine the age category of each athlete. Copy the function to cell K46. (5) 3.9 Each athlete pays the fee per event given in cell J3 for every event that the athlete entered (column G). Insert a formula in cell L7 to calculate the amount due by each athlete. Copy the formula to cell L46. (3) Copyright reserved Please turn over

Computer Applications Technology/P1 8 Hlayiso/Mock 2026 NSC Mock 3.10 Insert a combination of functions in cell M7 to create a code for each athlete, as follows: • The first letter of the athlete’s first name, followed by • The first THREE letters of the surname, all in capital letters, followed by • The number of characters in the surname Example: Ntsako Chauke → NCHA6 Copy the function to cell M46. (4) 3.11 Apply a conditional formatting rule to cells H7:H46 so that ONLY the FIVE fastest (lowest) heat times are displayed with a green fill and dark green 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: • The slice for Thabakgolo High School must be pulled out (exploded) from the rest of the pie. • Place the chart on the Summary worksheet below the data. (5) Save and close the 3Results 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 coaches, the partner schools and the athletes of TrackStars Limpopo. Open the 4TrackStars database. 4.1 Open the tblCoaches table in Design View and edit it as follows: 4.1.1 Change the field size of the Surname field to 25. (1) 4.1.2 Create an input mask for the CellNo field so that: • TEN compulsory digits must be entered • The number is displayed with spaces as in the example: 082 555 1234 • The hash symbol (#) is used as the placeholder character (3) 4.1.3 Insert a validation rule for the YearsExp field so that only values from 1 up to and including 40 can be entered. Add appropriate validation text. (3) 4.1.4 Set a property of the Province field so that ’Limpopo’ is automatically entered for every new record. (1) 4.1.5 Set a property of the Email field so that it may NOT be left empty. (1) 4.1.6 Modify the lookup properties of the Level field so that a user can select ONLY ’Club’, ’District’ or ’Provincial’ from a drop-down list. A user must NOT be able to type any other value. (3) Save the tblCoaches table and open it in Datasheet View. 4.1.7 Change the datasheet of the tblCoaches table so that the font size is 12 pt AND the alternate row colour is any light orange colour. (2) Save and close the tblCoaches table. 4.2 Create a form called frm4_2 based on the tblAthletes table as follows: • Display ONLY the AthleteID, Surname, FirstName, Gender, SchoolID and HeatTime fields in a tabular layout. • Change the title of the form to ’TrackStars athletes’. • Insert a function in the form footer to display the fastest (lowest) heat time. • Change the background colour of the Detail section to any light colour. Save and close the frm4_2 form. (5) 4.3 Create a query called qry4_3 based on the tblAthletes table. • Display ONLY the AthleteID, Surname, Gender, DOB and HeatTime fields. • Display ONLY the girls (F) who were born in 2010 or 2011. • Sort the records from the fastest to the slowest heat time. 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 tblAthletes table. Display the Surname, FirstName, SchoolID and Events fields of ALL the athletes whose surname starts with the letter ’R’ OR who entered 4 events. Save and close the qry4_4 query. (4) 4.5 Create a query called qry4_5 based on the tblAthletes table that displays, for EACH school (SchoolID), the number of athletes AND the average heat time of the athletes. Save and close the qry4_5 query. (4) 4.6 Create a report called rpt4_6 based on the tblAthletes table as follows: • Display ONLY the Gender, Surname, FirstName and HeatTime fields, grouped by Gender. • Within each group the records must be sorted from the fastest to the slowest heat time. • Change the report title to ’Heat times per gender’. Save and close the rpt4_6 report. (4) Save and close the 4TrackStars 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 5Meet 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 ’TrackStars Limpopo’ so that it displays on the tab of the web browser. (1) 5.2 Change the background colour of the web page to lightyellow AND the colour of ALL the text to navy. (2) 5.3 Change the heading ’Capricorn Schools Championship’ to a level 2 heading that is displayed in italics. (2) Copyright reserved Please turn over

Computer Applications Technology/P1 12 Hlayiso/Mock 2026 NSC Mock 5.4 Insert the image 5Track below the first paragraph as follows: • Height: 150 pixels • Border: 2 • Alternative text: Athletics track • Centred on the page, as shown in the example above (4) 5.5 Change the list below the heading ’What to bring’ so that it appears as in the example above. (2) 5.6 Create a target location called programme at the heading ’Programme’ so that the existing link ’Jump to the programme’ jumps to this heading when it is clicked. (2) 5.7 Format the table as follows: • The cell ’Event times’ must span THREE columns and must be centred. • The space between the table cells must be 4. (3) 5.8 Format the text ’Entries close on 14 November 2026.’ so that it is displayed in bold, in a red font colour AND in font size 5. (3) Save and close the 5Meet 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 6Coaches spreadsheet that contains the details of the TrackStars coaches. Work in the Coaches worksheet. 6.1 Change the page setup settings of the worksheet as follows: • Landscape orientation • Row 1 must be printed at the top of EVERY page. • The data must be centred horizontally on the page. (3) 6.2 Use a spreadsheet feature to display ONLY the coaches from Polokwane AND Seshego. Do NOT delete any data. Save the worksheet, with the filter applied, as a PDF file called 6Coaches in your examination folder. (3) Save and close the 6Coaches spreadsheet. 6.3 TrackStars wants to award certificates to the athletes who finished in the top three places of each event. Open the 6Certificate document and prepare the certificates using mail merge as follows: • Use the 6Winners spreadsheet as the data source. • ONLY athletes who finished in position 1, 2 or 3 must receive a certificate. • Replace the text <<NAME>> with the FirstName and Surname fields (with a space between them) and the text <<EVENT>> with the Event field. • Save the 6Certificate document in your examination folder. • Complete the merge and save the merged document as 6Merged. (5) Close the 6Certificate and 6Merged documents. 6.4 Open the 6Report document. Replace the text ’Question/Vraag 6.4’ with the data in cells A1:B5 of the Summary worksheet of the 6Coaches spreadsheet, so that the data in 6Report will be updated automatically when the data in the spreadsheet changes. (3) Save and close the 6Report document. [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 – GR 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 1Athletics 28 2 2Entry 14 3 3Results 38 4 4TrackStars 36 5 5Meet 20 6Coaches (.xlsx) 6Coaches (.pdf) 6 6Certificate 14 6Merged 6Report TOTAL 150 Comment: (for office/marker use only) Copyright reserved