• Radiowaves are omnidirectional while microwaves propagate in one direction at a time(unidirectional)
• Radiowaves can be propagated over long distances through sky mode while microwaves require a relay satellite to amplify and retransmit the microwaves signals to the receiver earth station

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.

• To provide access to the Internet

1. Application
2. Presentation
3. Session
4. Transport
5. Network
6. Data link
7. Physical

SECTION A (40 MKS)

Answer all the questions in this section.

1. a) What is disk formatting?                                                        (1mk)

b) Indicate whether the following devices are used for input or output  (2mks)

i) Plotter

ii)Light pen

iii)Mouse

iv)Visual display unit

2.a)Explain why the following and give one reason why they are not allowed in a computer laboratory. (2mks)

b) For each of the following give one reason why they are not allowed in a computer laboratory.  (2mks)

i) Smoking

ii)Eating foods

3.Distinguish between Real, integer and Character data types as used in programming (3 mks)

4.The cells k3 to K10 of a worksheet contain remarks on student’s 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”      (3mks)

5.a) State the purpose of registers in a computer system               (1mk)

b)Name two multiprogramming operating systems                   (2 mks)

6.a) A series file comprises of records placed in positions 1 to 10.  State the position of the end of file marker.      (1mk)

  b)State the purpose of each of the following: (2mks)

 i)File server software

ii)Communication software

7.a) Name the control structure depicted by the flowchart below.                   (1 mk)

b)Explain the following terms as used in program implementation.      (2mks)

 i)Parallel running

 ii)Direct change over

8. Consider the linear arrays:

 i) AAA (5:50)

 ii)BBB (-5:10)

 iii)CC (18)

Find the number of elements in each array (3mks)

9.Define the term artificial intelligence  (2 mks)

10.Name two types of relationships that can be applied in database design  (2mks)

11.Explain binary Coded Decimal code of data representation (1 mk)

 a)Indenting

 b)Alignment

 c)Word wrap

12.Outline two ways in which a computer can be used in hotels               (2 Marks)

13.a)Explain Binary Coded Decimal code of data representation (1marks)

 b)Write the number 4110 in BCD notation (1 mk)

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

   BYTE, FILE, BIT, NIBBlE     (2mks)

15.State two health issues that may result from prolonged use of computers     (2 mks)

SECTION B (60 MARKS)

16. a) State the stage of program development in which  (4 mk)

i) A flowchart would be drawn

 ii)The programmer would check whether the program does as required

 iii)The user guide would be written

iv)The requirements specifications would be written.

b)State the output of the following flow chart segment                  (1mk)

c) i)Draw a flowchart to compute the combined resistance ® of two resistors R1 and R2 in parallel using the formula;

                      (5mks)

ii)Write a program using Pascal or C languages for the flowchart in C (i) above. (5 ½ mks)

17. a)List three paragraph formatting activities in word processing  (3mks)

 b)Differentiate between bolding and highlighting text (2mks)

c) 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

i)Draw a spreadsheet that would contain the information.  Indicate the rows as 1, 2, 3 …. And the columns as a, B, C    (4mks)

ii)State the expression that would be used to obtain:

 I Monday’s profit  (2mks)

 II Total income (2mks)

III)Highest expenditure (2mks)

18.a) Subtract 0112  from 10012 (1mk)

 b)Using two’s compliment, subtract 7 from 4 and give the answer in decimal notation (4mks)

c) Convert

i) 91B16  to octal    (3mks)

ii) 3768   to hexadecimal   (3mks)

iii) 9.62510 to binary  (4 mks)

19.a) Explain what the following DOS commands will do when executed.

    i)  A: \copy *.* B:    (2 mks)

   ii)   C: \> ERASE*. DOC   (2mks)

  iii)   b: \> Md EXAMS  (2mks)

 b)  i)  With the aid of a diagram, explain hierarchical (tree) network topology   (3mks)

  ii)List two advantages and two disadvantage of hierarchical network topology.  (4 mks)

   Advantages:-

   Disadvantages:

