KENYA CERTIFICATE OF SECONDARY EDUCATION

451/1 COMPUTER STUDIES

PAPER 1 (THEORY QUESTIONS)

FORM ONE – INTRODUCTION TO COMPUTERS

1. Explain the following terms as used in computer science:
   • (1 mark)
   • (2 marks)
   • Data processing. (2 marks)
   •             (2 marks)
2. What role(s) does each of the following units of a computer play during data processing?

• Input unit. (1 mark)
• Output unit. (1 mark)
• Central processing unit. (2 marks)

3. List down four characteristics of a computer. (4 marks)
4. State four different parts that make up a computer. (2 marks)
5. (a) Explain the term System Unit.             (1 mark)

(b) Name four components found in the System unit.                                        (4 marks)

(c) Outline three features of a computer’s System Unit.                                                (3 marks)

6. (a) What are peripheral devices?             (1 mark)

(b) Give two examples of peripheral devices.                                                     (1 mark)

7. (a) Match the following generations of computers with the technology used to develop them.             (2 marks)

(b) Computers have evolved through a number of generations.  List any 4 characteristics of the First generation of computers.                                                                        (4 marks)

(c)  Give four differences between today’s computers and the first generation computers.                                                                                                                              (4 marks)

8. (a) State and explain five factors considered when classifying computers according to

generations.                                                                                                    (5 marks)

(b)  Briefly discuss the classification of computer according to historical development (generations)                                                                                                  (10 marks)

9. Explain four methods of classifying computers.             (4 marks)
10. Giving two points in each case, state the difference between the following types of computers.

• Supercomputer and Mainframe computer.             (2 marks)
• Digital computer and Analogue computer.             (2 marks)
• Special-purpose (dedicated) computer and a General-purpose computer. (2 marks)
• Desktop computers and Laptop computers.

11. (a) Explain the emerging trends in Microcomputer technology in relation to size. (1 mark)

(b) Give two reasons why smaller computers like Laptops tend to be more expensive than Desktop computers.                                                                                            (2 marks)

12. (i) Explain four reasons which make laptop computers suitable for personal computing work.               (4 marks)

(ii) Recommend any two application areas that would require the use of laptop computers.                                                                                                                              (2 marks)

13. Give three reasons why a Mobile phone is regarded to be a computer. (3 marks)
14. State a specific example where each of the following types of computers can be used.

• (1 mark)
• Mainframe computer. (1 mark)
• (1 mark)
• Microcomputer / Personal computer. (1 mark)

15. (a) Differentiate between a Minicomputer and a Personal Computer.             (2 marks)

(b) List three factors to be considered when purchasing a microcomputer.       (3 marks)

(c) Explain four reasons which make microcomputers suitable for personal computing work.                                                                                                                                       (8 marks)

16. (a). Explain how computers are used in the following areas to process data. (10 marks)

• Schools/education centres.
• Police station.
• Transport industry.

(b) Give three advantages of using computers for data processing over other types of office and business equipment.                                                                                  (3 marks)

17. (a) Define the term ‘Computer laboratory’ and give three factors to be considered when preparing a computer laboratory. (4 marks)

(b) Mention any FOUR features which a standard computer laboratory should have.                                                             bc                                                                                (4 marks)

18. (a) State and explain three safety precautions and practices in a computer laboratory.       (3 marks)

(b) State four precautions that should be taken when handling diskettes.          (4 marks)

19. Njeru the lab technician wants to buy a fire extinguisher for the computer lab. Which type of extinguisher is the most suitable for the computer laboratory?                         (1 mark)

20. (a) Give one major environmental and one energy problem Kenya faces as far as computer installations are concerned.             (1 mark)

(b) How could these problems be avoided?                                                        (2 marks)

21. What actions should be taken in case of a fire outbreak in the computer laboratory?                                                                                                                                           (4 marks)
22. Describe the ideal environment for a computer to work properly. (3 marks)
23. Identify three facilities that will ensure proper ventilation in a room. (3 marks)
24. For each of the following, give one reason why they are not allowed in a computer laboratory.             (2 marks)

• Eating foods.
• Beverages/liquids.

25. Why would it not be good to install Powder or Water-based fire extinguishers in the computer room? (2 marks)

26. (a) State one reason why a computer needs to be connected to a stable power supply.             (1 mark)

(b) Give two reasons why it would be necessary to have a UPS (Uninterruptible power supply) in a computer laboratory.                                                                 (2 marks)

27. Mention two things that are likely to cause eye-strain in the computer room. (2 marks)
28. Identify three proper sitting postures while using the computer.             (3 marks)
29. Computers are usually susceptible to dust, humidity, and heat. State two ways of how you would control each of the three hazards in a typical computer laboratory?            (3 marks)

30. What do you understand by the term ‘Write-protected’ with reference to a diskette?
31. List three things that can spoil a Printer if they are not of the correct specification, and explain what damage may be caused. (3 marks)

32. A computer teacher has put a rule that diskettes should not be used in the Computer

• Give a reason for the rule. (1 mark)
• State two alternatives that can be used to achieve the same objective. (2 marks)

33. State and explain three ways that computer technology could make office work more efficient. (6 marks)

34. (a) Explain the steps you would follow to set up a new computer. (3 marks)

(b) Explain the correct procedure for shutting down the computers in the computer laboratory.                                                                                                      (4 marks)

35. A computer must go through the process of booting/initialization before use.

(a) Briefly explain the term “computer booting”.                                                           (1 mark)

(b) Explain what happens in the computer during the booting process.             (2 marks)

(c) Give and explain two types of booting.                                                         (2 marks)

