Give importance of having the following in computer laboratory;-
i) Standard furniture in the laboratory
………………………………………………………………………………………………………………
………………………………………………………………………………………………………………
ii) Antiglare screen/ monitor
………………………………………………………………………………………………………………
………………………………………………………………………………………………………………
iii) UPS
………………………………………………………………………………………………………………
………………………………………………………………………………………………………………

Distinguish between ROM and RAM
………………………………………………………………………………………………………………
………………………………………………………………………………………………………………

Explain the following computer crimes
(i) Fraud.
………………………………………………………………………………………………………………
………………………………………………………………………………………………………………
(ii) Alteration
………………………………………………………………………………………………………………
………………………………………………………………………………………………………………

(a) Define
(i) Firewalls (1mark)
………………………………………………………………………………………………………………
………………………………………………………………………………………………………………
(ii) Data encryption (1mark)
………………………………………………………………………………………………………………
………………………………………………………………………………………………………………

Differentiate between the following terms as used in word processing
(a) Drop Cap and Case
………………………………………………………………………………………………………………
………………………………………………………………………………………………………………
(b) Superscript and subscript
………………………………………………………………………………………………………………
………………………………………………………………………………………………………………

(a) State and explain any one type of computer processing file (1mark)
………………………………………………………………………………………………………………
………………………………………………………………………………………………………………
(b) List any two file organization methods (2marks)
………………………………………………………………………………………………………………
………………………………………………………………………………………………………………

Describe the following terms as used in internet.
(a) Webpage (1mark)
………………………………………………………………………………………………………………
………………………………………………………………………………………………………………
(b) Blog (1mark)
………………………………………………………………………………………………………………
………………………………………………………………………………………………………………
(c) Hyperlinks (1mark)
………………………………………………………………………………………………………………
………………………………………………………………………………………………………………
(d) Web portal (1mark)
………………………………………………………………………………………………………………
………………………………………………………………………………………………………………

(a) Give four advantages of DTP over a word processor (2marks)
………………………………………………………………………………………………………………
………………………………………………………………………………………………………………
(b) Differentiate between the following
(i) Kerning and tracking (2marks)
………………………………………………………………………………………………………………
………………………………………………………………………………………………………………
(ii) Margins and column guides (2marks)
………………………………………………………………………………………………………………
………………………………………………………………………………………………………………

Define the term simulation
………………………………………………………………………………………………………………
………………………………………………………………………………………………………………

Differentiate between baseband and broadband signal as used in networking
a) Baseband signal
………………………………………………………………………………………………………………
………………………………………………………………………………………………………………
b) Broadband signal
………………………………………………………………………………………………………………
………………………………………………………………………………………………………………

Explain how the operating system controls the following resources
i) Processor
………………………………………………………………………………………………………………
………………………………………………………………………………………………………………
ii) Main memory
………………………………………………………………………………………………………………
………………………………………………………………………………………………………………
iii) Input and output devices
………………………………………………………………………………………………………………
………………………………………………………………………………………………………………

What is deadlock in reference to operating systems
………………………………………………………………………………………………………………
………………………………………………………………………………………………………………

(a) The most popular type of electronic data storage currently us magnetic disk storage such as hard disk or Winchester disk. Give reasons as to why they are popular. (2marks)
………………………………………………………………………………………………………………
………………………………………………………………………………………………………………
………………………………………………………………………………………………………………
………………………………………………………………………………………………………………
(b) Outline two advantages of hard disk over floppy disk. (2marks)
………………………………………………………………………………………………………………
………………………………………………………………………………………………………………

Define the following computer crimes
a) Piracy (1mark)
………………………………………………………………………………………………………………
………………………………………………………………………………………………………………
b) Industrial espionage (1mark)
………………………………………………………………………………………………………………
………………………………………………………………………………………………………………

Explain two ways of protecting data and information against unauthorized access
………………………………………………………………………………………………………………
………………………………………………………………………………………………………………

