Computer Applications Technology Grade 11 P2 2015 QP (Eng)

Downloaded from hlayiso.com NATIONAL SENIOR CERTIFICATE GRADE 11 NOVEMBER 2015 COMPUTER APPLICATIONS TECHNOLOGY P2 MARKS: 150 TIME: 3 hours *ICATNE* This question paper consists of 16 pages.

Downloaded from hlayiso.com 2 COMPUTER APPLICATIONS TECHNOLOGY P2 (EC/NOVEMBER 2015) 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. Leave a line between each question. 6. In general, a mark is allocated per fact. A 2-mark question would therefore require TWO facts, et cetera. 7. Write neatly and legibly. Copyright reserved Please turn over

Downloaded from hlayiso.com (EC/NOVEMBER 2015) COMPUTER APPLICATIONS TECHNOLOGY P2 3 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 number (1.1–1.10) in the ANSWER BOOK, for example 1.11 D. 1.1 The action used on an image or picture to remove unwanted parts is called … A Crop. B Cut. C Resize. D Undo. (1) 1.2 Which one is another name for web address? A http B URL C html D www (1) 1.3 Which one of the following restricts unauthorised access to and from a computer network? A Firewall B Modem C UPS D 3G Card (1) 1.4 An e-mail message that promises the school principal that he will receive large amounts of money if he forwards this e-mail to at least 10 people is called a … A driver. B hoax. C trojan. D firewall. (1) 1.5 A fingerprint reader and voice verification systems are examples of … devices. A animation B multimedia C biometric D geographic (1) Copyright reserved Please turn over

Downloaded from hlayiso.com 4 COMPUTER APPLICATIONS TECHNOLOGY P2 (EC/NOVEMBER 2015) 1.6 Which one of the following is the general term for computer viruses and worms? A Freeware B Spyware C Shareware D Malware (1) 1.7 Proprietary software is a software that … A is completely free. B needs a licence to be bought in order to use it. C can be copied freely from the legal owner of the software. D can be shared with friends. (1) 1.8 Which one of the charts below would be the most appropriate to display the percentage budgeted for the different items in a household budget? A Column chart B Line chart C Bar chart D Pie chart (1) 1.9 Which one of the following utilities can be used to make more storage space available by removing temporary files? A Disk defragmenter B Backup software C Disk cleanup D Recycle bin (1) 1.10 Which one of the following is an example of a micro blogging site? A WhatsApp B Twitter C Google D Flickr (1) [10] Copyright reserved Please turn over

Downloaded from hlayiso.com (EC/NOVEMBER 2015) COMPUTER APPLICATIONS TECHNOLOGY P2 5 QUESTION 2: MATCHING ITEMS Choose a term/concept from COLUMN B that best matches the description in COLUMN A. Write only the letter (A–O) next to the question number (2.1–2.7) in the ANSWER BOOK, for example 2.8 P. COLUMN A COLUMN B 2.1 Policy which defines users' rights and responsibilities within A Contrast a network. ratio 2.2 A fast type of port typically used for video input. B UPS 2.3 A device that can be used to protect a computer against C USB power spikes, surges and outages. 2.4 A small text file saved automatically on your computer by a D Drivers website. 2.5 Database feature used to ensure the correct format of data E Primary is input by the user. memory 2.6 The relationship between the width and the height of a F Data display device. Validation 2.7 A flash disk is classified as … memory. G Aspect ratio H Skype I cookie J AUP K WYSIWYG L Input mask M FireWire N IDSL O Secondary memory (7 x 1) [7] Copyright reserved Please turn over

Downloaded from hlayiso.com 6 COMPUTER APPLICATIONS TECHNOLOGY P2 (EC/NOVEMBER 2015) QUESTION 3: MODIFIED TRUE/FALSE Indicate whether the following statements are TRUE or FALSE. Where the statement is false, rewrite ONLY the underlined section to make it true. (You may not simply use the word ‘NOT’ to change the statement when you rewrite it.) 3.1 A switch is a network device used to connect two or more networks to each other. (2) 3.2 The SUMIF function adds figures in a range of cells if specific criteria are met. (1) 3.3 A word processor is the best application to display an HTML page. (2) 3.4 A legend is a key that identifies the colours used for each category in a chart. (1) 3.5 DOCX is the file extension for a Microsoft Word Template. (2) [8] TOTAL SECTION A: 25 Copyright reserved Please turn over

