PRESIDENT’S OFFICE

REGIONAL ADMINISTRATION AND LOCAL GOVERNMENT

INFORMATION AND COMPUTER STUDIES
MASTERING EXAMINATION KILAKALA - 2020
FORM II

Time: 2:30 hours

INSTRUCTIONS:
 This paper consists of two sections A, B and C
 Answer ALL questions
 All answers should be written in the spaces provided in this question paper

FOR EXAMINER’S USE ONLY

QUESTION NUMBER SCORE INITIALS OF EXAMINER

1
2

10

TOTAL

Page 1 of 8
 SECTION A: (20 MARKS)
1. Choose the most correct answer for each of the following questions and encircle your
answer around the
correct letter.

i). Which of the following commands moves the pointer to another location onscreen?
A. Pressing the arrow keys on the keyboard.
B. Moving the mouse until the pointer points to that spot.
C. Moving the mouse until the pointer points to that spot and click the left mouse button.
D. Moving the mouse until the pointer points to that spot and click the right mouse button.

ii). The speed of a CPU is measured in what?

A. Megahertz (MHz) and gigahertz (GHz)
B. Horsepower
C. Bits per second (Bps)
D. Lux

iii).Which of the following can you read and write to many times?
A. CD-ROM
B. CD-R
C. CD-RW
D. DVD-ROM

iv). The following keys are in the typing section apart from one:
A. Backspace
B. Spacebar
C. Delete
D. F2

v).You are thinking about buying Tsh. 50,000 million house. What function can help you
calculate your monthly payments?
A. SUM
B. IF
C. PMT
D. COUNT

vi). A computer can be defined as:

A. An electronic device that can process data into information
B. A device that can solve problems by executing a special set of instructions
C. A time keeping device
D. None of the above

vii). The following statements are true about data except one:
A. Data are raw facts collected about a topic on certain area
B. Data is meaningful to the user
C. Data needs processed in order to make meaning out of it
D. All the above

viii). Information is useful because:

A. It can be used as a basis for decision making
B. It can be spread throughout the world
C. It can be shared by different people
D. None of the above

Page 2 of 8
 ix). MICR stands for
A. Magnetic Ink Character Reader
B. Magnetic Ink Code Reader
C. Magnetic Ink Cases Reader
D. None

x).Who designed the first electronics computer – ENIAC?

A. Van-Neumann
B. Joseph M. Jacquard
C. Presper Eckert and John W Muchly
D. Bill Gates

ANSWERS
i ii iii iv v vi vii viii ix x

2. Write “T” for a true statement and “F” for a false statement in the space provided.
i). You can read and write to a computer’s ROM________
ii). Hardware is any software that is installed on a computer’s hard disk________
iii).A floppy disk is more expensive than a hard disk________
iv).Laser printer is an example of impact printers________
v). Memory which the CPU has direct access is Secondary storage________

3. Match the item in the LIST A write it’s number to the space provided in the LIST B.
LIST A LIST B
i. Worksheet A. Shows the data/formula/phrase in the cell selected
ii. Cell B. Formulas built into Excel
iii. Name Box C. The cell/table selected
iv. Formula Bar D. Used to rename cells/tables
v. Functions E. An Excel file
F. A working area within an Excel file
G. The menu bar at the top of Excel
H. A rectangular box in a worksheet to contain data

ANSWER

i ii iii iv v

SECTION B (60 MARKS)

Page 3 of 8
 SHORT ANSWER QUESTIONS
4. Fill in the Blanks using the words/phrases in the table below
Software, Input, Purpose, data handling technique, Notebooks, Control unit,
arithmetic and logic unit, register, Integrated circuits, functionality, Personal
Digital Assistant, Vacuum tube, Slide ruler , Size

i). The basic component of first generation computer was __________.

