• Labels
• Values
• Formula
• Functions

a)  i)  Explain what is meant by the term volatile memory                                                            (1mark)

• Memory content is lost when the power is turned off

ii) What is normally stored in the non-volatile part of a computer’s main memory                       (1mark)

• The Computer’s BIOS

b) Explain why having cache memory can improve the performance of the CPU                         (2mks)

• Frequently used data/instructions are store in the cache; Meaning they don’t have to be fetched from the main memory;
• Data/instructions stored in the cache memory can be accessed faster (than data/instructions stored in the main memory) MAX 2

Refers to a small piece of software designed to update, fix, or improve a specific part of the operating system or an application.

NB: Patches are typically released by the software's developer or the operating system vendor to address security vulnerabilities, software bugs, or to add new features or enhancements

(i) Incorrect use of language, e.g. PLINT instead of PRINT
(ii) A mistake in the structure of the solution, e.g. a jump goes to the wrong line
(iii) Inappropriate arithmetic is used, e.g. division by 0 is attempted

1. (a)State what is meant by the terms:

Parallel data transmission

• 8 bits/1 byte/multiple bits sent at a time  

1. using many/multiple/8 wires/lines

Serial data transmission

• one bit sent at a time  
• over a single wire

b) Give one benefit of each type of data transmission.

• Parallel - faster rate of data transmission

Serial

1. -more accurate/fewer errors over a longer distance
2. -less expensive wiring  
3. less chance of data being skewed/out of synchronization/order

Give one application of each type of data transmission. Each application must be different

Parallel

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

Serial

• connect computer to a modem

State what is meant by the term USB

• universal serial bus

Describe two benefits of using USB connections between a computer and a device.

• -devices are automatically detected and configured when initially attached
  • Impossible to connect device incorrectly/connector only fits one way
  • has become the industry standard
  • supports multiple data transmission speeds
  • lots of support base for USB software developers
  • supported by many operating systems
  • backward compatible
  • faster transmission compared to wireless

DVD - optical media which use one spiral track; red lasers are used to read and write data on the media surface; makes use of dual-layering technology to increase the storage capacity

ROM - non-volatile memory chip; contents of the chip cannot be altered; it is often used to store the start-up routines in a computer (e.g. the BIOS)

SSD/ Solid State Drive/memory (SSD): a non-volatile memory device that uses NAND flash memories (which consist of millions of transistors wired in series on single circuit boards)

Blue Ray -  optical media that uses blue laser technology to read and write data on the media surface; it uses a single 1.1 mm polycarbonate disc

Viruses, pharming and phishing are all examples of potential Internet security issues.
Explain what is meant by each of these three terms.

Virus

• - program/software that replicates/copies itself
• – can delete or alter files/data stored on a computer
•  – can make the computer “crash”/run slow

Pharming - malicious code/software installed on a user’s hard drive/actual webserver

 – this code redirects users to a fake website (without their knowledge)

 – to obtain personal/financial information/data

Phishing - legitimate-looking emails sent to a user – as soon as the recipient opens/clicks on the link in the email/attachment,  the user is directed to a fake website (without their knowledge) – To obtain personal/financial information/data

control bus- this bus carries signals used to coordinate the computer’s activities

address bus - this uni-directional bus carries signals relating to memory addresses between processor and memory

data bus - this bi-directional bus is used to exchange data between processor, memory and input/output devices

The seven stages in a von Neumann fetch-execute cycle

• the PC (program counter) contains the address of the next instruction to be fetched
• the address contained in the PC (program counter) is copied to the MAR (memory address register) via the address bus
• the instruction is then copied from the memory location contained in the MAR (memory address register) and is placed in the MDR (memory data register)
• the entire instruction is then copied from the MDR (memory data register) and placed in the CIR (current instruction register)
• the value in the PC (program counter) is then incremented so that it points to the next instruction to be fetched
• the address part of the instruction is placed in the MAR (memory address register)
• the instruction is finally decoded and is then executed

Modern LCD monitors and televisions use LED-backlit technology.
Give two advantages of using this new technology compared to the older cold cathode fluorescent lamp (CCFL) method

• no need to warm up
• – whiter tint/more vivid colours/brighter image
• – higher resolution
• – much thinner monitors possible/lighter weight
• – more reliable technology/longer lasting
• – uses much less power/more efficient

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)

• Computer systems use binary/ones and zeros/voltage on or off;
• Sound is analogue/continuous;
• Computers use digital data/discrete values

• College authorities are the experts in the problem
• A system Analyst is an expert with computers
• The two need to pool resources to come up with a clear definition
• Agree on the outcomes so that when the system is , there are a set of criteria to judge it by