Downloaded from hlayiso.com (EC/NOVEMBER 2015) COMPUTER APPLICATIONS TECHNOLOGY P2 7 SECTION B QUESTION 4: SYSTEMS TECHNOLOGIES 4.1 One of the local computer shops is advertising a tablet computer, as well as other laptops. 4.1.1 Name TWO differences between a laptop and a tablet computer. (2) 4.1.2 Name TWO disadvantages of a laptop. (2) 4.1.3 Name ONE advantage of a tablet PC. (1) 4.2 Most new software that is written will usually have bugs in it. Two common ways of fixing software related bugs are by using patches and service packs. 4.2.1 What is meant by a software bug? (1) 4.2.2 Briefly explain the difference between a patch and a service pack, by describing the essential feature of each one. (2) 4.3 South Africa is plagued by power outages and load shedding in recent times. 4.3.1 Name ONE potential danger that this can pose for a computer system. (1) 4.3.2 Name ONE hardware measure that one could use to help counteract these problems. (1) 4.4 Backup utilities enable users to make copies of certain files or the entire hard disk to other storage media. 4.4.1 What is a backup used for? (1) 4.4.2 What storage medium would you suggest to backup large volumes of files for a long term? (1) 4.4.3 You can also archive your files. Explain the term archive in this context. (2) 4.5 The resolution at which a digital photo is taken is quite important. 4.5.1 Name ONE advantage of taking digital photos at the maximum resolution (1) 4.5.2 Name ONE disadvantage of taking digital photos at the maximum resolution. (1) Copyright reserved Please turn over

Downloaded from hlayiso.com 8 COMPUTER APPLICATIONS TECHNOLOGY P2 (EC/NOVEMBER 2015) 4.6 In our quest for a paperless office, people are encouraged to make use of electronic mail instead of letters and faxes. 4.6.1 Explain what a web-based e-mail service is. (2) 4.6.2 Give ONE reason why you would use a web-based e-mail service. (1) 4.6.3 What is the major disadvantage of a web-based e-mail service? (1) 4.6.4 What are Message rules and how can they help you to organise your e-mails? (2) 4.7 Screen settings can be used to benefit both sight impaired and hearing impaired users. Name TWO examples of these settings. (2) 4.8 Explain how speech recognition software can help disabled people to make use of computers. (1) [25] Copyright reserved Please turn over

Downloaded from hlayiso.com (EC/NOVEMBER 2015) COMPUTER APPLICATIONS TECHNOLOGY P2 9 QUESTION 5: INTERNET AND NETWORK TECHNOLOGY 5.1 Briefly explain the difference between LAN and WLAN by describing what each of these terms refers to. (NOTE: Do not just expand the abbreviations.) (2) 5.2 Name TWO potential disadvantages of a WLAN. (2) 5.3 Servers play a big role in the network environment. Name ONE way in which a server differs from a client computer other than its function. (1) 5.4 Briefly describe the function of the following components of a network: 5.4.1 NIC (network interface card) (1) 5.4.2 Modem (1) 5.5 What is the purpose or function of a web browser? (1) 5.6 Online shopping facilities are being used by many people nowadays. State TWO safety measures that you should bear in mind when shopping online. (2) 5.7 Many people make use of an RSS aggregator. Name ONE advantage of RSS aggregators. (1) 5.8 Give TWO reasons why business people prefer web based applications over software that is installed in your own computer. (2) 5.9 What is the function of an ISP? (1) 5.10 What is the purpose of FTP? (1) [15] Copyright reserved Please turn over