(d) What type of memory is used to store the boot up program (the first program to be

executed on switching on a computer.                                                           (1 mark)

(e) State two ways of warm booting a computer.                                                           (2 marks)

36. Classify the following keyboard characters. (6 marks)
37. A, B, C ……..Z
38. 0, 1, 2 ………9
39. F1, F2 ……..F9
40. Del, Insert, Backspace
41. Home, End, Page Up, Arrow keys
42. CTRL, SHIFT, ALT

37. State five different types of keys found on a standard keyboard.             (5 marks)

38. Name and explain the function of the keyboard keys represented by the following symbols.

• (2 marks)

•                         (2 marks)

•                                                 (2 marks)

39. (a) Explain the following terms associated with the use of a Mouse:
40. Left-clicking.
41. Double-clicking.

• Right-clicking.

1. Drag and drop.

COMPUTER SYSTEMS

1. (a) Define the following terms as used in computing: (2 marks)
   • Computer system.

(b) Differentiate between a Computer and a Computer system.                        (2 marks)

2. (a) List and explain three functional elements of a computer system             (3 marks)

(b) Using a well-labelled diagram, give a descriptive illustration of a computer system.                                                                                                                                                (7 marks)

3. (a). The diagram below represents the essential features of a computer system. Study the diagram and answer the questions that follow:

• Name the components A, B, C, and D             (4 marks)
• On the diagram above, indicate the direction of the data flow using arrows.                                                                                                                            (3 marks)
  4. Give an example of a: (3 marks)

1. Device that reads data.
2. Pointing device.

• Voice input device.
  5. (a) What are computer scanning devices?                                                          (1 mark)

(b) Name the type of scanner used:                                                                    (2 marks)

1. To capture prices of goods at points of sale terminals in supermarkets and superstores.

1. To grade multiple choice examination
   6. Briefly describe how each of the following I/O devices work.
2. Tracker ball. (3 marks)
3. Touch screen. (3 marks)

• Light pen. (3 marks)

1. Graphic (Digitizing) Tablet. (3 marks)
2. (3 marks)
3.                                     (3 marks)

• Speech (voice) recognition device.             (3 marks)
• Speech (voice) Synthesizer. (3 marks)

7. (a) Explain the principle of a Kimball tag as a data input device.             (3 marks)

(b) Outline any two advantages of a Light pen as an input device.                    (2 marks)

8. (a) Identify two advantages and four limitations of the Speech recognition devices.                                                                                                                                           (6 marks)

(b)  State two situations in which speech recognition devices may be useful as a method of data entry.                                                                                                  (2 marks)

9. (a) What are turnaround documents? (1 mark)

(b) Name any two data capture techniques that make use of turnaround documents.                                                                                                                                                   (2 marks)

10. Magnetic Ink Character Reader (MICR) technology uses the principle of magnetism to encode certain characters/data.

1. Recommend one application areas where this technology is used.             (1 mark)
2. Name any three data items that can be encoded using magnetized ink. (3 marks)
   11. Name four factors one would consider when selecting a data input device. (4 marks)
   12. (a) Describe three functions performed by the CPU. (3 marks)

(b)  Explain the functions performed by each of the following central processing unit elements.

1. Control Unit. (2 marks)
2. Arithmetic and Logic Unit. (2 marks)

• (1 mark)

1. The Main memory. (2 marks)
2. The System clock. (1 mark)
   13. In reference to ALU, explain the meaning of logic operations, and give an example of this processing operation.             (2 marks)

14. (a) Give four types of registers found in the CPU.             (4 marks)

(b) Explain how the CPU registers may be used to carry out a basic calculation such as:                   2 + 3 = 5                                                                                                          (4 marks)

15. State the function of each of the following computer bus. (3 marks)

• Data bus.
• Address bus.
• Control bus.
  16. Computer systems are built from three types of physical components: Processor, memories and Input/Output devices.

1. State two tasks of a processor. (2 marks)
2. State the functions of I/O devices. (2 marks)

17. (a) What is the computer Motherboard?             (1 mark)

(b) State any four components found on the computer motherboard.                (2 marks)

18. (a) What is a read/write drive? (2 marks)

(b) State any two types of computer drives, giving an example of a storage device used by each.                                                                                                                       (3 marks)

19. (a) Give two reasons why it is necessary for a computer to have secondary/backing storage facilities                                                                                                          (2 marks)

(b) List three different examples of auxiliary storage devices.                          (3 marks)

20. (a) The hard disk is composed of Platters, Hard disk Drive, Access arm, Motor device, Read/Write heads, and Spindle. State the function of each of these parts. (6 marks)

(b) State three advantages of using hard disks as medium of storage.               (3 marks)

(c) Describe three precautions you would take to avoid damaging the hard disk. (3 marks)

(d) Explain the internal mechanism of the hard disk in reference to disk platters and read/write head.                                                                                              (3 marks)

(e) Describe the structure of a hard disk in reference to cylinders, tracks and sectors.                                                                                                                                     (3 marks)

21. (a) Write down two advantages of storing data in a magnetic disk over a magnetic tape. (1 mark)

(b)  State two reasons why Magnetic tapes are not commonly used as computer data storage medium today.                                                                                              (2 marks)

22. Differentiate between:

1. Fixed and removable disks.             (2 marks)
2. Volatile memory and Non-volatile memory. (2 marks)

• Magnetic and Optical storage media. (2 marks)

1. CD-ROM and Floppy disk.             (2 marks)
2. Hardcopy and Softcopy. (2 marks)
   23. Give three advantages of using a Scanner over the keyboard as an input device.(3 marks)
   24. (a) Using a well-labelled diagram, differentiate between Sectors and Tracks as used in

Magnetic disks.                                                                                              (4 marks)

(b) Draw a well-labelled diagram of a 3.5-inch floppy disk showing its parts.             (7 marks)

(c) Explain four rules for handling magnetic disks.                                            (4 marks)

25. (a) Give two uses of floppy disks in a computer system. (2 marks)

(b) Draw a labelled diagram to illustrate the internal structure of a diskette.   (7 marks)

26. The diagram below shows a formatted plate surface of a storage disk.

Shade and label:

• one sector (1 mark)
• one block (1 mark)
  27. RAM and Magnetic disks are both Random access devices. List four differences between the two devices.                                                                                                 (4 marks)

28. State any three main differences between Primary and secondary computer storage.                                                                                                                                           (3 marks)
29. Giving an example, explain the term memory Volatability? (2 marks)

30. (a) State four functions of Read-Only memory (ROM)             (4 marks)

(b) Give three characteristics of ROM                                                                (3 marks)

(c) Name two different types of ROM                                                                 (2 marks)

31. Mention any four types of programs or facilities that are stored in the Read Only Memory.                   (4 marks)
32. (a) Outline three characteristics of Random Access memory (RAM).             (3 marks)

(b) Name the two types of RAM clearly stating their differences.                     (3 marks)

33. Give two examples of special purpose memories found in the CPU. (2 marks)
34. Give two types of information that are found in the RAM. (1 mark)
35. What do the following phrases mean in reference to computers:             (4 marks)
36. 2 Ghz processor speed.
37. 128 KB Cache.

• 256 MB RAM

1. 80 GB Hard disk
2. The diagram below shows an example of a secondary storage.

1. Identify the name of the device.             (1 mark)
2. List down two advantages of this device over a floppy disk in storage. (2 marks)
3. Calculate the capacity in MB of a two-sided floppy disk with 6 sectors per surface, and 512 bytes per sector.             (2 marks)

38. (a) List any four examples of Optical storage devices.             (4 marks)

(b) Give two application areas that make extensive use of Optical disks.         (2 marks)

(c) Give two advantages of a Digital Versatile Disk over a normal Compact disk.                                                                                                                                                       (2 marks)

39. (a) Explain two features of a DVD that enables it to store more information than a CD-R. (4 marks)

(b)  How many Optical disks of 720 MB storage capacity are needed to store 20 GB storage of hard disk data?  (Give your answer to the nearest whole number).        (2 marks)

40. (a) Define the term Multimedia.             (2 marks)

(b) List down four components required to make a computer multimedia.       (3 marks)

41. Giving reasons in each case, suggest the most suitable backing store medium for each of the following:

1. Data for payroll program.             (2 marks)
2. Documents for a word processing program. (2 marks)

• A company’s financial records for the last four years. (2 marks)

42. (a) List any four examples of computer output devices.             (2 marks)

(b) Identify three functions of computer output devices.                                               (3 marks)

43. Outline two advantages and two disadvantages of using a Monitor for output. (4 marks)
44. (a) Show two differences between a CRT monitor and a Flat-panel display.   (2 marks)

(b) Give three examples of flat-panel monitors available in the market today.  (3 marks)

45. Describe five types of display video cards used in computers.             (5 marks)
46. (a) What are pixels? (1 mark)

(b) What role do pixels play in screen display?                                                  (1 mark)

47. List three possible factors that you would consider when buying a computer monitor.       (3 marks)
48. (a) What are Character printers?             (1 mark)

(b) Give two examples of character printers.                                                      (2 marks)

49. State any four differences between Printer output and Monitor output. (4 marks)
50. Distinguish between Impact and Non-impact printers, and give two examples of each.       (3 marks)
51. (a) State two advantages and one disadvantage of: (6 marks)

1. Laser printers.
2. Inkjet printers.

(b) Distinguish between a Line printer and a Page printer.                                (2 marks)

52. List three differences between a laser printer and a dot matrix printer. (3 marks)
53. (a) State two advantages of using a Printer for output.             (2 marks)

(b) Highlight four factors one should consider when purchasing a printer.       (4 marks)

54. (a) Name two types of Plotters. (1 mark)
    • State the main difference between the plotters you have named in (a) above. (2 marks)

(c) List three advantages of a Plotter over normal printer machines.                (3 marks)

55. Give two advantages of using sound output devices. (2 marks)
56. George connected new multimedia speakers to his computer and tried to play his favourite music CD, but no sound came out. Suggest two problems that might have occurred.                                                                                                                                             (2 marks)
57. Give one device which can perform both input and output functions in a computer.                                                                                                                                           (1 mark)
58. (a) Define the following terms: (3 marks)
60. Data interface cable.

• Power cable.

(b) State the function of the Power supply unit found in the System unit.        (1 mark)

59. (a) Name any two peripheral devices that are connected to the computer through the PS/2 port.                         (1 mark)

(b) Give two major advantages of a USB interface cable over other cables in the computer.                                                                                                                                            (2 marks)

(c)  Explain two differences between Serial (COM) and Parallel (LPT) communication ports of a computer.                                                                                       (2 marks)

60. In relation to cabling, give two reasons why a printer may not print work sent from the computer as expected?             (2 marks)

61. (a) With reasons, briefly describe the most appropriate type of printer or output device for the output of:                               (6 marks)
    1. Customer invoices on multiparty stationery.
    2. Letters to customers.

• Detailed engineering designs.

(b) Give three reasons why Optical disks are better storage devices compared to floppy disks.                                                                                                                          (3 marks)

62. Outline three precautions one should take when assembling a computer. (3 marks)
63. (a) Define computer Software. (2 marks)

(b) Discuss the purpose and use of the following software found in microcomputers:

1. System software. (8 marks)
2. Application software. (7 marks)

(c) You have been asked by a local secondary school to assist them in selecting a microcomputer for their use.  Discuss five hardware and five software factors you would consider in order to select the most suitable computer system.                    (10 marks)

64. (a). What is a utility software?                                                                           (1 mark)

(b). Give four examples of utility software.                                                        (2 marks)

65. Give two reasons why people prefer in-house developed application programs to general-purpose application packages.             (2 marks)

66. (a) Why is it important to carefully study a warranty before committing yourself by signing it?             (1 mark)

(b) Give three reasons why one might purchase a computer with a one year warranty instead of a three year warranty.                                                                                (3 marks)

67. (a) What is a Standard software?             (1 mark)

(b) Name five advantages and five disadvantages of off-the-shelf packages.   (10 marks)

(c) Discuss four factors you would consider when purchasing an Application package.                                                                                                                                                (4 marks)

68. Differentiate between single-purpose programs and integrated software. (2 marks)

69. (a) A firm intends to purchase new software. List three items that should accompany the software.                                                                                                   (3 marks)

(b) When buying a new software product, usually an installation guide is needed by the buyer.  State one reason for this.                                                                   (1 mark)

70. State any two sources of an accounting application software for an organization.                                                                                                                                           (2 marks)
71. Describe the following categories of software:             (2 marks)

• Proprietary software.

72. (a) Explain the following software terms:                                                 (3 marks)

(b) What is meant by the term User-friendly as used in software development?          (1 mark)

73. Write the following acronyms in full: (3 marks)
    • BIOS
    • EPROM
    • WAP
74. Briefly state the need for:             (2 marks)

• Software maintenance.
• Software updates.

75. A school bought a computer system. The hardware items supplied include: a 800 MHz processor, 640 MB of RAM, a sound card, speakers, a monitor, a keyboard, a 120 GB hard disk, a floppy disk drive, a CD -Read/Write drive, a mouse, a modem, an inkjet printer, and a joystick.

The software supplied include: an operating system, a BASIC interpreter, and the following packages: spreadsheets, graphics, word processor, art, database and games.

76. List three input devices from the given specifications.               (3 marks)

• Explain the meaning of the following:

• 800 MHZ (2 marks)
• 640 MB of RAM (2 marks)
• 120 GB hard disk (2 marks)
  • Some of the students in the school use the computer to do homework.

Name the package used to:

• Do calculations and draw graphs. (1 mark)

• Write an essay. (1 mark)
• Make a poster. (1 mark)
• Students enjoy playing noisy computer games.

• Which two hardware items are needed to produce sound?             (2 marks)

• Which input device is only used for playing games? (1 mark)

OPERATING SYSTEMS

1. The central processor and peripheral devices of a computer system are coordinated by the operating system.

(a) Define the term ‘Operating system’                                                              (2 marks)

(b) Other than the processor, list two other resources/components that an operating system manages.                                                                                                        (2 marks)

(c) There are several types of operating systems in use today.  State two examples of operating systems with which you are familiar.                                           (2 marks)

2. Explain why Operating systems are so important.             (4 marks)
3. Explain any five basic functions of an operating system software.             (5 marks)
4. Show the difference between the Control Unit of a processor and the Operating system in terms of functionality.             (2 marks)

5. (a) Explain what is meant by system Interrupt? (1 mark)

(b). Name any five examples of system interrupts and their possible causes.   (10 marks)

(c). Mention two advantages of using interrupts for input or output devices.   (2 marks)

6. One of the tasks of an operating system is to allow communication between the computer and the user. State any four system messages from the computer to the operator.   (4 marks)

7. (a) Why must an operating system be installed in the computer before installing any other software.                         (1 mark)

(b) Differentiate between scheduling and sequencing of tasks by the operating system.

(2 marks)

8. (a) Give three ways in which operating systems are classified.             (3 marks)

(b) Giving an example in each case, explain the following types of operating systems:

1. Single-user / Single-tasking             (2 marks)
2. Multi-user / Multi-tasking (2 marks)
3. (a) Give two examples of single-user operating system.             (1 mark)

(b) State any three computer software that can be classified as a Multi-user operating system.                                                                                                                                   (3 marks)

10. A computer user may interact with a computer either through Graphical User Interface (GUI) or through typed commands.

(a) State two features of a graphical user interface.                                           (2 marks)

(b) Give two advantages of using GUI based operating system over a Command line interface.                                                                                                         (1 mark)

(c) Some computer systems still use Command line interfaces.  State two advantages of command line interface.                                                                                (2 marks)

11. State three merits of Menu driven interface over a Command based interface. (3 marks)
12. What is a Deadlock in reference to operating systems?             (2 marks)
13. Explain briefly the following concepts as used in the Windows environment:

• (2 marks)
• (2 marks)
• (2 marks)
• Sidekick menu. (2 marks)
• (2 marks)
• Task (2 marks)

14. Describe three methods of opening an icon into a window. (3 marks)
15. Distinguish between Operating system software and Utility software. (2 marks)

16. Differentiate between a Toolbar and a Status bar. (2 marks)
17. (a) Identify three functions of each of the following window components: (2 marks)
19. Title bar.

(b) List and explain down the three parts of the windows Taskbar.                  (3 marks)

18. (a) Identify three Application software that are installed in your computer. (3 marks)

(b) Give three ways you can start an application in Windows.                          (3 marks)

19. (a) Explain each of the following commands used to manage files and folders. (5 marks)
20. Rename
21. Copy

• Sort

1. Properties

(b). Name the command one would use to repair cross-linked files in Graphical user interface software.                                                                                                     (1 mark)

20. (a) What is disk formatting?                                                             (1 mark)

(b) Why should precautions be taken while formatting diskettes?                     (1 mark)

21. Differentiate between Hard-sectored and soft-sectored disk.             (2 marks)
22. Distinguish between disk compression and disk defragmentation.             (2 marks)

23. (a). Define ‘Folder/ directory tree’ (1 mark)

(b). Give two examples of root directories you know.                                        (1 mark)

(c) Give three uses of sub-directories or subfolders.                                          (3 marks)

24. Draw a directory tree showing how files and folders are organized by an operating system.                   (5 marks)
25. Identify two factors that you would consider when choosing an operating system for use in a computer.             (2 marks)

26. You are employed in an organization as a computer operator in the Accounts department. The following are some of the tasks you are supposed to perform:
    • Data entry.
    • Ensuring that data entered in the computer is stored in a well-organized manner.
    • Backing up data.
    • Monitoring hard disk space of all computers in the department.

• What is used in Microsoft Windows to store programs and files in a well-organized manner? (1 mark)

• Explain two methods of backing up data into a storage device in Windows.                                                                                                                                    (2 marks)
• Identify two reasons why a user needs to know the space available for data storage in the hard disk.             (2 marks)

27. Explain how Windows organizes information in reference to files and folders. (1 mark)
28. Distinguish between System files and Application files.             (2 marks)
29. Outline three reasons why it is important to first shut down the computer before turning it off.                         (3 marks)

30. Outline the procedure of renaming a file or folder using windows operating system.                                                                                                                                           (3 marks)
31. Which keys in the keyboard should one press when he/she wants to:
32. Cut
33. Copy

• Paste

1. Rename an item
2. (a) What is meant by the term ‘disk Partitioning’? (1 mark)

(b) Give two reasons why the hard disk may be partitioned.                              (2 marks)

33. (a) State two purposes of the Recycle Bin. (2 marks)

(b) Give two advantages of using a password in Windows as an operating system.                                                                                                                                                     (2 marks)

34. A computer specification has the following details:

Pentium III

1.44 MB Floppy disk drive

20 GB Hard disk

Full Multimedia

17” SVGA monitor

Pre-installed Operating system

Pre-installed Office Suite

• What is meant by: –             (3 marks)
  • 44 MB floppy disk drive.
  • 20 GB
  • 17” SVGA
• Which operating system might be pre-installed in this computer, and why? (2 marks)

35. A school organizes its work in directories. The directory WP contains the files CATS, EXAMS and ASSIGNMENTS. The directory SP contains the spreadsheet files.  The directory DB contains the database files.  The directory PROG is contained in the OTHERS directory.  The directory WP also contains the PERSONAL directory.  Given that the directory STUDENT contains directories SP, DB, WP and OTHERS.

• Draw the directory tree structure with C as the root. (7 marks)

• Write the path at which the contents of subdirectory DB can be erased or displayed.                         (2 marks)

• Write the path for the directory PROG. (2 marks)
• Give two reasons for storing files in directories and subdirectories. (2 marks)

FORM TWO – WORD PROCESSING – MS WORD

1. (a) What is a Word processor? (1 mark)

(b) State 4 purposes of word processing.                                                             (2 marks)

(c) Name any three characteristics of a good word processor.                           (2 marks)

2. State four editing and six formatting features of any good word processor. (10 marks)
3. Give four uses of the Horizontal ruler in Microsoft Word. (4 marks)
4. (a) What is a Template? (1 mark)

(b) State two advantages of using a template to create a document.                  (2 marks)

(c) List five types of documents where you would use a template.                   (5 marks)

5. Explain the difference between Type over and Insert mode in word processing. (2 marks)
6. Veronica tried to retrieve a document file following all the steps correctly. The filename did not appear in file list box.  State three causes for this.                                    (3 marks)

7. (a) What is the function of the following combination of keys?             (4 marks)

• CTRL + A.
• CTRL + Page Up.
• CTRL + Home.
• CTRL + B
• CTRL + E
• CTRL + Z
• CTRL + F
• CTRL + SHIFT + HOME

8. Explain the role/use of the following features in a word processor: (4 marks)

• Find and Replace.
• Undo and Redo.

9. Differentiate between bolding and highlighting text. (2 marks)
10. (a) Name and explain the use of any three buttons found in a Spell-check dialog box.             (6 marks)

(b) List the steps that you would use to correct wrongly-spelled words in a document using the spell-checking feature.                                                                               (3 marks)

11. Clearly explain the meaning of the following terms as used in word processing:

• Blocking text. (1 mark)
• Word wrap. (1 mark)
• Italicizing text. (1 mark)
• Page Break. (2 marks)
• (2 marks)
• (1 mark)
• (1 mark)
• (2 marks)
• (2 marks)
• (1 mark)
• (1 mark)

12. (a) What is document formatting?                                     (1 mark)

(b) Give any five document formatting features.                                                            (5 marks)

(c) Differentiate between ‘Superscript’ and ‘Subscript’ font.                            (2 marks)

(d) State one function of Drop Cap in a document.                                            (1 mark)

13. (a) Explain the importance of Page numbers in a document.             (1 mark)

(b) Explain how you can give different page numbering styles to different pages in a multipage document.                                                                                      (1 mark)

14. Differentiate between:

• A Hard page break and a Soft page break.             (2 marks)
• Return address and Delivery address. (2 marks)
• AutoComplete and AutoCorrect. (2 marks)
• Drawing and inserting a table in a document. (2 marks)
• First line indentation and Hanging indentation (2 marks)

15. (a) Distinguish between Copying and Moving text.             (2 marks)

(b) Explain how a paragraph can be moved from one page to another using a word processor.                                                                                                                               (4 marks)

16. Distinguish between margins and borders as used in word processing. (2 marks)
17. (a) What is Line spacing?             (1 mark)

(b) Explain any three line spacing specifications used in Microsoft Word.      (3 marks)

18. Give any four alignment features.             (4 marks)
19. Give two advantages of using a Text box to write text in an advertisement. (2 marks)
20. (a) Explain the concept of importing objects into a word processor.             (1 mark)

(b) What is the difference between object Linking and Embedding?                (2 marks)

21. Give a reason why it may be necessary to merge cells in a table. (1 mark)
22. (a) List two arithmetic operations that can be performed on a row of numeric data in a word

processing table.                                                                                             (1 mark)

(b) In each case of (a) above, write the expression used.                                                (2 marks)

23. (a) Define Mail merging.             (2 marks)

(b) Outline the three basic steps required to mail merge a document.               (3 marks)

(c). List any two ways of merging a document with its data source.                  (2 marks)

(d) Give three advantages of mail merge over copy and pasting several times to mass mail a document?                                                                                                       (3 marks)

24. Give two advantages of previewing a document before printing. (2 marks)
25. (a) Distinguish between Portrait and Landscape orientations.             (2 marks)

(b) State two reasons why it is necessary to specify the correct paper size before printing a document?                                                                                                 (2 marks)

26. Name two functions performed by a word processor.             (2 marks)

SPREADSHEETS – MS EXCEL

1. (a) What is Electronic spreadsheet software?                                                    (2 marks)

(b). Explain the use of electronic spreadsheet software in business organizations.                                                                                                                                                 (4 marks)

2. Differentiate between the traditional analysis ledger sheet and an electronic spreadsheet.                               (5 marks)
3. (a) Describe the three components of a spreadsheet.             (3 marks)

(b)  Apart from Microsoft Excel, give any two other application programs classified as spreadsheets.                                                                                                  (2 marks)

4. Explain five application areas where spreadsheet software can be used.             (5 marks)
5. Describe any five features (advantages) of electronic spreadsheet software. 5 marks)
6. Explain the following terms as used in spreadsheets. (4 marks)
   • Rows
   • Automatic recalculation.
