Computer Applications Technology Grade 12 P2 2019 QP (Eng)

NATIONAL SENIOR CERTIFICATE GRADE 12 SEPTEMBER 2019 COMPUTER APPLICATIONS TECHNOLOGY P2 MARKS: 150 TIME: 3 hours *catne2* This question paper consists of 17 pages.

2 COMPUTER APPLICATIONS TECHNOLOGY P2 (EC/SEPTEMBER 2019) INSTRUCTIONS AND INFORMATION 1. This question paper consists of: SECTION A (25 marks) SECTION B (75 marks) SECTION C (50 marks) 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. 6. Leave a line after EACH subquestion. 7. In general, ONE mark is allocated per fact. A 2-mark question would therefore require TWO facts, et cetera. 8. Write neatly and legibly. Copyright reserved Please turn over

(EC/SEPTEMBER 2019) COMPUTER APPLICATIONS TECHNOLOGY P2 3 SECTION A QUESTION 1: MULTIPLE-CHOICE QUESTIONS Various options are provided as possible answers to the following questions. Choose the answer and write only the letter (A–D) next to the question number (1.1– 1.10) in the ANSWER BOOK, for example 1.11 D. 1.1 Which ONE of the following is NOT web-based software? A Adobe Photoshop Express B Office 365 C Linux D Google Calendar (1) 1.2 Which ONE of the following is an example of a monitor’s refresh rate? A 5 ms B 1920 x 1080 C 16:9 D 60 Hz (1) 1.3 Cloud storage refers to ... A shared data storage on a central server usually managed by a hosting company. B store and control by a single person over the internet. C software that allows access to files without an internet connection. D faster uploading of data. (1) 1.4 How do solid-state drives store data as compared to traditional hard drives? A Optical B Electronic C Magnetic D Digital (1) 1.5 Which ONE of the following statements about a URL shortener is FALSE? A A URL shortener is a service used to convert a long URL to a shorter one. B A website will allow access if you paste a long URL. C A URL shortener will make a long URL much easier to share. D All websites prevent URL shorteners from being used. (1) 1.6 Which ONE of the following statement about RAM is FALSE? A RAM is more expensive per GB than hard drives. B RAM does not store data and programs when the device is switched off. C RAM has a much lower capacity than hard drives. D RAM operates on a mechanical basis and is therefore, relatively slower. (1) Copyright reserved Please turn over

4 COMPUTER APPLICATIONS TECHNOLOGY P2 (EC/SEPTEMBER 2019) 1.7 The automatic movement of text to the next page in a document is known as a …. A continuous section break. B soft page break. C hard page break. D next page section break. (1) 1.8 The defragmentation utility can be used to ... A rearrange files in a continuous order. B remove corrupted files. C compress unused files. D increase hard drive space. (1) 1.9 You want to find out how many times a date in 2014 appears in a column of dates consisting of month and year. Look at the screenshot below and complete the formula. =COUNTIF(B5:B36; ____) A “>2013” B 2014 C “*2014” D =2014 (1) 1.10 If you want to determine how many records appear in a report, you should use the following expression in a calculated field: A =Sum(([Name of specific field]) + Count([Name of specific field])) B =Count([Name of specific field]) C =Sum([Name of specific field]) D =Max([Name of specific field]) (1) [10] Copyright reserved Please turn over

(EC/SEPTEMBER 2019) COMPUTER APPLICATIONS TECHNOLOGY P2 5 QUESTION 2: MATCHING COLUMNS Choose a term/concept from COLUMN B that matches the description in COLUMN A. Write only the letter (A–P) next to the question number (2.1–2.10) in the ANSWER BOOK, for example 2.11 Q. COLUMN A COLUMN B 2.1 A port usually found on portable devices such as A Switch smartphones 2.2 A standard that allows devices to connect wirelessly by B Crowd funding touching them together or bringing them into close proximity 2.3 The purpose is data theft in order to gain free network C Thesaurus access 2.4 An example of an online storage facility or service D NFC 2.5 A standard used in wireless communication which provides E USB Hub high-speed data transfer between cellular devices and ISPs 2.6 A business idea/practice funded by multiple small donations F Phishing from volunteer contributors 2.7 A data type in Access that creates a list of options for the G LTE user to choose from when entering data in a field 2.8 A word processing feature to look up synonyms for selected H Card reader words on command 2.9 A central node where all the computers on a network plug in I Trojan 2.10 A device designed to read data from the following type of J Micro USB storage devices: SD cards, flash memory cards, etc. K 1G L Spell-check M Piggybacking N VGA O Input mask P Lookup wizard Q External HDD R SSD S Dropbox T Wi-Fi (10 x 1) [10] Copyright reserved Please turn over

