Computer Applications Technology Grade 11 P2 2026 QP (Eng)

Mock hlayiso mock exams Practice Series: Grade 11 Exam Preparation WWW.HLAYISO.COM NATIONAL SENIOR CERTIFICATE GRADE 11 COMPUTER APPLICATIONS TECHNOLOGY P2 NOVEMBER EXAMINATION 2026 (MOCK) MARKS: 150 TIME: 3 hours This question paper consists of 12 pages. Copyright reserved Please turn over

Computer Applications Technology/P2 2 Hlayiso/Mock 2026 NSC Mock INSTRUCTIONS AND INFORMATION 1. This question paper consists of: SECTION A (25) SECTION B (75) SECTION C (50) 2. Answer ALL the questions. 3. Number the answers correctly according to the numbering system used in this question paper. 4. Start EACH question on a NEW page. 5. Do NOT write in the right-hand margin of the ANSWER BOOK. 6. Leave a line after EACH subquestion. 7. Generally, one mark is allocated per fact; therefore, a 2-mark question would require TWO facts, etc. 8. Read the questions carefully. DO NOT give more answers than the question requires as it will NOT be marked. 9. All answers MUST be related to Computer Applications Technology. 10. Unless otherwise specified, answers such as ’cheaper’, ’slower’/’faster’, etc. will NOT be accepted. 11. Do NOT use brand names in your answers, unless specifically required. 12. Write neatly and legibly. Copyright reserved Please turn over

Computer Applications Technology/P2 3 Hlayiso/Mock 2026 NSC Mock SECTION A QUESTION 1: MULTIPLE-CHOICE QUESTIONS Various options are given as possible answers to the following questions. Choose the answer and write only the letter (A–D) next to the question numbers (1.1 to 1.10) in the ANSWER BOOK, e.g. 1.11 D. 1.1 Which ONE of the following is an example of utility software? A Word processor B Antivirus program C Web browser D Presentation program (1) 1.2 The resolution of a printer is measured in … A ppm. B dpi. C GHz. D Mbps. (1) 1.3 The component that temporarily stores the data and instructions that the CPU is busy using: A Hard drive B RAM C ROM D Flash drive (1) 1.4 A network that covers a large geographical area, such as a country: A PAN B LAN C WAN D WLAN (1) 1.5 Which ONE of the following is a valid e-mail address? A info.rebootsa.org.za B info@rebootsa.org.za C www.rebootsa.org.za D @info rebootsa.org.za (1) 1.6 The spreadsheet function that counts ONLY the cells in a range that contain numbers: A COUNT B COUNTA C SUM D COUNTBLANK (1) Copyright reserved Please turn over

Computer Applications Technology/P2 4 Hlayiso/Mock 2026 NSC Mock 1.7 Which ONE of the following file extensions indicates a web page? A .docx B .xlsx C .html D .accdb (1) 1.8 Malware that pretends to be a useful program so that the user will install it: A Worm B Trojan C Spam D Cookie (1) 1.9 The word processing feature that automatically creates a separate letter for each record in a data source: A Mail merge B Track changes C Template D AutoCorrect (1) 1.10 The database object that is used to present data in a printable format with groups and totals: A Table B Query C Form D Report (1) [10] Copyright reserved Please turn over

Computer Applications Technology/P2 5 Hlayiso/Mock 2026 NSC Mock QUESTION 2: MATCHING ITEMS Choose a term/concept from COLUMN B that matches the description in COLUMN A. Write only the letter (A–T) next to the question numbers (2.1 to 2.10) in the ANSWER BOOK, e.g. 2.11 U. COLUMN A COLUMN B 2.1 Software that interprets the code of a web page A defragmenting and displays the page B cookie 2.2 Preparing a storage medium for use by creating C shareware a new file system on it D #REF! 2.3 A copy of files that is kept so that the files can E web browser be restored if the originals are lost F header 2.4 A small text file that a website stores on a user’s G bandwidth computer H foreign key 2.5 The amount of data that can be transferred over I firewall a connection in a given time J formatting 2.6 The error displayed when a formula refers to a K #VALUE! cell that has been deleted L backup 2.7 Text that appears at the bottom of every page of M latency a document N primary key 2.8 A field in one table that links to the primary key O hacking of another table P freeware 2.9 Gaining unauthorised access to a computer Q search engine system R footer 2.10 Software that may be used free of charge for a S cache trial period, after which the user must pay for it T spoofing (10 x 1) [10] Copyright reserved Please turn over

Computer Applications Technology/P2 6 Hlayiso/Mock 2026 NSC Mock QUESTION 3: TRUE/FALSE ITEMS Indicate whether the following statements are TRUE or FALSE. Write ’true’ or ’false’ next to the question numbers (3.1 to 3.5) in the ANSWER BOOK. Correct the statement if it is FALSE by changing the underlined word(s) to make the statement TRUE. (Do NOT simply use the word ’NOT’ to change the statement.) NO mark will be awarded if only FALSE is written. EXAMPLES: QUESTION ANSWER A keyboard is an input device. True A printer is used to capture images of printed False, scanner documents. 3.1 A webcam is an input device. (1) 3.2 Cache memory is slower than RAM. (1) 3.3 An IP address is a unique number that identifies a device on a network. (1) 3.4 In a spreadsheet, $A$1 is an example of a relative cell reference. (1) 3.5 Phishing is when malware secretly records the keys that a user presses. (1) [5] TOTAL SECTION A: 25 Copyright reserved Please turn over

