Information Technology Grade 12 P2 WC Prelim 2020 QP (Eng)

Downloaded from hlayiso.com SCHOOL NAME GRADE 12 - INFORMATION TECHNOLOGY PAPER 2 (THEORY) September 2020 Time: 3 Hours – Marks 150 This question paper consists of 17 pages.

Downloaded from hlayiso.com INFORMATION TECHNOLOGY PAPER 2 – GRADE 12 (September 2020) Page 2 of 17 INSTRUCTIONS AND INFORMATION 1. This question paper consists of SIX sections: SECTION A: Short Questions (15) SECTION B: Systems Technologies (25) SECTION C: Communication and Network Technologies (25) SECTION D: Data and Information Management (25) SECTION E: Solution Development (25) SECTION F: Integrated Scenario (35) 2. Read ALL the questions carefully. 3. Answer ALL the questions. 4. The mark allocation generally gives an indication of the number of facts/reasons required. 5. Number the answers correctly according to the numbering system used in this question paper. 6. Write neatly and legibly.

Downloaded from hlayiso.com INFORMATION TECHNOLOGY PAPER 2 – GRADE 12 (September 2020) Page 3 of 17 SECTION A: SHORT QUESTIONS QUESTION 1.1: MULTIPLE CHOICE QUESTIONS Various possible options are provided as answers to the following questions. Choose the most correct answer and write only the letter (A – D) CLEARLY next to the question number (1.1.1 – 1.1.5) on your ANSWER paper. Example: 1.1.6 D MAKE SURE THAT YOUR LETTERS ARE CLEAR AND LEGIBLE 1.1.1 This technology superimposes a computer-generated image on a user's view of the real world, thus providing a composite view. A. Cloud computing B. Virtual reality C. Augmented reality D. Virtualisation (1) 1.1.2 In order to continue working from home during the Covid-19 pandemic, but still be able to access the files and hardware devices, such as printers, that are available on your school network, you need to make use of … A. Google Meet. B. a VPN. C. Zoom. D. DropBox. (1) 1.1.3 A hacking technique where SQL statements are typed into an input field in order to access data such a usernames and passwords. A. SQL queries B. Data mining C. Integrity checking D. SQL injection (1) 1.1.4 RAID … A. is a technology used to enable a server to continue running in the event that some part of the server’s storage becomes corrupted or fails. B. stands for Re-Usable Array of Independent Drives. C. is an operating system. D. is used to prevent access to a LAN if a hacker tries to break into the system. (1)

Downloaded from hlayiso.com INFORMATION TECHNOLOGY PAPER 2 – GRADE 12 (September 2020) Page 4 of 17 1.1.5 The following Delphi code is supposed to print a list of uneven integers from 19 to 1: 1 var 2 I: Integer; 3 sLine: String; 4 begin 5 sLine := ''; 6 for I := 20 downto 1 do 7 begin 8 Inc(I,-1); 9 sLine := sLine + IntToStr(I) + ' '; 10 end; 11 ShowMessage(sLine); 12 end; However, the code contains an error that will keep it from compiling. Identify the correct reason for the error. A. Line 3: sLine needs to be declared as a global variable in order to store all the values from 19 to 1. Currently sLine will only store the final value of 1. B. Line 6: The keyword downto must be written as two words: down to. C. Line 8: The Inc() procedure contains too many parameters. Use the Dec() procedure instead. D. Line 8: The value of the control variable (I) may not change inside the For loop. (1)

Downloaded from hlayiso.com INFORMATION TECHNOLOGY PAPER 2 – GRADE 12 (September 2020) Page 5 of 17 QUESTION 1.2: SHORT QUESTIONS Give ONE word/term for each of the following descriptions. Write down only the word/term next to the question number (1.2.1 – 1.2.10) on your ANSWER paper. 1.2.1 A hardware device, consisting essentially of a constantly charged battery between the computer and the wall plug, to protect against power outages. (1) 1.2.2 An electronic document, issued by a trusted third party, used to authenticate the identity of a person/organisation/website. (1) 1.2.3 A data capture technology that stores more data than barcodes and uses radio waves to identify objects. (1) 1.2.4 A logical error that occurs when the computer program attempts to handle a number that is too large for the variable type. (1) 1.2.5 A device that connects networked devices on the same network in order to communicate. (1) 1.2.6 A thin rectangular electronic board on the motherboard that contains banks of RAM chips. (1) 1.2.7 An upgraded version of Wi-Fi, that allows for more secure transfer of data over greater distances. (1) 1.2.8 The standard language used to query and manipulate data in a database. (1) 1.2.9 A technique used by the operating system to increase the capacity of the RAM by creating a temporary or dedicated file on the hard disk drive. (1) 1.2.10 A copyright licence that allows one to use parts of, copy and distribute work for non-profit purposes. (1) TOTAL SECTION A: 15