6 COMPUTER APPLICATIONS TECHNOLOGY P2 (EC/SEPTEMBER 2019) QUESTION 3: TRUE/FALSE ITEM Indicate whether the following statements are TRUE or FALSE. Write ‘true’ or ‘false’ next to the question number (3.1–3.5) in the ANSWER BOOK. Correct the statement if it is FALSE. Change the underlined word(s) to make the statement TRUE. (You may not simply use the word ‘NOT’ to change the statement. NO mark will be awarded if only FALSE is written down.) EXAMPLES: QUESTION ANSWER Google is the world’s most popular search engine. True A NIC has slots for hardware components such as False – motherboard the CPU. 3.1 A multi-touch screen offers more functionality without using menus. (1) 3.2 A solid state drive is a drive that has no moving parts, thus making it quieter and more robust. (1) 3.3 The term Virtual Reality (VR) is associated with simulation of a 3D-environment. (1) 3.4 ICT refers to the trend whereby all sorts of objects and devices increasingly being connected to one another via the Internet. (1) 3.5 Freeware refers to software that has copyright, but may be copied or shared for the purpose of trying it out, with the understanding that an amount should be paid for continuous use. (1) [5] TOTAL SECTION A: 25 Copyright reserved Please turn over

(EC/SEPTEMBER 2019) COMPUTER APPLICATIONS TECHNOLOGY P2 7 SECTION B QUESTION 4: SYSTEM TECHNOLOGIES 4.1 Study the advertisement below and answer the questions that follow. DEVICE A A stylish all-in-one with a stunning screen 196 x 196 x 36mm VGA and HDMI output Quad-Core i7 Intel Iris Graphics 6000 Crucial 8GB DDR4-2133Mhz 1TB WD Blue 7200RPM Hard Drive 3 TB SSD Wireless: 802.11ac, Bluetooth 4.0 MacOS Sierra 10 DEVICE B 4.1.1 Name the TWO hardware components for Device A that are most important for the effective working of a computer, other than the hard drive. (2) 4.1.2 Explain how adding more RAM to a computer can improve the overall system performance of the computer. (2) 4.1.3 Give TWO reasons why solid state drives (SSDs) will in future replace hard disk drives as the main storage device of a computer. (2) 4.1.4 Give TWO benefits of buying Device A, which is an ‘all-in-one’ computer. (2) 4.1.5 Give TWO reasons why HDMI output is better than VGA output. (2) Copyright reserved Please turn over

8 COMPUTER APPLICATIONS TECHNOLOGY P2 (EC/SEPTEMBER 2019) 4.2 The following questions refer to Device B: 4.2.1 Name TWO features/functionalities, which were added to a cell phone when multiple technologies converged as a phablet. (2) 4.2.2 Name ONE way in which you could transfer photos from Device B to your desktop computer. (1) 4.2.3 Give ONE example of an action that can be performed on a ‘multi- touch sensing screen’. (1) 4.2.4 Name ONE biometric feature of Device B listed in the advert. (1) 4.2.5 Compare the operating systems found on both devices by referring to: (a) Cost of the software (2) (b) Support from the developer (2) 4.3 Write down the TWO processes in the information processing cycle that have the least influence on the overall performance of the computer. (2) 4.4 Explain why the central processing unit (CPU) of a computer needs cache memory. (2) 4.5 A buyer considers purchasing a 3D printer. Name TWO advantages of buying a 3D printer. (2) [25] Copyright reserved Please turn over

(EC/SEPTEMBER 2019) COMPUTER APPLICATIONS TECHNOLOGY P2 9 QUESTION 5: INTERNET AND NETWORK TECHNOLOGIES 5.1 Give TWO reasons for compressing files before uploading them to cloud storage. (2) 5.2 Study the Internet connection package advertised below and answer the questions that follow. 30 GB data per month 15 Mbps Shaped 5.2.1 Give the common term used when an Internet Service Provider slows down your Internet speed when you download huge amounts of data. (1) 5.2.2 Give TWO factors (besides the one in QUESTION 5.2.1) that can influence Internet speed. (2) 5.2.3 Explain the term shaped and provide ONE example of a situation where it would be necessary to ‘shape’ a connection. (2) 5.3 How would RSS-feeds be used to distribute podcasts? (1) 5.4 You are unable to attend a seminar in Limpopo due to protests. A friend suggests you use a video conference. 5.4.1 How can a video conference be used to share information about the seminar in Limpopo? (2) 5.4.2 Give TWO advantages of using a video conference. (2) 5.5 Your friend complained that he was automatically redirected to a fake website, even when he typed in the correct URL for a specific website. Name TWO ways how he can prevent becoming a victim of pharming. (2) 5.6 What is digital migration? (1) [15] Copyright reserved Please turn over