Downloaded from hlayiso.com 10 COMPUTER APPLICATIONS TECHNOLOGY P2 (EC/NOVEMBER 2015) QUESTION 6: INFORMATION MANAGEMENT 6.1 A questionnaire is a tool/method used to collect the opinions of people in a survey. 6.1.1 Give TWO reasons why it is always a better idea to use 'closed questions' in setting up a questionnaire for research purposes. (2) 6.1.2 Name TWO guidelines to be used when setting up a questionnaire, other than making use of ‘closed’ questions. (2) 6.2 Name ONE other possible source of information when doing research on a specific topic. (1) 6.3 What is meant by the term plagiarism? (1) 6.4 What is the difference between data and information? (2) 6.5 One of the options given when records are imported into an Access database is to append the records. Briefly explain the term append. (1) 6.6 Explain why many academic institutions do not allow their students to quote Wikipedia as a source. (1) [10] Copyright reserved Please turn over

Downloaded from hlayiso.com (EC/NOVEMBER 2015) COMPUTER APPLICATIONS TECHNOLOGY P2 11 QUESTION 7: SOCIAL IMPLICATIONS 7.1 Name ONE alternative to a mouse that can be used by physically challenged people. (1) 7.2 Name ONE way you could secure your laptop to the desk. (1) 7.3 Electricity is an expensive resource. Name TWO ways in which you can save electricity when making use of electronic devices like laptops or computers. (2) 7.4 Social engineering has become a real threat to computer users today. 7.4.1 Briefly explain what social engineering is. (1) 7.4.2 Give TWO precautions you can take to prevent becoming a victim of a social engineering attack via e-mail. (1) 7.5 Spyware is becoming a huge problem for computer users. 7.5.1 What is the aim of spyware? (1) 7.5.2 Name TWO signs that could indicate that your computer is infected with spyware. (2) 7.6 Name ONE disadvantage of social networking sites. (1) [10] Copyright reserved Please turn over

Downloaded from hlayiso.com 12 COMPUTER APPLICATIONS TECHNOLOGY P2 (EC/NOVEMBER 2015) QUESTION 8: SOLUTION DEVELOPMENT 8.1 What is the difference between a footnote and endnote? (2) 8.2 8.2.1 Which feature of Microsoft Word would you use to apply the landscape option to some of the pages in a portrait document? (1) 8.2.2 Which feature of Microsoft Word would you use to ensure uniform heading formatting throughout a document? (1) 8.2.3 Give ONE advantage of making use of the above feature to format your document. (1) 8.3 Briefly explain what the Bcc field indicates on an e-mail. (1) 8.4 Study the screenshot below and answer the questions that follow: 8.4.1 Which spreadsheet feature was used to display the text over two lines in the heading in the first row? (1) 8.4.2 Which spreadsheet function can be used to determine the 7 th lowest position in column D? (1) 8.5 Explain the cause of each of the following error messages in a spreadsheet: 8.5.1 ####### (1) 8.5.2 #REF (1) Copyright reserved Please turn over

Downloaded from hlayiso.com (EC/NOVEMBER 2015) COMPUTER APPLICATIONS TECHNOLOGY P2 13 8.6 Details about a national sports academy was captured in a database as shown below: 8.6.1 Which of the fields above can be allocated with a default value? (1) 8.6.2 Name ONE technique that can be used in the Province field to ensure that the code is entered correctly and accurately. (1) 8.6.3 Which feature of the database can be used to extract a list of the hockey players that will be attending the national sports academy? (1) 8.6.4 When will you use the OLE data type in a database? (1) 8.6.5 What is the use of Required field property in a database? (1) [15] TOTAL SECTION B: 75 Copyright reserved Please turn over

Downloaded from hlayiso.com 14 COMPUTER APPLICATIONS TECHNOLOGY P2 (EC/NOVEMBER 2015) SECTION C QUESTION 9: INTEGRATED SCENARIO SCENARIO You were selected as the head prefect of the Student Representative Council of your school and you have been tasked to set up a small office at the school to be used for the administration of the SRC. You received a limited budget from the school’s governing body to buy the necessary hardware and software needed. Although it is more expensive than a desktop, you convinced the governing body that a laptop would be a better option. You presented the following quotation from a leading computer store:  19.5" LED 20D300H Monitor  Intel® Core TM i3-4150 Processor 3.50 GHz  4GB RAM  1 TB Hard Drive  Windows 8.1  DVD-Super 8X Multi DL drive  USB 3.0 (1x Rear)  WiFi  Bluetooth 4.0  Front Camera 2.0 MP  Embedded 3G card slot  3-in-1 Card Reader  Free 2 GB online storage facility exclusive from DELL  Warranty – 1 Year Onsite Warranty Free M2070W Multifunction Printer Worth R1599 90 with 802.11 B/G/N 9.1 The governing body has the following questions with regard to the quotation above: 9.1.1 What is the capacity of the primary memory of the laptop in the quotation above? (1) 9.1.2 The laptop has far more storage space than memory. Briefly explain why computers need more storage space than memory by referring to their functions. (2) 9.1.3 Name ONE difference between memory and storage OTHER than their functions. (1) Copyright reserved Please turn over