ii). Keyboard is an __________ device.
iii). Laptops are also known as __________.
iv). Computers can be classified according to __________, ____________, and __________.
v). The invention of logarithms influenced the development of __________.
vi). Third generation computers were __________ based machines.
vii). PDA stands for __________.
viii). Instructions to the computers are given in the form of computer program, which constitute
the __________.
ix). The central processing unit consists of three main subsystems, namely, ______________
and __________.
x). Backup __________________________.
5. a) Mobile telephones are used for accessing the internet. Give two advantages and three
disadvantages of using a mobile telephone rather than using a PC to access the internet.
Advantages
…………………………………………………………………………………………………
…………………………………………………………………………………………………
Disadvantages
…………………………………………………………………………………………………
…………………………………………………………………………………………………
…………………………………………………………………………………………………
b) What is operating system?
…………………………………………………………………………………………………
…………………………………………………………………………………………………
…………………………………………………………………………………………………
c) Explain briefly four types of operating system
…………………………………………………………………………………………………
…………………………………………………………………………………………………
…………………………………………………………………………………………………
………………………………………………………………………………………………....

Page 4 of 8
 d) Mention three factors when you want to buy operating system for your computer
…………………………………………………………………………………………………
…………………………………………………………………………………………………

6. i) a) Define an input device.

……………………………………………………………………………………………………
……………………………………………………………………………………………………
……………………………………………………………………………………………………
b) Other than scanning devices, name four other input devices.
……………………………………………………………………………………………………
……………………………………………………………………………………………………
……………………………………………………………………………………………………
……………………………………………………………………………………………………
ii) Differentiate between the following terms as used in ICS
a) Download and Upload
…………………………………………………………………………………………………
…………………………………………………………………………………………………
…………………………………………………………………………………………………
b) Attachment and Hyperlink
…………………………………………………………………………………………………
…………………………………………………………………………………………………
…………………………………………………………………………………………………

c) Information and information sources

…………………………………………………………………………………………………
…………………………………………………………………………………………………
…………………………………………………………………………………………………
…………………………………………………………………………………………………

d) Tick whether the following statements apply to RAM or apply to ROM

RAM ROM
This memory can only be read from not written to
This memory is not volatile
This memory is used to store the data the user is currently working on
This memory is used to store the startup instructions of a computer

7. i) Distinguish between a workbook and a worksheet

…………………………………………………………………………………………………
…………………………………………………………………………………………………
…………………………………………………………………………………………………

ii) Why charts are useful in Excel? Give any three chart types available in Excel
…………………………………………………………………………………………………
…………………………………………………………………………………………………
…………………………………………………………………………………………………

iii) If cells: A1=90 A2=85 A3=80 A4=75 A5=75. What will be your formula if you are going to
get the average?
…………………………………………………………………………………………………
……

Page 5 of 8
iv) If cells: A1=90 A2=85 A3=80 A4=75 A5=75. What will be your formula if you are going
to get the total?

…………………………………………………………………………………………………

v) Get the remarks in cell E10 that valued 75 which noted, if the remarks will be higher than
74, the remarks will be "PASSED" or else "FAILED".

…………………………………………………………………………………………………

8. a) What is cable as used in computer network?

…………………………………………………………………………………………………
b) Mention three cable types and two features of each type of a cable you mentioned
i………………………………………………………………………………………………
…………………………………………………………………………………………………
…………………………………………………………………………………………………
ii………………………………………………………………………………………………
…………………………………………………………………………………………………
…………………………………………………………………………………………………
iii………………………………………………………………………………………………
…………………………………………………………………………………………………
…………………………………………………………………………………………………
c) Mention three factors to consider choosing a kind of cable to be used in network
…………………………………………………………………………………………………
…………………………………………………………………………………………………
…………………………………………………………………………………………………

9. Study very careful the word processor window bellow and label all parts showing with
arrows

Page 6 of 8
 SECTION C: (20 MARKS)
