TANZANIA HEADS OF ISLAMIC SCHOOLS COUNCIL

FORM FOUR INTER ISLAMIC MOCK EXAMINATION

INFORMATION AND COMPUTER STUDIES 1

036/1 (For Both School and Private Candidates)

TIME: 3 HOURS Tuesday 29th August, 2023 p.m.

Instructions

1. This paper consists of Section A, B and C with a total of twelve (12) questions.
2. Answer all questions in section A, B and two questions in section C in answer sheet provided.
3. Calculator, cellular phones and any unauthorized materials are not allowed in the examination
room.
4. Write your examination number on every page of your answer booklet(s).

Page 1 of 7
 SECTION A (16 Marks)
Answer all questions in this section.
1. For each of the items (i) – (x), choose the correct answer from among the given alternatives
and write its letter beside the item number in the answer booklet provided.
i. Cell A4, A7, C4, C5 and C7 contain values 4,4,9,2 and 3 respectively. Then in cell
D78 a formula, =C5*(A4+A7) – (C4/C7) is entered. What will be the value of cell
D78?
A. 10
B. 12
C. 11
D. 13

ii. Communication channel between the user and application program that provides
information such as current page, current page, current section, total number of
pages, total number of words, the language used, current line number and current
column number.
A. Title bar
B. Menu bar
C. Document window
D. Status bar

iii. 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 video. What
type of presentation was used in relation to the devices used?
A. Multimedia presentation
B. Power point presentation
C. Visual and text presentation
D. Video and text presentation.

iv. 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 B C D E F

1 Computer Studies Task Scores

2 Name Task1 Task2 Task3 TOTAL AVERAGE

3 Jumma 44 39 25 108 36.0

4 Emilia 37 42 30 109 36.3

5 Koku 40 39 27 ########! 35.3

6 Betula 22 40 29 91 30.3

7 AVERAGE 35.8 40.0 27.8

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

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
Page 2 of 7
v. The circuit that provides a pathway that connects the various system components
A. PCMCIA channel
B. Bus
C. SCSI device
D. Information superhighway

vi. How would you explain the reasoning behind the term” monitor” being used to
refer to a display screen?
A. It displays the monitor lizard
B. It monitors users
C. It helps the user to track what is going on in the computer
D. It is television.

vii. Given a specific computer memory disk, can you accurately calculate the amount
of disk space that will occupied by the word “DAR”?
A. 3 bits
B. 6 bits
C. 17 bits
D. 24 bits

viii. What is your knowledge and experience with the scanning technology commonly
used in banks to accurately read and process the numbers located at the bottom of
checks?
A. MICR
B. OCR
C. OMR
D. GRE

ix. Can you demonstrate your knowledge of computer networking by correctly

identifying the term used to describe the global interconnection of computers?
A. WAN
B. Internet
C. Intranet
D. MAN

x. The information is communicated so that a recipient of the information has enough

time to decide appropriate actions based on the information received.
A. Reliability
B. Timeliness
C. Understandable
D. Relevant

Page 3 of 7
2. Match the description of landmasses given in LIST A with its corresponding responses in
LIST B by writing the letter of correct answer in answer booklet.

LIST A LIST B

i). Memory devices which are becoming unpopular due to A. Removal storage
the entry into market of affordable mass storage. B. PROM
ii). Memory storage whose content can be accessed and C. Flash disk
read but cannot be changed. D. Buffer storage
iii). The memory which can be written only once by the E. Register
user after which it cannot be changed again. F. Permanent storage
iv). Working storage that is used to hold instructions and G. ROM storage
data needed by the currently running application. H. Volatile storage
v). Non-volatile storage media that employs integrated I. Real storage
circuits rather than mechanical or optical technology. J. RAM storage
vi). Computer storage where data is written and read from K. Floppy disks
them uses a laser beam. L. Optical storage
M. Non- volatile storage
N. Digital Versatile Disks

SECTION B (54 Marks)

Answer all questions in this section.
3. Fill in the blanks with the following giving words. (5 marks)
HTML Closing website Markup
<body> Webpage image tag

i. A _________________ is a group of Webpages that are connected together.

ii. A _________________ is an instruction written in a text file that is given to the web
browser.
iii. A _________________ is part of a website that contains specific information.
iv. The _______________ tag contains all the contents of an HTML page, such as text, images,
videos and hyperlinks.
v.A tag can be an opening tag or a ______________________ tag.

