1. Identify any computer output device suitable for each of the following tasks:

1. Generating receipts where carbon copies are required  (1mk)

• Impact printers e.g dot matrix

     b) an architectural drawing where precision is required         (1mk)

• Plotter

(c ) producing document output for a visually impaired person (1mk)

• Braille/speakers

1. Pesa Tele has offices in Nairobi and Kampala connected in a network . the management is convinced that someone is illegally gaining access to the data in their computers. State three ways in which the company can overcome this problem (3mks)

• Encryption
• Firewall
• Audit trail/tracking
• Use of passwords
• Limit the number of log-in attempts

1. Explain two ways in which the use of internet could make reporting of corruption easier (4mks)

• Interactive: the internet based technology enables real-time dialogue hence instantaneous reporting of cases
• Outreach: the technology allows the coverage of wide areas
• Social mobilization : it easy to create a network of people with similar concerns
• Anonymity : it is easier to report corruption without being  known
• Security: the message sent reaches destination without being intruded

1. State ways in which software errors can be prevent during program development

• Use of antivirus software
• Performing system update frequently
• Testing the software before implementation
• Proper training

State four advantages for using a graphical user interface in loading programs and files

• User friendly
• No need to know command language as commands are executed by clicking on icons
• Allows multitasking as several programs open at the same time therefore easier to switch between applications
• Selecting an item using a mouse is easier and faster than entering commands

Or any other correct response

Advantage @ 1 Mark

Total = 4 X 1 Mark

= 4 Marks

A vehicle assembly company has introduced robots to replace the human workforce.  State two effects this would have on the workforce                

• Unemployment
• Need to retrain
• No longer need to do hazardous or tedious jobs
• Employment of skilled staff who will manipulate the robots

Or any other correct response

Effect @ 1 Mark

Total = 2 X 1 Mark

= 2 Marks

SECTION A (40 MARKS)

ANSWER ALL THE QUESTIONS IN THIS SECTION

1.Compare the two types of diskettes used in microcomputers in terms of physical size and densities.    (2mks)

2.Why is it necessary to have a UPS in a computer laboratory?  (2mks)

3 a) Explain what is meant by batch processing   (1mk)

   b) Give one advantage and one disadvantage of batch processing ( 2mks)

4. List any four high level programming languages  (2mks)

5.A 3 by 4 matrix M is to be added to another 3 by 4 matrix array N so as to give a third 3 by 4 matrix array P.  Using a high level programming language, write a program segment that assigns the sum of M and N to P.(4mks)

6. The first column in the table below contains the formulae as stored into the cell F10 of a spreadsheet.  Enter the formulae, as they would appear when copied to the cell M20 of the same spreadsheet.  (3mks)

7.  Give three advantages of separating data from the applications that use the data in database design. (3mks)

8.  Explain the impact of information on organizations in each of the following areas:  (2mks)

   a) Competition

   b) Pace of growth

9. a) List any four tasks that an electronic spreadsheet should be able to perform other than calculations  (2mks)

    b) Explain what is meant by automatic recalculation as used in a spreadsheet.(1 mk)

10. Describe the functions of the following computer hardware components:

   a)Mouse                     (2 ½  mks)

   b)Scanner.                   (1 ½ mks)

11. a)State two differences between Disk Operating System (DOS) and WINDOWS operating system.

 b. i) Define the term application software  (1mk)

     ii) Give one example of application software (1mk)

12. a)  Give one difference between internal and external commands in Disk Operating System.   (2mks)

      b)  Name two DOS commands that may be used for checking disk errors.  (2mks)

13. Explain how a paragraph can be moved from one place to another in word-processing. 2mks)

14.  Define the term structured programming. (2mks)

SECTION B (60MKS)

Answer question 15 and any other three questions from this section.

15.a)  What is meant by each of the following terms:

 i)   pseudocode        (1 ½ mks)

  ii)  Flowchart           (1 ½ mks)

b) a program is required to list the first 1000 numbers in the series:  2, 4, 6, 8,

10. Draw a flowchart and write a program that can be carried out this task.   (12 mks)

16. The following car details are to be entered in a database; make, date-of-manufacture, colour and cost.

 a) Prepare a suitable database structure showing field names and their field types   (5mks)

 b) Explain how you index the data such that cars of the same make and colours are together   (2mks)

 c)  Write a statement that can be used to select cars of the colour green        (2 mks)

 d) Give an instruction that would;

  i)select cars whose cost lie between 500,000/= and 1,000,000/=  (3 mks)

 ii)Determine the average cost of all cars         (3mks)

17.  a)The diagram below represents the essential features o a computer system. Study the diagram and answer the questions that follow:

i)Name the components (4mks)

            A

            B

            C

            D

ii) On the diagram above, indicate the direction of data flow using arrows.  (3mks)

b) Name the three types of buses in a computer system (3mks)

c) Explain how CPU registers may be used to carry out a basic calculation such as:2 + 7 = 9

d) Name two computers output devices. (1 Mark)

18. a)State three ways in which computer technology may affect employment patterns in organizations   (3mks)

b) State three ways in which computer technology may affect employment patterns in organizations (3mks)

c)Suggest three strategies that can be employed to manage resistance to change  (3mks)

d) Give three advantages of computerization in an organization.  (3mks)

19. a)In a computer based information system, state the purpose of the following files and give one example where such a file may be required in a school.                (8mks)

i) report file

ii)Back-up file

iii)Reference file

iv) Sort file

b) State three precautions that should be taken to ensure that diskettes are well stored.  (3 mks)

c)  Distinguish between “serial” and Indexed sequential” file organization methods.  (2mks)

d)  Distinguish between binary and octal number systems and give an example of each  (2mks)

Answer question 16 and any other three questions from this section in the spaces provided.

16. a) With the aid of a flow chart, describe a loop control structure as used in programming. [4]  

A control structure that allows statement(s) to be repeatedly executed until a certain condition is met                                                                                                      2mks

NB. Accept any other looping construct

Any two from:

• Registers
• Clock
• CU
• ALU

• Developing training materials
• Training computer users
• Conducting ICT examinations
• Managing the learning and examination process
• Developing guidelines for using the computer lab
• Planning the course content
•  

• It prevents double-booking which could happen in paper-based booking system
• The customer gets immediate feedback on the availability of seats
• The customer can make  booking at any time of the day
• Emails provided by customers during booking can be used by companies for advertisement

• To detect and remove errors
• To confirm if the program produces the expected output

• It is a feature used to prevent unwanted changes to be made on the data contained in a sheet by limiting the ability to make changes

• By setting the validation rule for the input controls on the property sheet in design view
• By use of VBA to restrict user inputs for a given control on a form
• By use of queries to restrict options available for the user in a combo box or listbox
• Setting correct data types for the fields in table the design
• Enforcing referential integrity in database relationships
• Use of input mask for the controls on the property sheeet in design view

- (provides) user interface
– input/output control
– security
– handling interrupts
– spooling
– memory management
– processor management
– utilities (e.g. copy, save, delete, re-name, etc.)
– maintain user accounts
– load/run software
– error reporting/handling
– multiprogramming
– batch processing (JCL)/real time processing
– multitasking/multiuser/multi-access
– file management

– multiple choice/yes-no answers
– easy to understand interface e.g. use of icons/drop down menus etc.
– output shown as % probabilities of fault