Find this and other free resources at:

[Link]

THE UNITED REPUBLIC OF TANZANIA

NATIONAL EXAMINATIONS COUNCIL OF TANZANIA
CERTIFICATE OF SECONDARY EDUCATION EXAMINATION
036/1 INFORMATION AND COMPUTER STUDIES 1
(For Both School and Private candidates)
Time: 3 Hours Year: 2020

Instructions

1. This paper consists of section A, B and C with total of twelve (12) questions.

2. Answer all questions in section Aand B, and one (1) question from section C.

3. Section A carries fifteen (15) marks, section B carries seventy five (75) marks and

section C carries ten (10) marks.

4. Cellular phones, and any unauthorized materials are not allowed in the examination

room.

5. Write your Examination Number on every page of your answer booklet (s).

Page 1 of 8
Find this and other free resources at:
[Link]
 Find this and other free resources at:
[Link]

SECTION A (15 marks)

Answer all questions in the section
1. Choose the correct answers among the given alternatives (A-E):
i) The following are physical network topologies except
A. ring topology.
B. ethernet topology.
C. bus topology.
D. star topology.
E. mesh topology.
ii) Which technology was used in the fifth computer generations?
A. Large Scale Integrated.
B. Vacuum tubes.
C. Transistors
D. Artificial intelligence.
E. Thermionic valves.
iii) Identify the correct data type in the field of gender in a given figure which is
shown in a drop down list of M for male and F for female.

A. Attachment.
B. Memo.
C. Lookup Wizard.
D. Hyperlink.
E. Yes/No.

Page 2 of 8
Find this and other free resources at:
[Link]
 Find this and other free resources at:
[Link]

iv) Suppose you want to find and download computer studies books from the
internet, which program would you use?
A. Google search engine
B. Mozilla Firefox
C. Google chrome
D. Web browser
E. Internet explorer
v) Which action enables a word processor to capture information?
A. Copy and paste
B. Cut and copy
C. Cut and paste
D. Copy and insert
E. Cut and save.
vi) What does the th tag in HTML emphasizes?
A. Italic text
B. Bold text
C. Coloured text
D. Underline text
E. Enlarge text.
vii) Identify the type of malicious program that duplicates itself, blocking the
computer memory and storage. The given options were;
A. Virus.
B. Firmware.
C. Trojan horse.
D. Worm.
E. Spam.
viii) Amina was rewarded with a computer game DVD during her birthday. In
Page 3 of 8
Find this and other free resources at:
[Link]
 Find this and other free resources at:
[Link]

which category does this gift fall?

A. Entertainment software and storage device.
B. Utility software and storage device.
C. Application software and storage device.
D. System software and storage device.
E. Firmware software and storage device.
ix) A school debate club invited speakers to address issues of gender and
HIV/AIDS in the school assembly hall. Speakers used a microphone, a
computer and a projector to demonstrate their presentation through animations
and videos. What type of presentation was used in relation to the devices
used?
A. Audio and sound presentation
B. Video and text presentation
C. Visual and text presentation
D. Multimedia presentation
E. Power point presentation
x) The following spreadsheet was prepared to show the results of the students
who did three different tasks. In cell E5 an error occurred. What might be the
reason?

A. The column is not wide enough to accommodate the value.

Page 4 of 8
Find this and other free resources at:
[Link]
 Find this and other free resources at:
[Link]

B. The formula references an invalid intersection of cells.

C. The formula uses incorrect argument or operator.
D. The reference to a value is not available to a formula.
E. There is invalid cell referencing in the formula used.
2. Match the functions of desktop publishing (DTP) tools in List A to their
corresponding tool names in List B by writing the letter of the correct response
beside the item number in the answer booklet provided.

LIST A LIST B
i) A tool which is used for magnifying A. Shapes tool
publications view. B. Objects tool
ii) A tool which is used to turn around text or C. Rotate tool
graphics. D. Select image tool
iii) A tool which you can use to draw passage E. Select tool
frames, insert and manipulate pages F. Texted tool
iv) A tool which can be used to pick, none and G. Zoom tool
resize images and text H. Text tool
v) A tool which is used to draw basis figures and
importing objects

SECTION B (75 marks)

Answer all questions from this section
3. Re-arrange the given sentences in a sequential order beginning with the first step to
the last step.
A. Click OK button.
B. Click print preview.
Page 5 of 8
Find this and other free resources at:
[Link]
 Find this and other free resources at:
[Link]

C. Click print from the file menu.

D. Open a document to be printed.
E. Select the printer.
4. (a) Explain the importance of information in our daily life, with examples
(b) Explain two ways of disseminating information with examples.
5. (a) Explain three possible types of database model he/she could develop when
designing a school database.
(b) State steps to follow in order to establish the relationship between two or more
tables in the opened database.
6. Read the given screenshot and answer the questions that followed:

(a) What is the name of a processor available at Nyangaluka Company?

(b) What are the sizes of primary memory and secondary memory offered by a
company? (c) Assume you have requested a member of Nyangaluka Company
to install for you Window 7 instead of UNIX operating system. What four
benefits do you expect to get on the use of such operating system?

7. The JJ Company which deals with home theatre system has four offices in three
different cities: Dar es Salaam, Mwanza and Dodoma. The Head of Department
decided to connect all these offices through a network. However, he does not know
Page 6 of 8
Find this and other free resources at:
[Link]
 Find this and other free resources at:
[Link]

the type of network to use.

(a) Explain to the Head of Department three types of computer networks you know
and suggest the proper type of network to be established.
(b) Provide one advantage and one disadvantage of the type of network suggested
in part (a).

8. (a) An academic master of your school asked you to prepare an end of term
students' academic report using Microsoft Word. The report intends to include the
table which shows different subjects and scored marks. As an IT student;
i) Which steps would you follow to insert a table with 10 rows and 7 columns?
ii) If after creating a table in part (a) (i), you realized that, the word computer is
typed komputa; which feature can you use to check and correct automatically
other mistakes made?
(b) Differentiate "autoText" from "autoComplete" as used in Microsoft Word.

9. Suppose you have been sent by your parent to buy some of the household items
from the shop. In order to make a clarification about the purchases, you decided to
use the following worksheet for simplicity.

(a) Which function would you apply to find the cost of sugar?
Page 7 of 8
Find this and other free resources at:
[Link]
 Find this and other free resources at:
[Link]

(b) Which function will you use to find the lowest cost for all items bought?
(c) Which function can be applied to count the number of cells that costs Tsh. 100
per item?
(d) If the price of all items has been increased by 10%, which formula would you
use in cell E2 in order to calculate the new cost of sugar?
HINT: (The increased price should be absolute reference).
(e) Assume your parent wants to know the increased cost, which functions and
formula can you use to accomplish this task?
10. Explain five factors to be considered in order to prepare a quality presentation.

SECTION C ( 10 marks)
Answer one (1) questions from this section
11. Describe four measures that could be taken to protect a computer from damage.
12. Explain four virtual (effective) services enhanced by the use of internet in the
society today.

Page 8 of 8
Find this and other free resources at:
[Link]