Search
Free School Management System
Free School Management System for Kenya

Free School Management System

Learn More

KCSE CLUSTER TESTS 25

Computer Studies Paper 1

SECTION A (30 Marks)

1.

List three functions of the main memory.

3 marks

2.

State any three measures that should be put in place in order to ensure safety of computer users in a computer room.

3 marks

3.

The interim electoral and boundaries commission of Kenya plans to carry out electronic voting in the next general election. State THREE ways in which computers will help the commission attain its target.

3 marks

4.

Define user- friendly as used in software development.

3 marks

5.

Distinguish between insert mode and type over mode as used in word processing. (2mks) ……………………………………………………………………………………………………… …………………………………..

2 marks

6.

List any three advantages of soft copy output.

2 marks

7.

What is a password? List any two characteristics of a good password.

2 marks

8.

Your school principal has identified you as an advisor in setting up a computer network for the school. The principal wants to set up either a wireless network or a wired network for the school. Advice the principal on the best type of network that will suit the school. Give two reasons for your choice.

3 marks

9.

Biometrics is one of the security measures organizations are adopting today. Explain what is meant by biometric analysis.

3 marks

10.

. List two attributes of a monitor that affect its display

2 marks

11.

What is a reference model? State any two models that are used in creating computer networks.

2 marks

12.

. Distinguish between relative cell referencing and absolute cell referencing. (2mks) ……………………………………………………………………………………………………… …………………………………..

2 marks

13.

Distinguish between an entity and an attribute as used in database design.

3 marks

14.

What is meant by; (4mks)

a) Superscript ………………………………………………………………………………………………… …………………………………….. ………………………………………………………………………………………………… ……………………………………..

b) Subscript

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

c) Section breaks ………………………………………………………………………………………………… …………………………………….. ………………………………………………………………………………………………… ……………………………………..

d) Indenting …………………………………………………………………………………………………

2 marks

15.

Using a well labeled diagram, describe the STP cable. (4mks)
……………………………………………………………………………………………………… ……………………………………

4 marks

16.

a) Define the following terms in relation to object oriented languages. (3mks)

i) polymorphism ………………………………………………………………………………………………

ii) Inheritance ………………………………………………………………………………………………

iii) Encapsulation ………………………………………………………………………………………………

b) Write a pseudocode for a program that can accept a student name, age, height and scores for three subjects. The program should be able to determine average age for all 40 students, height for all the 40 students and average score for each of the 40 students. The program should also be able to output the average score for each student and average height and average age for all the 40 students. (6mks) ……………………………………………………………………………………………… ………………………………………………………………………………………………

c) draw a flowchart for the pseudocode above. (6mks)

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

16 marks

SECTION B (20 Marks)

COMPULSORY
17.

a) Describe any three coding systems used for representing data in a computer. (6mks) ……………………………………………………………………………………………………… ……………………………… ……………………………………………………………………………………………………… ……………………………… ……………………………………………………………………………………………………… ……………………………… ……………………………………………………………………………………………………… ……………………………… ……………………………………………………………………………………………………… ……………………………… ……………………………………………………………………………………………………… ……………………………… ……………………………………………………………………………………………………… ……………………………… ……………………………………………………………………………………………………… ……………………………… ……………………………………………………………………………………………………… ………………………………

b) Convert the decimal number 7.562510 into its binary equivalent. (3mks)
9 © MUMIAS SUB-COUNTY 2013 451/1
……………………………………………………………………………………………………… ……………………………… ……………………………………………………………………………………………………… ……………………………… ……………………………………………………………………………………………………… ……………………………… ……………………………………………………………………………………………………… ……………………………… ……………………………………………………………………………………………………… ……………………………… ……………………………………………………………………………………………………… ………………………………