Downloaded from hlayiso.com INFORMATION TECHNOLOGY PAPER 2 – GRADE 12 (September 2020) Page 6 of 17 SECTION B – SYSTEM TECHNOLOGIES QUESTION 2 – HARDWARE AND SOFTWARE Technology in education is the biggest change in teaching we will ever see. For years, policy makers, teachers, parents, and students alike have been weighing the potential benefits of technology in education against its risks and consequences. But now the debate is more pressing than ever, as curricula increasingly incorporate technology and teachers experiment with new teaching methods…on one hand, technology allows you to experiment and on the other hand, some argue technology in the classroom can be distracting and even foster cheating. (Extract taken from www.tophat.com) 2.1 When buying a new device, the devices’ performance is very important. One aspect that will enhance performance is caching. 2.1.1 Explain the general purpose of caching. (2) 2.1.2 There are three important forms of caching. Name ONE and briefly explain how it enhances the performance of a device. (3) 2.2 To be able to access technology at school you will need a mobile device. 2.2.1 Except for mobility, give TWO other reasons why mobile devices may be preferred to desktop computers. (2) 2.2.2 State TWO factors that might limit your use of a mobile device in class. (2) 2.3 A new trend in technology is the use of SaaS. 2.3.1 What does SaaS refer to? (3) 2.3.2 Give TWO reasons for using SaaS instead of standard mobile software. (2) 2.4 Connecting your device to the network at school may put your device at risk. To ensure the safety of your data, you can make regular back-ups. Explain the difference between making a backup and archiving your data. (4) 2.5 Virtualisation refers to the process of creating a virtual version of something, including virtual computers.

Downloaded from hlayiso.com INFORMATION TECHNOLOGY PAPER 2 – GRADE 12 (September 2020) Page 7 of 17 2.5.1 List TWO advantages of virtualisation. (2) 2.5.2 Give ONE example of virtualization software. (1) 2.6 Modern computers have CPUs that can perform multitasking, multithreading and multiprocessing. Explain TWO of these processing techniques. (4) TOTAL SECTION B: 25

Downloaded from hlayiso.com INFORMATION TECHNOLOGY PAPER 2 – GRADE 12 (September 2020) Page 8 of 17 SECTION C: COMMUNICATION AND NETWORK TECHNOLOGIES QUESTION 3 3.1 Almost every existing computer is connected to a network in some way. However, connecting to a network is not always advantageous. Give TWO disadvantages of connecting a computer to a network. (2) 3.2 A learner who uses a laptop in class can connect to the network by using a wired or a wireless connection. In both cases, a NIC is required. 3.2.1 What is the purpose of the NIC (Network Interface Controller / Card)? (2) 3.2.2 What medium is used to send data… (a) in a Wireless network. (1) (b) from one continent to another. (1) 3.3 Examine the network shown in the diagram below and answer the questions that follow. Internet Router Server Switch PC PC

Downloaded from hlayiso.com INFORMATION TECHNOLOGY PAPER 2 – GRADE 12 (September 2020) Page 9 of 17 3.3.1 Would you regard the network shown above to be a PAN, LAN, or MAN? Justify your answer. (2) 3.3.2 Would you classify the router in the diagram as an all-in-one device? Give a reason for your answer. (2) 3.3.3 What type of cables are usually used between the PCs and the switch? (1) 3.3.4 You are told that both PCs connected to the switch are thin clients. Briefly explain what this means. (2) 3.3.5 The users of the PCs referred to in 3.3.4 are engineers and want to store large CAD files for later use. Briefly describe TWO options that would be open to them, considering the structure of the network shown to you in the diagram. (2) 3.4 A major use of a network is to facilitate the sharing of data. Within the network, an administrator ensures that this happens responsibly. 3.4.1 One job of a network administrator is to allocate permissions to users (or groups of users) and to control access to files and folders. Name ONE type of permission that can be granted, and briefly explain what the permission does. (2) 3.4.2 Give ONE other job of a network administrator. (1) 3.5 Files can be shared across the internet by making them downloadable from a website. This can cause a lot of traffic problems for that website. An alternative solution is to make use of BitTorrent. 3.5.1 Define BitTorrent. (1) 3.5.2 Briefly describe TWO internet-related risks that you run when you use BitTorrent. (2) 3.6 In order to protect digital data, encryption can be used. 3.6.1 With regard to encryption, describe what SSL (Secure Socket Layer) is? (1) 3.6.2 Financial institutions, such as banks, use public key encryption to transmit data securely. Briefly describe the process of public key encryption. (3) TOTAL SECTION C: 25

