Search
Free School Management System
Free School Management System for Kenya

Free School Management System

Learn More

KCSE CLUSTER TESTS 27

Computer Studies Paper 1

SECTION A (40 Marks)

1.

Distinguish between parallel and serial cables

2 marks

2.

Differentiate between Error Handling and interrupt handling

2 marks

3.

Name four malicious programs that can affect your computer system

2 marks

4.

What is meant by expert systems? Name the three components

4 marks

5.

Name two ways of editing cell entries in spreadsheets.

2 marks

6.

Describe TWO roles of each of the following;

(a) Database Administrator (2 marks)

(b) System analyst (2 marks)

4 marks

7.

(a) Describe two facilities offered by email software such as Ms Outlook. (2 marks)

(b) Name other two email softwares available in the market? (1 mark)

3 marks

8.

State the functions of the following protocols; (2 marks)

(a) FTP

(b) TCP/IP

2 marks

9.

What is meant by World Wide Web?

2 marks

10.

Explain the difference between Gas Plasma Display and Liquid Crystal display Monitors

2 marks

11.

State the purpose of the following field properties in a Database management software

(a) Input Mask

(b) Validate Rule

2 marks

12.

Differentiate between logical and syntax errors encountered in programming

2 marks

13.

What is a computational error? Give an example to illustrate

2 marks

14.

Anita was working on her computer studies project. She was worried of the media to use for storing her data.

She settled on a media that used serial file organization. How are files organized on a storage medium using this method?

List two advantages offered by this type of file organization

3 marks

15.

Define the following terms in relation to computer security: (6 mks)

a) Data Encryption

_______________________________________________________________________________________ _______________________________________________________________________________________ _______________________________________________________________________________________

b) Sabotage

_______________________________________________________________________________________ _______________________________________________________________________________________

c) Firewall

_______________________________________________________________________________________ _______________________________________________________________________________________ _______________________________________________________________________________________

6 marks

SECTION B (60 Marks)

16.

a) Generate output for the following pseudo code (4mks)

START X= 1

WHILE X<4

DO PRINT (X) X=X+1 Y= X +2

ENDWHILE PRINT (“DONE’,X)

END

b) Draw a flowchart for the above pseudo code (4 mks) _______________________________________________________________________________________

b) List any four components of Requirement specification made during system development (2 mks) _______________________________________________________________________________________ _______________________________________________________________________________________


c) Describe three kinds of program documentation used in program development (6 mks) _______________________________________________________________________________________

16 marks

17.

The information below is maintained by Jesica Fruit store. Study it and answer the questions that follow:

a) Describe the field data types used in the database above (4 mks) _______________________________________________________________________________________

b) Provide query statements you can use to list the following;

i) Product names starting with letter P. (2 mks) _______________________________________________________________________________________

ii) Value per unit below 200. (2 mks) _______________________________________________________________________________________

i) List and describe four areas of application of spreadsheets. (4 mks) _______________________________________________________________________________________ _

ii) Explain Data range, legend and axis as used in spreadsheet charts. (3 mks) _______________________________________________________________________________________

15 marks

18.

a) What is automated production. List two advantages and two disadvantages of automated production (5mrks) _______________________________________________________________________________________

b i) Name three ways of representing signed binary numbers (3 mks) _______________________________________________________________________________________

ii) Convert 5D616 to Binary (2 mks) _______________________________________________________________________________________

iii) Describe any four activities that take place during implementation stage of a system (4 mks) _______________________________________________________________________________________

d) Define the following terms as used in DTP software (1 mks)

i) Cropping _______________________________________________________________________________________

15 marks

19.

a) State and explain any four operating system disk management utilities (8 mks) _______________________________________________________________________________________

b i) What is system maintenance? (2 mks) _______________________________________________________________________________________

ii) Define the following terms in relation to computer software (3 mks)

a) Freeware

_______________________________________________________________________________________

b) Propriety

_______________________________________________________________________________________

c) Open source

_______________________________________________________________________________________

iii) List any four likely causes of data and program loss in a computer system? (2 mks) _______________________________________________________________________________________

15 marks

20.

a) With the aid of a diagram explain the following network typologies (6 mks)

i) Ring topology.

_______________________________________________________________________________

ii) Bus topology

______________________________________________________________________________

iii) Star topology

______________________________________________________________________________

b) Define the following terminologies in relation to networking (4 mks)

i) Crosstalk

______________________________________________________________________________

ii) Noise

______________________________________________________________________________

iii) Attenuation

______________________________________________________________________________

iv) Frequency

______________________________________________________________________________

c) State two advantages of wireless communications (4 mks) ______________________________________________________________________________

d) List down one major advantage of networking. (1mk) _______________________________________________________________________________________


15 marks

Back Top