Computer Applications Technology/P2 7 Hlayiso/Mock 2026 NSC Mock SECTION B QUESTION 4: SYSTEMS TECHNOLOGIES 4.1 Differentiate between system software and application software. (2) 4.2 State TWO functions of an operating system. (2) 4.3 Lerato wants to buy a computer that she will use for video editing. 4.3.1 Explain why the amount of RAM is important for this task. (2) 4.3.2 Name the expansion card that will improve the computer’s ability to process graphics and video. (1) 4.3.3 Give TWO factors that Lerato should consider when she chooses a monitor for video editing. (2) 4.4 Explain the difference between a UPS and a surge protector. (2) 4.5 What is meant by a plug-and-play device? (2) 4.6 Study the following extract from an advertisement for a laptop and answer the questions that follow. LAPTOP SPECIAL – Quad-core 2.8 GHz processor – 8 GB DDR4 RAM – 512 GB SSD – 15.6” Full HD display – 2 x USB 3.0 ports, 1 x USB-C port, HDMI port – Wi-Fi 6 and Bluetooth 5.0 4.6.1 What does Full HD indicate about the display? (1) 4.6.2 Name ONE device that can be connected to the HDMI port. (1) 4.6.3 Give TWO advantages of connecting devices with USB. (2) 4.6.4 State the purpose of Bluetooth. (1) 4.7 Explain the difference between the Save and the Save As options when you work with a file. (2) 4.8 Name TWO utility programs that can help to keep a computer running efficiently. (2) 4.9 Give TWO disadvantages of storing your files ONLY in the cloud. (2) 4.10 Name the type of software licence that allows a school to install a program on many computers with one licence. (1) [25] Copyright reserved Please turn over

Computer Applications Technology/P2 8 Hlayiso/Mock 2026 NSC Mock QUESTION 5: INTERNET AND NETWORK TECHNOLOGIES 5.1 Give TWO advantages of connecting the computers in a school to a network. (2) 5.2 Name TWO hardware items, other than the computers, that are needed to set up a wired LAN. (2) 5.3 Name ONE type of wireless internet connection, other than Wi-Fi. (1) 5.4 Explain the difference between the internet and the World Wide Web. (2) 5.5 Name TWO features of a web browser that make it easier to browse the Web. (2) 5.6 Explain what a search engine is AND give ONE technique that can be used to make search results more specific. (2) 5.7 Give TWO rules of netiquette that should be followed when sending e-mails. (2) 5.8 Explain what VoIP is AND give ONE advantage of using VoIP. (2) [15] QUESTION 6: INFORMATION MANAGEMENT Thabo is doing a research task (PAT) on how households in his community get rid of old electronic devices. 6.1 Name TWO methods that Thabo can use to collect primary data. (2) 6.2 Give TWO characteristics of a good question in a questionnaire. (2) 6.3 Explain the difference between an open question and a closed question. (2) 6.4 Give ONE reason why information on a website that anyone can edit may NOT be reliable. (1) 6.5 Explain what a bibliography is AND why Thabo must include one in his task. (2) 6.6 Name the spreadsheet feature that Thabo can use to display ONLY the rows of data that meet certain criteria. (1) [10] Copyright reserved Please turn over

Computer Applications Technology/P2 9 Hlayiso/Mock 2026 NSC Mock QUESTION 7: SOCIAL IMPLICATIONS 7.1 Give TWO precautions that a user should take when using a free public Wi-Fi hotspot. (2) 7.2 Explain the term identity theft AND give ONE way in which a user can protect himself/herself against it. (2) 7.3 Give TWO ways in which computer users can reduce the impact of ICT on the environment. (2) 7.4 Give TWO ergonomic guidelines that should be followed when setting up a computer workstation. (2) 7.5 What is cyberbullying? (1) 7.6 Explain the term digital divide. (1) [10] QUESTION 8: SOLUTION DEVELOPMENT 8.1 The spreadsheet extract below shows the hours that four volunteers worked at ReBoot SA. Volunteers earn points for every hour that they work. A B C 1 Volunteer Hours Points 2 Sipho 12 3 Priya 30 4 Lwazi 8 5 Thandeka 25 6 7 Total hours 75 8 Points per hour 5 8.1.1 Write down the formula that must be entered in cell C2 to calculate the points for Sipho. The formula must give the correct answers when it is copied to cells C3:C5. (3) 8.1.2 Write down a function that will determine how many volunteers worked more than 20 hours. (2) 8.1.3 What value will be displayed if the function =AVERAGE(B2:B5) is entered in cell B9? (1) 8.1.4 Name the error that will be displayed in cell D7 if the formula =A7+B7 is entered. (1) 8.2 Answer the following questions on word processing: 8.2.1 Name the feature that automatically creates a list of the headings in a document together with their page numbers. (1) 8.2.2 Give TWO reasons why styles should be used instead of formatting each heading manually. (2) Copyright reserved Please turn over