10 COMPUTER APPLICATIONS TECHNOLOGY P2 (EC/SEPTEMBER 2019) QUESTION 6: INFORMATION MANAGEMENT 6.1 Youth participating in social media has advantages and disadvantages. 6.1.1 Can continuous online participation decrease social interaction between people? Motivate your answer. (2) 6.1.2 Give TWO ways in which social media sites such as Facebook can benefit you in searching for a job. (2) 6.2 A strategy to prevent information overload is to read more accurately and faster. Give TWO more strategies to overcome overload of information. (2) 6.3 Compare plagiarism and copyright infringement by explaining: 6.3.1 What each offence is (2) 6.3.2 How you can avoid being guilty of the offence (2) [10] Copyright reserved Please turn over

(EC/SEPTEMBER 2019) COMPUTER APPLICATIONS TECHNOLOGY P2 11 QUESTION 7: SOCIAL IMPLICATIONS 7.1 Give TWO reasons why it would be necessary for a school or company that has a policy of BYOD to take extra measures to secure their data. (2) 7.2 Computers on any network can be open to ransomware attacks. 7.2.1 What is a ransomware attack and what is required of a user to do? (2) 7.2.2 What is the best way to safeguard/protect yourself against ransomware? (2) 7.3 Briefly explain how bitcoins work to financially benefit entrepreneurs or individuals. (2) 7.4 Social media has been overflowing with fake news recently. Give TWO ways to spot fake news. (2) [10] Copyright reserved Please turn over

12 COMPUTER APPLICATIONS TECHNOLOGY P2 (EC/SEPTEMBER 2019) QUESTION 8: SOLUTION DEVELOPMENT 8.1 Name TWO possible data sources to create mailing labels in a mail merge. (2) 8.2 The following message appears when one tries to create a Table of Figures for all images in a document: "No table of figures entries found". What change should you make to the document to ensure a Table of Figures can be generated? (1) 8.3 Study the screenshot below which shows part of a spreadsheet. Cell B1 contains the formula =A1 * 5. Give a possible reason why the answer displayed in cell B1 is not 60. (2) 8.4 Explain the difference between a validation rule and validation text by referring to their functions. (2) 8.5 What is the function of the ‘eye’ icon in the screenshot below? (1) Copyright reserved Please turn over

(EC/SEPTEMBER 2019) COMPUTER APPLICATIONS TECHNOLOGY P2 13 8.6 The screenshot below shows part of a spreadsheet listing movie titles. The function =COUNTIF(A2:A11, “Gold*”) returns a result of 3. 8.6.1 Explain the purpose of the ‘*’ in the criterion “Gold*”. (2) 8.6.2 If the criterion were changed to “Gold”, what would the result be? (1) 8.6.3 If the criterion were changed to “*Gold*”, what would the result be? (1) 8.7 The html code <table border=“3”> <tr> <td>Cell 1</td> <td>Cell 2</td> </tr> <tr> <td>Cell 3</td> <tr> </table> displays the following table in the browser: How would you correct the highlighted (bold) line (the third line of code) so that the table will display as shown below? (2) 8.8 Mention ONE example of metadata that is saved with a word processing document. (1) [15] TOTAL SECTION B: 75 Copyright reserved Please turn over

