• URL is clicked/typed into a web browser address bar. The page is requested (by the web browser) so HTML and files are fetched from a web server and the browser collates the page, which is then displayed on the monitor.
• OR
  URL is clicked/typed into a web browser address bar (1). The browser locates the IP address either in cache or using a DNS server and the browser sends a request to the web server with that IP address web server uses HTTP to send back the requested web page and the browser displays the content of the page .

• Outsourcing is the practice of using third-party providers to perform services and/or create goods that would traditionally be done within the business.

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.

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

(a)State what is meant by the terms:

Parallel data transmission

• 8 bits/1 byte/multiple bits sent at a time  
• using many/multiple/8 wires/lines

Serial data transmission

• one bit sent at a time over a single wire

Parallel

• sending data from a computer to a printer
•  internal data transfer (buses)

Serial

• connect a computer to a modem

1. Primary Storage (Memory):

   • Random Access Memory (RAM): This is a volatile memory used to store data and instructions that the CPU (Central Processing Unit) can access quickly. RAM is essential for running applications and the operating system. However, its contents are lost when the computer is powered off.
   • Read-Only Memory (ROM): ROM is a non-volatile memory that stores essential firmware and instructions necessary for the computer's boot-up process. It retains its contents even when the power is turned off.
   • Cache Memory: Cache is a small and fast memory located closer to the CPU. It stores frequently accessed data to speed up the processing.

2. Secondary Storage (Mass Storage):

   • Hard Disk Drive (HDD): HDDs use magnetic storage to store data on rotating platters. They provide relatively large storage capacities and are commonly used in computers and laptops for long-term data storage.
   • Solid-State Drive (SSD): SSDs use NAND flash memory to store data, offering faster read and write speeds than HDDs. They are more durable and consume less power, making them increasingly popular in modern computers.
   • Optical Discs: CDs, DVDs, and Blu-ray discs are examples of optical storage media. They are mainly used for distribution of software, music, movies, and archival purposes.
   • USB Flash Drives: Also known as thumb drives or pen drives, these portable storage devices use flash memory to store data and can be easily connected to a computer's USB port.
   • Memory Cards: Memory cards, such as SD cards and microSD cards, are used in various devices like cameras, smartphones, and tablets to store data, photos, videos, etc.
   • External Hard Drives: These are HDDs or SSDs contained within an external enclosure, allowing users to expand their computer's storage capacity or create backups.

• it is a format style that shows the listed items of different levels rather than at one level. Each level has a different indentation and numbering style

1. Chapter 1

     1.1. Introduction

                 1.1.1.Definition of terms

• 4 (four)

• the computer appears to “freeze”/”hang”
• computer won’t respond
• failure of hardware (stops computer normal functioning)
• failure of software (stops computer normal functioning)

17. a) i) Explain the term search as used in the Internet.                                            [2]

A web based application that locates items or information from the World Wide Web

ii) Peter intends to download a movie from the Internet. State the three factors that may determine the total time taken to complete the download.                                           [3]

• Size of the video/format
• The bandwidth of the media/speed of network/network traffic
• Type of browser software
• Background activities running in the computer
• Restrictions enforced in the computer/firewall/antivirus
• Speed of the computer/CPU speed
• Size of RAM

b) Wakulima online is an organization that runs a web based system for assisting farmers to obtain market for their produce. State four technological reasons that may cause a farmer not to access the organization’s system.                                                                                  [4]

• Poor network/lack of connection
• Software failure in the system

• Hardware failure
• Lack of access rights
• System overload/hanging
• Lack of skills/disability/illiteracy
• Lack of power supply

c) Explain a situation when each of the following Desktop Publishing program features may be used when creating a publication:

i. Cropping                                                                                                               [2]

Applies to graphics – used to trim/remove/hide some portions in the graphics

ii. Transparency                                                                                                         [2]

Used to make background of a graphic to be clear/visible

d. List two areas where infrared waves are used in data communication.                             [2]

18. a) List four activities of the planning stage of systems development.                             Ignore this question, marks redistributed elsewhere

b) Explain a circumstance when each of the following feasibility studies are carried out during systems development.

i. Technical                                                                                                               [3]

Done to determine whether technology exists to support the proposed solution

ii. Economic                                                                                                              [3]

Done to determine whether the proposed solution is economically viable

iii. Schedule                                                                                                               [3]

Done to determine whether the proposed system can be done within an acceptable time.

c) Table 1 and Table 2 are related tables in a database. Use them to answer the questions that follow.

Table 1

Table 2

i. Identify the appropriate primary key for each table.                    [2]

Table 1 – Dept code, Student Registration No

ii. Explain two benefits of enforcing referential integrity in the database. [4]

• No record can be added in Table 2 if its corresponding record in Table 1 does not exist
• No record in Table 1 can be deleted without first deleting the corresponding record in Table 2
• Reduces data redundancies/ensures integrity
• Prevents deletion of related table

19. a) Describe each of the following validation checks as used in data processing.

i. Preserve check                                                                                                      [2]

Ignore this question, marks redistributed elsewhere

ii. Data type check                                                                                                    [2]

Ensure correct type of data is entered for the field

iii. Check digit                                                                                                           [2]

This is a number added/calculated by the computer to a binary number. The check digit ensures correct transmission of the binary number.

b. Write each of the following abbreviations in full:

i) BCD                                                                                                                                    [1½]

Binary Coded Decimal

ii) EBCD                                                                                                                                 [

This question was thrown out and marks redistributed elsewhere

iii) ASCII                                                                                                                    [1½]

American Standard Code for Information Interchange

c) Using 10-bits binary number system, perform the following decimal operation using two’s complement.                                                                                                                                   [6]

12910 - 12810

+129 = 00 1000 0001

128 = 00 1000 0000

-128 = 11 0111 1111 (ones complement)

                            +1

          11 1000 0000 (Twos complement)

129- 128

     00 1000 0001

+ 11 1000 0000

 100 0000 0001

Hence = 00 0000 00012 or 12 (the overflow bit is ignored)

• online storage
• incremental backup
• full backup
• RAID (level 0, 1, 10)
• uninterruptible power supply (UPS)

• Distributed data processing is where computers located in physically separate location transmit data after processing to a server computer that updates the master file. Time-sharing on the other hand is where various terminals transmit data to be processed by a central computer's CPU. Each terminal's tasks are allocated a time slice of the CPU

(i) the potential health hazards of this type of work,

• backstrain due to long periods of immobility
• eye strain due to long periods of staring  at the screen
• RSI- continual use of the same muscle group

(ii) the ways that management can help to overcome the effects of the health hazards.

• Move around regularly
• use ergonomic chair
• use anti-glare screen
• use of wrist pads

• Used to resize the image
• Used to rotate the image
• Used to move the image

• 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

• she had actually described verification
• data could be incorrect, therefore same incorrect data typed in twice
• accept description of validation process e.g. range check

• System software manages the computer hardware/application software
• application software is for end-user tasks

(a) Pointer

•  A graphical object on a computer screen that responds to move movement and allows the computer user to select and execute commands in graphical user interface operating systems

(b) Desktop

• It Is a special folder in the file system that is displayed when no other windows are open

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)