Essay question
10. Explain five factors which hindered effective communication.
…………………………………………………………………………………………………………
…………………………………………………………………………………………………………
…………………………………………………………………………………………………………
…………………………………………………………………………………………………………
…………………………………………………………………………………………………………
…………………………………………………………………………………………………………
…………………………………………………………………………………………………………
…………………………………………………………………………………………………………
…………………………………………………………………………………………………………
…………………………………………………………………………………………………………
…………………………………………………………………………………………………………
…………………………………………………………………………………………………………
…………………………………………………………………………………………………………
…………………………………………………………………………………………………………
…………………………………………………………………………………………………………
…………………………………………………………………………………………………………
…………………………………………………………………………………………………………
…………………………………………………………………………………………………………
…………………………………………………………………………………………………………
…………………………………………………………………………………………………………
…………………………………………………………………………………………………………
…………………………………………………………………………………………………………
…………………………………………………………………………………………………………
…………………………………………………………………………………………………………
…………………………………………………………………………………………………………
…………………………………………………………………………………………………………
…………………………………………………………………………………………………………
…………………………………………………………………………………………………………
…………………………………………………………………………………………………………
…………………………………………………………………………………………………………
…………………………………………………………………………………………………………
…………………………………………………………………………………………………………
…………………………………………………………………………………………………………
…………………………………………………………………………………………………………
…………………………………………………………………………………………………………
…………………………………………………………………………………………………………
…………………………………………………………………………………………………………
…………………………………………………………………………………………………………
…………………………………………………………………………………………………………
…………………………………………………………………………………………………………
…………………………………………………………………………………………………………
…………………………………………………………………………………………………………
…………………………………………………………………………………………………………
…………………………………………………………………………………………………………
…………………………………………………………………………………………………………
…………………………………………………………………………………………………………
…………………………………………………………………………………………………………
…………………………………………………………………………………………………………
…………………………………………………………………………………………………………
…………………………………………………………………………………………………………
................................................................................................................................................................

Page 7 of 8
…………………………………………………………………………………………………………
…………………………………………………………………………………………………………
…………………………………………………………………………………………………………
…………………………………………………………………………………………………………
…………………………………………………………………………………………………………
…………………………………………………………………………………………………………
…………………………………………………………………………………………………………
…………………………………………………………………………………………………………
…………………………………………………………………………………………………………
…………………………………………………………………………………………………………
…………………………………………………………………………………………………………
…………………………………………………………………………………………………………
…………………………………………………………………………………………………………
…………………………………………………………………………………………………………
…………………………………………………………………………………………………………
…………………………………………………………………………………………………………
…………………………………………………………………………………………………………
…………………………………………………………………………………………………………
…………………………………………………………………………………………………………
…………………………………………………………………………………………………………
…………………………………………………………………………………………………………
…………………………………………………………………………………………………………
…………………………………………………………………………………………………………
…………………………………………………………………………………………………………
…………………………………………………………………………………………………………
…………………………………………………………………………………………………………
…………………………………………………………………………………………………………
…………………………………………………………………………………………………………
…………………………………………………………………………………………………………
…………………………………………………………………………………………………………
…………………………………………………………………………………………………………
…………………………………………………………………………………………………………
…………………………………………………………………………………………………………
…………………………………………………………………………………………………………
…………………………………………………………………………………………………………
…………………………………………………………………………………………………………
…………………………………………………………………………………………………………
…………………………………………………………………………………………………………
…………………………………………………………………………………………………………
…………………………………………………………………………………………………………
…………………………………………………………………………………………………………
…………………………………………………………………………………………………………
…………………………………………………………………………………………………………
…………………………………………………………………………………………………………
…………………………………………………………………………………………………………
…………………………………………………………………………………………………………
…………………………………………………………………………………………………………
…………………………………………………………………………………………………………
…………………………………………………………………………………………………………
…………………………………………………………………………………………………………
................................................................................................................................................................

Page 8 of 8