State the technology used in the following computer generations (2 mks)

i)4th generation:

______________________________________________________________________________ ______________________________________________________________________________

ii)1stgeneration:

______________________________________________________________________________ ______________________________________________________________________________

iii)2nd generation:

______________________________________________________________________________ ______________________________________________________________________________

iv)3rd generation:

______________________________________________________________________________ ______________________________________________________________________________

Outline two areas that should be considered when categorizing software. ______________________________________________________________________________ ______________________________________________________________________________ ______________________________________________________________________________

State any three disadvantages of a magnetic diskette

______________________________________________________________________________ ______________________________________________________________________________ ______________________________________________________________________________ ______________________________________________________________________________ ______________________________________________________________________________

a) Define the data processing (1 mk)

______________________________________________________________________________ ______________________________________________________________________________ ______________________________________________________________________________

b) Explain two characteristics of good information. (2 mks)

______________________________________________________________________________ ______________________________________________________________________________ ______________________________________________________________________________ ______________________________________________________________________________ ______________________________________________________________________________

Distinguish between data verification and data validation

Describe the following menu tools as used in Ms. Word (2 mks)

i) Print layout:

______________________________________________________________________________ ______________________________________________________________________________

ii) Web layout:

______________________________________________________________________________ ______________________________________________________________________________

Define the following terms as used in mail merging (4 mks)

i) Main document:

______________________________________________________________________________ ______________________________________________________________________________

ii) Data source

______________________________________________________________________________ ______________________________________________________________________________

a)Difference between real –time system and online systems (2mks) ______________________________________________________________________________ ______________________________________________________________________________ ______________________________________________________________________________ ______________________________________________________________________________ ______________________________________________________________________________
b) Explain how information and communication technology has contributed to teaching and learning in schools (2 mks) ______________________________________________________________________________ ______________________________________________________________________________ ______________________________________________________________________________ ______________________________________________________________________________ ______________________________________________________________________________

a) State the use of the following network devices. (2 mks)

i) Network interface cards
______________________________________________________________________________ ______________________________________________________________________________

ii) Routers

______________________________________________________________________________ ______________________________________________________________________________

iii) Distinguish between thinnet and thicknet coaxial cables. (2 mks) ______________________________________________________________________________ ______________________________________________________________________________ ______________________________________________________________________________ ______________________________________________________________________________ ______________________________________________________________________________

Convert (111.0102) to decimal number.

______________________________________________________________________________ ______________________________________________________________________________ ______________________________________________________________________________ ______________________________________________________________________________ ______________________________________________________________________________

Explain the type of errors that are likely to exist in a program? ______________________________________________________________________________ ______________________________________________________________________________ ______________________________________________________________________________ ______________________________________________________________________________ ______________________________________________________________________________

State three ways in which ICT can be used in industrial control. ______________________________________________________________________________ ______________________________________________________________________________ ______________________________________________________________________________ ______________________________________________________________________________ ______________________________________________________________________________

State two reasons why it is necessary to have well connected and proper cables in a computer lab
______________________________________________________________________________ ______________________________________________________________________________ ______________________________________________________________________________ ______________________________________________________________________________

What do you understand by the term ‘soft system’’ in a system development?

______________________________________________________________________________ ______________________________________________________________________________ ______________________________________________________________________________ ______________________________________________________________________________

What do you understand by the term ‘soft system’’ in a system development? ______________________________________________________________________________ ______________________________________________________________________________ ______________________________________________________________________________ ______________________________________________________________________________

Mumias sugar company pays casual employees based on the number of hours worked as follows

a) Write a pseudo code to input the name, rate hours worked. The pseudo code should output the name, hours worked and the wage paid. (6 mks)

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

c) Write brief notes on structured programming (4mks)

a) List four characteristics of a system (2 mks)

______________________________________________________________________________ ______________________________________________________________________________ ______________________________________________________________________________ ______________________________________________________________________________

b) Give any three circumstances that may make an organization to develop a new information system (3 mks)

c) Study the spreadsheet below and answer the questions that follow

i) Write down the formula used to find the price of the cheapest book. (1mk)
______________________________________________________________________________ ______________________________________________________________________________ ______________________________________________________________________________

ii) Write down the formula used to determine the total sales for the book titled’ computer applications (1 mk) ______________________________________________________________________________ ______________________________________________________________________________ ______________________________________________________________________________

iii) Write down the formula used determine the average price of the all books (2MKS) ______________________________________________________________________________ ______________________________________________________________________________ ______________________________________________________________________________

d) State any four advantages of using an electronic spreadsheet as compared to a traditional spreadsheet (2 mks) ______________________________________________________________________________ ______________________________________________________________________________ ______________________________________________________________________________ ______________________________________________________________________________ ______________________________________________________________________________
e) Differentiate between a column chart and a bar chart as used in spreadsheets (4 mks) ______________________________________________________________________________ ______________________________________________________________________________ ______________________________________________________________________________ ______________________________________________________________________________ ______________________________________________________________________________

f) Define the term gutter in relation to column setting in DTP (1MK) ______________________________________________________________________________ ______________________________________________________________________________ ______________________________________________________________________________

a) Name and describe four main application areas of artificial intelligence in ICT

b) State three advantages of automated production in manufacturing industries (3 mks)

a) Describe any two roles of the following career opportunities in the ICT field. (8mks)

i) Systems analyst

ii) Information system manager

______________________________________________________________________________ ______________________________________________________________________________ ______________________________________________________________________________ ______________________________________________________________________________ ______________________________________________________________________________

iii) Network administrator

______________________________________________________________________________ ______________________________________________________________________________ ______________________________________________________________________________ ______________________________________________________________________________

iv) Computer trainer

______________________________________________________________________________ ______________________________________________________________________________ ______________________________________________________________________________ ______________________________________________________________________________

b) Distinguish between a primary key and a foreign key as used in DBMS. (2 MKS) ______________________________________________________________________________ ______________________________________________________________________________ ______________________________________________________________________________ ______________________________________________________________________________

C) What do the term header and footer mean? (2 mks)

______________________________________________________________________________ ______________________________________________________________________________ ______________________________________________________________________________ ______________________________________________________________________________

d) What do you understand by the terms attenuation and baseband signal. (2 mks)

a) Define the following terms. (3 mks)

i) Record

______________________________________________________________________________ ______________________________________________________________________________

ii) File

iii) Database

______________________________________________________________________________ ______________________________________________________________________________

b) i) List any three ways of dealing with a virus on a computer. (3 mks) ______________________________________________________________________________ ______________________________________________________________________________ ______________________________________________________________________________ ______________________________________________________________________________
ii) Explain the functions performed by (2 mks)

a) The control unit

_________________________________________________________________________ _________________________________________________________________________ _________________________________________________________________________ _________________________________________________________________________

b) Arithmetic and logic unit (ALU)

___________________________________________________________________________ ___________________________________________________________________________ ___________________________________________________________________________ ___________________________________________________________________________

c) Convert the 5228 to its base 10 equivalent (2 mks)

______________________________________________________________________________ ______________________________________________________________________________ ______________________________________________________________________________

d) Using long division methods convert 6710 into binary. (2 mks) ______________________________________________________________________________ ______________________________________________________________________________ ______________________________________________________________________________ ______________________________________________________________________________

e) Outline three disk management activities. (3 mks)

______________________________________________________________________________ ______________________________________________________________________________ ______________________________________________________________________________ ______________________________________________________________________________