Distinguish between parallel and serial cables

Differentiate between Error Handling and interrupt handling

Name four malicious programs that can affect your computer system

What is meant by expert systems? Name the three components

Name two ways of editing cell entries in spreadsheets.

Describe TWO roles of each of the following;

(a) Database Administrator (2 marks)

(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

What is meant by World Wide Web?

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

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

(a) Input Mask

(b) Validate Rule

Differentiate between logical and syntax errors encountered in programming

What is a computational error? Give an example to illustrate

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

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

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

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

i) Cropping _______________________________________________________________________________________

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

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