• Developing training materials
• Training computer users
• Conducting ICT examinations
• Managing the learning and examination process
• Developing guidelines for using the computer lab
• Planning the course content
•  

• Network operating systems
• Protocols

a repeater will amplify a signal and resend it to overcome reduction in signal strength (attenuation) because over a distance network signals diminish in size/amplitude (are attenuated) due to characteristics of the media.

• Resizing using resize handles
• Rotating
• Cropping
• Flipping
• Moving

• Distributed data processing is where computers located in physically separate location transmit data after processing to a server computer that updates the master file. Time-sharing on the other hand is where various terminals transmit data to be processed by a central computer's CPU. Each terminal's tasks are allocated a time slice of the CPU

• 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

• A physical file contains the original data whereas a logical file does not contain any data
• A physical file contains one record format while a logical file can contain up to 32 record formats
• A physical file can exist without a logical file while a logical file cannot exist without a physical file

• OS controls operation of system/hardware
• Applications software allows the system to do something useful

• 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.

(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

• This approach causes minimum disruption

• It ensures that each row has a unique and non-null primary key

• Artificial intelligence
• Parallel processing
• Natural language processing
• quantum computing

1. Low level languages do not resemble natural languages they are made up entirely of bit patterns
2. Low level languages produce code that is executed faster as it is already in a format the CPU can execute / does not need to be translated.
3. High level languages are easier to understand / learn as commands are more like English / identifiers can be meaningful .
4. High level languages are easier to use leading to fewer errors.

• 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

• To get the latest features
• To update security features

• To provide legal backing so that it is possible to seek redress if the rights are violated
• To observe copyright for those who create original works
• To protect the confidentiality of information kept  about an individual

• URL is clicked/typed into a web browser address bar. The page is requested (by the web browser) so HTML and files are fetched from a web server and the browser collates the page, which is then displayed on the monitor.
• OR
  URL is clicked/typed into a web browser address bar (1). The browser locates the IP address either in cache or using a DNS server and the browser sends a request to the web server with that IP address web server uses HTTP to send back the requested web page and the browser displays the content of the page .

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

• Repeaters : amplify data signal thereby extending the physical coverage of a network. It can connect two LANs locally.
• Bridges: connect similar types of networks e.g a token ring to another token ring
• Routers: link networks of different types
• Gateway: allows computers in a network to connect regardless of their topology