14 COMPUTER APPLICATIONS TECHNOLOGY P2 (EC/SEPTEMBER 2019) SECTION C QUESTION 9: INTEGRATED SCENARIO Your cousin is a young man who has just completed his studies in Creative Brand Communication. He wants to start his own business of Branding using the savings he accumulated during his years at university. His type of business needs a ‘powerful’ computer/notebook as he has to use graphic design software like Photoshop. 9.1 Your cousin needs to start shopping for two computers: a notebook for himself and another one for his secretary. 9.1.1 You mention to your cousin that the notebook he needs to buy for the secretary should meet the minimum system requirements. What does this mean? (2) 9.1.2 You recommend to him that he has to buy a notebook with higher specifications for himself than the requirements for his secretary. Give TWO reasons why this is good advice. (2) 9.1.3 Your cousin has been given a trial version of a program by the software developers. Give ONE advantage of using a trial version of software before installing the full version. (1) 9.2 RFID tags and bar codes have similar functions. 9.2.1 What medium does an RFID reader use to read RFID tags? (1) 9.2.2 What medium does a bar code scanner use to read bar codes? (1) 9.3 Give ONE advantage of using a QR code to advertise his business. (1) 9.4 Your cousin has stored a lot of confidential information on his notebook. 9.4.1 Mention TWO practical ways in which he can prevent his notebook from being stolen from his office, besides being locked on the desk. (2) 9.4.2 Give TWO examples of biometric features to ensure secure access to a notebook. (2) 9.5 The secretary wants to telecommute on some days (wants to work from home instead of actually being present at the workplace). Give TWO general advantages of telecommuting or teleworking for the employee. (2) Copyright reserved Please turn over

(EC/SEPTEMBER 2019) COMPUTER APPLICATIONS TECHNOLOGY P2 15 9.6 Besides social networking sites, your cousin wants to use a blog for the business. Suggest TWO ways in which he can attract or maintain their interest in reading the blog in future. (2) 9.7 Your cousin wants to carefully consider certain aspects when choosing an Internet Service Provider (ISP). List TWO possible aspects to consider when choosing between different Internet Service Providers (ISP). (2) 9.8 The user has a choice of allowing an automatic download of a patch. Mention TWO disadvantages of choosing an automatic download of a patch. (2) 9.9 There will be instances where your cousin would want some of the hard copies to be converted and used electronically on his notebook. 9.9.1 Which device would be suitable to do this? (1) 9.9.2 Which software does the device use and briefly mention how this software works? (2) 9.9.3 Mention TWO disadvantages of using the device you mentioned in QUESTION 9.9.1 to create soft copies. (2) [25] Copyright reserved Please turn over

16 COMPUTER APPLICATIONS TECHNOLOGY P2 (EC/SEPTEMBER 2019) QUESTION 10 Your school is planning to roll out tablets to be used in the class. The school needs your support to make this transition smooth with the help of ICTs (Information and Communication Technologies). 10.1 The following are specifications of a tablet the school would like to purchase. Technical Specifications: 1.3GHz Spreadtrum T-Shark quad-core processor 1 GB of system memory 7" touchscreen, 1024 x 600 resolution Built-in 802.11b/g/n Wi-Fi and Bluetooth v4.0: 2 MP camera Wi-Fi Direct micro USB 2.0 port SIM card slot 16 GB eMMC Up to 64 GB 8 GB onboard storage memory, additional memory via micro SD card slot Speakers 10.1.1 Give TWO uses for a front camera of a tablet. (2) 10.1.2 What does it mean when the tablet is both Wi-Fi and SIM Card enabled? (2) 10.1.3 Give the name of the specification that 1024 x 600 refers to. (1) 10.1.4 Explain what the term micro SD refers to, and what the purpose of the micro SD is. (2) 10.1.5 What is meant by a quad-core processor and what is the significance of such a processor? (2) 10.2 When used in a classroom, tablets have both advantages and disadvantages. 10.2.1 Name TWO tasks associated with teaching and learning in the class that can best be done by using a tablet. (2) 10.2.2 Give TWO ways in which educators can make sure that their learners are unable to access inappropriate websites while ‘surfing’ the web. (2) 10.2.3 Name TWO ways in which the use of tablets in class can promote ‘green computing’. (2) 10.2.4 Some sight impaired learners are struggling with viewing work on the tablets due to the size of the screen. Recommend TWO solutions how this challenge can be overcome. (2) Copyright reserved Please turn over

(EC/SEPTEMBER 2019) COMPUTER APPLICATIONS TECHNOLOGY P2 17 10.3 ISPs offer data bundles which provide different limitations in the amounts of data that can be downloaded and uploaded in a month. 10.3.1 Why is it better for the school to have uncapped data? (2) 10.3.2 Explain the difference between a hard cap and a soft cap. (2) 10.4 The school should have a backup policy. 10.4.1 Name TWO measures that should be included in such a policy. (2) 10.4.2 Name TWO advantages of dedicated backup programs. (2) [25] TOTAL SECTION C: 50 GRAND TOTAL: 150 Copyright reserved Please turn over