IT P2 GR11 MEMO NOV2020 ENG D

NATIONAL SENIOR CERTIFICATE GRADE 11 NOVEMBER 2020 INFORMATION TECHNOLOGY P 2 MARKING GUIDELINE MARKS: 150 This marking guideline consists of 13 pages.

2 INFORMATION TECHNOLOGY P2 (EC/NOVEMBER 2020) SECTION A: SHORT QUESTIONS QUESTION 1 1.1 1.1.1 B 9– (Low-level programming language) (1) 1.1.2 A 9– (0) (1) 1.1.3 A 9– (Process) (1) 1.1.4 B 9– (Data verification) (1) 1.1.5 C 9– (_Discount) (1) 1.1.6 B 9– (Data maintenance) (1) 1.1.7 B 9– (Modulation and Demodulation) (1) 1.1.8 C 9– (Machine code) (1) 1.1.9 A 9– (Acceptable Usage Policy) (1) 1.1.10 B 9– (Office automation) (1) 1.2 1.2.1 Data redundancy 9 (1) 1.2.2 Telecommuting 9 (1) 1.2.3 Anomaly/Anomalies 9 (1) 1.2.4 Constant 9 (1) 1.2.5 Jail breaking 9 (1) TOTAL SECTION A: 15 Copyright reserved Please turn over

(EC/NOVEMBER 2020) INFORMATION TECHNOLOGY P2 3 SECTION B: SYSTEM TECHNOLOGIES QUESTION 2 2.1 2.1.1 Dual Inline Memory Module / DIMM 9 (1) 2.1.2 Volatile memory 9 (1) 2.1.3 DIMM slots/RAM slots 9 (1) 2.1.4 32bit operating system can only see and use 4GB of memory. 9 (1) 2.1.5 Any ONE: 9 x Loads data and instructions (programs or applications) before the CPU can work with them. x Temporarily stores data and instructions (programs or applications) before the CPU can work with them. (1) 2.2 Any ONE: 99 Spec A x Windows 10 Pro – Operation system (OS) x Kaspersky – Utility software Spec B x Windows 10 Home – Operating system (OS) x ESET – Utility software (2) 2.3 2.3.1 8192 GB / 8GB 9 (1) 2.3.2 Double Data Rate 9 (1) 2.4 2.4.1 Intel CoreTM i7 9750H 9 (1) 2.4.2 Machine cycle 9 (1) 2.4.3 x Fetching the instructions and data from memory (RAM) 9 x Decoding the instructions 9 x Executing the instructions 9 x Transferring data back to the memory 9 (4) 2.5 2.5.1 x Built-in video/integrated adapter is used when doing normal tasks 9 because it uses much less power and battery life. x Video card is used by programs that require good graphics. 9 (2) 2.5.2 x Intel RX 5700XT 8GB 9 x NVDIA GTX 1660 4GB 9 (2) Copyright reserved Please turn over

4 INFORMATION TECHNOLOGY P2 (EC/NOVEMBER 2020) 2.6 x Compiler 9 takes the entire program and translates into machine language. 9 x Interpreter 9 runs one line of a program and the current line is converted into machine language. 9 (4) 2.7 2.7.1 HDMI is an audio/video interface for transferring uncompressed video data, 9 compressed or uncompressed digital audio from HDMI device to a computer monitor, video projector, digital TV or digital audio device. 9 (2) 2.7.2 High Definition Multimedia Interface 9 (1) TOTAL SECTION B: 26 Copyright reserved Please turn over

(EC/NOVEMBER 2020) INFORMATION TECHNOLOGY P2 5 SECTION C: COMMUNICATION AND NETWORK TECHNOLOGIES QUESTION 3 3.1 3.1.1 Computer network is a collection of computers or other computing devices connected by some sort of communication medium/channel to allow users to share software, hardware, data and information. 9 (1) 3.1.2 Any TWO: 99 x Fast and efficient communication x Sharing of hardware resources x Centralisation of data x Transfer of files x Leisure x Increased control and security x Flexible access (2) 3.1.3 Global Area Network (GAN) / World Wide Web (WWW) 9 (1) 3.2 3.2.1 (a) Wi-Fi 9 NIC (1) (b) 3G/4G/LTE/5G 9 (1) 3.2.2 (a) Wi-Fi 9 NIC (1) (b) Ethernet 9 port (1) 3.3 Wi-Fi access point sends and receives radio signals and allows devices to connect to a wired network wirelessly. 9 (1) 3.3.1 Base station 9 (1) 3.3.2 x Hotspot is an area, usually in a public space (such as airport, hotel lobby and restaurant etc), where people may be granted Wi-Fi access from access point to connect wirelessly to the Internet via a wired network. 9 x Bandwidth refers to the total amount of data that can be transferred from one point to another in a given period of time. 9 (2) 3.4 3.4.1 Any ONE: 9 x Skype x Google voice x Vonage x ooVoo x Viber x Facebook Messenger x Jitsi x MicoSIP x 8*8 x EkigaZoiPer (1) Copyright reserved Please turn over

