Information Technology Grade 11 2015 QP & Memo

Downloaded from hlayiso.com a INFORMATION TECHNOLOGY t i SEPTEMBER CONTROL TEST 2015 t (3 [ GRADE 11 MARKS: 60 Examiner: M PADAYACHEE TIME: 1% HOURS Moderator: S NAIDOO DATE : 29 ~ 09 - 2014 INSTRUCTIONS: iy 1. This question paper consists of 8 pages including the cover page and an os Annexure. 2. Answer all questions. 3. Use the mark scheme as a guide as to the number of points you should write. 4. Answer Q2.1.4. and hand in the annexure with your answer book. Page 1 of 8

Downloaded from hlayiso.com QUESTION 1 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 your ANSWER BOOK. 1.1 Which of the following is NOT a cellular connection? A) B) C) D) EDGE 3G LTE SSL 1.2 Akey that uses a single ‘secret’ key. A) B) C) D) Primary key Private key Foreign key Public key 1.3. Asearch in which the results are customized by search engines like Google. A) B) C) D) Profiled search Context-aware search Mediated search Semantic search 1.4 The latest and still developing standard used for the compression of audio and visual digital data. A) B) C) D) MPEG - 2 MP3 MPEG — 4 JPEG Page 2 of 8

1.5 1.6 , 1.7 1.8 1.9 Downloaded from hlayiso.com Which ONE of the following tasks is NOT a typical function for home or personal use of computers? A) Accounting or billing B) Social networking C) Internet banking D) Limited office tasks The average battery life on a Smartphone is ... A) 6-10 hours B) 10-24 hours C) 3-10 hours D) 24-34 hours Which of the following technologies does cloud computing rely on? A) _ Information technology B) Wireless technology C) GPS technology D) Virtualisation technology The process of ensuring that data meets a set of requirements. A) Validation B) Verification C) Integrity D) Warehousing An RFID tag contains ... A) Atadio chip, some circuitry and a microchip B) Amicro card, some circuitry and an antenna C) Anantenna, some bots and a microchip D) An antenna, some circuitry and a microchip Page 3 of 8

Downloaded from hlayiso.com 1.10 A... is a computer attached to a network that has had its security compromised and as a result is remotely controlled for a purpose other than what it was intended for. A) bot B) puppet C) Trojan horse D) Zombie SCENARIO Your school needs to raise funds to open a Media Centre for the learners that attend the school. They have decided to have a mini singing competition called IT got Talent. You and your friends have been requested to assist the school in the administration and setup of the computers for both the competition as well as the media centre. QUESTION 2 [10] 2.1 The management of the school has designed the database that will hold the information of the events and the participants. The table below shows the table tblEvent. tblEvent Participant | Participant Event EventID Name Surname Catergory | Event Date Time HHO01 | Adam Joans Hip-Hop 12-Sep-15 | O9h00 RPOOS __| Llewellyn lyer Rap 13-Sep-15 | 09h30 JZ008__| James White Jazz 14-Sep-15 | O09h00 CL111 Thandi Khumalo Classical 16-Sep-15 | 09h30 HHO01__{ Themba Gumede Hip-Hop 12-Sep-15 | 09h00 RPOO5 _| Peaceful Zungu Rap 13-Sep-15 09h30 JZ008 John Govender Jazz 14-Sep-15 | O9h00 JZ008 Shaheel Maharaj Jazz 14-Sep-15 Ogho0 CL111__| Sole Buddy Classical 16-Sep-15 | 09h30 2.1.1 Data integrity and data redundancy are two ways in which one can improve a database. Briefly differentiate between data integrity and data redundancy. 2.1.2 Name and explain ONE type of anomaly. 2.1.3 Give ONE advantage of data independence. (2) (2) (1) 2.1.4 You need to normalise the tblEvent table to 2NF. Answer this question on ANNEXURE A (attached) by doing the following: a) Separate the fields in the tblEvent table into two new tables, thlEvent and tbIParticipant. Page 4 of 8 (4)

(3 Downloaded from hlayiso.com b) c) qd) Clearly indicate which field (s) in the thlEvent and tbIParticipant tables will serve as the primary key field (s). Indicate using PK. Clearly indicate the type of relationshi line drawn between the relevant fields. p between the two tables using a Indicate any relevant foreign key field (s). Indicate using FK. 2.2 Study the database below and answer the questions that follow. The table thIVoters below contains details about individuals that have voted for the participants. VoterlD represents a uni code for each prize. que voter number. PrizelD represents a unique tblVoters VoteriID 7 . (PK) oterName | VoterSurname Age PrizelD (FK) 12345 | Blane Pillai 25 RC11 67894 | Terry Mthembu 18 TBO1 12546 | Roland Chetty 26 RC11 12584 | Keshnee Smith 20 BD14 15478 | Akira Singh 16 BD14 The table thIPrize below contains details about the prize that each individual will receive if they have voted for the participants. tb!Prize PrizelD ar «gt (PK) Description Cost Restriction TBO1 Teddy Bear R 5-00 > 3 years RC11 Remote Control R 9-00 > 10 years BD14 Barbie Doll R 6-00 >12 years 2.2.1 Write SQL statements for each of the following requests: a) b) ¢) Display all the details of each voter in ascending order of the voter's age. Display the Prizel[D and Description of all those prizes that cost more than R 6-00. Display the name, surname and prize description for all those voters who are older than 20. NOTE: You will need to link the tables with an appropriate where clause. Page 5 of 8 Total for Section D: (2) (2) (1) (3) (3) (5) 25

