MINISTRY OF EDUCATION AND HUMAN RESOURCES MAURITIUS .

MINISTRY OF EDUCATION AND HUMAN RESOURCESMAURITIUS EXAMINATIONS SYNDICATENATIONAL ASSESSMENT AT FORM IIINAMESCHOOL NAMECLASS/SECTIONCOMPUTER STUDIES/LITERACYOctober 20141 hour 45 minsStudents answer on the Question Paper.READ THESE INSTRUCTIONS FIRSTWrite your name, the name of your school and your class/section in the spaces provided above.Write in dark blue or black ink.You may use a soft pencil for any diagram.Do not use correction fluid.Check that this document consists of 20 printed pages.Any discrepancy in the document must be immediately notified to the responsible officer in yourschool.This paper consists of two sections : Section A and Section BSection AAnswer all questions.Section BAnswer all questions from any three options.All answers must be written in the spaces provided.The number of marks is given in brackets [ ] at the end of each question or part question.The total of the marks for this paper is 100. MOEHR & MES 2014

SECTION AAnswer ALL questions.Question 1For each question, four options (A, B, C and D) are given. Choose and circle the correct one.(i)(ii)(iii)(iv)(v)Which of the following is a hand-held ich of the following is not a software?AWord processorBSpreadsheetsCMicroprocessorDMicrosoft PowerpointWhich of the following is a unit of measurement for storage capacity?AByteBHertzCMemoryDGramWhich of the following is a disadvantage of e-banking?AA building is not requiredfor transactionsBTransactions can be performed athomeCA client can monitor his/heraccount easilyDHackers can access anaccountOne way to prevent health hazards when working with a computer system would be toAtake regular breaks whenworking on the computer.Buse very bright screen light.Cavoid using arm and wristrest.Dplace the screen at a higher levelthan our eye level.2 MOEHR & MES 2014

(vi)(vii)(viii)(ix)(x)Which one of the following is TRUE about LAN?AIt spans over largeareas like a townBIt stands for large area networkCIt spans over a small regionnetworkDIt requires connection to theinternet to functionA multimedia system will consist ofAtext and images only.Btext and video only.Ctext, image, audio and video.Daudio and video only.WAN stands forAWorld Access Network.BWide Area Network.CWorld Area Network.DWide Access Network.Which one of the following is not a search mDwww.yahoo.comWhich one of the following represents a process symbol in a flowchart?ABCD[10] MOEHR & MES 20143

Question 2Complete the following sentences by using the correct word from the given nURLscanner(i)The device used to produce hard copies of a document is the . .(ii)The device used to capture a printed document to a computer is called the .(iii)Using teaching and learning materials with the support of the internet is referred to as .(iv) Buyingand.selling A global network of computers is called the . .(vi) The address bar in a web browser allows us to enter the . of a website.(vii)Microsoft Word is an example of an . package.[7]Question 3For each of the following, put a tick ( ) in the correct box to show whether it is a piece ofhardware or software. An example is given.HardwareSpeaker(i)Central Processing Unit(ii)Read Only Memory(iii)Anti-virus(iv)Logic bomb(v)Modem(vi)Web browser MOEHR & MES 2014Software [6]4

Question 4Tick ( ) True or False next to each of the following statements.True(i)Terabyte is a smaller unit than Gigabyte.(ii)Bit is a unit of measurement for storage capacity.(iii)Repetitive strain injury is a potential health hazard related tothe prolonged use of ICT equipment.(iv)One way to reduce back-problems is to adopt correct sittingposture.(v)E-mail is the service that allows printed messages to passfrom one computer to another.(vi)Postal services allow faster delivery of message than ane-mail service.(vii)A flowchart should always start with a process box.(viii)Manual sorting is faster than using a spreadsheet to sort alarge amount of data.False[8]Question 5Match column A to Column B by drawing an arrow. An example has been provided.Column AColumn Bbarcode readercaptures videos to a computerwebcamallows communication via video to people abroadtele-workingconnects ATMs of a bank across the island.e-bankingallows financial transactions using a computervideo-conferencingstands for World Wide WebWWWimplies less office space requiredWANidentifies articles in supermarkets[6] MOEHR & MES 20145