(a) list two examples of
(i) Third generation languages (2marks)
………………………………………………………………………………………………………………
………………………………………………………………………………………………………………
(ii) Object oriented languages (2marks)
………………………………………………………………………………………………………………
………………………………………………………………………………………………………………
(b) Define (2marks)
i) Object code
………………………………………………………………………………………………………………
………………………………………………………………………………………………………………
ii) Source code
………………………………………………………………………………………………………………
………………………………………………………………………………………………………………
(c) Differentiate between a compiler and an interpreter (2marks)
………………………………………………………………………………………………………………
………………………………………………………………………………………………………………
(e) A car rental firm leases its cars for Kshs. 2500.00 per day. The manager gives a discount based on the number of days that the car is rented. If the rental period is greater than or equals to 7 days then a 25% discount is given. Write a peudocode to accept a car number and the rental period, and calculate the total amount earned by the company when a car is leased. (7marks)

(a) Subtract 0111₂ from 1001₂ (2marks)
………………………………………………………………………………………………………………
………………………………………………………………………………………………………………
………………………………………………………………………………………………………………
………………………………………………………………………………………………………………
(b) Using two’s compliment, subtract 7 from 4 and give the answer in binary notation. (4marks)
………………………………………………………………………………………………………………
………………………………………………………………………………………………………………
………………………………………………………………………………………………………………
………………………………………………………………………………………………………………
(c) Convert
i) 91C₁₆ to octal (3marks)
………………………………………………………………………………………………………………
………………………………………………………………………………………………………………
………………………………………………………………………………………………………………
………………………………………………………………………………………………………………
ii) 377₈ to hexadecimal (3marks)
………………………………………………………………………………………………………………
………………………………………………………………………………………………………………
………………………………………………………………………………………………………………
………………………………………………………………………………………………………………
iii) 9.625₁₀ to binary (3marks)
………………………………………………………………………………………………………………
………………………………………………………………………………………………………………
………………………………………………………………………………………………………………
………………………………………………………………………………………………………………

A school computer laboratory is scheduled to undergo major renovations. The lab is schedule to receive new computer whose specifications are given below:-
Pentium IV 2.8GHz processor
40GB HDD
3 ½ FDD
256MB RAM
56 x CD ROM
17” SVGA TFT monitor
The computers are going to be networked and will be able to browse the internet.

a) Explain what is meant by the terms:- (2marks)
i) FDD
………………………………………………………………………………………………………………
………………………………………………………………………………………………………………
ii) HDD
………………………………………………………………………………………………………………
………………………………………………………………………………………………………………
iii) SVGA
………………………………………………………………………………………………………………
………………………………………………………………………………………………………………
iv) TFT
………………………………………………………………………………………………………………
………………………………………………………………………………………………………………
b) The computer is to be networked, name one extra device that should be fitted on every computer to
enable this to happen (1mark)
………………………………………………………………………………………………………………
………………………………………………………………………………………………………………
c) The computer is to receive internet facilities through the server on a dial; up system. Name and describe
the function of a special device that needs to be connected to the server to complete the connection.
(1mark).
………………………………………………………………………………………………………………
………………………………………………………………………………………………………………
d) (i) The school has to apply star topology to link up the computer. List two advantages of this type of
topology. (1mark)
………………………………………………………………………………………………………………
………………………………………………………………………………………………………………
(ii) Name the central device used to connect the computers in this topology. (1mark)
………………………………………………………………………………………………………………
………………………………………………………………………………………………………………
e) List two other types of topologies that the school could have opted for (1mark)
………………………………………………………………………………………………………………
………………………………………………………………………………………………………………
f) List four advantages of using a network (2marks)
………………………………………………………………………………………………………………
………………………………………………………………………………………………………………

