• not able to directly manipulate the hardware
• may need to wait for translation before running
• the program may be less efficient.

• A barcode is one-dimensional while a QR code is two dimensional
• Barcodes are a set of vertical lines and QR code contains squares
• QR codes can be read from any angle . Barcode is only above or below and lined up horizontally

• Because it will be subject to movement  and it does not use mechanical/moving parts

          OR

• Solid state storage is smaller/more compact so better suited for a wearable device

          OR

• Doesn’t have moving parts  because they could be disrupted during use

• two's complement has only one value for zero

Transcription Errors: Transcription errors involve the incorrect entry of data due to mistakes made during the copying or typing process. These errors can occur when transferring information from one source to another.

Transposition Errors: Transposition errors specifically refer to errors where the order of characters or digits is accidentally reversed or swapped. This can happen during manual data entry or when processing information.

• virtual memory

• more efficient than a human
• more accurate than a human
• can lift larger and heavier equipment than a human
• can replace humans working in a dangerous environment
• reduces running costs, such as wages and overheads
• can produce consistent results/output
• can work 24 hours a day // do not need to take breaks.

• do not allow outside floppy disks/CD’s/DVD’s
• use disk free work stations
• download/install and use anti virus software
• scan hard disks regularly
• update the anti virus program regularly
• do not open file attachments from unknown sources/download
• doubtful software from the Internet
• do not use files that come from unknown sources
• buy original software/do not buy pirated software
• use firewalls

• to enable logon information to be kept on his computer
• to provide pages customised for Ahmed the next time he logs on
• to implement shopping carts and one-click purchasing
• to be able to distinguish between new and repeat visitors to the website

• It transfers data signals from one node directly to another in the network without broadcasting

Phased:
Advantages:

• only a small part of the operation affected if new system fails
•  no need to pay for two sets of wages

Disadvantages:

•  time consuming (each part needs testing fully before expanding system)

Pilot:
Advantages:

• if new system fails, only that part will be affected
• possible to gradually train staff on pilot before whole system changes over

Disadvantages:

•  time consuming (waiting to see how pilot works before rolling out to rest of the organisation)

Direct:
Advantages:

•  less likely to malfunction since fully tested
• immediate benefits/less time wasted
•  reduced costs (only one system so no need to duplicate staff)

Disadvantages:

• disastrous if the new systems does fail

Parallel:
Advantages:

•  if new system goes down, there is a backup system in place
• possible to gradually train staff/staff have time to get used to the new system

(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

• Ease of installation and use
• Application software intended for use in the computer
• Processor type. Some processors do not support all operating systems

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)

• This approach causes minimum disruption

(i) Jobs collected together for processing at a later time
(ii) Output produced quickly enough to affect the next input
(iii) User has direct contact with the processor
(iv) User cannot communicate directly with the processor

• mirrored hard disk/hot standby/second computer
• re-run the old master file with the transaction file

Direct changeover – new system replaces existing system immediately/overnight

 Parallel running – new system runs alongside/together with existing system

Parallel running – there is always the old system to fall back on in the event of the new system failing/information is not lost/always a second copy

Direct changeover – if things go wrong lose all data/old system is not available

Direct changeover – training is more difficult to organise

Parallel running – training can be gradual Parallel running is more expensive to implement than direct changeover....

Direct changeover is a quicker method of implementation than parallel running

Direct Changeover: The old system is stopped completely, and the new system is started. All of the data that used to be input into the old system, now goes into the new one.

 Parallel Running: The new system is started, but the old system is kept running in parallel (side-by-side) for a while. All of the data that is input into the old system, is also input into the new one. Eventually, the old system will be stopped, but only when the new system has been proven to work.

• A compiler translates the whole program in one go whereas An interpreter translates each line of code (often an intermediate code) at run time
• A compiler produces an executable file that will run on the target hardware machine without the compiler being installed  A run time interpreter will be required at run time
• Compilers tend to be large complex programs Interpreters are smaller simpler programs
• Interpreted programs can be amended and run without translating whole program Compiled programs have to be re-compiled after a change
• Compilers compile programs that will usually only run on the target platform (hardware/operating system)  Interpreters will interpret same program (or intermediate code) on different (some virtual) platforms

• Font Formatting:

  • Font Style: You can change the font style (e.g., Arial, Times New Roman) for cell content.
  • Font Size: Adjust the size of the text within cells.
  • Bold, Italic, and Underline: Apply these formatting options to emphasize text.
  • Font Color: Change the color of the text.

• Cell Formatting:

  • Number Formats: Apply various number formats, such as currency, percentage, date, and time.
  • Cell Borders: Add or remove borders around cells or cell ranges.
  • Fill Color: Change the background color of cells.
  • Text Alignment: Control how text is aligned within cells (left, right, center, top, bottom).
  • Text Wrapping: Allow text to wrap within a cell if it's too long to fit in one line.