Open source : refers to software provided freely with its source code. The user can modify and redistribute the software.

Freeware: these are software that can be downloaded for free and distributed, buta  the source code is hidden and cannot be altered.

Shareware: is software that is available for free within a given trial period, after which it must be bought.

Proprietary: software made for commercial purposes. The source code is hidden, and it can only be used after paying for a licence.

(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

• All processes are held in a queue 
• Processes are prioritised 
• Processes are switched On each clock cycle

A computer keyboard is an input device used to enter text, characters, and various commands into a computer or other digital devices.

Windows for example a word processing application and a spreadsheet
 
Menus, for example, allow the user to perform operations or run applications such as right-click to create a new folder  
 
Icons for example a picture of linked computers for networking
 
Pointers(mouse or touchscreen)  for example to select items/trigger events  
 
Shortcuts for example to frequently used applications for example having a shortcut to your mail client on your desktop
 
File navigation for example when searching the hard disc for a file/folder using a browser
 
copying / deleting / moving/sorting/naming/searching of files or folders for example copying of a file from the hard drive to a USB pen drive (File handling)
 
Desktop customisation for example changing the colours and background image
 
Copy and paste for example between applications e.g. copying a graph from a spreadsheet to a word processor
 
Error messages for example provide users with error/warning/help messages for example ‘printer out of paper’ 

1. Enable resource sharing
2. Facilitate remote communication
3. Enable distributed processing
4. Provide better data security and management

• Financial accounting
• Prediction and forecasting
• Inventory keeping
• Budgeting
• Keeping records

A backup is a copy of data that can be used if the original data is lost.

• 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

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

        Misreading error

(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

• colour codes // colour in HTML/CSS
• error messages
• locations in memory
• memory dump // debugging 
• IP(v6) address
• ASCII // Unicode
• assembly language
• URL.

(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

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

• where the new system is completely different from the old one
• if there has been extensive testing of the system and the system analyst has confidence in its functionality
• If the system is not critical

The booting process is the sequence of events that occur when a computer is turned on or restarted. It involves a series of steps that allow the computer's operating system to initialize and become functional. Here's a simplified explanation of what happens during the booting process:

1. Power-On Self-Test (POST): When the computer is powered on, the first thing it does is perform a Power-On Self-Test. During this step, the computer's hardware components, such as the CPU, memory, and storage devices, are checked for proper functioning. The POST verifies that all essential hardware components are present and operational.

2. Bootloader: Once the POST is completed, the computer looks for the bootloader. The bootloader is a small program stored in the computer's firmware or on the bootable device (such as the hard drive or a USB drive). It is responsible for loading the operating system.

3. Loading the Operating System: The bootloader locates the operating system's files and initiates the loading process. It may display a boot menu allowing the user to choose the operating system if multiple options are available. The selected operating system's core files are loaded into the computer's memory.

4. Kernel Initialization: The operating system's kernel, which is the central component responsible for managing system resources, is initialized. The kernel sets up essential components such as device drivers, memory management, and process management.

5. System Initialization: After the kernel is initialized, the operating system proceeds with system initialization. During this stage, various system services and processes are started, and hardware devices are initialized and configured. The operating system loads essential system files and prepares the environment for user interaction.

6. Login/Graphical Interface: Once the system initialization is complete, the user is presented with a login prompt or a graphical user interface (GUI). The user can then log in with their credentials or interact with the GUI to access the computer's functionalities.

State the function of each of the following keys on the computer keyboard :  (2mks)

Backspace;

• Deletes characters to the left of the cursor

Insert

• Add characters at the cursor position
• Toggles between overtype and insert modes

An organization intends to replace an existing system by carrying out the process in stages .

Name the implementation strategy ;  (1mk)

• Phased change-over

Give two reasons why the  organization is opting to use the implementation strategy  in (a) above     (2mks)

• Gives employees time to learn
• Organizations can revert to the old system in case of failure
• Reduces resistance by the employees
• It is easier to find system errors as you are dealing with only one part at a time
• Accessing parts of the old system is still is possible in case of failure of the new system

A manager wishes to replace the current manual system with a computerized one. Describe three areas that must be evaluated to justify the replacement  (6 marks)

• Technical feasibility

• Does the current technology suffice

• Economic feasibility

• Benefits outweigh costs/ whether the project is cost effective

• Schedule feasibility

• Can it be done within the schedule

Headache, back and neck pain may result from the use of computers. State how each of them can be minimized                               (2mks)

• Proper lighting
• Regular breaks
• Use of antiglare
• Correct position of the screen
• Ergonomic furniture

Students of a school intended to elect their school Captain by secret ballot.  State three ways in which computers can be used to improve the election process                          (3mks)

• Registrations of voters
• Voter identification
• Actual voting
• Tallying

Explain why intranet is a more secure way to share files within an organization compared to internet (2mks)

• Intranet involves the interconnection of computers  within  the organization hence it is easier to monitor the access and sharing of files since the users in an organization can be assigned accounts and passwords which will enable to access files they are authorized to access unlike the internet where many can access what is stored in the organization’s website

List two career opportunities directly associated with computer networking               (2mks)

• Network administrators
• Network engineers
• Network technicians

Distinguish between a formula and a function as used in spreadsheets

• A formula is a mathematical expression that returns a value
• A function is an excel inbuilt formula that returns a value given a range of values or arguments

 The C directory of a computer has folders named Form 1, Form 2, Form 3 and Form 4. Each class has students’ folder named according to their admission number.  The student created their own folder for subjects they are studying based on the table below:

Blagging

• This is where a victim is tricked/persuaded by a fraudster to give their details or payment information for a false reason/purpose;

Phishing

• This is where the victim receives and responds to communication that appears to be from a valid or known source but is in fact fraudulent. (It allows the fraudster to capture private information before the victim realises);

Shouldering

• This is where someone watches and records\remembers a victim entering their pin or security information such as passwords. (They can then use this information to gain access to a system)

• a computer that responds to requests to provide information and services over the Internet - an Internet server
• defines how messages are transmitted and formatted over the Internet-HTTP
• software that enables users to access/view documents and other resources on the Internet - Browser     
• numerical ID for each device on the Internet-IP address
• unique ID for a network interface card  -MAC address