Downloaded from hlayiso.com (EC/NOVEMBER 2015) COMPUTER APPLICATIONS TECHNOLOGY P2 15 9.2 The laptop comes with a free online storage facility. 9.2.1 Explain what online storage is. (1) 9.2.2 Name TWO advantages of online storage. (2) 9.2.3 Name TWO disadvantages of online storage. (2) 9.3 Explain the term on-site warranty offered with the laptop. (1) 9.4 The DVD drive mentioned in the quotation is a dual layer drive. What is the advantage of a dual layer DVD? (1) 9.5 The computer shop decided to donate the multifunction printer to the SRC if they decided to accept this quotation. 9.5.1 What does the 802.11 B/G/N in the specification refer to? (1) 9.5.2 One of the members of the governing body wanted to know what the monthly duty cycle of the printer is. What does this specification of a printer refer to? (2) 9.5.3 Name TWO advantages of buying a multifunction printer. (2) 9.6 All laptops come with a touch pad. 9.6.1 What is a touch pad? (1) 9.6.2 Name ONE advantage and ONE disadvantage of using a touch pad. (Remember to clearly distinguish between the advantage and disadvantage in your answer.) (2) 9.7 What is the advantage of the 3-in-1 card reader that comes with the laptop? (1) 9.8 Another necessity for the office is the correct software. 9.8.1 What type of software is listed in the quotation? (1) 9.8.2 List TWO functions of the software referred to in QUESTION 9.8.1. (2) 9.9 You also need application software and you suggested that they buy an Office Suite. 9.9.1 What is an Office Suite? (2) 9.9.2 Name TWO advantages of buying an Office Suite. (2) Copyright reserved Please turn over

Downloaded from hlayiso.com 16 COMPUTER APPLICATIONS TECHNOLOGY P2 (EC/NOVEMBER 2015) 9.10 When buying the software, their attention was drawn to the minimum system requirements needed to run the program. 9.10.1 Explain the term minimum system requirements. (1) 9.10.2 Name TWO examples of such system requirements. (2) 9.11 During the installation of the software, the installation wizard prompted the member installing the software for an activation code. What is the aim of an activation code? (2) 9.12 The use of technology can have significant drawbacks to the environment. 9.12.1 How can the LED technology for the monitor, listed in the quotation, contribute towards green computing? (1) 9.12.2 Explain TWO ways in which the SRC can practise green computing when using their printer. (2) 9.13 There is definitely certain health risks involved in working on computers for long hours. Buying more ergonomically designed hardware is one potential solution to RSI injuries. 9.13.1 Briefly explain the term ergonomics. (1) 9.13.2 Name TWO features of an ergonomically designed keyboard. (2) 9.14 One of the members saw an advertisement for a cordless keyboard and mouse on special at the local computer shop. 9.14.1 How does a cordless keyboard communicate with a computer? (1) 9.14.2 Name TWO possible disadvantages of using a cordless mouse. (2) 9.15 One of the members of the SRC suggested that they free up some hard disk space by defragmenting the hard disk. Explain to him why defragmenting the drive will not help you to gain free space on your hard drive by referring to what happens in the defragmentation process. (2) 9.16 The SRC decided to create a blog. 9.16.1 What is a blog? (1) 9.16.2 Name THREE good practices that the SRC should use to attract people to read and return to their blog. (3) 9.17 Name TWO advantages of using a network to connect all of the computers in the school in a network. (2) 9.18 What is an App? (1) TOTAL SECTION C: 50 GRAND TOTAL: 150 Copyright reserved Please turn over