7. Explain the concept of ‘What if’ analysis. (2 marks)
8. (a) Explain the term ‘Range’. (1 mark)

(b) State two actions that can be performed on ranges in Microsoft Excel.       (2 marks)

9. State any four data types used in a spreadsheet.             (2 marks)
10. List four formatting features provided by Microsoft Excel. (4 marks)
11. Define the following terms as used in computer environment.             (3 marks)
    • Operator
    • Operands
    • Operation
12. (a) Define the following terms as used in spreadsheets:             (6 marks)

• values
• formula
• Function
• Labels

(b). List four mathematical functions provided by Microsoft Excel.                      (4 marks)

13. (a) The following is a simple payroll:

Write formulae using cell names for the following expressions.  State where the formula is placed:                                                                                                            (10 marks)

• Basic pay = Hours worked x Hourly rate.
• Allowances are allocated at 10% of the Basic pay.
• Gross pay = Basic pay + Allowances.
• Tax deduction is calculated at 20% of the Gross pay.
• Net pay = Gross pay – Tax deductions.

(b). List four types of information that can be entered into a spreadsheet cell. (4 marks)

14. (a) What is a cell reference? (1 mark)

(b) Mention four examples of cell reference                                                      (2 marks)

(c) Distinguish between Absolute cell reference and Relative cell reference.   (2 marks)