• It has electrical components.
• It is programmable.

• Access Controls: Authentication of users in order to access files
• Performing regular patches of updates
• creating secure accounts with required privileges
• scrutinizes all incoming and outgoing packets of data through a firewall
• encryption of data, during transmission
• Log files to detect any breach

1. SECTION A
2.  Answer all questions in this section
3. What is a computer?                                                                                                            1mks
4. State three physical components that make up a computer                                                 3mks
5. State the hardware technological differences between the second generation and third generation computers                                                                                                          2mks
6. State and explain three characteristics of a computer                                                         3mks
7. State the functions of the following special memories in a computer                                3mks
8. Buffers
9.  
10. Registers
11. Cache
12.  
13. Define the following as used in data representation in a computer                                  (5mks)
14. Bit
15.  
16.  
17. Byte
18.  
19.  
20. Nibble
21.  
22.  
23.  
24. Word
25.  
26.  
27.  
28. Word-length
29.  
30.  
31. State two reasons why a DVD is superior to a typical compact disk                               (2mks)
32. State three advantages of flat panel monitors over cathode ray tube monitors                   3mks
33. Explain the following terms as used in word processing                                                  3mks
34. Section breaks
35. Thesaurus
36. Superscript
37. State two advantages of  impact printers                                                                             2mks
38. State the function of the following keys on the computer keyboard                                  3mks
39. Enter key
40. Insert key
41. Delete key
42. State the technology used by the following secondary devices to store data                      3mks
43. Magnetic storage devices
44. Solid state storage devices
45. Optical storage devices
46. State three reasons why an operating system is important in a computer                         3mks
47. A typical computer’s main memory consists of both volatile and non-volatile memory.
48. i)  Explain what is meant by the term volatile memory                                          (1mark)
49. ii) What is normally stored in the non-volatile part of a computer’s main memory (1mark)
50. Explain why having cache memory can improve the performance of the CPU         (2mks)
51. What is a computer system?                                                                                           (1mk
52. Give two differences between a solid state drive (SSD) and a hard disk drive (HDD)   2mks
53. State three categories of software classified according User license agreement              (3mks)
54. State two disadvantages of Random Access Memory                                                       (1mk)
55.  
56.  
57. a) Explain the functions performed by the following components of a processor   (2 marks)
58. Control unit

• consists of values between 0–255 / 0–FFF
• values are separated by full stops/colons
• it is a unique address
• can be static or dynamic
• can be public or private
• can be IPv4 / have four groups of digits
• can be IPv6 / have eight groups of digits
• in IPv6: can replace groups of zeros.

• Protection against Password-related Vulnerabilities: Traditional password-based authentication methods are vulnerable to various risks, such as weak passwords, password sharing, or password theft.
• Stronger Access Control: Biometric readers add an additional layer of access control to laptops. Even if someone gains physical possession of the laptop, they would still need the authorized user's biometric data to unlock it and access the data. This helps prevent unauthorized individuals from accessing sensitive information stored on the laptop,
• Audit Trail and Accountability: Biometric authentication systems often come with built-in logging and auditing capabilities. This means that each time someone accesses the laptop using their biometric data, it can be recorded and associated with a specific user. This creates an audit trail, allowing organizations to track and monitor access to laptops and establish accountability in case of any security incidents or breaches.

1. Speeds up coding since converting a pseudocode into a programming language is usually faster and easier
2. Acts as documentation
3. Simplifies debugging since logical errors can be identified and corrected early in design stage
4. Language independent since it is not tied to any specific language so can be translated into different languages
5. It uses simple english-like statements

• Radio waves
• Microwaves
• Infrared waves

Dual input of data

• Two inputs are compared by the system and any discrepancies are reported (and not stored.)
• Data input once, either printed out or checked on the screen and  errors corrected

 Rules are given to the processor

• Only accept A, B, C, D, E, F, G i.e Any other input rejected.

Drop-down list/radio buttons

• Provides only valid inputs, so no other validation is required

– faster communications now widely available
– safety reasons, e.g. increase in terrorist attacks on international flights
– reduced transportation/accommodation/hardware costs
– environmental issues, e.g. reduced carbon footprint
– increase in multinational working

• Patient monitoring
• Used to control medical equipment e.g ultra sound
• medical research and studies
• communication and telemedicine

SECTION A (40 MKS)

Answer all the questions in this section in the spaces provided.

1.Describe the computer booting process.    (2 mks)

2. State the functions of the following keys on the computer keyboard   (2 mks)

  a) Backspace

  b)Insert (ins)

3. Jane has noticed the following problems with her computer keyboard    (2mks)