4. (a)We cannot do anything and we cannot get correct message if there is no information in our
daily life, we can get information through different sources.
i. Mention sources of Information (1 mark)
ii. Define sources in 4(i) above and give two examples each. (4 marks)

(b) i. How we can explain communication media in our environment? (1 mark)

Page 4 of 7
 ii. With the help of diagram define the components of communication media
(3 marks)

5. In computer network Data Communication is very important. What is the meaning of the
following TERMS that are used in Data Communication? (@2 marks)
i. Bandwidth
ii. Attenuation
iii. Simplex transmission
iv. Baseband signal
v. Full duplex transmission.

6. A computer club keeps member information on a computer system (database). Part of the
member table in the database is as shown in the diagram below.
CODE SURNAME LOCATION SEX PHONE NO DOB

S 1001 MABUMBA TANGA F 56782 11/12/86

S 1011 KIUNDU MOSHI M 4523561 4/01/88

S 1025 GALIMOSHI DAR F 355123 15/05/86

S 1037 SEMAINDA MUHEZA M 406021 18/02/87

S 1057 NYENGE DODOMA M 123489 21/07/86

S 1075 TAUSI LINDI F 801267 09/02/88

S 1096 TEWA PWANI M 89541230 03/09/87

S 1102 TAMBAZA DAR M 3541239 22/04/88

S 1124 KARAKAYA ARUSHA M 5431291 14/04/86

S 1139 MWINYI MWANZA F 2090807 09/04/88

a) State how many fields are there in each record (1 mark)

b) State the data type that should be used for the code data (1 mark)
c) Give 2 reasons why the data in “sex” field has been coded (2 marks)
d) Which code data will be listed if (DOB < 01/01/87 and SEX = “M”) condition is set?
(2 marks)
e) Which field in the table should be used as a key field? Why? (2 marks)
f) How many records are in this table? (2 marks)

Page 5 of 7
7. The picture below shows the salary slips of BROUKESHIRE DAIRIES LTD. Answer the
following questions:

a) Name the software used to create the above picture (1 mark)

b) What is the name of the active cell? (1 mark)
c) Write the feature(s) used in row 1 and 2 to make the text appear as a single cell in
columns A-E. (1 mark)
d) Using appropriate functions:
i. Calculate the gross pay of Nancy. (1 mark)
ii. Calculate the total of Medical allowance which is above 5000. (2 marks)
iii. Determine the highest Salary and the lowest Gross Pay. (2 marks)
iv. How many employees get Salary above 30000 (2 marks)

8. a) In our environment nowadays we cannot escape the availability of multimedia. Can you
tell us how do you understand about multimedia? (1 mark)
b) List basic elements of Multimedia. (1 mark)
c) The World nowadays needs a lot of effort in order to make sure that there is enough
multimedia in order to simply life and communication in the society Briefly explain any four
points from the above statements about multimedia to the society. (4 marks)
d) Describe two types of multimedia content and give an example of each. (4 marks)

9. (a) What is Utility program? (1 mark)

(b) Defrag (defragmentation) and antivirus are two important utilities. Briefly describe their
functions. (2 marks)
(c) Put the following in order of their size, starting with the smallest. (4 marks)
Megabyte, Bit, Terabyte, Kilobyte, Gigabyte, Nibble, Byte and Petabyte

(d) With reference to Megabytes, Bytes and Kilobytes: State which of these units is most
appropriate for the following items data. (3 marks)

Page 6 of 7
  A one page text document
 A ten minute movie clip
 A person’s surname.

SECTION C (30 Marks)

Answer two (2) questions from this section.

10. Rapid development of technology has brought many positive impacts in the societies, but
also there are negative impacts. Explain five health hazards facilitated by the use of ICT.

11. During the development of computer, different scientists contributed much to make sure
that computers are portable. Hence we reached to a point of recognizing Charles Babbage as
a father of computer. With this context write an ESSAY based on history of computer,
explain computer evolution, explain why Charles Babbage is a father of computer and hence
discuss the five generations of computer based on time and used technology.

12. Hamis was invited to a certain school to present the effects of COVID- 19 to people health.
i. Describe any four factors he should consider before doing the presentation.

ii. Explain any four presentation skills he should have.

iii. State any two presentation methods and explain which one he should use

Page 7 of 7