(d) For each of the following, state the type of cell reference.                           (4 marks)

1. A5
2. $F$5

• H$21

1. $D7

15. Compute: (2 marks)

• 37 MOD 5
• 37 DIV 5

16. (a) A formula to add the contents of B5 and C4 was entered in cell F5.  What will it become when it is copied to cell H8?                                                                                    (1 mark)

(b) Explain the reason for your answer.                                                              (2 marks)

17. (a) Write the formulae =F10 + G20 as absolute.             (1 mark)

(b) The formulae =A1+C2 is initially typed in cells D1.  What will it be when copied to cell E1?                                                                                                                       (1 mark)

(c) What is the equivalent R1C1 reference for G20?                                          (1 mark)

18. Give at least five categories of functions that are available in Microsoft Excel. (5 marks)
19. What is the role of the following functions as used in a spreadsheet program? (5 marks)

• Product
• SQRT
• Average
• Max
• IF
• COUNTIF
• SUMIF

20. A worksheet contains the data shown below:

State the value displayed in G1.                                                                          (2 marks)

21. Explain why a value such as 611233444555 may be displayed as ######### when typed on a spreadsheet.             (2 marks)
22. (a). Assuming that the formula ‘= A5 * $B2’ is in cell C10 of a spreadsheet. Show how it will appear after copying it to cell H12.                                                    (1 mark)

(b). Explain how you would select non-contiguous cells in spreadsheet.          (2 marks)

23. A worksheet contains the data as shown below.

• The formula =COUNTIF (C1:C3, “> 10”) was entered at G1. Write down the value that was displayed.                                                                                                       (2 marks)

• Write down the formula that would be entered at cell B7 to sum the values in column A whose values are greater or equal to 5.             (3 marks)

• The formula = $C2 + C$3 is entered in cell C5 and then copied to D10. Write down the formula as it appears in the destination cell.                                                         (3 marks)

24. (a) What is a Chart wizard in spreadsheets? (1 mark)

(b) Give two examples of charts that you know.                                                 (2 marks)

(c). Outline the steps required when creating a simple chart.                             (6 marks)

25. Andrew, Jane, David and Zablon had Tea, Sausages and Bananas for breakfast. They took one sausage, two sausages, three sausages and one sausage respectively.  In addition, they each took a cup of tea and two bananas.  Tea, sausages and bananas cost Ksh. 10, 15, and 5 respectively.

• By naming columns A, B, C, ………and rows 1, 2, 3……….Construct a worksheet showing the above information. (7 Marks)

• State the expression you would use to obtain:
  1. Total expenditure by David. (4 marks)
  2. Total number of sausages taken. (2 marks)

• The cost of the cheapest item. (2 marks)

26. The following diagram is a Microsoft Excel worksheet containing the scores of Form 1 students of Excellent High school.

Write Microsoft Excel formula to calculate:

• Total score for each student.             (1 mark)
• Highest score per subject. (1 mark)
• Mean score per subject. (1 mark)
• Best overall student. (1 mark)

27. What is a cell reference error as used in spreadsheets?             (1 mark)
28. A worksheet contains the data shown below:

• The formula =IF(A1:A5 = “Jane”, 1, 0) is entered in cell B1
  • State the value displayed (2 marks)
  • If the formula in B1 is copied and pasted to cells B2, B3, B4 and B5 respectively, fill in what is displayed in each cell.                         (2 marks)

• Under what two conditions does a worksheet display # # # # # #             (2 marks)
• A spreadsheet application can be used in analysis of trends of performance. List any three types of charts you can make.                                                                 (3 marks)

29. Consider the entries made in the cells below:

State the value displayed in cell C13.                                                                        (1 mark)

30. A student presented a budget in the form of a worksheet as follows.

The student intends to have spent half the amount by mid-term.

• Given that the value 0.5 is typed in cell B9, write the shortest formula that would be typed in cell C2 and then copied down the column to obtain half the values in column B. (1 mark)

• Write two different formulae that can be typed to obtain the total in cell B6 and then copied to cell C6. (2 marks)

31. The cells K3 to K10 of a worksheet contain remarks on students’ performance such as Very good, Good, Fair and Fail depending on the average mark. Write a formula that can be used to count all students who have the remark “Very good”.                                  (3 marks)

32. The following information shows the income and expenditure for “Bebayote” matatu for five days. The income from Monday to Friday was Kshs. 4,000, 9,000, 10,000, 15,000, and 12,000 respectively while the expenditure for the same period was Kshs. 2,000, 3,000, 7,000, 5,000, and 6,000 respectively.

• Draw a spreadsheet that would contain the information. Indicate the rows as 1, 2, 3 …. and the columns as A, B, C …..                                                               (4 marks)

• State the expression that would be used to obtain:

I  Monday’s profit                                                                                          (2 marks)

II  total income                                                                                               (2 marks)

III  highest expenditure.                                                                                 (2 marks)

33. (a) Distinguish between the following sets of terms as used in spreadsheets.

• Worksheet and workbook. (2 marks)

• Filtering and sorting. (2 marks)

(b) State one way in which a user may reverse the last action taken in a spreadsheet package.                                                                                                                              (1 mark)

(c) The following is a sample of a payroll.  The worksheet row and column headings are marked 1, 2, 3 … and A, B, C … respectively.

Use the following expressions to answer the questions that follow:

• Basic pay = Hours worked x pay per hour
• Allowances are allocated at 10% of basic pay
• Gross pay = Basic pay + allowances
• Tax deductions are calculated at 20% of gross pay
• Net pay = Gross pay – tax deductions

Write formulae using cell references for the following cells:

• D2 (1 mark)
• E4 (1 mark)
• F10 (1 mark)
• G7 (1 mark)
• H5 (1 mark)

DATABASES – MS ACCESS

1. (a) Define a Database, and give two examples of database programs in use today. (2 marks)

(b) List any two database objects.                                                                                   (2 marks)

2. List five features found in an electronic database management system.             (5 marks)

3. State three advantages of an electronic database over the traditional file management system.                   (3 marks)
4. (a) Distinguish between the following terms in relation to a database: (6 marks)
5. Field type and field properties.
6. Records and Fields.

• AND and OR operators.

(b). Explain three types of database models.                                                       (3 marks)

(c) Explain three major concerns in database systems.                                      (3 marks)

5. (a) Distinguish between Flat file and Relational databases.             (2 marks)

(b) State three operations that can be performed on a relational database files.           (3 marks)

6. Identify five functions of a Database management system. (5 marks)
7. Explain the importance of using Database management system in organizations. (2 marks)
8. State the components of a Database hierarchy in ascending order. (2 marks)
9. State the use of the following objects in Databases.
   1. Tables (1 mark)
   2. Forms (1 mark)

• Query (1 mark)

1. Macros (1 mark)
2. Reports (1 mark)

10. Name two different types of tools one can use to search for data in a database. (1 mark)
11. (a) Differentiate between: (14 marks)
12. Primary key and Relationship.
13. Tabular and Columnar form layout.

• Database file and Database table.

1. Primary key and Index.
2. Field name and Caption.
3. Table and Query.

• Bound and unbound control.

(b) What is the importance of the Primary key?                                                 (1 mark)

(c) State three types of relationships that can be used to link tables in Databases.                                                                                                                                                       (3 marks)

12. (a). Describe four major shortcomings of the conventional (paper) file structures that are being addressed by the database approach.             (4 marks)

(b). List any two methods used to secure data in a database.                             (2 marks)

13. A student’s database comprises of students’ details table and fees received table as shown below:

Students’ details table                                                     Fees Received table

• State the primary key field for each table. (2 marks)
• State the field which should serve as the linking field for the two tables.         (2 marks)

DESKTOP PUBLISHING (DTP) – MS PUBLISHER

1. (a) What is Desktop publishing?             (2 marks)

(b) Give three examples of desktop publishing software available in the market today.                                                                                                                                                            (3 marks)

(c) State five features in desktop publishing.                                                     (5 marks)

2. Identify four common features in word processing and desktop publishing software.                                                                                                                                           (4 marks)
3. List four areas of DTP application.             (2 marks)
4. Differentiate between the following:

• Pasteboard and Printable page. (2 marks)
• Margins and Column guides.                         (2 marks)
• Change case and drop cap. (2 marks)
• Kerning and tracking. (2 marks)
• Fill and line stroke. (2 marks)

5. Explain the following as used in DTP: (3 marks)

• Master pages.
• Placeholders / selection handles.

6. Why are master pages important in a publication? (1 mark)
7. (a) What are non-printing guides? (1 mark)

(b) Give three nonprinting guides used in PageMaker.                                       (3 marks)

8. What does the term Gutter mean in relation to column setting?             (1 mark)
9. What commands are used in place of portrait and landscape page orientation in PageMaker?                               (1 mark)
10. Explain the function of each of the following tools on the PageMaker’s toolbox.                                                                                                                                           (4 marks)
11. Pointer tool
12. Text tool