g) (i) Data transmission via the internet is done using a mode known as packet switching. Describe this
data transmission mode (1mark)
………………………………………………………………………………………………………………
………………………………………………………………………………………………………………
(ii) Name two other modes of transmission (1mark)
………………………………………………………………………………………………………………
………………………………………………………………………………………………………………
h) (i) The school’s LAN is done using UTR cable. List two advantages of using this type of cable.
(1mark)
………………………………………………………………………………………………………………
………………………………………………………………………………………………………………
(ii) List two advantages of using fibre cable in networking (1mark)
………………………………………………………………………………………………………………
………………………………………………………………………………………………………………
i) Data flows in the school’s LAN in a duplex manner. Discuss two other types of data transmission in
network giving examples (2marks)
………………………………………………………………………………………………………………
………………………………………………………………………………………………………………

(a) Consider the topologies demonstrated in the diagram below.

(i) Identify the network topologies (3marks)
A
………………………………………………………………………………………………………………
………………………………………………………………………………………………………………
B
………………………………………………………………………………………………………………
………………………………………………………………………………………………………………
C

………………………………………………………………………………………………………………
………………………………………………………………………………………………………………
(ii) In topology A, identify the network device that should be at the end point 1 and 2 (1mark)
………………………………………………………………………………………………………………
………………………………………………………………………………………………………………
(iii)Which of the above topologies is likely to be used in a wide area network? (1mark)
………………………………………………………………………………………………………………
………………………………………………………………………………………………………………
(iv)Highlight three disadvantages of topology B. (3marks)
………………………………………………………………………………………………………………
………………………………………………………………………………………………………………
(v) Identify the device labeled X in topology A (1mark)
………………………………………………………………………………………………………………
………………………………………………………………………………………………………………
(b) State two main classes of network software (2marks)
(c) Briefly describe the following as used in networking (4marks)
i) Repeaters
………………………………………………………………………………………………………………
………………………………………………………………………………………………………………
ii) Network hub
………………………………………………………………………………………………………………
………………………………………………………………………………………………………………
iii) Fibre optic cables
………………………………………………………………………………………………………………
………………………………………………………………………………………………………………
iv) Network interface card (NIC)
………………………………………………………………………………………………………………
………………………………………………………………………………………………………………

(a) Define the following terms
(i) Database ( ½mark)
………………………………………………………………………………………………………………
………………………………………………………………………………………………………………
(ii) Database management system ( ½ mark)
………………………………………………………………………………………………………………
………………………………………………………………………………………………………………

(iii)Hierarchical database (1mark)
………………………………………………………………………………………………………………
………………………………………………………………………………………………………………
(iv)Relational database (1mark)
………………………………………………………………………………………………………………
………………………………………………………………………………………………………………
(v) Network database (1mark)
………………………………………………………………………………………………………………
………………………………………………………………………………………………………………
(b) List the advantages of using an electronic database system for storage of data over the file approach.
(4marks).
………………………………………………………………………………………………………………
………………………………………………………………………………………………………………
………………………………………………………………………………………………………………
………………………………………………………………………………………………………………
(c ) Study the spreadsheet below and answer the questions that follow

i) Write down the formula that can be used to find the price of the most costly book (1mark)
………………………………………………………………………………………………………………
………………………………………………………………………………………………………………
ii) Write down the formula that can be used to determine the total sales for the book titled COMPUTER
STUDIES (1mark)

………………………………………………………………………………………………………………
………………………………………………………………………………………………………………
iii) Write down the formula that can be used to determine the average price of the books. (1mark)
………………………………………………………………………………………………………………
………………………………………………………………………………………………………………
iv) Write down the formula in cell D6 that can be used to find the new price per book if they went up by a
percentage written in cell B 10 and the formula has to be entered only in cell D3 then be copied to
others. (1mark)
………………………………………………………………………………………………………………
………………………………………………………………………………………………………………
v) Write down the output in D7 if in B6 is 10% (1mark)
………………………………………………………………………………………………………………
………………………………………………………………………………………………………………
(d) State any four advantages of using an electronic spreadsheet as compared to a traditional worksheet.
(2mark)
………………………………………………………………………………………………………………
………………………………………………………………………………………………………………