(a) Defragmentation software   -   Reorganises files on a disk to improve efficiency

(b) Disk contents analysis/repair software - Scans a hard disk to identify bad sectors

(c) Disk formatter -  Prepares a hard disk for first use

• Commandline/ Character interface Operating systems
•  Menu Driven Operating Systems
•  Graphical User Interface Operating Systems

RAID (Redundant Array of Independent Disks) technology refers to a method of combining multiple physical disk drives into a logical unit to improve performance, data availability, and data redundancy. RAID technology is commonly used in storage systems to provide fault tolerance, data protection, and increased storage performance.

The primary purpose of RAID is to create a more reliable and robust storage solution by spreading data across multiple drives and implementing various data redundancy techniques. This helps to mitigate the risk of data loss and system downtime in case of drive failures.

There are different levels or configurations of RAID, each offering different features and trade-offs. The most commonly used RAID levels are:

1. RAID 0 (Striping): Data is split evenly across multiple drives, resulting in increased performance as data can be accessed from multiple drives simultaneously. However, there is no redundancy, so if one drive fails, data loss can occur.

2. RAID 1 (Mirroring): Data is duplicated or mirrored across two drives, providing redundancy. If one drive fails, the other drive can still function and serve the data. RAID 1 offers data protection but does not offer increased performance.

3. RAID 5 (Striping with Parity): Data and parity information are striped across multiple drives, providing both increased performance and fault tolerance. Parity information allows for the recovery of data in case of a single drive failure. RAID 5 requires a minimum of three drives.

4. RAID 10 (Combination of Mirroring and Striping): RAID 10 combines elements of RAID 1 and RAID 0. It involves mirroring data across two sets of drives and then striping the mirrored sets for increased performance and fault tolerance. RAID 10 provides high levels of data redundancy and performance but requires a minimum of four drives.

• 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

A parameter represents additional information that  a function requires to perform its task. Each parameter required by a function is specified in the function header

An argument the value supplied in the function call. When the function is called, the argument value is passed into the function parameter so that the function can perform its task

A primary key is a table field that uniquely identifies each record and ensures that duplicate entries are not allowed

A foreign key is primary key of a parent table placed in a child table to ensure that any record added to a child table is related to the one in parent table.

A foreign key is a field (or a set of fields) in one table that refers to the primary key of another table. It is used to establish and enforce a link between the data in the two tables, ensuring referential integrity.

• (Cache) Stores regularly accessed instructions/data
• Reduces the need to access instructions/data from the main memory
•  Makes up for the difference in speed of the CPU and main memory

Cloud computing refers to the delivery of on-demand computing resources over the internet. Instead of relying on a local server or personal computer, cloud computing allows users to access and utilize a wide range of computing services and resources hosted on remote servers.

• Sarah could keep all of her files in the cloud and easily access these with her devices. This way she does not have to keep different version on her desktop and laptop.
• Flexibility she could access the files from other devices such as the library etc.
• Disaster recovery if she accidently dropped or damaged a device – all files would be easy to access.

• File handling - Copy/move/delete
• Anti-virus software - To protect files from attack by a virus
• Defragmentation - To keep files sensibly arranged on the hard drive
• Format - To divide the surface of a drive into smaller areas to aid storage

• A collection of related webpages under the same domain name

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)

Describe how the computer on board the aeroplane uses GPS to find its exact location

– satellites transmit signals to onboard computers
– computers receive/interpret these signals
– system depends on very accurate timing/use of atomic clocks
– each satellite transmits data indicating location and time
– computer in aeroplane calculates location based on at least three satellites
– at least 24 satellites in operation at any one time
– position accurate to within one metre
– can also calculate altitude of aeroplane
– ref to “triangulation”:

Give two benefits of using GPS in this application

– safer as the known location is exact/more accurate
– reduces the possibility of pilot error
– allows accurate estimation of arrival time
– display and guide the pilot to the nearest airport in case of emergency

The following are some of the possible definitions:

It is system software designed to help the users to analyse, configure, optimize, or maintain a computer

System software that helps maintain the proper and smooth functioning of a computer system

Examples include antivirus software, Disk clean-up tools, disk defragmenters, backup software, etc

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;

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.

A PAN exist around a single person whereas a LAN covers a larger area

- Passwords
- Hierarchy
- Only allow some staff to access student files
- Only some machines able to access
- Physical location of these machines
- Physical lock on machines
- Encrypted data in files
- Firewall if connected to the Internet

Any four of:
Sequential:
• Individual instructions are executed one after another
• Flow control is accomplished by jump/branch/goto instructions
• Results are usually achieved less quickly than parallel processing (do
not award twice)
Parallel:
• Individual instructions can be routed to different processors for
simultaneous execution
• Results are usually achieved quicker than sequential instruction (do not
award twice)
• Requires multi-core processors or multiple microprocessors
• Tasks may be split into different parts with each part executed on a
different processor
• Results need to be merged back together after completion

Definition

• Disk formatting is the process of preparing a data storage media for initial use

Reasons:

• To make a disk blank for reuse
• To make it compatible with another operating system
• to create tracks and sectors for first time use

• Radio waves
• Microwaves
• Infrared waves