Question 6A computer system is made up of various components.(i)(ii)List four input devices.1. 2. 3. 4. .[2]For any of two from the above list, give one function of each.1. 2. (iii)[2]Explain the difference between RAM and ROM. . . [2]Question 7There are various ways in which ICT impacts on society. It has advantages but it may alsopresent dangers and drawbacks.(i) Explain what you understand by the term ‘computer virus’. MOEHR & MES 20146[1][6]

(ii)Give two ways to prevent computer viruses from infecting your computer.1.2.(iii) . [2]Automated Teller Machines (ATM) are widely used across the island.State one advantage of using an ATM for the client. . (iv)[1]Give a health hazard and explain how it arises when working with a computer systemfor a long time. . .[2][6]Question 8(i)What does LAN stand for? Give one function of LAN. (ii)(iii)[2]List three advantages of using a LAN.1. 2. .3. [3]Give one disadvantage of LAN. [1][6] MOEHR & MES 20147

SECTION BInstructionsThis section consists of four options: Word Processing, Spreadsheet, Database and ProgramFlowchart.Answer ALL the questions from any three (3) options.Option 1 : Word ProcessingQuestion 1Table 11The Brief History of Social Media2Where people interact freely, sharing and discussing information about their lives34567Social media are Internet sites where people interact freely, sharing and discussinginformation about each other and their lives, using a multimedia mix of personal words,pictures, videos and audio.On these Web sites, individuals and groups create and exchange content and engage inperson-to-person conversations.11They appear in many forms including blogs and microblogs, forums and message boards,social networks, wikis, virtual worlds, social bookmarking, tagging and news, writingcommunities, digital storytelling and scrapbooking and data, content, image and videosharing, podcast portals and collective intelligence.12There are lots of well-known sites such t164.You 7.Second Life186.Instagram12.Typepad18.Reddit19.Lulu and others891019 MOEHR & MES 20148

(a)For each question from (i) to (vi), four options (A, B, C and D) are given. Refer toTable 1, choose the correct one and circle it.(i)(ii)(iii)(iv)(v)The font style of the text labelled at line 1 isAbold, italic.Bitalic, underlined.Cbold, underlined.Dbold, italic, underlined.The font style of the text labelled at line 2 isAbold.Bitalic.Cunderlined.Dsubscript.The paragraph labelled from lines 3 to 5 isAleft aligned.Bcentre aligned.Cright aligned.Djustified.The paragraph labelled from lines 8 to 11 isAleft aligned.Bcentre aligned.Cright aligned.Djustified.The text labelled from lines 13 to 19 is aAbulleted list.Bnumbered list.Cheader.Dfooter. MOEHR & MES 20149

(vi)(b)(i)The text in Table 1 is in Portrait mode. Portrait mode deals withAthe size of the marginsof the page.Bthe paragraph formatting usedin the document.Cthe page orientation used.Dthe type of printer used.[6]Give the steps required to add a table having three (3) columns and three (3)rows in a document. . . (ii)[3]Give the steps required to add a picture in a document. . . (iii)[3]Explain how you will save a document with a different name using the optionsprovided in the Word Processor. . MOEHR & MES 201410[3][9]

Option 2 : SpreadsheetQuestion 1(a)For each question from (i) to (iii), four options (A, B, C and D) are given. Refer toTable 2, choose the correct one and circle it.Table 8715306(i)What is the cell address of the cell showing the total number of medals won byMAURITIUS?(ii)AB1BB2CE1DE2Which formula should be used to calculate the average number of medalswon by SEYCHELLES?(iii)A (B4 C4 D4)/3B (B4 C4 D4 E4)/4C (B4 C4 D4)/4D (B4 C4 D4 E4)/3Which formula has been used to calculate the total number of medalswon by SEYCHELLES?A average(B4:D4)B sum(B4:D4)C MAX(B4:D4)D MIN(B4:D4) MOEHR & MES 201411

