Trojan (horse); a program which misleads the user into thinking it is another

piece of software which, when run, executes another program;

Spyware; a program which records data such as usernames and passwords on

a host system and forwards the information to a third party;

Adware; code embedded or attached to program files which will persistently

show adverts (that attempt to generate revenue);

Worm; code which will run autonomously and replicates itself on a host system;

Ransomware; a program that encrypts user’s data to make it unreadable until

they pay for the key;

Remote Access Tool (RAT); allows access to control and monitor a computer

from a remote network location;

Rootkit; malware that has managed to gain ‘root’ admin privileges;

Bots/Zombies; a program installed on a computer that performs a job for the

remote owner of the bot/zombie such as sending spam or sending web requests

to perform a DOS or attacking a computer system;

Scareware; malware that tells you something is wrong with your system in an

attempt to get you to make a purchase;

Keylogger; a program that monitors/records a user’s keystrokes in order to steal

passwords/confidential details;

• A formula is a mathematical expression that returns a value
• A function is an excel inbuilt formula that returns a value given a range of values or arguments

SECTION A (40 MARKS)

1.Describe the purpose of each of the following computer functional units:    (2mks)

    a) Control

    b) Storage

2.Explain how each of the following would affect the suitability of a room for use as a computer room: (2mks)

a) Burglar proofed door

b)Availability of taps and sinks in the room

3.State three data representation codes used in computers       (3mks)

4.State two types of documentation in program development and give the purpose of each.     (4mks)

5.Suppose a 5 element array A contains the values 9, 12, 17, 7 and 20.  Find the value in A after executing the loop below:

            Repeat for k = 1 to 4

            Set A [k +1]: = A [k]

                        [End of loop]            (3mks)

6.State any three activities that occur in a program compilation process  (3mks)

7.The formula = k20 + P$ 18 was typed in cell L21 and then copied to cell M24 of a spreadsheet. Write the formula as it appears in cell M24.(2mks)

8.State two ways in which a computer may be used in the efficient running of a hospital (2mks)

9.List three disadvantages of using the traditional file management method          (3mks)

10.Give one disadvantage of a single processor multi-user system    (1mk)

11. List three differences between a micro-computer and a super-computer.         (3mks)

12.State and explain two reasons why word processing is one of the most common applications of many computer users.   (2mks)

13. write- 1 in twos complement notation in byte form                                        (4mks)

14.Explain the following input/output terms as used in computer systems. Give an example for each        (4mks)

  a) Read

  b) Write

15.State two disadvantages of networking.

SECTION B (60 MKS)

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

16.The following flowchart can be used to list the odd numbers between 0 and 100

a)Write a program segment for the flowchart using a high level language.  (7mks)

b)What would be the output from the flowchart if the statement in the decision box is changed to:  (3 mks)

i)          Odd = 100

ii)         Odd< 100

iii)        Odd> 100

c)  Modify the flowchart so that it prints only the sum of the odd number between 0 and 100  (5mks)

17.a)  List five precautions that can be taken to protect data stored in diskettes   (5mks)

b)State and explain two precautions that can be taken to help recover data lost through accidental erasure. (4mks)

   c) Describe each of the following data processing methods:    (6mks)

   i) Batch processing

   ii) Distributed processing

   iii) Multiprogramming

18. a)  i)  What is a computer keyboard?      (1 mk)

           ii)  ist four types of keys found on a computer keyboard.  Give an example of each(4mks)

     b) Give four differences between present day’s computers and the older generation of computers   (4mks)

     c)   i) State three advantages and one disadvantage of using a laser printer.  (4mks)

           ii) Distinguish between a line printer and a page printer             (2mks)

19  a) Identity three public Universities and three National Polytechnics in Kenya where further computer training is offered. In case, state the highest level of qualification that can be acquired in computer training. (6 mks)

b) Distinguish between “Job replacement” and “Job displacement” in reference to computerization.  (2mks)

c) Give four reasons why a firm may decide to computerize its operations.   (4mks)

d) An individual has a right to demand a guarantee of privacy of personal information stored on a computer.Give three such types of information.  (3mks)

20. a)  Give three comparisons of the traditional file management method of typing a document on a typewriter against using a word processor.     (6mks)

      b)  i) Define the term spreadsheet (1 mk)

            ii) Give two examples of spreadsheet packages available in the market today        (2mks)

      c) Explain the following terms as used in a spreadsheet:

             i)  What if …analysis         (2 mks)

             ii) Cell                (1 mk)

             iii) Formula  (1mk)

             iv)  Pie chart                                                                      (2 mks)

Uploading a file  refers to the process of transferring a file from a local computer to a remote webserver while downloading a file refers to the process of transferring or copying a file from a remote webserver to a local machine

device: beeper/loud speaker
use: to indicate barcode correctly read/error in reading barcode
device: (LCD) screen/monitor
use: to show prices and other information about goods
device: touch screen
use: to show prices and other information about goods/to select items that need to be
weighed/identified
device: weighing machine
use: to find weight of loose items (e.g. fruit) to enable pricing
device: (magnetic) card reader/CHIP and PIN reader
use: to read customer’s debit/credit card/enable customer to pay for goods using a
credit or debit card
device: printer
use: to print receipts