Downloaded from hlayiso.com INFORMATION TECHNOLOGY PAPER 2 – GRADE 12 (September 2020) Page 10 of 17 SECTION D: DATA AND INFORMATION MANAGEMENT QUESTION 4 Gio's Garden Supplies is a successful family business specialising in the supply of garden tools, general gardening materials and fertilisers to garden centres and hardware stores throughout the country. Their business database is in need of redesign. They are very disappointed that the original developer has produced a badly designed database that clearly is not working properly. 4.1 The database currently has two tables as shown below. It is meant to be used to show which items each customer has ordered from Gio's Garden Supplies. tblClient: AccNo Business Address Order Item Quantity Item Quantity Item Quantity Name Date 1 1 2 2 3 3 10021 Busy 7 Begonia 01/06/ FER 30 TOO 5 Plants Street, 2020 001 202 George, 6530 20152 Heavy 8 Industrial 02/06/ TOO 3 FER 15 FER 10 Hardware Park, Smith 2020 101 001 002 Str, Gordons Bay, 7150 10021 Busy 7 Begonia 02/06/ TOO 2 Plants Street, 2020 202 George, 6530 tblStock: ItemCode Description CostPrice SellingPrice QuantityInStock FER001 Super Compost 10kg R 22.50 R 25.89 124 TOO101 Spade garden large R 180.00 R 210.00 23 4.1.1 The database has clearly not been normalised. Explain what is meant by the normalisation of a database. (2)

Downloaded from hlayiso.com INFORMATION TECHNOLOGY PAPER 2 – GRADE 12 (September 2020) Page 11 of 17 4.1.2 There are several design issues with the tblClient table that are going to cause anomalies when this database is being used. (a) Explain what is meant by the term anomaly. (1) (b) Name TWO anomalies that might occur when using the tblClient table AND EXPLAIN what is meant by each anomaly using an example of each to support your explanation. Use information from this table in your example. (4) (c) There is a design issue specific to the Address field in the tblClient table. Explain what it is and how it can be resolved. (2) 4.1.3 The ItemCode field is the primary key field in the tblStock table. Explain what is meant by the term primary key. (2) 4.1.4 The Order Date in the tblClient table will require validation when it is entered. Name the type of validation that needs to be done AND explain why it will be necessary. (2) 4.1.5 The validation measure discussed above will help to ensure the logical integrity of this database. Explain what is meant by the term logical integrity. (1) 4.1.6 Validation may not be necessary if direct data capturing techniques such as RFID are used. Give a practical example of how Gio's Garden Supplies can use RFID to better manage their stock. (2) 4.1.7 You need to redesign this database in order to normalise it. To do so you will need to add a third table. Draw a diagram to show the three tables and how they will be related to each other. Pay attention to the following: • Clearly show the name of each table. Example table: • Draw the tables showing the field names tblStock only – use the example on the right as a guide. Note that this shows the current PK/FK Field name design of the tblStock table and is only meant as a guide. ItemCode • Base your design on the original tables as Description shown on the previous page. • Clearly show the primary and foreign keys CostPrice in each table where appropriate. • Clearly indicate the relationships between SellingPrice the tables. QuantityInStock (7)

Downloaded from hlayiso.com INFORMATION TECHNOLOGY PAPER 2 – GRADE 12 (September 2020) Page 12 of 17 4.2 Gio's Garden Supplies runs their business from a small warehouse and an office where two staff members process the orders through the database using two computers. 4.2.1 Is a desktop database or a server-based database the best option for this business? (1) 4.2.2 Provide a reason for your answer to 4.2.1. (1) TOTAL SECTION D: 25

Downloaded from hlayiso.com INFORMATION TECHNOLOGY PAPER 2 – GRADE 12 (September 2020) Page 13 of 17 SECTION E: SOLUTION DEVELOPMENT QUESTION 5: ALGORITHMS AND PLANNING The National Parks Board uses the interface below as a booking form for Hikers that want to book a hiking excursion. The different types of available hikes can be categorised as '3-day', '7-day' and 'same-day'. 5.1 Numbers 1–3 indicate edit boxes for data input. NOTE: In questions 5.1.1 - 5.1.3 you are not allowed to reuse the same component for more than one answer. 5.1.1 Indicate a more appropriate input component to ensure that valid data is entered in section 1. (1) 5.1.2 Indicate a more appropriate input component to ensure that valid data is entered in section 2. (1) 5.1.3 Indicate a more appropriate input component to ensure that valid data is entered in section 3. (1)

