Computer Studies Paper 1 Question Paper
KCSE CLUSTER TESTS 25
Computer Studies Paper 1
SECTION A (30 Marks)
List three functions of the main memory.
3 marks
State any three measures that should be put in place in order to ensure safety of computer users in a computer room.
3 marks
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
Define user- friendly as used in software development.
3 marks
Distinguish between insert mode and type over mode as used in word processing. (2mks) ……………………………………………………………………………………………………… …………………………………..
2 marks
List any three advantages of soft copy output.
2 marks
What is a password? List any two characteristics of a good password.
2 marks
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
Biometrics is one of the security measures organizations are adopting today. Explain what is meant by biometric analysis.
3 marks
. List two attributes of a monitor that affect its display
2 marks
What is a reference model? State any two models that are used in creating computer networks.
2 marks
. Distinguish between relative cell referencing and absolute cell referencing. (2mks) ……………………………………………………………………………………………………… …………………………………..
2 marks
Distinguish between an entity and an attribute as used in database design.
3 marks
What is meant by; (4mks)
a) Superscript ………………………………………………………………………………………………… …………………………………….. ………………………………………………………………………………………………… ……………………………………..
b) Subscript
………………………………………………………………………………………………… …………………………………….. ………………………………………………………………………………………………… ……………………………………..
c) Section breaks ………………………………………………………………………………………………… …………………………………….. ………………………………………………………………………………………………… ……………………………………..
d) Indenting …………………………………………………………………………………………………
2 marks
Using a well labeled diagram, describe the STP cable. (4mks)
……………………………………………………………………………………………………… ……………………………………
4 marks
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)
COMPULSORYa) 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 questionsa) 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
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
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