State THREE factors to be considered when setting up a computer laboratory.
………………………………………………………………………………………………………
………………………………………………………………………………………………………
………………………………………………………………………………………………………
……………………………………………………………………………………………………….

A mobile phone is regarded as a computer. Give two reasons why.
………………………………………………………………………………………………………
………………………………………………………………………………………………………
………………………………………………………………………………………………………
………………………………………………………………………………………………………

What is the difference between a Gas Plasma Display and Liquid Crystal Display
…………………………………………………………………………………………………
…………………………………………………………………………………………………
…………………………………………………………………………………………………
………………………………………………………………………………………………….

In reference to CPU explain fetch-execute cycle
…………………………………………………………………………………………………
…………………………………………………………………………………………………
…………………………………………………………………………………………………
…………………………………………………………………………………………………
…………………………………………………………………………………………………

Give anyTHREE reasons why magnetic Ink Character recognition are too popular in banking
industry for processing cheques
…………………………………………………………………………………………………
…………………………………………………………………………………………………
…………………………………………………………………………………………………
………………………………………………………………………………………………….

Mention any THREE parameters that makes up the access time of storage media
…………………………………………………………………………………………………
…………………………………………………………………………………………………
…………………………………………………………………………………………………
…………………………………………………………………………………………………

………………………………………………………………………………………………….

Highlight the use of the following keys found on a standard keyboard.
a) Esc
…………………………………………………………………………………………………
…………………………………………………………………………………………………
b) Home
…………………………………………………………………………………………………
…………………………………………………………………………………………………

a) Define a candidate key (1 mark)
…………………………………………………………………………………………………
…………………………………………………………………………………………………
b) Describe anyTHREE data integrity constraints in a database. (3 marks)
…………………………………………………………………………………………………
…………………………………………………………………………………………………
…………………………………………………………………………………………………
…………………………………………………………………………………………………
…………………………………………………………………………………………………
…………………………………………………………………………………………………
…………………………………………………………………………………………………
………………………………………………………………………………………………….

MrMatano is a teacher at Kassu High school and wishes to use Spreadsheet to process the
marks obtained by his students during the term. The worksheet below shows the details used.

NB:CAT -1 and CAT -2 are out of 15 marks each and EXAM is out of 70 marks
a) Write a function that displays “PASSED” when the total marks is >60 otherwise display “FAIL”.
(2 marks)
…………………………………………………………………………………………………………
…………………………………………………………………………………………………………
…………………………………………………………………………………………………………
b) Write a function that arranges the students according to their performance (2marks)
…………………………………………………………………………………………………………
…………………………………………………………………………………………………………

State any TWO duties of a database administrator
…………………………………………………………………………………………………………
…………………………………………………………………………………………………………
…………………………………………………………………………………………………………
………………………………………………………………………………………………………….

A student in KASSUHigh School was working with computer using windows operating
system. After sometime he started experiencing the following problems.
- The computer failing to load the operating system during the booting process.
- The computer hangs (stops responding) now and then.
- Abnormal restarting.
- Displays a blue screen with the message such as fatal exception error has occurred.
State any TWO possible causes of the above problems?
…………………………………………………………………………………………………………
…………………………………………………………………………………………………………
…………………………………………………………………………………………………………
…………………………………………………………………………………………………………

List any THREE ways in which ICT can be used to enhance security in a supermarket.
…………………………………………………………………………………………………………
…………………………………………………………………………………………………………
…………………………………………………………………………………………………………
…………………………………………………………………………………………………………

Mention any TWO components of an expert system
…………………………………………………………………………………………………………
…………………………………………………………………………………………………………
…………………………………………………………………………………………………………

State any TWO negative impacts of ICT on the environment
…………………………………………………………………………………………………………
…………………………………………………………………………………………………………
…………………………………………………………………………………………………………
…………………………………………………………………………………………….....................

State what should beconsidered when carrying out requirement analysis for selecting a
computer system?
…………………………………………………………………………………………………………
…………………………………………………………………………………………………………
…………………………………………………………………………………………………………
………………………………………………………………………………………………………….

A lecturer is in need of calculating the percentage mark for individual students who took two
CATs that were marked out of 30 marks each, for a class of 150 students and grade the student as
follows.
- Marks from 95 and above, one would get grade ‘A’
- Marks from 80 and above, one would get grade ‘B’
- Marks from 60 and above, one would get grade ‘C’
- Marks from 50 and above, one would get grade ‘D’
- Anyone whose score is less that 50, would get a ‘F’
a. Draw a flowchart that can be used to compute the percentage markand output Grade for each
student. (8marks)

b. Write a pseudo code for the above flow chart. (7marks)

(a) Do the binary calculations in binary numbers (2marks)
i. 11101.0011₂+ 101.011₂
ii. 101001.10101₂-110.01101₂
iii. Using twos complement, perform the following calculation leaving your answer in decimal
number. (4marks)
23₁₀ - 41₁₀

iv. Determine the BCD representation of (- 89010) (2marks)
(a) With a relevant example Distinguish between the following terms as used in data processing.
(i) Online processing and real time processing. (2marks)
…………………………………………………………………………………………………………
…………………………………………………………………………………………………………
…………………………………………………………………………………………………………
…………………………………………………………………………………………………………
(ii) Backup file and Archive file. (2marks)
…………………………………………………………………………………………………………
…………………………………………………………………………………………………………
…………………………………………………………………………………………………………
…………………………………………………………………………………………………………
(b) (i)During manual data entry, the data entry clerks need to verify and validate their data to
ensure that it is free from errors. Define the term error as used in this context (1 mark)
…………………………………………………………………………………………………………
…………………………………………………………………………………………………………
(ii) In an exam, where the subject marks for each student was summed and the mean calculated from
the sum, the students realized that their marks were inaccurate by a fraction of the mean
mark.Likewise a great difference between the actual class mean and the sum of the recorded
mean mark.
Describe any two types of errors that may have caused the difference between the recorded mean
marks and the actual mean marks. (2 marks)
…………………………………………………………………………………………………………
…………………………………………………………………………………………………………
…………………………………………………………………………………………………………
…………………………………………………………………………………………………………