c) Using 8 bits binary notation, find the twos complement of 2010. (3mks) ……………………………………………………………………………………………………… ……………………………… ……………………………………………………………………………………………………… ……………………………… ……………………………………………………………………………………………………… ……………………………… ……………………………………………………………………………………………………… ……………………………… ……………………………………………………………………………………………………… ……………………………… ……………………………………………………………………………………………………… ………………………………

Using ones complement, subtract 1101 from 11001. (3mks) ……………………………………………………………………………………………………… ……………………………… ……………………………………………………………………………………………………… ………………………………

15 marks

SECTION C (0 Marks)

Answer any TWO questions
18.

a) What is database model? Give two examples. (3mks) ……………………………………………………………………………………………………… ……………………………… ……………………………………………………………………………………………………… ……………………………… ……………………………………………………………………………………………………… ………………………………

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

b) List three characteristics of a primary key. (3mks) ……………………………………………………………………………………………………… ……………………………… ……………………………………………………………………………………………………… ……………………………… ……………………………………………………………………………………………………… ……………………………… ……………………………………………………………………………………………………… ………………………………

c) Define foreign key as used in databases. (2mks) ……………………………………………………………………………………………………… ……………………………… ……………………………………………………………………………………………………… ……………………………… ……………………………………………………………………………………………………… ………………………………

e) List five field properties and explain their purpose. (5mks) ………………………………………………………………………………………………… …………………………………… ………………………………………………………………………………………………… …………………………………… ………………………………………………………………………………………………… …………………………………… ………………………………………………………………………………………………… …………………………………… ………………………………………………………………………………………………… ……………………………………

f) Define an index as used in databases. (2mks) ………………………………………………………………………………………………… …………………………………… ………………………………………………………………………………………………… …………………………………… ………………………………………………………………………………………………… ……………………………………

20 marks

19.

a) Distinguish between; (4mks)

i) Switch and hub …………………………………………………………………………………………… …………………………………. …………………………………………………………………………………………… …………………………………. …………………………………………………………………………………………… …………………………………. …………………………………………………………………………………………… ………………………………….

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

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

b) Using a well labeled diagram, describe a fibre optic cable. (8mks)


c) List three disadvantages of wireless networks. (3mks)
…………………………………………………………………………………………… ……………………………………… ……………………………………………………………………………………………………… …………………………… ……………………………………………………………………………………………………… …………………………… ……………………………………………………………………………………………………… ……………………………

15 marks

20.

The diagram below represents the role of operating system in a computer system. Use it to answer the questions that follow.

N.......................................................................................................................................................................................................

M………………………………………………………………………………………………… …………………………….. N………………………………………………………………………………………………… ………………………………

b) Explain two advantages of using program N in commercial organization. (4mks) ……………………………………………………………………………………………… ……………………………. ……………………………………………………………………………………………… …………………………… ……………………………………………………………………………………………… ……………………………. ……………………………………………………………………………………………… ……………………………. ……………………………………………………………………………………………… ……………………………. ……………………………………………………………………………………………… ……………………………. ……………………………………………………………………………………………… …………………………….

c) Classify three types of program M. (3mks) ………………………………………………………………………………………………… ………………………………… ………………………………………………………………………………………………… …………………………………
User
N
M
Hardware

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

d) State three situations that may lead to use of questionnaire than interviews. (3mks) ………………………………………………………………………………………………… ………………………………… ………………………………………………………………………………………………… ………………………………… ………………………………………………………………………………………………… …………………………………

e) Explain the purpose of the following files (3mks)

Backup ………………………………………………………………………………………………… ………………………………….. ………………………………………………………………………………………………… ………………………………….. ………………………………………………………………………………………………… …………………………………..

Reference ………………………………………………………………………………………………… ………………………………….. ………………………………………………………………………………………………… ………………………………….. ………………………………………………………………………………………………… …………………………………..

State two types of database relationships. ………………………………………………………………………………………………… ………………………………….. ………………………………………………………………………………………………… ………………………………….. ………………………………………………………………………………………………… ………………………………….. ………………………………………………………………………………………………… …………………………………..

20 marks

Back Top