20. a)Name and explain the function of the keyboard keys represented by the following symbols.

  b) Simulation is one of the application areas of computers        

  i) What is meant by the term simulation      (1mk)

  ii)Name two application areas of simulation   (2 mks)

 iii) State three advantages of computer based simulation (3 mks)

 c) Explain three ways in which computers have impacted education (3mks)

a)Spreadsheets                                                                                                                               (2mks)

• Microsoft Excel
• Lotus 1-2-3
• Google Sheets
• OpenOffice Calc

                                           Any 2 @ 1mk

b) Word processors                                                                                                                          (2mks)

• Microsoft Word
• Wordpad
• Corel WordPerfect
• Lotus Word Pro

                                         Any 2 @ 1mk

Memory management

• Manage the computer’s memory;
• It can control which parts of the memory are being used by which process

Processor management

• Manage the computer’s processor(s)CPU;
• Schedules of which processes are to be executed;

Input/output management

• Manages input/output devices;
• Interacts with/manages/handles the (automatic) installation of device drivers;
•  Handles peripheral device interrupts;
• the computer can communicate with the outside world;
• Control network communication;
• Allow devices to send and receive data;

Managing storage

• Manage secondary storage devices;
• Loading data and programs into the computer’s memory;
• Storage space management (disk quotas);
• To ensure that storage space is allocated fairly and efficiently to specific tasks\users;

Managing security

•  User authentication;
• To make sure that users must prove who they are to access the system;
• Protect against malware;
• Block access to specific vulnerable operations or system areas. For example, software can only be installed with admin access;

Managing applications

• Control access to applications;
• Prevent users or processes from using unauthorised programs // allow users or
• processes to use authorised programs;
• Control application access;
• Prevent/allow an application access to data (or devices);

• Radio waves
• Microwaves
• Infrared waves

Is an arrangement of people, data, processes, communication and IT that interact to support problem solving

Components of an information system

• Hardware
• Software
• Data - information manipulated by software
• people- all people involved
• Processes - steps to accomplish a goal

• Is the protection of programs and data in computers and communications systems against unauthorized modification, access or disclosure
•  

• No licence agreement as a certificate of authenticity
• Prices that are extremely cheap
• No documentation manual
• when one connects to the internet for authentication, the report from the manufacturer indicates that the user may be a victim of software counterfeiting
• frequent runtime or occurrence of fatal errors when using the machine

 the trial version of software for a limited time/number of uses with limited features  free of charge

If a full version is required need to pay a fee/sign up

When the trial is over user is asked to pay/sign up

Protected by copyright

Type of software licence
 

• compact disks
• DVDs
• Blue Ray

(a) Identifying technologies that may be used in a proposed system

• System Analysis/Information gathering/Problem recognition

(b) Identifying the shortcomings of the old system

• Problem definition

(c) Prepares the software migration plan

• Implementation stage

(a) Like "*kenya*"

• Returns the records of all countries that contain the string "kenya"

(b) Like "*ina"

• Returns records for all countries/regions whose names end in "ina", such as China and Argentina.

(c) Like U*

• Returns records for all countries/regions whose names start with "U", such as UK, USA, and so on.

(d) Not Like U*

• Returns records for all countries/regions whose names start with a character other than "U".

(e) >= "Mexico"

• Returns records of all countries/regions, beginning with Mexico and continuing through the end of the alphabet.

(f) Like "[A-D]*"

• Returns records for countries/regions whose names start with the letters "A" through "D".

(g) "USA" Or "UK"

• Returns records for USA and UK.

https://support.microsoft.com/en-us/office/examples-of-query-criteria-3197228c-8684-4552-ac03-aba746fb29d8

Hard disk drive

• to hold the operating system/communication and applications software/ISP software
• for storing files/information/cookies on backing store

RAM

• for data, computer programs and operating instructions which are moved into it/downloaded for data currently in use

DVD writer

• Films/videos/pictures/music/multimedia data downloaded/purchased

Modem

• link/dial up/establish communication with the Internet
• Convert digital signals to analogue/audio tones (and vice versa) Which can travel across the telephone system

• star - if one computer goes down the others can still be used
• ring - if one computer goes down the others can not be used

(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

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)