Computer Studies Paper 1 Question Paper - KCSE CLUSTER TESTS 27 (2024)

Free School Management System

Learn More

(b) System analyst (2 marks)

(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)

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

(a) FTP

(b) TCP/IP

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

(a) Input Mask

(b) Validate Rule

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

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

a) Data Encryption

_______________________________________________________________________________________ _______________________________________________________________________________________ _______________________________________________________________________________________

b) Sabotage

_______________________________________________________________________________________ _______________________________________________________________________________________

c) Firewall

_______________________________________________________________________________________ _______________________________________________________________________________________ _______________________________________________________________________________________

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) _______________________________________________________________________________________

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) _______________________________________________________________________________________

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) _______________________________________________________________________________________

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) _______________________________________________________________________________________

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) ______________________________________________________________________________