ICT is used to create e-commerce platforms that have made business transactions easier and convenient by allowing customers make purchases and payments from anywhere at any time

ICT is used by marketing agents to create exciting multimedia presentations concerning products or services and present them to the target customers using presentation software such MS PowerPoint

Using multimedia, presentation and animation software, it is possible to design attractive advert materials and video clips to display on billboards, broadcast over a television or uploaded on the internet

highest = -1
for student = 1 to 3000
total = 0
for exam = 1 to 8
input mark
total = total + mark
if mark > highest then highest = mark
next
average = total/8
output average
next
output highest

Python code:

highest = -1
for student in range(1, 3001):
    total = 0
    for exam in range(1, 9):
        mark = int(input("Enter mark: "))
        total += mark
        if mark > highest:
            highest = mark
    average = total / 8
    print("Average:", average)
print("Highest mark:", highest)

VBA Code

Option Explicit

Sub CalculateAverageAndHighest()
    Dim highest As Integer
    Dim total As Integer
    Dim mark As Integer
    Dim average As Double
    
    highest = -1
    
    For student = 1 To 3000
        total = 0
        For exam = 1 To 8
            mark = InputBox("Enter mark:")
            total = total + mark
            If mark > highest Then
                highest = mark
            End If
        Next exam
        average = total / 8
        MsgBox "Average: " & average
    Next student
    
    MsgBox "Highest mark: " & highest
End Sub

• 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

• virtual memory

give uninterrupted path through the system of linked traffic lights/
green link - wave
turn all lights to red
activate emergency generator
alarm

• hexadecimal is easier (for humans) to read (than binary);
• numbers are displayed in a more compact way (in hexadecimal than in binary);
• it is quicker to type in (hexadecimal numbers than binary numbers);
• it reduces the risk of typing errors (in hexadecimal numbers than binary numbers);

method of transmission e.g

• blue tooth
• radio
• optical
• satellite
• infra-red
• microwave

device e.g.

• 3G (WAP) mobile phones/mobile phones/cell phone/remote
• key pad/remote control/keyboard
• infra-red mouse
• multimedia mobile handsets/notebooks
• GPRS (general packet radio service) mobiles
• WLAN(or WiFi) hotspots sited in public areas - e.g. coffee
• shops, railway stations, airports, motorway services
• linked printers
• PDA's (personal digital assistants)
• GPS

• holds an indexed sequence of variables of the same data type
• Arrays can be used to store values of the same data type and the array is then used as a singular variable to increase efficiency

• A HDD can contain multiple platters (disks);
• A disk/disks that move/spin
• Each platter is divided into sectors;
• The disks are spun at a very high speed (approximately 7,200 rpm to 10,000 + rpm);
• Read\write heads (move across the disk to) read and write data;
• There is one read\write head for each side of a platter ie two heads per platter;
• Data is written to\read from the disk by magnetising\polarising\sensing microscopic regions on the disk;
• Data is organised in concentric rings called tracks;
• There is a small circuit board on the drive that controls the reading and writing of data;
• Data is transferred from and to the disk via a cable/electrical current being passed;
• The intersection of sectors and tracks are called blocks;
• Data is read 1 block at a time

• Users need to ensure that their software is licensed

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

• loss of jobs as some traditional shops/banks close
• lower profits for companies that do not get involved with e-commerce
• decline of leisure shopping as goods are bought on-line
• city centres becoming deserted as shops/banks close down
• gap between rich and poor widening as richer get savings from
• shopping on-line
• more people choosing to interact with computers rather than people
• increase in small businesses
• less pollution/travelling

1. Availability in the market
2. Initial and maintenance cost
3. User friendliness
4. Compatibility
5. User needs

• Easy to add nodes
• Managed centrally
• Fewer data collisions
• A single node failure does not affect the rest of the network

device: beeper/loud speaker
use: to indicate barcode correctly read/error in reading barcode
device: (LCD) screen/monitor
use: to show prices and other information about goods
device: touch screen
use: to show prices and other information about goods/to select items that need to be
weighed/identified
device: weighing machine
use: to find weight of loose items (e.g. fruit) to enable pricing
device: (magnetic) card reader/CHIP and PIN reader
use: to read customer’s debit/credit card/enable customer to pay for goods using a
credit or debit card
device: printer
use: to print receipts

1.State two reasons for the increased use of laptop computers in government offices. [2]

They are small and fit in a small storage space

They are light weight hence can be carried to areas where their services are required

The monitor, system unit, keyboard units are integrated together

Easy to share

Have rechargeable battery

Have low power consumption

2.Computer network technicians prefer to use command-line based operating systems when configuring networks. State three reasons for the preference. [3]

Do not take up a lot of memory

Have direct access to most hardware devices/provide complete control during configuration

Cheaper to acquire as some are freeware/shareware

Faster to execute commands

Difficult to hack/more secure

More stable

3.State three measures that should be put in place in a computer laboratory to safeguard users’ health. [3]

• All power cables must be insulated and hidden from users
• Furniture used must be of standard
• Room should have adequate lighting
• No overcrowding
• Monitor should be fitted with anti glare
• Avoid dust
• Avoid slippery floor
• Avoid bright coloured walls
• Promote use of ergonomic devices