• Rectangle tool

1. Rotate tool
2. Zoom (magnifier) tool

11. Mention the three main purposes of a desktop publishing software.             (3 marks)
12. Define the term artwork. (1 mark)
13. Give three methods that are used to transform an object.             (3 marks)

14. (a) What is Text wrap? (1 mark)

(b) Give three ways you can wrap text on an object.                                          (3 marks)

(c) Explain the concept of wrapping text around objects.                                   (1 mark)

15. Explain the following graphic terms:             (2 marks)

16. State three ways of moving round the page in a Desktop Publishing window. (3 marks)

INTERNET & E-MAIL

1. Explain the following: (3 marks)

• File Server.

2. List any three major services provided on the Internet.             (3 marks)
3. Name four facilities that are needed to connect to the Internet.             (4 marks)
4. Your manager wishes to be connected to the Internet. He already has a powerful Personal Computer (PC), a Printer, and access to a Telephone line.  However, he understands that he will need a Modem.

Required:

• State why a modem is required to connect him to the Internet.             (2 marks)
• Suggest any four application areas in which you would expect a supermarket retail manager to use the Internet.                         (4 marks)

5. (a) What is a Website? (2 marks)

(b) Give the advantages and disadvantages of a Website.                                  (4 marks)

6. (a) What is meant by the term E-learning? (1 mark)

(b) A school intends to set-up an e-learning system.  List three problems that are likely to be encountered.                                                                                                      (3 marks)

7. (a) What are network Protocols?

(b) Write the following in full:

1. TCP/IP
2. HTML

• HTTP

1. FTP
2. (a) Explain the meaning of the following concepts as used in Internet: (6 marks)

1. Internet service provider (ISP)
2. Web pages

• Internet telephony

1. Browser software
2. Hyperlink

(b) Name three examples of Internet Service Providers (ISP) in Kenya.                       (3 marks)

9. Give two common examples of web browsing software.             (1 mark)
10. Briefly describe four advantages of using Internet to disseminate information compared to other conventional methods. (8 marks)

11. (a) Identify the parts of the following e-mail address labelled A, B, C, and D. (4 marks)

Iat@africaonline.co.ke

A        B             C   D

(b) Mention two examples of e-mail software.                                                   (2 marks)

12. A school has its e-mail address as mwangaza@school.co.ke. Briefly explain this address code.                                                                                                                    (3 marks)
13. State two benefits of saving information from the Internet to your hard disk. (2 marks)
14. Explain the following internet address http://www.google.com in reference to the structure of a URL.                   marks)

15. Identify institutions whose e-mail addresses end with the following extensions: (6 marks)
    1. .org
    2. .edu

• .com

1. .net
2. .mil
3. .gov

16. (a) Discuss four advantages and two disadvantages that electronic mails have over regular mails.                                                                                                             (6 marks)

(b) Give three differences between Post-office mail and Electronic mail (E-mail).                                                                                                                                               (3 marks)

17. (a) What is a Search engine? (2 marks)

(b) Give four examples of search engines you know.                                         (2 marks)

(c) State two ways that search engines use to locate Web pages.                      (2 marks)

18. List two advantages of using Hyperlinks when browsing the Internet.             (2 marks)
19. Differentiate between a www server and a Host computer. (2 marks)
20. The Internet can be used to source information about emerging issues that may not be available in print form. Give two advantages and two disadvantages of information obtained from the Internet.                                                                                                    (4 marks)

DATA SECURITY & CONTROL

1. (a) Differentiate between Data Security and Data Integrity.             (2 marks)

(b) Give the three types of data that should be protected in a computer.                       (3 marks)

2. State any three threats to data and information.             (3 marks)
3. State five possible ways of preventing data loss from a computer. (5 marks)
4. (a) Define the term Computer crime. (2 marks)

(b) Explain the meaning of each of the following with reference to computer crimes.

1. Tapping

1. Industrial espionage

1. Data alteration
2. Fraud

• Firewalls

5. Give two reasons that may lead to computer fraud. (2 marks)
6. Outline four ways of preventing piracy with regard to data and information. (4 marks)
7. (a) Differentiate between Hacking and Cracking with reference to computer crimes. (2 marks)

(b) Describe the following terms with respect to computer security:                (6 marks)

• Audit trail.
• Data Encryption.
• Log files.
• Physical security
• Logic bombs.

8. (a) What is a Computer virus? (2 marks)

(b) Outline four symptoms of a virus infection in a computer system.             (4 marks)

(b) State two damages which a computer virus may cause to a computer.        (2 marks)

(c) Explain three control measures you would take to protect your computers from virus attacks.                                                                                                           (3 marks)

9. List three functions of an antivirus software. (3 marks)
10. Computer systems need maximum security to prevent an unauthorized access. State six precautions that you would expect an organization to take to prevent illegal access to its computer-based systems.                                                                                     (6 marks)

11. (i) Explain what is meant by the term “computer security”                              (2 marks)

(ii) State two environmental factors that can affect operations of a computer. (2 marks)

(iii) State two control techniques or measures that can be implemented to prevent the effect in (i) above.                                                                                                      (2 marks)

12. Explain why the following controls should be implemented for computer based systems.

1. Backups (2 marks)
2. Air conditioning (2 marks)

• Uninterruptible power supply (UPS) (2 marks)

1. Segregation of duties (2 marks)
2. Passwords (2 marks)
3. Give four rules that must be observed in order to keep within the law when working with data and information.                   (4 marks)

14. (a) Define the term Computer ethics. (1 marks)

(b) Give two examples to show how a person who has committed a computer crime can help to improve a computer system.                                                             (2 marks)

FORM THREE – DATA REPRESENTATION IN COMPUTERS

1. Data in a computer is represented in one major form. Define the term ‘Data representation’ in a computer.                                                                                               (1 mark)

2. (a) Differentiate between Analogue data and Digital data. (2 marks)

(b) Draw a sketch of:

• Analogue data signal. (1 mark)
• Digital data signal. (1 mark)

3. Give two reasons for the popularity of binary number representation.             (2 marks)
4. Explain the role of a Modem in communication.             (2 marks)
5. Distinguish between the following terms as used in data representation in computers:

• A Byte and a Nibble. (2 marks)
• Word and Word length.             (2 marks)

6. Arrange the following data units in ascending order of size.

BYTE, FILE, BIT, NIBBLE.                                                                                (2 marks)

7. Write out what A, B, C and D represent in the table below. (4 marks)

8. Perform the following computer arithmetic. In each case, show how you arrive at your answer.

• Convert the following Decimal numbers to their Binary equivalent.
  1. 11 (1 mark)
  2. 001 (1 mark)

• 457

• Convert the following Octal numbers to their Binary equivalent.

1. 77 (2 marks)
2. 0000001 (2 marks)

• Use Binary addition to solve the following decimal summations.

1. 4₁₀ + 3₁₀ (2 marks)
2. 13₁₀ + 2₁₀ (2 marks)

• Convert the following Hexadecimal numbers to their Binary equivalent.

1. C3 (3 marks)
2. 13 (3 marks)

• Convert the following Binary numbers to their Hexadecimal equivalent.

110111. 11 (2 marks)
110112. 1110101 (2 marks)

• 110000111111111111 (2 marks)

9. (a) State one use of hexadecimal notation in a computer. (1 mark)

(b) Convert 767₈ to hexadecimal.                                                                                    (2 marks)

10. Use One’s compliment to solve the following sums:
    1. 9 – 6 (3 marks)
    2. 17 – 15 (3 marks)

• 1110 – 1011                         (2 marks)

1. 111010 – 110011             (2 marks)

11. Perform the following conversions:
    20. 2₁₆ to decimal. (3 marks)
    21. 11101₂ to Decimal. (3 marks)
12. (a) Perform the following Binary arithmetic: 75 + 45             (2 marks)

(b). Use Two’s compliment to perform the following Binary subtraction:

1. 10111 – 10001 (2 marks)
2. 11000 – 10011 (2 marks)
3. Use Two’s compliment to solve the following SUMS (the numbers are in decimal notation)

1. 23 – 20 (3 marks)
2. 17 – 14 (3 marks)

14. Perform the following binary arithmetic:
    • 11100111 + 00101110 (1 mark)
    • 1000 – 101 (using 2’s complement)             (2 marks)
15. Convert the decimal number 4 ¾ into binary form.             (4 marks)
16. Convert the binary coded decimal number given into its hexadecimal equivalent.

10001001₂ (show your work clearly)                                                                   (2 marks)

17. Work out the 8-bit binary two’s complement of the number -2₁₀             (3 marks)
18. Convert the hexadecimal number FC1 to its binary equivalent.             (6 marks)
19. Convert 7AE₁₆ to a decimal number. (2 marks)
20. State three methods of representing data in binary number system.             (3 marks)
21. (a) Explain Binary Coded Decimal code of data representation.             (1 mark)

(b) Write the number 451₁₀ in BCD notation.                                                     (1 mark)

22. (a) Subtract 0111₂ from 1001₂ (1 mark)

(b) Using two’s complement, subtract 7 from 4 and give the answer in decimal notation.                                                                                                                                                (4 marks)

(c) Convert:

• 91B₁₆ to octal (3 marks)
• 376₈ to hexadecimal (3 marks)
• 625₁₀ to binary (4 marks)

DATA PROCESSING

1. Distinguish between Data and Information. (2 marks)
2. Using an illustration, describe the four primary stages of the data processing cycle. (6 marks)
3. Clearly differentiate between the following processing terms:
4. Data collection and Data capture. (2 marks)
5. Verification and Validation.             (2 marks)
6. (a) Give four methods of data collection.             (4 marks)

(b) Outline the stages of data collection.                                                            (3 marks)

5. (a) Explain the relevance of the term Garbage in Garbage out (GIGO) in reference to errors in data processing.             (1 mark)

(b) Explain two main types of errors in data processing.                                               (2 marks)

6. (a) Name and explain the two types of transcription errors. (3 marks)

(b) State three types of computational errors.                                                     (3 marks)