Downloaded from hlayiso.com : QUESTION 3 3.1 Now that the competition is reaching the finals, the voting process has become mobile so that people with smartphones, tablets and phablets can vote from anywhere. 3.1.1. What is a phablet? (1) 3.1.2 Name ONE disadvantage of a smartphone. (1) 3.1.3 Other than the mobility of a mobile device, name ONE advantage of a mobile device. (1) 3.1.4 Smartphones have many advantages. Two of these advantages is that they are ‘always on’ and/or ‘always connected.’ Differentiate between always on and always connected. (2) 3.1.5 Mobile devices have limited battery life. List TWO tasks that you have to perform to prove that mobile devices have a limited battery life. (2) 3.1.6 Having mobile devices, one is able to install and use e-readers. a) What is the purpose of an e-reader? (1) b) Name TWO advantages and ONE disadvantage of dedicated e-reader devices in mobile technology. (3) 3.2 The principal has decided to save some of the videos of the performances using cloud computing as well as upload some of the videos on Youtube. 3.2.1 Describe in detail how cloud computing works. (2) 3.2.2 Name ONE cloud application that can be used by the principal. (1) 3.2.3 Name and explain TWO benefits of using cloud computing. r¢ ‘) 3.2.4 People will be given the opportunity to either download the videos or to stream the videos. How does downloading a video differ from streaming a video? (2) 3.2.5 Online storage is a good way of creating a backup of files, documents and multimedia. a) Explain how the process of disk imaging works as a form of backup. (2) b) List TWO tips to consider when creating backups. : (2) 3.3 Due to many people using the computers setup for the competition and having the computers connected to the Internet, the computers have many security threats even though they have anti-virus software installed. Page 6 of 8

3.4 3.5 3.6 Downloaded from hlayiso.com 3.3.1 Name ONE reason why the computers were infected if it had anti-virus software instaled. 3.3.2 The IT learners have setup a firewall on the computers. Explain how a firewall will reduce the infection rate on the computer by making reference to what a firewall is and how it works. Now that the competition is growing. Many of the videos and details of the participants are now on the Internet for people to see and vote for who they think should win this competition. 3.4.1 Explain to the principal how the participants are now subjected to identity theft. 3.4.2 The theft of participant details is not the only theft that can happen when using computers and the Internet. Name and explain ONE example of theft of resources. 3.4.3. The IT learners have ensured that whatever has been created or sent over the Internet has a digital signature and or a digital certificate. a) Ofwhat purpose is a digital signature? b) List THREE details that a digital certificate must contain. Social networking has become a huge demand due to the competition that the school is having. 8.5.1 Explain how social networking will assist the school in the competition. 3.5.2 A wikiis said to be a type of social networking tool. a) What is meant by the term wiki? b) Give ONE example of a wiki. The school principal has decided that he wants to let this competition go global. Explain what is meant by the term globalisation. [40] GREENBURY SECONDARY SCHOOL faa DEPARTMENT OF MATHS & SCIENCES ud 4.0.0. MR L. PILLAY SF ML pune ARS Page 7 of 8 (1) (2) (2) (2) (1) (3) (2)

Downloaded from hlayiso.com

Downloaded from hlayiso.com ANNEXURE A (Q 2.1.4.) Full Name: Grade/Div: GREENBURY SECONDARY SCHOOL BES DEPARTMENT OF MATHS & SCIENCES e H.0.D. #4R L PILLAY Pe 4 iF | wll Page 8 of 8

Downloaded from hlayiso.com

Downloaded from hlayiso.com GRADE 11 SUGGESTED ANSWERS: SEPTEMBER CONTROLS 1.1.D 1.2.B tac GREENBURY SECONDARY SCHOOL 15.A agape © DEPARTMENT OF MATHS & SCIENCES 5. Os) .D. MRL YY 1.6.B i 1.0.0. MRL ay 17. D 4 . nh wh 21.1. 18.A 1.9.D 1.10.D Data integrity refers to maintaining the accuracy and consistency of data stored in a database Vv where as data redundancy speaks to unnecessary repetition of data across multiple fields in a database or the intentional duplication OR distribution of the database across multiple storage media. ¥ (2) 2.4.2. + insert — the database design prevents a user from capturing data when they want or need to + delete — deleting one piece of data results in the simultaneous removal of other, unrelated data. * update — when an item of data changes, it has to be altered in multiple records in the table. 2.1.3. + the user application cannot change the structure Name, Si ac} Sumeme 2 or the format of the data multip 90 [PK] EventiD applications can Gatesony interface to the Time, same data - * data management is Description aang left to the DBMS for the field: Hit in the two thiParti it P a) | tables corractly and Annexure onsen software used. ver thiEvent, Unique field in tiParticipant v ¥ (accept one advantage) b) clearly Indicated EventiD PK indicated In tbiEvent ca cs) | 4 - relationship v Cine drawn in Correct field ~. | Eventi FI indicated in y thiParticipant 2.1.4, 2.2.1, . SELECT *Y FROM tblVoters “ ORDER BY Age Vv (3) 2.2.2. SELECT PrizelD, Description Vv FROM tbIPrize Y WHERE Cost > 6 v (3)

