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 storage media is an optical disc? A Flash drive B Blu-ray disc C Solid-state drive D Memory card (1) 1.2 The specification of a monitor that indicates how many times per second the image on the screen is redrawn: A Resolution B Contrast ratio C Refresh rate D Aspect ratio (1) 1.3 Software of which the source code is made available so that users may study, change and distribute it: A Freeware B Shareware C Open-source software D Proprietary software (1) 1.4 The type of network that is created when a smartwatch is connected to a cellphone: A WAN B PAN C LAN D MAN (1) 1.5 The process of converting data into a code so that unauthorised people cannot read it: A Encryption B Compression C Authentication D Validation (1) 1.6 A small program that allows the operating system to communicate with a specific hardware device: A Driver B Utility C Plug-in D Macro (1) Copyright reserved Please turn over

Computer Applications Technology/P2 4 Hlayiso/Mock 2026 NSC Mock 1.7 The database field property that limits the number of characters that can be entered in a Short Text field: A Format B Field size C Default value D Caption (1) 1.8 Which ONE of the following is NOT an input device? A Scanner B Webcam C Data projector D Microphone (1) 1.9 The type of tab stop that lines up a column of numbers such as 12.5, 104.25 and 7.75 on the decimal point: A Left tab B Centre tab C Right tab D Decimal tab (1) 1.10 The spreadsheet feature that automatically changes the colour of a cell when its value meets a certain condition: A Data validation B AutoFill C Freeze panes D Conditional formatting (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 A device that connects the computers in a LAN A podcast and sends data only to the computer for which it is intended B router 2.2 Memory that keeps its contents when the C #DIV/0! computer is switched off and contains the start-up instructions D archiving 2.3 A company that provides individuals and E RAM businesses with access to the internet F firmware 2.4 A website that is updated regularly with entries G AUP (posts), with the newest entry shown first H switch 2.5 Rearranging the parts of files on a hard drive so I blog that each file is stored in one continuous area J #### 2.6 Moving files that are seldom used to another K compression storage medium for long-term storage L ROM 2.7 Presenting another person’s work or ideas as M EULA your own N plagiarism 2.8 A document that sets out the rules for using an O wiki organisation’s computers and network P ISP 2.9 What a spreadsheet displays when a column is Q backup too narrow to show a number R defragmentation 2.10 A legal agreement between the software S shareware developer and the user that sets out how the software may be used T copyright (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 The data on a DVD is read by means of a laser. (1) 3.2 Bluetooth is used to connect devices wirelessly over short distances. (1) 3.3 A web browser is a website that searches an index of web pages for the keywords that a user types in. (1) 3.4 Spyware is software that displays unwanted advertisements, such as pop-ups, on a user’s screen. (1) 3.5 In a database table, a record is a single item of data, such as a learner’s surname. (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 A processor is described as a quad-core 3.2 GHz processor. Explain what quad-core AND 3.2 GHz indicate. (2) 4.2 Give TWO advantages of a desktop computer compared to a laptop computer, other than cost. (2) 4.3 A school must choose between the two monitors below for its design room. Specification Monitor A Monitor B Screen size 24” 27” Resolution 1 920 x 1 080 2 560 x 1 440 Refresh rate 75 Hz 144 Hz Response time 5 ms 1 ms Ports HDMI, VGA HDMI, DisplayPort 4.3.1 Which monitor will display the sharper, more detailed image? Motivate your answer. (2) 4.3.2 What does a refresh rate of 144 Hz mean? (1) 4.3.3 Give TWO reasons why the HDMI port should be used rather than the VGA port to connect Monitor A. (2) 4.4 The hard disk drive (HDD) of an old computer is replaced with a solid-state drive (SSD). Give TWO advantages of an SSD compared to an HDD. (2) 4.5 State the main purpose of a UPS AND explain why a UPS that can power a computer for only 10 minutes is still useful during load-shedding. (2) 4.6 Give TWO reasons why software updates and patches should be installed regularly. (2) 4.7 When Sipho installs an office suite, he chooses the custom installation option instead of the typical option. Give ONE reason why he would do this. (1) 4.8 What is meant by multitasking in an operating system? (1) 4.9 Explain why an SSD should NOT be defragmented. (2) 4.10 Ravi has the following files in a folder: report.pdf, budget.xlsx, logo.png and intro.mp4. 4.10.1 Which file contains a video? (1) 4.10.2 Which file can be opened and edited in a spreadsheet program? (1) 4.11 Why is RAM described as volatile memory? (1) 4.12 A printer is advertised as: 30 ppm, 1 200 x 1 200 dpi, automatic duplex printing. 4.12.1 What does 30 ppm mean? (1) 4.12.2 Give ONE advantage of duplex printing. (1) 4.12.3 Name the type of printer that is best suited to print large volumes of black-and-white documents. (1) [25] Copyright reserved Please turn over

Computer Applications Technology/P2 8 Hlayiso/Mock 2026 NSC Mock QUESTION 5: INTERNET AND NETWORK TECHNOLOGIES Zanele’s family wants to install an internet connection at home. 5.1 Give TWO factors, other than cost, that the family should consider when they choose an internet connection. (2) 5.2 Explain the difference between a capped and an uncapped internet connection. (2) 5.3 Zanele’s video call keeps freezing in the evenings while her brothers stream movies. Explain why this happens. (2) 5.4 Zanele wants to e-mail a 30 MB video to her teacher. 5.4.1 Give ONE reason why the e-mail may NOT be delivered. (1) 5.4.2 Suggest ONE other way in which she can share the video with her teacher. (1) 5.5 Zanele sometimes uses a computer in the community library. Explain why she should clear the browser history and log out of all websites before she leaves. (2) 5.6 Give TWO ways in which a school can use a blog to communicate with parents. (2) 5.7 Why is the internet regarded as an example of a WAN? (1) 5.8 Name the device that connects the home network to the ISP’s network. (1) 5.9 Give ONE advantage of fibre-optic cable compared to UTP cable. (1) [15] QUESTION 6: INFORMATION MANAGEMENT Kamo is doing a research task (PAT) on how cellphone use at night affects the sleep of teenagers. 6.1 Explain the difference between primary data and secondary data. (2) 6.2 Kamo included the following two questions in his first draft of the questionnaire: Question 1: How old are you? □ 12–14 □ 14–16 □ 16–18 Question 2: Don’t you agree that cellphones are bad for teens? □ Yes □ No 6.2.1 Identify the problem with the options in Question 1. (1) 6.2.2 Rewrite Question 2 so that it is no longer a leading question. (1) 6.3 One question asks: Which apps do you use after 22:00? (Select ALL that apply.) Name the most suitable form control for this question. (1) 6.4 Give TWO criteria that Kamo can use to decide whether the information on a website is reliable. (2) 6.5 Kamo quotes a sentence from an online article. Name TWO details of the article that he must include in his reference list. (2) 6.6 Name the most suitable type of chart to show the percentage of teenagers in each of four sleep categories. (1) [10] Copyright reserved Please turn over

Computer Applications Technology/P2 9 Hlayiso/Mock 2026 NSC Mock QUESTION 7: SOCIAL IMPLICATIONS 7.1 A staff member receives a phone call from someone who pretends to work for the IT department and asks for her network password. 7.1.1 Name the general term for this type of technique in which people are tricked into giving away confidential information. (1) 7.1.2 Give ONE reason why this technique can succeed even when a network has a firewall and antivirus software. (1) 7.2 Give TWO signs that a computer may be infected with malware. (2) 7.3 Give TWO advantages of using a fingerprint scanner instead of a password to log on to a computer. (2) 7.4 Name ONE health problem that can be caused by looking at a screen for long periods AND give ONE way to prevent it. (2) 7.5 Explain why old computers and cellphones should NOT be thrown away with ordinary household rubbish. (2) [10] QUESTION 8: SOLUTION DEVELOPMENT 8.1 The spreadsheet extract below shows the sales at a school tuck shop on Market Day. Cell C4 is empty because the chips were not delivered. A B C D E 1 Item Price (R) Units sold Income (R) Stock 2 Muffin 8.50 120 1 020.00 3 Juice 12.00 95 1 140.00 4 Chips 7.00 0.00 5 Popcorn 5.50 140 770.00 6 Sandwich 18.00 640 #### 7 Total 8.1.1 Write down the formula that was entered in cell D2 to calculate the income from muffins. (1) 8.1.2 What value will be displayed if the function =COUNT(C2:C6) is entered in cell C7? (1) 8.1.3 Cell D6 displays ####. Explain why this happens AND how the problem can be solved. (2) 8.1.4 Write down a function that can be entered in cell D7 to calculate the total income. (1) 8.1.5 Write down a function for cell E2 that will display the word Reorder if more than 100 units were sold; otherwise the cell must remain empty. (3) 8.2 The tuck-shop committee creates a newsletter in a word processor. Copyright reserved Please turn over

Computer Applications Technology/P2 10 Hlayiso/Mock 2026 NSC Mock 8.2.1 Name the type of indent in which the first line of a paragraph starts further to the left than the other lines, as used in a reference list. (1) 8.2.2 Give ONE reason why tab stops, and not spaces, should be used to line up text in columns. (1) 8.2.3 The newsletter is set out in two columns. Name the feature that forces the text to continue at the top of the next column. (1) 8.2.4 The committee ran the spelling checker, but the sentence ”Collect you’re order form the office” was not flagged. Explain why the spelling checker did NOT detect these errors. (2) 8.3 Study the HTML code below and answer the questions that follow. <img src="tuckshop.png" width="200" alt="Tuck shop logo"> 8.3.1 State the purpose of the alt attribute. (1) 8.3.2 Name the HTML tag that is used to create a numbered (ordered) list. (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 Siyakhula Sports Club is a community soccer and netball club in Pietermaritzburg with 350 junior members. The club office has three desktop computers and a printer that are connected in a wired LAN. 9.1 The coaches want to connect their tablets to the office network. 9.1.1 Name the device that must be added to the network so that the tablets can connect wirelessly. (1) 9.1.2 Give TWO ways in which the club can protect the wireless network against unauthorised users. (2) 9.2 The coaches use tablets at training sessions. 9.2.1 Give TWO reasons why a tablet is more practical than a laptop for a coach at the side of the field. (2) 9.2.2 A coach’s tablet has 40 GB of free storage space. Each training video is 500 MB. Calculate how many complete videos can be stored. Show ALL calculations (use 1 GB = 1 024 MB). (2) 9.3 The club keeps the details of its members in a database. Study the extract from the table tblMembers below. MemberID Surname DateOfBirth Team FeesPaid Phone SSC0127 Dlamini 2012/03/14 U15 Yes 0821234567 SSC0128 Naidoo 2014/07/02 U13 No 0739876543 SSC0129 Dlamini 2010/11/23 U17 Yes 0614445566 9.3.1 Which field is the most suitable primary key? Motivate your answer. (2) 9.3.2 Name the most suitable data type for the FeesPaid field. (1) 9.3.3 Give ONE reason why the Phone field should be a Short Text field and NOT a Number field. (1) 9.3.4 Write down the criterion for the DateOfBirth field that will display ONLY the members who were born in 2012. (2) 9.3.5 Write down a validation rule for the Team field that will allow ONLY the values U13, U15 and U17. (2) 9.3.6 Give ONE reason why a report, rather than the table itself, should be used to print a list of members who still owe fees. (1) 9.4 The database is backed up every Friday onto an external hard drive that is kept on the secretary’s desk. 9.4.1 Explain why it is risky to keep the backup in the same office as the computer. (1) 9.4.2 Suggest a better way of keeping the backup safe. (1) 9.5 The secretary sends a newsletter by e-mail to 300 parents. Give TWO reasons why the addresses of the parents should be placed in the Bcc field. (2) 9.6 The club shares match results and photos of junior players on its social networking page. 9.6.1 Give TWO risks of posting photos of children on social media. (2) 9.6.2 Give ONE thing that the club should do before it posts a photo of a player. (1) Copyright reserved Please turn over

Computer Applications Technology/P2 12 Hlayiso/Mock 2026 NSC Mock 9.7 Volunteers also use the office computers. Give TWO rules that should be included in the club’s acceptable use policy (AUP). (2) [25] QUESTION 10: INTEGRATED SCENARIO Mr and Mrs Ngcobo run Amatola View, a small guesthouse in Hogsback in the Eastern Cape. 10.1 Guests receive free Wi-Fi, but the signal is weak in the cottages furthest from the main house. Suggest ONE hardware solution for this problem. (1) 10.2 Explain why the guests should NOT be connected to the same network as the office computer that stores the guesthouse’s records. (2) 10.3 Guests book and pay for their stay on the guesthouse’s website. 10.3.1 Give TWO advantages for the guesthouse of an online booking system. (2) 10.3.2 The booking form uses a date picker for the arrival date. Give ONE reason why this is better than letting guests type the date. (1) 10.3.3 The invoice that is e-mailed to guests is saved as a PDF file. Give ONE reason for using the PDF format. (1) 10.4 Mr Ngcobo is moving his bookings from a spreadsheet to a database that contains the table tblBookings. Name ONE other table that the database should contain AND the field that will link this table to tblBookings. (2) 10.5 Guests can pay by tapping their bank card on a card machine. Name the wireless technology that makes this possible. (1) 10.6 The security cameras save their video footage to cloud storage. 10.6.1 Give TWO advantages of saving the footage in the cloud rather than on a hard drive in the office. (2) 10.6.2 Give ONE disadvantage of saving the footage in the cloud. (1) 10.7 One morning the office computer displayed a message that all the files had been locked and that money must be paid to unlock them. 10.7.1 Name this type of malware. (1) 10.7.2 Give TWO measures that could have prevented this attack or reduced the damage. (2) 10.8 A guest with poor eyesight wants to use the computer in the guest lounge. Name TWO features or devices that will help him to use the computer. (2) 10.9 Guests post reviews of the guesthouse on travel websites. Give TWO ways in which the guesthouse can use these online reviews to benefit its business. (2) 10.10 Mr Ngcobo wants to buy a new laptop and compares the following two laptops: Laptop X Laptop Y Dual-core 2.0 GHz processor Octa-core 3.4 GHz processor 4 GB RAM 16 GB RAM 1 TB HDD (5 400 rpm) 256 GB SSD 10.10.1 Laptop Y will start up and open programs faster. Give TWO reasons for this, with reference to the specifications. (2) 10.10.2 Give ONE situation in which Laptop X would be the better choice. (1) 10.11 Mr Ngcobo wants to give guests live video tours of the cottages. Name TWO hardware devices that his laptop must have for a video call. (2) [25] TOTAL SECTION C: 50 GRAND TOTAL: 150 Copyright reserved