(a) Prime systems Ltd. is a record label company. It wishes to introduce a computerized system,
so it has asked a team of consultants to investigate the possibility.
i. The consultants first carried out an initial study and produced a feasibility report.
Explain the purpose of a feasibility report (2marks)
…………………………………………………………………………………………………………
…………………………………………………………………………………………………………
…………………………………………………………………………………………………………
…………………………………………………………………………………………………………
…………………………………………………………………………………………………………
…………………………………………………………………………………………………………
ii. Give TWO reasons why some clerical staff at Prime systems Ltd. might have been
worried with the prospect of computerization. (2marks)
…………………………………………………………………………………………………………
…………………………………………………………………………………………………………
…………………………………………………………………………………………………………
…………………………………………………………………………………………………………
…………………………………………………………………………………………………………
(b) State the stage at which the following activities are performed in system development lifecycle
(3marks)
(i) Flowcharting.
…………………………………………………………………………………………………………
………………………………………………………..………………………………………………….
(ii) Staff training
………………………………………………………………….………………………………………
…………………………………………………………………………………………………………
(iii) Changeover
………………………………………………………………………….………………………………
…………………………………………………………………………………………………………
(c) (i) What is pilot running in system development? (1mark)
…………………………………………………………………………………………………………
……………………………………………………………………..……………………………………
…………………………………………………………………………………………………………..

(ii) State TWO circumstances under which pilot strategy may be used during system
changeover. (2marks)
…………………………………………………………………………………………….……………
…………………………………………………………………………………………………………
…………………………………………………………………………………………………………
…………………………………………………………………………………………………………
…………………………………………………………………………………………………………
…………………………………………………………………………………………………………
(d) (i ) State THREE disadvantages of observation method of information gathering (3marks)
…………………………………………………………………………………………………………
…………………………………………………………………………………………………………
…………………………………………………………………………………………………………
…………………………………………………………………………………………………………
…………………………………………………………………………………………………………
…………………………………………………………………………………………………………
…………………………………………………………………………………………………………
(ii) Explain the importance of using automated methods of fact finding (2marks)
…………………………………………………………………………………………………………
…………………………………………………………………………………………………………
…………………………………………………………………………………………………………
…………………………………………………………………………………………………………
…………………………………………………………………………………………………………

a) Describe the following wireless communication devices (6 marks)
i. Access point (AP)
…………………………………………………………………………………………………………
…………………………………………………………………………………………………………
…………………………………………………………………………………………………………
ii. Wireless Antenna
…………………………………………………………………………………………………………
…………………………………………………………………………………………………………
…………………………………………………………………………………………………………
iii. PCMCIA cards
…………………………………………………………………………………………………………
…………………………………………………………………………………………………………
…………………………………………………………………………………………………………

b) Explain the following (4marks)
i. Search engine
…………………………………………………………………………………………………………
…………………………………………………………………………………………………………
…………………………………………………………………………………………………………
ii. Web browser
…………………………………………………………………………………………………………
…………………………………………………………………………………………………………
…………………………………………………………………………………………………………
c) The diagram below shows an e-mail extract.

What is purpose of the following folders? (2 marks)
a) Junk
………………………………………………………………………………………………………
………………………………………………………………………………………………………
………………………………………………………………………………………………………
b) Drafts
………………………………………………………………………………………………………
………………………………………………………………………………………………………
………………………………………………………………………………………………………
d) Differentiate between Pasteboard, master page and printable area as used in desktop publisher.
(3marks)
…………………………………………………………………………………………………………
…………………………………………………………………………………………………………
…………………………………………………………………………………………………………
…………………………………………………………………………………………………………
…………………………………………………………………………………………………………
…………………………………………………………………………………………………………

a) Explain each of the following type of operating systems (4marks)
i. Distributed
…………………………………………………………………………………………………………
…………………………………………………………………………………………………………
…………………………………………………………………………………………………………
ii. Multi-user.
…………………………………………………………………………………………………………
…………………………………………………………………………………………………………
…………………………………………………………………………………………………………
b) List any TWO types of embedded operating systems used in modern cell phones (2marks)
…………………………………………………………………………………………………………
…………………………………………………………………………………………………………
…………………………………………………………………………………………………………
c) Mostoperatingsystemsprovide afilesystem. Mention any TWO file systems used in windows
environment. (2 marks)
…………………………………………………………………………………………………………
…………………………………………………………………………………………………………
…………………………………………………………………………………………………………d)
(i) Mwangingi an IT expert would like to create tableofcontents for his 50 page dossier. Explain to
him how he could do this. (3marks)
…………………………………………………………………………………………………………
…………………………………………………………………………………………………………
…………………………………………………………………………………………………………
…………………………………………………………………………………………………………
…………………………………………………………………………………………………………
(ii) As an IT expert, explain how a 20 page document can be formatted to have first five pages
numbered i,ii,iii,iv,v while the remaining pages numbered from1,2,3,4….15. (4marks)
…………………………………………………………………………………………………………
…………………………………………………………………………………………………………
…………………………………………………………………………………………………………
…………………………………………………………………………………………………………
…………………………………………………………………………………………………………
…………………………………………………………………………………………………………