4.State three ways in which barcode readers may be used in schools. [3]

Take inventory of items

Transactions in the school library

Keep track of movement of goods

Track students in and out of school

Used to register roll call

5.State three advantages of flat panel monitors over cathode ray tube monitors as used in computers.                                                                                                                     [3]

• Compact and light/portable/less bulky/occupy less space
• Consume less power
• Low angle distortion
• Improved color depth
• Higher resolution
• Have less radiation
• Produce less heat

6.State three possible reasons for the extinction of daisy wheel printers in the market. [3]

• Slow
• Noisy
• Lack of graphic support
• Monochrome printer
• Supported on font type and size

7.State three ways in which an operating system secures a computer system.             [3]

• User authentication
• Secure user accounts with privileges
• Encryption of data
• Keeping log files
• Auto backup and auto recovery features
• Inbuilt antivirus

8.A law firm prefers to use hard copy output when handling documents for legal matters. State two reasons for this preference.                                                            [2]

• Can be used without electricity
• Can serve as physical evidence/exhibit
• Not easy to change content without leaving evidence
• No need of computer knowledge

9.State the function of each of the following feature in a word processor

a. Thesaurus                                                                                                                    [1]

Feature that suggests words with similar or opposite meanings to the selected word

b. Comments                                                                                                                   [1]

Feature that allows a user to attach remarks

10. With the aid of an example, explain the term multi-level list as used in word processing.                                                                                                                [3]

1. Chapter 10
   1. Summary
      1. xxxxxxxx

Formatting style that shows listed items at different level instead of using one line

11. Distinguish between real-time operating system and distributed operating system. [3]

Accept answers based on data processing concept

12. Explain the function of protect sheet feature in a spreadsheet program.                   [2]

A tool/feature that prevents unwanted changes to the spreadsheet. Requires a user to key in a password inorder to make changes

13. State four computer based careers introduced as a result of computerized data processing method at the airport.                                                                                     [2]

• System analysts
• Web designers
• Network administrators
• Network technicians
• Programmers
• Database Administrators

NB/ Accept any computer based career

14. In a spreadsheet, the formula = If(A1>10,A1*77,A1*50) is entered in a cell. Interpret the results.                                                                                                                        [3]

Checks the value in cell A1if it is more than 10, if the comparison is true then the outcome of the value in cell multiplied by 77 is displayed, else if it is false the results of the value in cell A1 multiplied by 50 are displayed.

15. State a stage in systems development cycle where each of the following activities are carried out:

a. Identifying the technologies that may be used in a proposed system.                       [1]

Accept any sub stage within system analysis e.g. requirement specification, problem definition, information gathering, etc

b. Identifying shortcomings of a system.                                                                       [1]

All stages of system development

c. Preparing the system migration plan.                                                                          [1]

Implementation stage

• Fibre optic cable would be used because it has a higher bandwidth, allowing faster communication in the main part of the network. It is also more secure as it cannot be tapped.
• Firewalls filter the data in and out of a network. Each packet is examined against the filter rules and if a packet is flagged, it is dropped. Only data packets that satisfy the filter rules are allowed through the firewall, thus providing a layer of security for the network.
• A satellite system would be better as it does not rely on wifi, cellular etc. It is not subject to interference and is reliable in remote conditions
• Radio-frequency identification (RFID) uses electromagnetic fields to automatically identify and track tags attached to objects. An RFID system consists of a tiny radio transponder, a radio receiver and transmitter. When triggered by an electromagnetic interrogation pulse from a nearby RFID reader device, the tag transmits digital data, usually an identifying inventory number, back to the reader. This number can be used to track inventory goods..

1. Use a humidifier: Using a humidifier can help maintain a consistent level of humidity in the computer lab, which can prevent the negative effects of low humidity.

2. Avoid dry air: Avoid creating a dry environment in the computer lab by opening windows or using fans to increase air circulation.

3. Regular maintenance: Ensure that all computer components are properly maintained and cleaned to prevent damage due to static electricity.

4. Backup data: Regularly backup all important data to avoid data loss in case of hardware failure caused by low humidity.

5. Monitor humidity levels: Use a hygrometer to monitor the humidity levels in the computer lab and take corrective measures if the levels fall below a safe range.

6. Use anti-static materials: Use anti-static mats or wristbands when handling computer components to prevent static electricity buildup.

Advantages

• on-line catalogues can be viewed
• much larger choice of products
• product reviews obtainable before purchase
• orders placed over internet any time day or night
• download software purchased straight away
• good and services usually cheaper on the internet
• programs that can search for best price/cheapest
• very fast placing an order has been placed as customer name, address
• and credit card details are stored so no need to re enter
• buy goods from anywhere in the world
• no need to go to shop/save travelling time

Disadvantages

• spam
• need a credit card to shop on-line/not everyone has a credit card
• hackers could retrieve credit card numbers and use them to buy goods
• security fears - of giving credit card number over the internet/fraud
• goods must be delivered/can not have the goods immediately
• can not touch/handle/see the goods

One to one  - Each record in the parent table has exactly one related record in the child table, and vice versa.

One to Many -  Each record in the parent table can have multiple related records in the child table, but each record in the child table is related to only one record in the parent table