(iv) To print a list of countries sorted by the smallest number of medals first, the datashould be sorted in ascending order of(v)AGOLDBSILVERCBRONZEDTOTALWhich cell will change as a result of MAURITIUS winning 2 additional GOLDmedals?AA2BB1CB3DE2(vi) MAYOTTE has to be inserted between SEYCHELLES and MADAGASCAR.Which row number should be chosen to insert a row between SEYCHELLESand MADAGASCAR?(b)(i)A2B3C4D5[6]Write down the steps required to rename a sheet. (ii)[2]Explain the term ‘sorting’. What is the difference between sorting in ascendingand descending order? . MOEHR & MES 201412[3]

(iii)(iv)State two ways in which a formula can be replicated.1. 2. [2]Refer to Table 2. State the value that the following formula would return1. MIN(B2:B5) 2. MAX(B3:D3). [2][9] MOEHR & MES 201413

Option 3 : DatabaseQuestion 1(a)For each question from (i) to (vi), four options (A, B, C and D) are given. Choosethe correct one and circle it.The following is part of a Bird database containing details about birds existing inMauritius.The following codes are used for the Category field:I IntroducedE EndemicNameBirdIDN NativeApprox. size (cm)CategoryFamilyEndangered102563Meller’s 600Francolin32IPhasianidaeNo102605Pink ropidaeNo(i)(ii)The above table containsAeight records and 6 fields.Bsix records and 7 fields.Cseven records and 42 fields.Dseven records and 6 fields.To which Family does the Parakeet belong?ASwallowBPhasianidaeCColumbidaeDPsittacidae MOEHR & MES 201414

(iii)(iv)(v)Which of the following fields would be the most appropriate as the key field?ABirdIDBNameCCategoryDFamilyThe data type of the Approx. Size (cm) field isAboolean.Balphanumeric.Cnumeric.Dcm.Which BirdID will be listed if the following search condition is input?(Category “N”) AND (Endangered “Yes”)(vi)(b)A102635, 102644B102563, 102566102605, 102612CNilD102635, 102644, 102563,102566, 102605, 102612How many birds are endangered OR of Category introduced?A5B4C6D2[6]Explain why a key field is required. . . . .(c)[2]Give two advantages of storing the Category information in coded form.(i) (ii) MOEHR & MES 201415[2]

(d)Write down the search criteria to retrieve details of birds of the Psittacidae family or ofbirds that are of size greater than 30 cm. . .[2] .(e)The record format for the bird table is as follows:FieldField SizeBirdID6NameSize (cm)Category1521Family13Endangered3Show how the details of the following bird will be stored in the record below.The Cuckooshrike with BirdID 102618 is an endemic bird of the CampephagidaeFamily. It is usually of size 16 cm and not considered as endangered.[2](f)The data type of the Endangered field is of type Text. Suggest a more appropriate datatype for it. [1][9] MOEHR & MES 201416

Option 4: Program FlowchartQuestion 1(a)Draw a flowchart that requires the user to input 5 numbers then display the total ofthose five numbers in the space below. MOEHR & MES 201417[6]

(b)Consider the given flowchartSTARTSet PASSMARK 50Set TOTALPASS 0Set REPEAT 0Enter MARKTOTALPASS TOTALPASS 1NOYESMARK PASSMARKISREPEAT REPEAT 1REPEAT 10?NOYESDisplayTOTALPASSEND MOEHR & MES 201418

One of the symbols has been incorrectly chosen. The logic of the flowchart is correct. Identifythe incorrect symbol by drawing an arrow next to it. Draw the correct symbol in the box below.[3](i)(ii)(iii)(iv)Which of the following gives information about the number of students having passed?APASSMARKBTOTALPASSCREPEATDMARKWhat is the final value of REPEAT?A9B10C11D12Which of the following shows the change that needs to be brought if the passingmark is increased by 5?APASSMARK 45BPASSMARK 55CREPEAT 5DREPEAT 15What would the final value of REPEAT be if the condition is changed toREPEAT 10?A9B10C11D12 MOEHR & MES 201419