Downloaded from hlayiso.com 2.2.3, SELECT VoterName, VoterSurname, “ _ tblPrize.Description (5) v¥ FROM tblParticipant, tbIPrize ¥ WHERE tblVoters.PrizelD = tblPrize.PrizelD ¥ AND Age > 20 v (25) 3.1.4, It is a combination of a Smartphone and tablet that has a screen size (1) between 5 and 8 inches. “ 3.1.2. * can combine functions in new, creative ways, which allow you to carry fewer items * are not restricted by time or location «can achieve or produce more in less time v¥ (Any relevant advantage) (1) * cannot run the same full-scale productivity apps * input can be difficult * not easily expandable with peripherals v¥ (Any relevant disadvantage) 3.1.3. * can combine functions in new, creative ways, which allow you to carry fewer items * are not restricted by time or location * can achieve or produce more in less time 0 (Any relevant advantage) 3.1.4. Always on refers to mobile technology is never off, its always working in the background ¥ where as always connected deals with a device being connected to the Internet. v 3.15, (2) + always have to have access to chargers or carry spare * never quite make it through the day without running out of power + have to make choices and limit how much we use our devices to conserve power « there is a trade off between computing power and power consumption vy (any TWO tasks that can be performed)

_— Downloaded from hlayiso.com 3.1.6. a) E-readers are devices that let youreade- (1) books. ¥ 3.1.6.b) Advantages + cheaper than a tablet or smartphone * smaller and lighter than a tablet * longer battery life * easy to read in sunlight Disadvantage + single-purposed * an extra item to carry around (TWO advantages and ONE disadvantage) NOTE TO MARKER: do not award marks for cheaper and smaller only as advantages. 3.2.1. Is where you pay a subscription fee Y to be able to access scalable computing (2) resource or software remotely, using the internet. Vv 3.2.2. + Scalability — the ability to increase or decrease in size and power quickly and effectively. + Ubiquity — as long as you have Internet you can access whatever you want anywhere and anytime. * enables collaboration — because data is not limited to a single machine, multiple people can access it at once and work together + Outsources maintenance and upgrades of hardware — no cost for buying hardware, or repairing and marinating computers. (Any TWO benefits. One mark for naming and one mark for the explanation) 3.2.4, Downloading a file or media means that it is downloaded and saved on your (2) device Y_ where as streaming a file is opend and is streamed in real-time on your device. ¥ 3.2.5. a) It makes a complete backup ‘image’ v of your entire hard drive including all (2)

Downloaded from hlayiso.com your software and then you can install this image on a new hard drive. ¥ 3.2.5. b) (2) * programs can be re-installed, so there is no need to back those up * automate or schedule the running of the backup software * backup your files onto external storage device + performing house keeping so that you don’t have multiple versions of the same data + consider archiving large files \\(Any TWO relevant tips) 3.3.1. * to many anti-virus installed + anti-virus not updated v (Any relevant answer) 3.3.2. It can consist of hardware or software or a combination of both ¥ and (2) acts as a barrier between your computer and the internet. ” 3.4.1. Identity theft occurs when someone steals your details “ so that they can pretend to be you so in this case participant’s details can be subjected to this theft because people will need their details to vote for them. “ (accept relevant explanation 3.4.2. « Piggybacking — criminals gain access to and use someone else’s Internet connection without paying for it. + Botnets — use malware to gain control of multiple computers without the user(s) knowing it. Vv (ONE mark to name and the other to explain) 3.4,3. a) It is used to identify the sender of a message or the signatory of a document.” 3.4.3b)

Downloaded from hlayiso.com * owners public key owner’s name expiration date of the public key name of the issuer serial number of the digital certificate digital signature of the issuer. Vv (Any THREE of the above) 3.5.1, Almost everyone in the 21st century have some for of social networking so by the school using this they can advertise the school and competition and bring in more money as well as get a larger amount of people to vote and assist the school. V qd) 3.5.2.a) Is a web application that allows people to add to and (1) modify content of an online knowledge resource. “ 3.5.2.b) Wikipedia 0 3.6. It is the integration of economics, cultures, ideas and grou across the globe Y driven by a world-wide network of communication. ¥

Downloaded from hlayiso.com