Computer Applications Technology/P2 10 Hlayiso/Mock 2026 NSC Mock 8.2.3 Name the type of break that must be inserted so that only one page of a document can be in landscape orientation. (1) 8.3 Answer the following questions on databases: 8.3.1 State the purpose of a primary key. (1) 8.3.2 Write down the criterion that will display ONLY the records of volunteers whose surnames start with the letter M. (1) 8.4 Study the HTML code below and answer the questions that follow. <table border="1"> <tr><td>???</td></tr> <tr><td>Laptops</td><td>Desktops</td><td>Tablets</td></tr> </table> <font color="green"><b>Thank you!</font></b> 8.4.1 Which attribute and value must be added to the first <td> tag (marked ???) so that the cell spans across all three columns? (1) 8.4.2 Identify the error in the last line of the code. (1) [15] TOTAL SECTION B: 75 Copyright reserved Please turn over

Computer Applications Technology/P2 11 Hlayiso/Mock 2026 NSC Mock SECTION C QUESTION 9: INTEGRATED SCENARIO ReBoot SA is a non-profit organisation in Durban that collects old electronic devices. Devices that still work are repaired and donated to schools, and the rest is recycled. 9.1 The workshop has 12 computers that are connected in a wired LAN. 9.1.1 Give TWO advantages of a wired network compared to a wireless network. (2) 9.1.2 Give TWO advantages of sharing one printer on the network. (2) 9.2 The technicians check the specifications of every laptop before it is refurbished. 9.2.1 Explain the function of the CPU. (2) 9.2.2 Explain why adding more RAM can make a slow laptop run faster. (2) 9.2.3 Some laptops are installed with an open-source operating system. Give TWO advantages of open-source software for schools. (2) 9.3 Every storage device must be wiped before a device is donated. 9.3.1 Explain why deleting files and emptying the Recycle Bin does NOT permanently remove the data. (2) 9.3.2 Give ONE way in which the data on a hard drive that cannot be wiped can be destroyed. (1) 9.4 Donors complete an online form on ReBoot SA’s website. 9.4.1 Give TWO advantages of an online form compared to a paper form. (2) 9.4.2 Name TWO types of controls that can be used in an electronic form to make it easier to complete. (2) 9.5 ReBoot SA keeps a record of all the donations. 9.5.1 Name the most suitable type of chart to compare the mass of e-waste collected in each month. (1) 9.5.2 Give TWO reasons why a database is more suitable than a spreadsheet to store the details of thousands of devices. (2) 9.6 The workshop computers are protected by a firewall and an antivirus program. 9.6.1 Explain what a firewall does. (2) 9.6.2 Give ONE reason why antivirus software must be updated regularly. (1) 9.7 Give TWO ways in which the work of ReBoot SA helps to reduce the digital divide. (2) [25] Copyright reserved Please turn over

Computer Applications Technology/P2 12 Hlayiso/Mock 2026 NSC Mock QUESTION 10: INTEGRATED SCENARIO Ayanda is a Grade 11 learner in Soweto. She started a small online business that sells handmade beadwork and cellphone covers. 10.1 Ayanda uses her smartphone to run the business. 10.1.1 Give TWO features of a smartphone that make it useful for running a small business. (2) 10.1.2 What is the general name for a program that is downloaded and installed on a smartphone from an online store? (1) 10.1.3 Give TWO ways in which Ayanda can make the battery of her smartphone last longer. (2) 10.2 Ayanda sells her products online. 10.2.1 Give TWO advantages of selling products online compared to selling them in a physical shop. (2) 10.2.2 Name TWO methods that customers can use to pay online. (2) 10.2.3 Explain why customers should check that a payment page uses HTTPS. (2) 10.3 Ayanda takes photos of her products to place on her web page. 10.3.1 Name ONE file format that is suitable for photos on a web page. (1) 10.3.2 Explain why the photos should be resized or compressed before they are uploaded to the web page. (2) 10.4 Ayanda advertises her products on social media. 10.4.1 Give TWO advantages of advertising on social media. (2) 10.4.2 Give ONE risk of posting personal information, such as a home address, on social media. (1) 10.5 Ayanda keeps a record of all her orders in a spreadsheet. 10.5.1 Name the function that she can use to find the highest order amount. (1) 10.5.2 Give ONE reason why she must make regular backups of the spreadsheet AND name ONE suitable backup medium. (2) 10.6 Ayanda received an e-mail that claimed that she had won a prize. The e-mail asked her to click on a link and enter her banking details. 10.6.1 Name this type of online scam. (1) 10.6.2 Give TWO signs that show that the e-mail is NOT genuine. (2) 10.7 Give TWO ways in which Ayanda can protect the personal information of her customers. (2) [25] TOTAL SECTION C: 50 GRAND TOTAL: 150 Copyright reserved