6 INFORMATION TECHNOLOGY P2 (EC/NOVEMBER 2020) 3.4.2 Any TWO: 99 x The call quality may be poor if you have a slow Internet connection. x Your data cap can be used up quickly, especially when using video. x You need to purchase credits to call telephones that are not on the Internet. x You need to have an Internet connection and both users need to use the same software. (2) 3.5 3.5.1 x Lossy compression compresses data by losing some of the data / compresses data by sacrificing some insignificant or virtually indetectable portion of the data. 9 x Lossless compression compresses data without losing any portion of the data. 9 (2) 3.5.2 Lossy compression (Any ONE): 9 x Audio x Video x Still images Lossless compression (Any ONE): 9 x Documents x Spreadsheet x Databases (2) 3.6 3.6.1 x Fixed location Internet access 9 refers to high speed data transmission to homes and businesses using cabled technology. 9 x Mobile Internet access 9 refers to the ability to connect to the Internet using wireless networks such as cellular phone network. 9 (4) 3.6.2 Fixed Location Internet Access x ADSL 9 Mobile Internet access (Any ONE): 9 x 3G x 4G/LTE x 5G (2) TOTAL SECTION C: 25 Copyright reserved Please turn over

(EC/NOVEMBER 2020) INFORMATION TECHNOLOGY P2 7 SECTION D: DATA AND INFORMATION MANAGEMENT QUESTION 4 4.1 4.1.1 DBMS is a software that allows you to work with electronic databases. 9 (1) 4.1.2 Any THREE: 999 x Creates database x Edits the structure of the database x Adds, edits and deletes data in the database x Queries or searches the data in the database x Processes the data in the database to extract information (3) 4.1.3 Bigtable 9 (1) 4.2 4.2.1 Any THREE: 999 x Format check x Data type check x Range check x Presence check x Check digit (3) 4.2.2 x Accurate and without errors 9 x Verifiable 9 x Timely information 9 (3) 4.3 4.3.1 tblStudent tblStudentTransactions 19 PK 9 StudentID PK 9 TransactionID ∞/m 9 FirstName FK 9 StudentID LastName PostDate Address Amount City Description PostalCode DateAdmitted Major Photo (5) 4.3.2 Composite keys refer to the combination of more than one field to uniquely identify a record. 9 Primary key is a field which identifies each record with a unique value. 9 (2) Copyright reserved Please turn over

8 INFORMATION TECHNOLOGY P2 (EC/NOVEMBER 2020) 4.4 Any THREE: 999 x Manages and maintains databases x Controls the allocation and supervision of users of the database and their access rights x Performs routine maintenance on the database x Ensures the DB software is updated regularly x Implementing a good backup policy x Installing and configuring software on additional servers x Ensuring systems have enough storage and memory (3) TOTAL SECTION D: 21 Copyright reserved Please turn over

(EC/NOVEMBER 2020) INFORMATION TECHNOLOGY P2 9 SECTION E: SOLUTION DEVELOPMENT QUESTION 5 5.1 5.1.1 American Standard Code for Information Interchange / ASCII 9 (1) 5.1.2 CSV/Comma elimited 9 (1) 5.1.3 (a) AssignFile(txtStock, ‘Goods.txt) – Links file variable (txtStock) to the file on the disk (Goods.txt). 9 (1) (b) Append(txtStock) – opens an existing file to write to, 9 the file pointer is positioned at the end of the file and the new data is added to the end of the file. 9 (2) 5.2 Step-and-Watch 9 (1) 5.3 Data persistence refers to the ability of data to be retrieved and used more than once after it has been saved. 9 (1) 5.4 5.4.1 Format function is used to convert the real values to strings of equal length, 9 with leading spaces added. (1) 5.4.2 (a) x % – this indicates that the text which follows is formatting instructions and not normal text 9 x 10 – shows that the final string must contain 10 characters 9 x 2 – shows that the final string must contain 2 decimal points/ values 9 x f – shows that the value being passed in the second parameter is a floating-point value 9 x rWeight – holds the information that needs to be converted into a formatted string 9 (5) (b) m, 9 monetary 9 (2) 5.5 x Selection sort is a sorting algorithm that uses two For loops to sort a list, by moving the smallest or largest element to the top of the list. 9 x Bubble sort is a sorting algorithm that bubbles the smallest or largest element to the bottom of the list by using Boolean flag and a For loop. 9 (2) Copyright reserved Please turn over