• It is taking a longer time to start-up;
• It is often hanging;
• Applications are taking longer to load.

 State three possible causes of these problems and how they can be solved (3mks)

4 a)Define authenticity as used in software selection  (1mk)

  b) List four ways of acquiring software in an organization     (2mks)

5 some of the storage disk available are:  zip disks, 3 ½ inch floppy disks, DVDs and 5 ¼ inch floppy disks. Arrange these devices in ascending order of storage capacity.    (2mks)

6.You have been asked to change your computer password. State a precaution you need to take in order to avoid each of the following:           

a) Forgetting the password     (1mk)

b) Hacking       (1mk)              

7.State four benefits of using a computer in a school library   (2 mks)

8. Using six bits, find the two’s complement of -2310.     (4 mks)

9. Explain data series, axis and legends as used in spreadsheet charts.  (3mks)

• Data

• Axis

• Legend                       

10. a) Describe the term data integrity.                                            (2 mks)

     b) State four situations in which data may lose integrity.           (2mks)

11.State the function of each of the following:

            a)Network interface card                                                           (1 mk)

            b)Network protocol                                                                    (1 mk)

           c)Hub                                                                                         (1mk)  

12. List four types of publications that can be designed by using desktop publishing software.   (2mks)

13. Differentiate between the following pair of terms as used in database design:

    a)  Input mask and design.                                                           (2 mks)

    b) Table and query                                                                      ( 2mks)

14. List four factors to be considered when purchasing an operating system.     (2mks)

15   Write an algorithm to compute the area of a triangle.   (2mks)

SECTION B (60 MARKS)

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

16. Study the flowchart below and answer the questions that follow

i) Name the control structures used in the flowchart                 (2mks)

ii) Determine the values of M, N, P and Q.                                ( 4 mks)

M………………………….. N………………………..

P ………………………….. Q ………………………

  iii) Write the pseudo code for the flowchart   (7mks)

 b)  List four functions of an assembler    (2 mks)

17. Define the following web related terms:       

 i)  Web browser   (1mk)

 ii)  Hyperlink      (1mk)

iii) Hypertext document                (1mk)

b)  List six activities performed on the web      (3mks)

c) An institution has ten stand alone computers

i)  Suggest with reasons the most appropriate topology required to inter-connect the computers.   (3mks)

ii) State the necessary steps required to connect the computers to the  internet.      (4mks)

d) Below is an email address:

Name the parts labeled:

                        i)

                        ii)

                        iii)

18.A computer C directory has folders for form 1, form 2, Form 3 and form 4.  Each class has student’s folders labeled according to their number.  The students create their own folder for the subject the are studying based on the table shown below

a)Assuming there is one student per class, draw the corresponding directory tree structure.  (6 mks)

b) i)  a form four student wants to create a folder to store her project. State the path for that project folder.(2 mks)

ii)Suggest how the student can ensure that:

                        1.         Work is not lost in case the hard disk fails.                (1mk)

                        2.         The project is not copied by other students.               (1mk)

c) i).  Other than I/O devices, list other three devices under the control of the operating system.                                                  (3mks)

 ii)Explain any one of the devices named in C (i) above            (1mk)

d)Define the term trouble shooting    (1mk)

19. A manager wishes to replace the current manual system with a computerized one

 a)Describe three main areas that must be evaluated to justify the  replacement   (6mks)

b) List the three areas that would be considered in the requirements specifications.      (3mks)

c)State and explain three ways that can be followed to replace the current system    (6mks)

20. a)  A head teacher keeps the following student details in a database:  Name, Address, Town, Date of Birth, Marks scored, Fees paid.

i)Name the most appropriate primary key. Give a reason      (2mks)

ii)For each item in the student’s details above, indicate its most appropriate data type as used in the database.           (3mks)

iii)Explain why input screens are better data entry designs than entering data directly to a table.        (2mks)

b)List two career opportunities associated with databases.       (2mks)

c)Distinguish between:

i) A table in a word-processing application and a table in a database application (2mks)

ii)Mouse pointer and insertion point.    (2mks)

d)Outline the steps to be followed in order to merge cells in a word processing table.    (2mks)

DVD - optical media which use one spiral track; red lasers are used to read and write data on the media surface; makes use of dual-layering technology to increase the storage capacity

ROM - non-volatile memory chip; contents of the chip cannot be altered; it is often used to store the start-up routines in a computer (e.g. the BIOS)

SSD/ Solid State Drive/memory (SSD)

non-volatile memory device that uses NAND flash memories (which consist of millions of transistors wired in series on single circuit boards)

Blue Ray -  optical media that uses blue laser technology to read and write data on the media surface; it uses a single 1.1 mm polycarbonate disc