Define an end user license agreement (EULA).
A sound engineer is recording a singer. Describe why the sound must be converted to a digital format before it can be stored on a computer system
A web server has an internet protocol (IP) address. Give three characteristics of an IP address.
Distinguish between Incremental and Full backup
Incremental:
Full:
State the types of storage devices used in a computer
Primary Storage (Memory):
Secondary Storage (Mass Storage):
What is meant by RAID technology?
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:
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.
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.
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.
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.
A school has 3000 students sitting final examinations.
Each student sits eight examinations.
Write an algorithm, using pseudocode or a flowchart, which:
• inputs the marks for all 8 examinations for each student
• outputs for each student the average mark for their 8 examinations
• outputs the highest mark overall
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
Differentiate between Physical and logical topologies
Give two characteristics of each of the system development methodologies listed below.
(a) Linear/Cascade/Waterfall
(b) Iterative Methodology
(a) Linear/Cascade/Waterfall
(b) Iterative Methodology
What is a Uniform Resource Locator?
She lost all her photographs when her computer crashed.
(i) What is meant by the term crashed?
(ii) How could she have avoided losing all her photographs?
Explain each of the strategies listed below.
(a) Phishing
(b) DoS
(a) Phishing
(b) DoS
Describe the purpose of the
(i) control unit
(ii) memory unit
(iii) arithmetic logic unit
in a computer.
i) To manage the execution of instructions
By running a clock
To decode instructions
(ii) To store OS
To store those parts of applications programs currently running
To store data currently in use
(iii) Part of the processor where data is processed/manipulated
All I/O must pass through here
Explain one benefit to a user if the program is distributed as free software
Joe plays online games using the world wide web. A sequence of processes is required to open a web page. Describe this sequence of processes
State the functions of the following features in word processors
What is audit trail?
A record showing who has accessed a computer system and what operations he or she has performed during a given period of time
Interfaces enable computer users to interact with the operating system.
(a) State four advantages for using a graphical user interface in loading programs and files
(b) A vehicle assembly company has introduced robots to replace the human workforce. State two effects this would have on the workforce
State four advantages for using a graphical user interface in loading programs and files
Or any other correct response
Advantage @ 1 Mark
Total = 4 X 1 Mark
= 4 Marks
A vehicle assembly company has introduced robots to replace the human workforce. State two effects this would have on the workforce
Or any other correct response
Effect @ 1 Mark
Total = 2 X 1 Mark
= 2 Marks
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)
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)
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
|
Form 1 |
Form 2 |
Form 3 |
Form 4 |
|
OS |
SP |
Pr. |
ADB |
|
WP |
DTP DB |
Internet |
|
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)