10 INFORMATION TECHNOLOGY P2 (EC/NOVEMBER 2020) 5.6 Line No Value1 Value2 Value3 Value4 Screen Output 1 10 9 2 59 3 79 4 10.6 9 5 29 6 59 7 59 8 29 9 10 9 10 10.6 9 (5) 5.7 x Readln will read a line of text from the file buffer/variable text file and place it into the string variable. 9 x Writeln will write a line of text to the buffer area/variable text file 9 and add an EOLn character to the line of text. (2) TOTAL SECTION D: 24 Copyright reserved Please turn over

(EC/NOVEMBER 2020) INFORMATION TECHNOLOGY P2 11 SECTION F: INTEGRATED SCENARIO QUESTION 6 6.1 6.1.1 Ant THREE examples: 999 x Better record keeping or data storage and management x Better communication and virtual presence x Automation x Artificial Intelligence and sensor driven computing (3) 6.1.2 Any TWO: 99 x Musicians now record an album with greater ease and lower cost than ever before. x Well-known musicians have released albums created entirely on iPads. x Musicians distribute their work directly without the aid of a studio. x IT gives them many ways to market themselves. x Customers can buy/ download music via Internet. (2) 6.1.3 x Workplace – is wherever work takes place/any place where people work. 9 x Employment practices – refer to how people are employed, 9 for how long, how they are paid, where and when they are expected to work. (2) 6.1.4 Outsourcing occurs when contracting a specialist business to run aspects of your own business that are essential for proper functioning, 9 but that do not fall within your area of expertise. 9 (2) 6.2 6.2.1 Settings in server operating system 9 (1) 6.2.2 Any THREE aspects: 999 x A code of conduct educating users and governing their behaviour when using the network and the Internet. x Details on when and where portable storage devices such as flash disks and portable media players may be used. x Details of restrictions about installing any hardware or software. x Procedures to follow if users become the victims of identity theft, malware, cyber bullying and/or cyber stalking. x Hints on how to avoid plagiarism and breaking copyright law. x Clear consequences of violating conditions spelt out in the AUP. (3) 6.2.3 Restrictions 9 (1) Copyright reserved Please turn over

12 INFORMATION TECHNOLOGY P2 (EC/NOVEMBER 2020) 6.3 6.3.1 Any THREE: 999 x Better communication x More efficient administration x Census and statistics x Elections x Weather services and predictions (3) 6.3.2 Any THREE: 999 x Insufficient knowledge of and exposure to ICT. x ICT exposes them to risks that they cannot manage. x Abuse of ICT by criminal elements through activities such as hacking, cybercrime. x Malware increases people’s fear of ICT and limits implementation and adoption of ICT projects. (3) 6.4 6.4.1 Globalisation is the integration of economies, cultures, ideas and groups across the globe 9 driven by a world-wide network of communication, transport, trade and immigration. 9 OR Globalisation is a process of connection, interaction and integration among people, companies, and governments. 99 (2) 6.4.2 Any THREE: 999 x An efficient market where there is an equilibrium between what buyers are willing to pay for a good or service and what sellers are willing to sell a good or service for. x Increased competition between companies which improves the service and quality of goods or services delivered to the consumers. x Security as countries’ economies are intertwined and dependent on each other. x Wealth equality throughout the world as poorer nations have more job opportunities. (3) 6.4.3 x Agricultural sector: 9 AI-powered machine vision systems can measure crop populations and detect weeds or plant pests and use robotic sprayers to precisely apply herbicides. 9 x Healthcare sector: 9 Precision medicine helps doctors analyse a patient’s genome sequence, medical history, and lifestyle, making a diagnosis more reliable. 9 (4) 6.5 6.5.1 Any THREE: 999 x Accidentally deleting files or reformatting a disk. x Not ensuring that regular backups are made. x Entering incorrect data in a program. x Losing or misplacing portable storage devices. x Allowing other unauthorised users to get access to data by not following security principles (such as having secure password and changing it on a regular basis.) (3) Copyright reserved Please turn over

(EC/NOVEMBER 2020) INFORMATION TECHNOLOGY P2 13 6.5.2 Any THREE: 999 x You need to back up data. x Automate or schedule the running of the backup software so that you do not forget to run the backup process. x Back up your files on an external storage device such as portable hard drive. x Keep the backups off-site in case of theft or a disaster such as fire. x Perform housekeeping so that you do not have multiple copies or versions of the same files on your computer. x Consider archiving large files that you seldom use by moving them off your computer to an external hard drive. x Check from time to time that the backups are actually working by restoring some of the files from backups. (3) 6.6 Any THREE: 999 x Minimising user input x Format checks x Data type checks x Range checks x Presence check (3) 6.7 Mandatory fields are specific fields that are compulsory and need to be filled in. 9 (1) TOTAL SECTION F: 39 GRAND TOTAL: 150 Copyright reserved Please turn over