Uses transistors( resistors and capacitors) . It can be implemented by the use of NAND or NOR gates. Data is stored on the chip as a charge

System Stability: Computers require a consistent and stable power supply to function properly. Fluctuations or interruptions in the power source can cause various issues that can disrupt the computer's operation or lead to hardware damage.

a. Data Loss: Sudden power outages or voltage fluctuations can cause the computer to shut down abruptly, resulting in data loss if unsaved work is not properly stored. This can be particularly problematic when working on critical tasks or handling important files.

b. Hardware Damage: Power surges or inconsistent power supply can damage the computer's internal components, including the motherboard, CPU, memory, and storage devices. These damages can result in system instability, reduced performance, or even complete hardware failure.

c. Operating System Corruption: Abrupt power loss or inconsistent power supply can corrupt the operating system files, leading to system crashes, error messages, and instability. This may require system repairs or reinstallation of the operating system.

d. Component Lifespan: Inconsistent power supply can put unnecessary stress on computer components, shortening their lifespan. Frequent power fluctuations or surges can cause wear and tear on various parts, reducing their efficiency and overall longevity.

Number of cores
The number of cores a processor has directly affects the performance of the processor. Each core can perform its own fetch-execute cycle independently of others, so different applications can be allocated to different cores. Quad-core (four-core) and even octa-core (eight-core) processors are becoming common

Cache memory
A processor’s cache is a small portion of incredibly fast memory. It has read and write speeds far higher than hard disk drives and even SSDs. The cache is used to store frequently used information and reduces time wasted in fetching the same information from main memory time and time again

Clock speed
A processor’s clock speed relates to the frequency of the pulses generated by the system clock. The higher the frequency, the more cycles of the fetch-execute cycle can be completed in the same period of time.

Word length
A word is a group of bits that is treated as a single unit by a processor. Words can be used for representing both instructions and data. The length of a word is the number of bits that are assigned to it, with higher word lengths allowing for more bits to be transferred and manipulated as a single unit.

Address bus width
The width of a bus relates to the number wires that make up the bus. Increasing the width of the address bus increases the range of addresses that it can specify, hence increasing the computer’s amount of addressable memory. Adding a single wire doubles the number of addressable memory locations

Data bus width
Increasing the width of the data bus increases the volume of data that can be transferred over the bus at any one time. A wider data bus allows the processor to fetch more data from the main memory in one cycle of the fetch-execute cycle, reducing the number of cycles required to fetch large volumes of data.

The user is not allowed to access the source code so, they cannot tailor the software to their needs and  they cannot fix any bugs in it

The software is still covered by copyright

The user must get the owner’s permission to do anything beyond using it

Enrolment:
- Data input on line
- Individual records validated
- Speed mismatch implications
- Indexes updated immediately
Exam grades:
- Data input twice
- Off line
- Run as a batch
- At otherwise downtime

• file deletion
• file copying
• file renaming
• file retrieval
• file closing
• file reading

a) What is an operating system? (1 mark)

• It is a system software that manages the computer hardware. It provides a platform for installation & execution of application software.

b) Briefly explain any four functions of an operating system. (8 marks)
Interrupt handling - When an interrupt occurs, the current state of the CPU is saved & the OS handles the request, after which the OS restores the previous state of the CPU & resumes the interrupted process.
Process scheduling - OS decides which process runs next & for how long.
Memory management - Ensures that each process has enough memory allocated to execute without interfering with other processes.
Error handling - OS provides a mechanism to detect & respond to errors such as segmentation faults, hardware failures, or invalid instructions.

Physical topology - the physical arrangement of nodes of a computer network

Examples

• bus topology
• ring topology
• mesh topology
• star topology

Logical topology- the way data flows in a network

Examples

• Ethernet
• Ring

(i) State the name of this protocol.   HTTPS 

(ii) Identify how this protocol changes the data to transmit the data securely.

• It encrypts it
• It applies encryption algorithm
• It applies an encryption key

Modulation refers to the process of converting a digital signal to analog signal at the transmission end while demodulation is to converting analog signal to digital signal at the receiving end

System analyst

Web designers

Network administrators

Database administrators

Programmers

Computer technicians

• Binary can represent two states because computer circuits use transistors, which can either be on or off

Sequence: Sequential execution of a program one line after another

Selection:  Involve the a decision between two or more options e.g  if...then...else

Loops/Repetitions: Used for looping i.e a line of code can be made to execute a given number times before terminating.

(i) Crop - used when handling a graphic and there is a need to remove some of the portions in the graphic

(ii)Transparency - used when there is a need to make background of a graphic visible

• The users may not have gained enough confidence to run the new system
• It may be very inconveniencing in case the new system fails or faces problems
• The weaknesses of the old system may not be corrected or may still be transferred to the new system