7. (a) Define the term Data integrity (1 mark)

(b) State three ways of minimizing threats to data integrity.                             (3 marks)

8. (a) Briefly explain the following data processing modes:
   1. Online processing.             (2 marks)
   2. Real-time processing. (2 marks)

• Batch processing.             (2 marks)

1. Distributed processing.             (2 marks)
2. Multi-programming (multi-tasking).             (2 marks)
3. Multi-processing.             (2 marks)

• Interactive processing.             (2 marks)
• Remote job entry. (2 marks)

(b) Differentiate between:

• CPU bound jobs and I/O bound jobs.             (4 marks)
• Command files and Text files. (2 marks)

9. (a) Mention five features of a Real-time system.                         (5 marks)

(b) Name two industries that extensively use Real-time processing.                 (2 marks)

(c) Give three advantages and two disadvantages of a Real-time system.         (5 marks)

(d) In Real-time systems, Front-End Processors are quite useful.  State any three reasons why you think they are important.                                                                           (3 marks)

(e) State why an online data processor should be a real-time processor in a multi-access plant.                                                                                                                           (2 marks)

10. Most companies are now shifting from the use of centralized mainframe computers to the use of geographically distributed personal computers. This method of data processing is known as Distributed Data Processing (DDP).

1. Name any three computing resources that can be distributed. (3 marks)
2. Explain three ways in which microcomputers/personal computers can be networked to form a distributed data processing system.                                 (6 marks)

• Name four examples of industries and business organizations that extensively use distributed processing systems. (4 marks)

1. List down two benefits and three risks that might be associated with the distributed data processing system.                                 (5 marks)

11. Explain time sharing data processing mode, giving two advantages and two disadvantages of its application.       (6 marks)
12. (a) Give two benefits that are derived from Multi-programming. (2 marks)

(b) In a Multiprogramming environment, how does the Operating system ensure that users’ input and output do not get jumbled (cluttered) up?                                      (1 mark)

13. List three factors to be considered when deciding on the choice of an electronic data processing method.                                                                                             (3 marks)

14. (a) What is a Computer file? (2 marks)

(b) Name the three constituent parts of a computer file.                                                (3 marks)

(b) State and explain five different types of data processing files.                    (5 marks)

15. Distinguish between Logical and Physical computer files.             (2 marks)
16. Arrange the following components of the information system data hierarchy in ascending order of complexity:

Field, Database, Byte, Record, Bit, and File                                                       (4 marks)

Provide a brief description for each component.                                                (4 marks)

17. (a) State three advantages of storing data in computer files over the manual filing system.       (3 marks)

(b) List four problems faced when using standard files for data processing systems.                                                                                                                                                  (4 marks)

18. (a) What is File organization? (2 marks)

(b) Describe what is meant by each of the following filing systems:               (4 marks)

• Indexed sequential.

(c) State three advantages of random file organization.                                                (3 marks)

19. State four file processing methods in a computer. (4 marks)
20. State why it is important to have the following computer file components: Beginning-of-file marker and End-of-file marker.             (1 mark)

21. Differentiate between “Serial access” and “Direct access”. Give an example of a storage media in each case.                                                                                              (4 marks)

22. A serial file comprises of records placed in positions 1 to 10. State the position of the end of file marker.                                                                                                            (1 mark)

PROGRAMMING

SECTION A:

1. Define the following terms: (6 marks)
   1. Computer Program

• Programming language.

1. Program portability.
2. Algorithm

2. (a) What are low-level languages? Give their features.             (4 marks)

(b) State 2 advantages and disadvantages of low-level languages.                    (4 marks)

(c) Identify two types of Low-level languages.                                                  (2 marks)

3. Distinguish between Machine language and Assembly language. (2 marks)
4. Most computer programming is carried out using High-level languages.

(a) What are High-level languages?                                                                    (2 marks)

(b) Give three features of high-level programming languages.                          (3 marks)

(c) Give three advantages of High-level languages as opposed to Low-level languages.                                                                                                                                          (3 marks)

5. List three considerations which are present in Assembly language programming but not in high-level programming.             (3 marks)

6. (a) Examine two features of fourth generation languages (4GLS) (2 marks)

(b) Highlight four advantages of fourth generation languages (4GLS)              (4 marks)

(c) List three examples of fourth generation programming languages.             (3 marks)

7. Describe the main feature of fifth generation languages.             (1 mark)
8. (a) Define the term Object-Oriented programming. (2 marks)

(b) List two examples of:

• third generation languages (2 marks)
• object oriented languages. (2 marks)

(c) Give an advantage of using an object-oriented programming language.     (1 mark)

9. Explain the meaning of the following as used in computer programming. (2 marks)
   • Syntax
   • Semantic
10. Describe 5 factors to be considered while choosing a programming language. (5 marks)
11. Differentiate between the following as used in programming:

• Source program and object code. (1 mark)
• Flowchart and Pseudocode. (2 marks)

12. What does the following abbreviations stand for: (2 marks)
13. FORTRAN
14. COBOL

• OOP

13. (a) Define a Language translator. (1 mark)

(b) What is the purpose of the following translator programs?

1. (1 mark)
2. (1 mark)

• (1 mark)

(c)  For each of the following programming languages, give their respective translators.                                                                                                                                                (2 marks)

14. Give two advantages of compiling a program rather than interpreting it. (2 marks)
15. Outline the seven stages in program development cycle in their logical sequence. (7 marks)
16. In program development cycle, what takes place in:

• Problem definition. (1 mark)
• Program documentation. (1 mark)

17. Give two reasons why it is necessary to have a program design.             (2 marks)
18. Using illustrations, explain at least six symbols used in flowchart design. (6 marks)
19. (a) Identify and briefly describe two types of flowcharts. (4 marks)

(b) State any four rules you would follow when:                                                            (8 marks)

1. Writing a pseudocode.
2. Drawing a flowchart

(c). Give two advantages of pseudocodes over flowcharts.                                (2 marks)

20. Define the following types of computer program errors:

• Syntax error. (2 marks)
• Logical error. (2 marks)
• Run-time (Execution) error.             (2 marks)
• Semantic error. (2 marks)

21. What do you understand by the following terms:

• Dry running.                                                 (1 mark)
• Structured walkthrough. (1 mark)
• Test data. (1 mark)
• User Defined Function/ Procedure (UDF) (1 mark)

22. (a) What is Program Documentation? (2 marks)

(b) In what stage of the development does program documentation take pace?            (1 mark)

(c) State two reasons for documenting all the stages of program development.            (2 marks)

(d) Describe three types of program documentation in reference to programming. (6 marks)

23. Briefly explain the purpose of the following types of program documents. (3 marks)

• User manual/guide
• Reference guide
• Quick reference guide.

24. (a) Explain the meaning of Program control structures.             (2 marks)

(b) State the three basic types of program control structures.                            (3 marks)

(c) Draw simple flowcharts to illustrate the following program control structure:

• The Nested IF selection
• The FOR loop
• REPEAT…UNTIL loop. (3 marks)

25. Name the control structure depicted by the flowchart below.             (1 mark)

26. Highlight two disadvantages of monolithic programs.             (2 marks)
27. (a) Define the term Structured programming.             (2 marks)

(b) List any two characteristics of Structured programming.                             (2 marks)

(c) Give two benefits of Structured programming.                                             (2 marks)

28. Structured programming language and Object-oriented programming language are the two main forms of high-level languages. State the difference between the two?         (4 marks)

29. (a) Define the term Selection in relation to program control structures.             (1 mark)

(b). List four selection control structures used in writing a program.                (4 marks)

30. State four features of a user-friendly program. (4 marks)

SECTION B:

1. Draw a flowchart for a program that would enable the user to enter student marks. The program should then determine whether the mark entered is a pass or fail given that the pass mark is 50.                                                                                                                (5 marks)

2. Write a pseudocode that reads temperature for each day in a week, in degree celcius, converts the celcius into Fahrenheit and then calculate the average weekly temperatures. The program should output the calculated average in degrees Fahrenheit.                              (5 marks)

3. Draw a flowchart to be used to develop a program to calculate the Area and Perimeter of a Rectangle. The user is required to input the Length and Width of the rectangle after which she then chooses either to calculate area or perimeter using the input data.  The program then outputs the results of the chosen calculation.                                                      (8 marks)

4. (a). Develop a Pseudocode which will simulate the processing of Student’s report. The simulation should be such that the user repeatedly inputs marks per subject for six subjects using a looping control structure.  The computer processes the total marks and mean score of the student.

Note. 1. It is assumed that the student does six subjects.

2.   The outputs required are; Average score and Total marks.                       (5 marks)

(b). Draw a fitting flowchart for question 1 (a) above.                                       (5 marks)

5. Study the following flowchart diagram.

1. Identify three problems with this flowchart (3 marks)
2. Describe briefly what this program is supposed to do. (2 marks)

• Modify this flowchart using a loop such that it processes a number of students records starting with the first until there are no more student records. (3 marks)

6. Mwalimu Savings Society (MSS) pays 5% interest on shares exceeding 100,000 shillings and 3% on shares that do not meet this target. However, no interest is paid on deposits in the member’s MSS bank account.

• Design a pseudocode for a program that would:
  • Prompt the user for shares and deposit of a particular member.
  • Calculate the interest and total savings.
  • Display the interest and total savings on the screen for a particular member of the society. (7 marks)

• Draw a flowchart for the above pseudocode. (8 marks)

7. The following is a Pseudocode developed for processing employees’ payslips. Read through the Pseudocode carefully, then draw a fitting flowchart.                                        (5 marks)

Start

Initialize employee count to 0

Open employee file

Repeat

Read employee record

Compute gross pay

Compute deduction amount

Compute net pay

Output employee ID, gross pay, deduction, and net pay

Add 1 to count

Until end of employee file

Close employee file

Stop

8. A man deposits 1,000 in a bank at an interest rate of 10% per year. At the end of each year, the interest earned is added to the amount on deposit and this becomes the new deposit for the next year.