Downloaded from hlayiso.com INFORMATION TECHNOLOGY PAPER 2 – GRADE 12 (September 2020) Page 14 of 17 5.2 Hikers can log in on the Parks Board’s website or portal to access information and book hiking trails. Below is an incomplete class diagram for an object class that was created to record information to a website. Hiking - fHikingType (String) - fTotalDue (integer) - fStartDate (double) - fEndDate (double) - fNumAdults (integer) - fNumChildren (integer) + constructor(HikingType, numAdults, numChildren, startDate, endDate) - calcTotalDue() + toString() 5.2.1 Motivate why it is NOT necessary to have the field fTotalDue as an attribute of the class. (1) 5.2.2 Explain the purpose of a toString method. (2) 5.2.3 An object's attributes should be encapsulated. Define the term encapsulation. (2) 5.2.4 Identify whether the method calcTotalDue() is a function or a procedure. (1) 5.2.5 Define a method that can be added to the class diagram that receives a parameter and changes the HikingType attribute. (2) 5.3 Answer the questions below on general aspects and concepts related to programming. 5.3.1 Explain what is meant by the term logical error. (2) 5.3.2 Explain what is meant by debugging a program. (2)

Downloaded from hlayiso.com INFORMATION TECHNOLOGY PAPER 2 – GRADE 12 (September 2020) Page 15 of 17 5.3.3 Looping is a common programming structure. Redraw the table below and compare a WHILE…DO loop and a REPEAT…UNTIL loop based on the following features: FEATURE WHILE...DO REPEAT…UNTIL Structure Probability of execution (2) 5.4 The athlete numbers of at least 1 000 long distance athletes are stored in an array called arrAthleteNum. The final position of the athletes in a race are stored in a parallel array called arrRacePosition. Example of the first seven athlete numbers and positions in the respective arrays: arrAthleteNum arrRacePosition A00100 872 A00101 231 A00102 187 A00103 648 A00104 52 A00105 210 A00106 15 The following Delphi code was used to enter an athlete number and update the athlete's race position: 1 sAthlete := edtAthletenumber.text; 2 for K := 1 to Length(arrAthleteNum) do 3 if arrAthleteNum[K] = sAthlete then 4 arrRacePosition[K] := 5 StrToInt(InputBox('Update position', 6 'Enter new position for athlete', '0')); Write pseudo code that uses a more effective search technique that will terminate the search process when the update has been done or when the end of the array is reached. NOTE: Marks will be deducted if Delphi code is given in your solution. (8) TOTAL SECTION E: 25

Downloaded from hlayiso.com INFORMATION TECHNOLOGY PAPER 2 – GRADE 12 (September 2020) Page 16 of 17 SECTION F: INTEGRATED SCENARIO QUESTION 6 In times of pandemics, like the current outbreak of Covid-19, there are strict rules imposed on the citizens of our country to stem the tide of the pandemic: social distancing, the wearing of masks, and reduced attendance at schools and at the workplace. In times like these electronic communications are of the utmost importance. 6.1 A community worker wants the public to know all about his efforts and work in the community, so he created a page on Facebook. 6.1.1 Recommend TWO ways in which the community worker can maintain a good profile of his efforts in the community on Facebook. (2) 6.1.2 He discovers that there is a troll posting messages on the page. What is meant by a troll? (2) 6.1.3 The community worker entered all his personal details on the Facebook page including his name, phone number, email address and ID number. Explain why this was foolish of him by giving ONE way in which publishing his ID number and ONE way in which publishing his phone number could be used against him. (2) 6.1.4 Name another social media platform (other than Facebook) that the community worker could use and describe how it would be effective. (2) 6.2 Unfortunately, increased electronic communication leads to increased risks. With increased electronic communication computers can pick up malware. Name TWO examples of malware and outline the dangers they pose and how you could protect your computer against it. Draw a copy of the following table on your answer sheet and use it to tabulate your answers. Type of malware Danger of the Protection malware (6) 6.3 A company has asked all their employees to electronically work from home. 6.3.1 Name a type of job where this “working from home” can be implemented successfully. (1) 6.3.2 Give THREE things that have to be in place to make working from home successful. (3)

Downloaded from hlayiso.com INFORMATION TECHNOLOGY PAPER 2 – GRADE 12 (September 2020) Page 17 of 17 6.3.3 Give an example of a type of job where working from home is not an option. (1) 6.3.4 Many companies make it possible for workers to work from anywhere by accessing the company network using either a VPN connection or remote access software e.g. remote desktop. Which of the two options is safer? Give a reason for your answer. (2) 6.3.5 Some people might want to work from home using their mobile devices. (a) State TWO disadvantages of using mobile devices for this purpose. (2) (b) Suggest TWO ways in which the battery life of mobile devices can be improved. (2) 6.3.6 Monday morning usually starts with a staff meeting. As most people are working from home this is a virtual staff meeting. (a) Name ONE such program for virtual meetings. (1) (b) Name THREE hardware requirements needed for such a virtual meeting. (3) (c) Name ONE advantage of having such a virtual meeting rather than a teleconference. (1) (d) Name TWO other advantages of having virtual meetings. (2) (e) In which way can virtual meetings be abused by outsiders? (2) 6.3.7 Many managers/companies have concerns when their employees work from home. Name ONE such concern. (1) TOTAL SECTION F: 35 EXAM PAPER TOTAL: 150