Candidate’s Examination Number . THE UNITED REPUBLIC OF TANZANIA NATIONAL EXAMINATIONS COUNCIL FORM TWO SECONDARY EDUCATION EXAMINATION 0143 INFORMATION AND COMPUTER STUDIES Time: 2:30 Hours ‘Thursday, 04" December 2014 Instructions 1. This paper consists of sections A, B and C. 2. Answer alll questions in sections A, B and C. 3. All answers must be written in black or blue ink. 4. Write your answers in the space provided. J] © Cello hones and calculators are not allowed in the examination room. 6. Write your Examination Number at the top right comer of every page. FOR EXAMINERS’ USE ONLY ; QUESTION NUMBER | SCORE 7 T 2 3 7 3 7 =| TOTAL Page 1 of 8Candidate’s Examination Number .. SECTION A (40 Marks) Answer all questions in this section. For each of the following items (i) — (xx), choose the correct answer and write its letter in the box provided. (i) Which one of the following is not a computer system specification? A RAM B Cost C Processor speed D_ Hard disk capacity (ii) The output produced by computers after proce: A data B information C hardcopy D__ softeopy Gi) Which one of the following is not an example of an input device? A OCR B MICR Cc OMR D LCD (iv) A computer program which used to display information on the internet is called A gopher" B internet explore C google D_ browser (¥) One of the most useful features of the spreadsheets is the ability to ‘A__ perform normal calculations B create tables C__ perform statistical analysis D_ create worksheet (vi) On the keyboard, the key that is used to exit some programs is called special key delete key escape key function key vaw> Page 2 of 8 tsm2014Candidate’s Examination Number (vii) A communication device which forwards a packet directly to the address node without broadcasting is called A. gateway B_ repeaters C switches D__ bridges Integrated cireuits (VLSI)? A Fourth generation B_ Third generation C Second generation D First generation Which one of the following computer generation were characterised by Very Large Seale (ix) A computer program that controls the execution of user applications and enables the user to access hardware and software resources is known as A operating system B utility programs C special programs D_ application programs (x) An application software that enables a user to create, edit, format and print text document is called A spreadsheets B / electronic word processor C electronic publisher D_ workbook (xi) One of the latest radio transmission technologies that enables people to use hand communication devises to access the Internet is called A facebook B bluetooth C radio waves D_ blog (xii) Which one of the following is not a formatting attribute? A. Bolding B Copying CC Underlining D_ Malicising (xiii) Examples of transmission media used to connect devices to access internet are ‘A radio waves and cables B__ telephone lines and radio waves C_ microwave and cables D telephone lines and cables Page 3 of 8 tmsm2004 held(xiv) (wv) (xvi) (xvii) (xviii) (xix) (x) Candidate’s Examination Number .. Which of the following is an example of secondary source of information? Intemet communication on e-mail Audio recording Diaries Newspaper vow> A special programs that help the user to easily find any information on the internet is known as A browser B information locator C search programs D search engine ‘Computers that process discrete data are called A hybrid computers B digital computers C general computers D super computers Which one of the following is not example of application software? A Microsoft window B_ Microsoft access C Microsoft word D_ Microsoft Excel The following are examples of physical topology except A ethemet topology B star topology C bus topology D__ mesh tépology ‘Which one of the following are types of communication media? A Bound and unbound media B_ Wireless and unbound media C Bound and coaxial media D__ Unbound and microwave media ‘The editing tool that detects automatically wrongly spelled or capitalised word with the necessary word is known as A autocorrect B thesaurus C find and replace D_ autotext Page 4 of 8 w Lisl and replaces mam2038Candidate’s Examination Number .... Match the following descriptions of computer peripherals in List A to their corresponding computer hardware in List B by writing the letter of the response option below the item number in the table provided. = List A __] (@ A device which converts printed documents into electronic | A Daisy wheel printer text without having to retype them. B_ Digital camera (i) A_ printer which has removable flower-like wheel |© Dot matrix printer | consisting of spokes with embossed characters. : oatmeal (iii) A printer that is expensive to buy but cheap to run. F Laser printer (iv) Printers which are used in the point of sale terminals to] G Microphone print receipts and bar codes. H Mouse (v) A printer which is very expensive to run due to the higher I Photo printer cost of replacing the cartridges. J Plotters (vi) A device which looks like lever used to control a pointer | K Scanner on he sowen Eee (vil) A device that is used to enter data in form of speech in the |) Touch pad computer. (iii) A type of printer grouped into the impact printer that prints by striking its pins on the ribbon placed on the / paper. (ix) An input device which is usually found in a laptop. (x) Printers which are used to print geographical, architectural and engineering drawings ANSWERS. Lista | @) |G) Ti) Ta) [@ [ei [oi (i) [io Tw | List B I J For each of the following statements, write TRUE if the statement is correct or FALSE if the statem @ Gi) Git) (iv) w ent is not correct. A strong password should contain text only. ........ A highlighted text is copied by pressing Ctrl + C and pasted by pressing Ctrl + V. Grammar checker and autocorrect are the basi tools for checking whether the document has typographical or grammatical error. ... In Ms excel, if the formula “= B4*C4” is in the cell D4, the formula assigned to cell D5 is “= BS*C5”, Installation of fibre optic cables isnot difficult. Page 5 of 8Candidate’s Examination Number ... (vi) The ALU of a computer responds to the commands coming from control section. (vii) A scanner is one of the examples of output devices. : (viii) Increasing the computer memory exposes the computer virus infection. (Gx) Cold booting is a process of turning on a computer, which has been completely shut down. ..... (%) Voltage stabilizers help to protect computer against power scratches. SECTION B (40 Marks) Answer alll questions in this section. 4. (a) Complete each of the following sentences using one item from the given list. ‘Twisted pair cables, Unshielded twisted pair, Coaxial cables, Fibre optic cable, line cables Yv (i) .. are very stable even under high loads. (i) are fast and supports high bandwidth, (iii) use cheap installation equipment and readily available. (iv) do not have a shield that prevents an electric noise, (b) (Define the term computer. (Describe two types of computers secording to purpose or tsk. 5. (a) (i) State three application areas of electronic spreadsheets. Page 6 of 8Candidate’s Examination Number ......1.0+1++++ (ii) Give three advantages of electronic spreadsheets. ase pocus v sialic Rr aaaician |S” lonces a ET Raa 320000} | © (i) Give the name of the program used to create the snapshot above. (ii) State the type of the graph/ chart given in the snapshot above. (iv) What format was done for the cells in row (v) Write the function for calculating lowest gross pay. (vi) The national social security fund was calculated as 15% of the gross pay. Write the formula for calculating national social security fund. Page 7 of 8Candidate’s Examination Number ... (vii) Write the funetion for calculating the highest basic salary. } } (viii) Write the formula required to calculate the total transport allowance. SECTION C (20 Marks) 6. Describe five advantages of Internet in the society. Page 8 of 8 tem 2048