Develop a pseudocode to determine the year in which the amount accumulated first exceeds 2,000.  Also for each year, print the year (starting from 1), the deposit, the Interest earned, and the total accumulated at the end of the year.

9. Classify the following examples in any of the three program control structures. (3 marks)

1. Statement 1

Statement 2

.

.

Statement n

………………………………………………………………………………………………

1. IF YourMarks > Mean THEN

PRINT Universal Donor

ELSE

PRINT UniversalReceiver

……………………………………………………………………………………………

• WHILE ExamTime Is Not Over

Read question carefully

Understand question

Think clearly

Answer appropriately

ENDWHILE

……………………………………………………………………………………………

10. Show exactly what is printed (output) by the following program: (3 marks)

PROGRAM MockExam (Input, Output);

CONST

Adjustment = 5;

VAR A, B, C: Integer;

Begin

Readln (A, B, C);

A: = A*B+A+Adjustment;

B: = B+Adjustment;

Writeln (‘The Answers are’, B, C, A, Adjustment);

END. (*PreExam*)

Use these data items: 1 2 3 as test for a, b, and c respectively.

……………………………………………………………………………………………………

……………………………………………………………………………………………………

11. Study the flowchart diagram below and answer the questions that follow:

NO

YES

• What will be the value of sum when printed? Show your workings.         (5 marks)
• Write a Pseudocode for the above flowchart.           (10 marks)

12. A program is required for reading in a students’ name and the scores obtained in two subjects. The output of the program will consist of the student’s name, the two scores, the average of the two scores and a comment.  The comment is based on the average as follows:

Write a program to solve the problem using a high-level language.                  (10 marks)

13. Draw a flowchart that will read a number N and then output the sum of squares from 1 to N.                         (10 marks)
14. (a) Draw a flowchart that can be used to write a program for displaying the first 1000 integers in the series of 2, 4, 6….             (7 marks)

(b) Modify the flowchart to sum up the numbers in (b) i above.                                    (3 marks)

15. The gross salary of employees of Mutson Chemist is based on the Basic salary and additional benefits. Employees with more than 10 year’s experience get an additional pay of 10% of their basic salary.  Bonuses are given as per employees sales of the month as:

>200,000                           15%

100,000 – 200,000            10%

Below 100,000                 5%

Draw a flowchart for the program that will calculate Gross salary and output each employees Basic salary, Gross salary and all benefits.                                                  (15 marks)

16. The following flowchart can be used to list the even numbers between 1 and 100 inclusive.

YES

                              NO

• What will be the output from the flowchart if the statement in the decision box is changed to:                         (6 marks)

• Even = 100
• Even =< 100
• Even > 100.

• Modify the flowchart so that it prints the sum of all the even numbers between.        (5 marks)
• Suppose a 10 element array A contains the values 9, 10, 5, 6, 7, 1, 0, 20, 21, and 11. Find the values in A after executing the loop below.                                    (4 marks)

REPEAT for K = 1 TO 10

Set A [K + 1] = A [K]

End Loop

17. Bidii wholesalers has two categories of customers for order processing. Category ‘A’ obtains 10% discount on all orders up to Ksh. 10,000 otherwise the discount is 20% on the entire order.  Category ‘B’ obtains 30% discount on all orders if the debt repayment is ‘good’ otherwise the discount is 15%.  Draw a flowchart for the order processing.        (15 marks)

18. (a) State the stage of program development in which: (2 marks)

• a flowchart would be drawn
• the programmer would check whether the program does as required
• the user guide would be written
• the requirements specifications would be written.

(b) State the output of the following flowchart segment.

(2 marks)

(c) Draw a flowchart to compute the combined resistance (R) of two resistors R₁ and R₂ in parallel using the formula;

R =      1

1  +  1

R₁    R₂                                                                               (5½ marks)

19. Draw a flowchart to compare three non-equal numeric values A, B, C and print the largest of the three.                   (11 marks)

SYSTEMS DEVELOPMENT

1. (a) What is a System?                         (2 marks)

(b) Differentiate between soft systems and hard systems.                                 (2 marks)

(c) Explain five characteristics of a system.                                                       (5 marks)

2. (a) Define the term Information system.             (2 marks)

(b) State and explain three purposes of information systems in organizations. (3 marks)

(c) Highlight three circumstances that necessitate the development of new information systems.                                                                                                          (3 marks)

3. State four roles played by an Information system analyst. (4 marks)
4. Define the following terms:
5. System control.
6. System boundary.

• Online analytical processing.

5. Explain three system development theories and methods. (6 marks)
6. (a) State one disadvantage of the Traditional approach in system development.(1 mark)

(b) State one advantage and one disadvantage of Rapid Application Development method.                                                                                                                                               (2 marks)

7. (a) Define the term System development lifecycle. (2 marks)

(b) Outline seven stages followed when creating an information system.         (7 marks)

8. (a) Define the term Feasibility study as used in system development.             (2 marks)

(b) List four contents of a feasibility study report.                                             (4 marks)

9. Your school has a plan to acquire and install computers.

• List six criteria considered when deciding between the various computer suppliers who have submitted their tenders.                         (6 marks)
• The school’s Board of Governors has employed an independent expert to carry out the feasibility study of the project. List four essential components of this study. (4 marks)
• State any five in-depth fact findings about the existing school system. (5 marks)

10. (a) State the importance of information gathering (fact-finding) in system development.             (2 marks)

(b) State four methods that can be used to gather information during system development.                                                                                                                                      (4 marks)

11. (a) Identify two advantages and two disadvantages of Observation method used in fact-finding.                                                                                                           (4 marks)

(b)  State two advantages and two disadvantages of the Interview method when used for information gathering.                                                                                   (4 marks)

12. Explain the concept of Proxemics in interviews.             (1 mark)
13. (a) State three merits and three demerits of using a questionnaire in information gathering.       (6 marks)

(b)  Name three circumstances in which it is better to use a Questionnaire than an Interview for gathering information.                                                                         (3 marks)

14. (a) Explain the importance of using Automated methods in fact finding. (1 mark)

(b) Give one example of Automated information gathering technique.             (1 mark)

15. Mention the four areas that are considered during the requirements specification stage.             (4 marks)
16. Explain three factors that should be considered during output design.             (6 marks)
17. (a) State four factors that may be considered in order to design a good file. (4 marks)

(b) Explain why it is important to consider file backup and recovery strategies during file design.                                                                                                                  (1 mark)

18. Define the term “Attribute” (1 mark)
19. Outline three factors that should be considered when sourcing for hardware and software resources required for a new system.                         (3 marks)

20. State two methods/tools that a system Analyst may use to design a system. (2 marks)
21. (a) Differentiate between a System flowchart and a Program flowchart.             (2 marks)

(b) Draw four system flowchart symbols and explain their functions.              (4 marks)

22. Explain three tasks that are carried out during system implementation.             (3 marks)
23. (a). What is systems documentation.                                                 (2 marks)

(b) In the context of information systems development, illustrate the significance of systems documentation.                                                                                             (8 marks)

(c) List any four tools that systems analysts may use to document their findings or design options during Systems analysis and design.                                                 (4 marks)

(d) Outline four contents of a User manual.                                                        (4 marks)

24. Most information systems are reviewed or critically examined 3 – 6 months after they have been implemented or put into operation.

1. State the purpose or objective of this review. (4 marks)
2. List four areas of systems operation on which the review focuses. (4 marks)

25. The company you work for has decided to replace its inventory control system. The current system was implemented ten years ago but has restricted reporting facilities and has a text-based interface.  As the project manager, you are now considering details of implementation.  You have been advised that you should consider both ‘Parallel running” and “direct changeover/conversion”.

• Explain the following terms as used in program implementation: (2 marks)
  1. Parallel running.
  2. Direct changeover
• Give one advantage of Direct changeover over Parallel running.             (1 mark)
• Identify two main risks of direct changeover, and suggest how these risks might be reduced for the inventory control system implementation.             (6 marks)

26. Your school wishes to replace the original filing system with an Information and Communication Technology (ICT) system.

• Name two things the school must be sure of before replacing the old system. (2 marks)

• Mention four problems that may arise incase the manual system is phased out completely and replaced with the ICT system.                        (4 marks)

• Give two advantages of running both the manual system and the ICT system simultaneously. (2 marks)

• Mention any two disadvantages of running the two systems simultaneously. (2 marks)

• Outline five basic qualifications of the IT manager should the school need to employ one.             (5 marks)

FORM FOUR – NETWORKING & DATA COMMUNICATION

1. Define the following terms: (2 marks)
   • Computer network.
   • Data communication.
2. (a) Describe the three methods of data transmission on a network.             (3 marks)

(b) State the factors to be considered while selecting a data transmission system. (3 marks)

3. Differentiate between a MODEM and a MULTIPLEXER. (2 marks)
4. Differentiate between:                                                                                     (8 marks)

• A baseband and broadband signal.
• A Network server and a workstation.
• Remote client and remote host.
• Half duplex and full duplex transmissions.

5. A student typed an e-mail to send over the Internet through a modem working at a speed of 100 Mbps. Calculate the maximum number of characters that can be sent per second if each character consists of 8 bits.                                                                                  (2 marks)

6. Explain the meaning of the following terms as used in networking:

• (1 mark)
• Baud rate. (1 mark)
• (1 mark)
• (1 mark)
• Guard band. (1 mark)
• Broadband (1 mark)
• Base band (1 mark)
• Resource (1 mark)
• Server (1 mark)
• Client / workstation                                                                                     (1 mark)
• (1 mark)

7. Explain three advantages and three disadvantages of computer networking. (6 marks)
8. (a) State the type of data communication media that could be used in an electronically noisy environment.             (1 mark)

(b) Explain your answer in (a) above.                                                                 (1 mark)

9. (a) Examine the major characteristics of each of the three types of computer networks. (9 marks)

(b) Briefly explain four important benefits of using Local Area Networks (LANs) at an

institution such as a college.                                                                          (8 marks)

(c)  List three differences between Wide Area Network (WAN) and Local Area Network (LAN).                                                                                                            (3 marks)

10. (a) Define the term Transmission media. (1 mark)

(b)  Give two advantages and two disadvantages of each of the following network transmission media.

1. Twisted pair cables.
2. Coaxial cables.

• Fibre optic cables.

1. Wireless / Microwave / Radio transmission.

11. Explain the line of sight principle in wireless communication.             (1 mark)
12. (a) Explain the function of each of the following on a network:
13. Network Interface Card                         (1 mark)
14. Repeater (1 mark)

• (1 mark)

(b) Differentiate between a router and a gateway as used in networking.          (2 marks)

13. (a) Study the diagram below and answer the questions that follow:

B

C                                           D

A

1. Name the communication media depicted in the above diagram. (1 mark)
2. Name the parts labelled A, B, C and D.             (4 marks)

• List three advantages of the above communication media.             (3 marks)

14. (a) Compare and contrast a Brouter and a Router.             (2 marks)

(b) Give one disadvantage of a Hub on a network.                                             (1 mark)

15. (a) Define a computer terminal as used in a communication network.             (1 mark)

(b) List any two items that may be referred to as Data Terminal Equipment in a network                                                                                                                                          (2 marks)

(c) Distinguish between an intelligent terminal and a dump terminal.              (2 marks)

16. (a) List two types of network software. (2 marks)

(b) Outline five functions of network operating system.                                                (5 marks)

17. (a) Give three examples of protocols used in networking. (2 marks)

(b) Outline the seven open system interconnection (OSI) reference model layers.                                                                                                                                                 (7 marks)

18. (a) Define the term Network topology. (2 marks)

(b) Distinguish between Logical and Physical network topology.                     (2 marks)

19. State and briefly describe any five types of physical network topologies used in LAN.                                                                                                                   (10 marks)
20. (a). Briefly explain the following terms as used in networking:             (2 marks)
    • Remote communication.
    • Distributed processing.

(b). State three advantages and two disadvantages of a mesh network topology. (5 marks)

21. (a) With the aid of a diagram, explain hierarchical (tree) network topology. (3 marks)

(b) List two advantages and two disadvantages of hierarchical network topology.

(4 marks)

22. State the purpose of each of the following: (2 marks)

• file server software
• communication software

23. (a) The diagram below shows four common network topologies A, B, C and D.

        Z

W                                        X                             Y

1          2        3         4         5         6        7         8       9

                                    TOPOLOGY A

                                                                                                                        TOPOLOGY B

                        TOPOLOGY C                                                                         TOPOLOGY D

Server                                                               Terminal                                        Printer

• Name the network topologies labelled A, B, C and D. (4 marks)
• Explain what happens if server X in topology A fails. (1 mark)
• List two problems associated with network topology B. (2 marks)
• List two disadvantages associated with network topology D. (2 marks)

(b) Differentiate between Internet and World Wide Web.                                        (2 marks)

(c) Describe the following network services and identify their applications.

• Voice mail. (2 marks)
• Video conferencing. (2 marks)

APPLICATION AREAS OF ICT

1. What is ICT? (1 mark)
2. Name the type of processing that would be required by a payroll system. (1 mark)
3. Outline two ways in which computers can be used in hotels. (2 marks)
4. State two ways on how Information & Communication Technology (ICT) can be used to reduce the spread of HIV/AIDS.                         (2 marks)

5. (a) Identify two benefits of using computers in accounting systems.             (2 marks)

(b) List down any four modules within an accounting package, stating the purpose for each                                                                                                                             (6 marks)

6. (a) List four functions of a computerized Stock control system.             (4 marks)

(b) Name two organizations that would benefit the most from computerized stock control systems.                                                                                                         (2 marks)

7. (a) How is a point of sale terminal used in a business organization?               (2 marks)

(b) State four components of an electronic Point-of-sale terminal.                   (4 marks)

(c) Give two advantages of using electronic point-of-sale terminals as opposed to manual entry at a supermarket checkout counter.                                                     (2 marks)

8. Write the following abbreviations in full:                         (4 marks)
   1. ATM
   2. EFTPOS

• CAD/CAM

9. Define the following terms:

• Biometric analysis
• Telecommuting
• Video conferencing.

10. Outline four devices required in order to conduct a video conference.             (4 marks)
11. With the improvement in price and performance of computers and communication equipment, it will be possible for people in various business organizations to work from home. Such working using a PC as a remote terminal is often described as teleworking.  State three advantages and three disadvantages of working from home.                       (6 marks)

12. (a) Define the term E-commerce.             (2 marks)

(b) List down two advantages and two disadvantages of e-commerce as used in modern business environment.                                                                                                (4 marks)

(c) Explain two ways in which ICT can enhance commerce.                             (2 marks)

13. (a) Explain the term “Virtual Reality”             (2 mark)

(b) List three areas where virtual reality is used.                                                            (3 marks)

(c) List down four interactive sensory devices used in virtual reality.              (3 marks)

14. (a) What is an Expert system? (1 mark)

(b) State and explain any three components of an Expert system.                     (6 marks)

(c) Identify at least two areas where Expert systems are used.                          (2 marks)

15. Describe how computing has been applied to each of the following areas:

• Educational systems.             (2 marks)
• Transportation systems. (2 marks)
• Financial systems. (2 marks)
• Scientific research.             (2 marks)
• Entertainment systems.             (2 marks)
• Reservation systems             (2 marks)
• Law enforcement (2 marks)
• Library management systems (2 marks)

16. State three areas where computers are used in financial systems: (3 marks)
17. Differentiate between:

• An electronic point of sale terminal and a Cash register
• Computer aided instruction and Computer aided learning
• Computer aided design and Computer aided manufacturing
• Teletext and Videotex
• Simulation and Virtual reality

18. (a) Despite the introduction of the ATM card, human resource is still necessary in the banks. Give two reasons why humans are still needed.                                           (2 marks)

(b) State four advantages to the users of the cards.                                            (4 marks)

(c) Give two safety precautions that the card owners should observe to ensure security of their money.                                                                                                           (2 marks)

19. (a) Define Process control. (2 marks)

(b) Name four different industries where computerized process control systems can be found                                                                                                                          (4 marks)

20. Simulation is one of the application areas of computers.

• What is meant by the term simulation?             (1 mark)
• Name two application areas of simulation.             (2 marks)
• State three advantages of computer based simulation.             (3 marks)
• Give two actual dangers in projecting using computer models. (2 marks)

21. (a) Define Computer Aided Design and Manufacturing (CAD/CAM)             (2 marks)

(b) List five features of CAD.                                                                              (5 marks)

(c) State any three areas where CAD is applied in the society today.                (3 marks)

(d) State one advantage of using CAD software.                                                (1 mark)

22. (a). Explain the role of robots in a motor vehicle assembling plant. (1 mark)

(b). Mention four areas where robots are used.                                                   (4 marks)

(c). Identify two advantages of using of robots in industries.                             (2 marks)

23. (a) Explain how computers are used in the medical field. (2 marks)

(b) In what ways have computers enhanced space exploration?                         (2 marks)

24. Give any three uses of computers in the shipping industry. (3 marks)
25. Suggest how computers may in future be made user-friendly for persons that are:

•             (1 mark)
• Without hands.                                                                                     (1 mark)

26. Give at least four reasons why a firm may decide to computerize its operations. (4 marks)

IMPACT OF ICT ON SOCIETY

1. Identify four benefits that may be derived from increased use of information technologies.                               (4 marks)
2. Identify four problems associated with the introduction of computers in a society.                                                                                                                                           (4 marks)

3. State two health issues that may result from prolonged use of computers. (2 marks)
4. (a) A recent breakthrough in the manufacturing industry is the development of a full manufacturing plant that can produce vehicles using robots only. Give three advantages and two disadvantages of fully automated manufacturing.                    (5 marks)

(b) Apart from manufacturing, state three other areas where automation is applicable.                                                                                                                                                            (3 marks)

5. Computers have proved to be useful in many areas of life though with negative effects to the user.

• State any two negative effects of computers to human health. (2 marks)
• State two practices that can be observed in order to ensure the safety of computer users.                     (2 marks)

6. Explain three ways by which computer users can protect their eyes from harmful emissions from the computer screen.                   (6 marks)

7. (a) Explain how the use of ICT may affect the environment.             (3 marks)

(b) Explain three ways in which computers have impacted on education.         (3 marks)

8. (a) Define the term artificial intelligence. (2 marks)

(b) Discuss the applications of Artificial Intelligence in each of the following fields:

1. Expert Systems. (2 marks)
2. Natural language processing. (2 marks)

• Artificial Neural Networks.             (2 marks)

1. (2 marks)

9. List and explain four advantages of using:
   1. A computerized system. (4 marks)
   2. A database system.             (4 marks)

10. ITCity Inc has been performing quite well in the past year. The management strongly feels that by automating all operations, the company will have a competitive edge.  However, most of the staff and part of the management are strongly opposed to the idea of automating the company’s operations.

Required:

• State and explain five reasons why the staff may be opposed to the idea of automating the company’s operations.                        (6 marks)
• List three ways in which this resistance may manifest itself. (3 marks)
• How can this resistance be overcome? (6 marks)

CAREER OPPORTUNITIES IN ICT

1. Give a brief description of the following careers available in the computing field.
2. Software engineers.             (2 marks)
3. Database administrators.             (2 marks)

• Data Processing Managers (DPM).             (2 marks)

1. Systems Analysts.                                                                                     (2marks)
2. Computer Programmer (2 marks)
3. Network Administrators. (2 marks)

• Computer Technicians. (2 marks)
• Information Systems Managers.             (2 marks)

2. Outline the roles of a Network administrator. (3 marks)
3. State the role of a computer Scientist. (2marks)
4. Distinguish between:

• A software engineer and a computer engineer.                         (2 marks)
• A system analyst and a programmer. (2 marks)

5. List three types of job opportunities that are available in the field of computer hardware.       (3 marks)
6. Identify three courses you would enrol in at the Post graduate university level. (2 marks)
7. (a) State three public universities where one can further her Computer Studies. (3 marks)

(b) Identify at least three ICT related courses offered at

1. polytechnic level
2. college level