Describe the query criteria given below
(a) Like "*kenya*"
(b) Like "*ina"
(c) Like U*
(d) Not Like U*
(e) >= "Mexico"
(f) Like "[A-D]*"
(g) "USA" Or "UK"
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?
Differentiate between a compiled and an interpreted program
Journalists are issued with laptops when they start working at a magazine publishing company. The company only uses free open-source software (FOSS).
The laptops are equipped with either an HDD or an SSD.
The journalists can access their data remotely using virtualisation or Software
as a Service (SaaS).
2.3.1 Define the term virtualisation. (1)
2.3.2 Office365 is an example of SaaS.
(a) Except for remote data access, state TWO benefits of using
SaaS. (2)
(b) Describe how the license model of SaaS works. (2)
2.1.1 Explain the concept of open source in the context of FOSS. (2)
Give ONE example of a free operating system the company could install on a laptop. (1)
2.1.3 State TWO disadvantages of using free open-source software.
Fibre optic cable is available in either single-mode or multi-mode. Outline the characteristics of each mode.
What is a Uniform Resource Locator?
State the primary function of the Dynamic Host Configuration Protocol (DHCP) protocol.
A typical computer’s main memory consists of both volatile and non-volatile memory.
a) i) Explain what is meant by the term volatile memory (1mark)
ii) What is normally stored in the non-volatile part of a computer’s main memory (1mark)
b) Explain why having cache memory can improve the performance of the CPU (2mks)
State advantages and disadvantages of the following system implementation strategies
Phased:
Advantages:
Disadvantages:
Pilot:
Advantages:
Disadvantages:
Direct:
Advantages:
Disadvantages:
Parallel:
Advantages:
Describe three possible threats to the computers connected to the network and give one way each threat can be reduced or prevented
Virus / trojan / worm / malware
Prevention
Spyware / malware / keylogger
Prevention
Data interception / passive
Prevention
Phishing
Prevention
Pharming
Prevention
Hacker
Prevention
A school intends to install a computer network. Explain three challenges that the school may experience after the installation (KCSE 2021 Computer Studies Q19(b))
Network Failure - when the network becomes faulty or the network is down, users may not access network resources hence operations of an organization may be brought to a standstill
Security Issues: A computer network can be accessed thus there is an increased chance of hacking
The rapid spread of viruses: Viruses can easily spread to terminals of a computer network which may be very expensive to clear
Cultural and moral effects: adult content may be shared in a networked environment which may be of negative impact on teenagers
Differentiate between a function parameter and a function argument
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
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
State three ways of transforming a picture embedded in a DTP program in order to fit on a designated space on a document (kcse 2019 paper 1)
Computer Studies Paper 1 2021 KCSE Prediction Section B Qs. 17,18 and 19
17. a) i) Explain the term search as used in the Internet. [2]
A web based application that locates items or information from the World Wide Web
ii) Peter intends to download a movie from the Internet. State the three factors that may determine the total time taken to complete the download. [3]
b) Wakulima online is an organization that runs a web based system for assisting farmers to obtain market for their produce. State four technological reasons that may cause a farmer not to access the organization’s system. [4]
c) Explain a situation when each of the following Desktop Publishing program features may be used when creating a publication:
i. Cropping [2]
Applies to graphics – used to trim/remove/hide some portions in the graphics
ii. Transparency [2]
Used to make background of a graphic to be clear/visible
d. List two areas where infrared waves are used in data communication. [2]
18. a) List four activities of the planning stage of systems development. Ignore this question, marks redistributed elsewhere
b) Explain a circumstance when each of the following feasibility studies are carried out during systems development.
i. Technical [3]
Done to determine whether technology exists to support the proposed solution
ii. Economic [3]
Done to determine whether the proposed solution is economically viable
iii. Schedule [3]
Done to determine whether the proposed system can be done within an acceptable time.
c) Table 1 and Table 2 are related tables in a database. Use them to answer the questions that follow.
Table 1
|
Dept Code |
Dept Name |
|
001 |
Computer |
|
002 |
Aviation |
|
003 |
Engineering |
Table 2
|
DeptID |
Student Registration No. |
Student’s Name |
|
002 |
St01 |
Alex Too |
|
003 |
St02 |
Naomi Komi |
|
002 |
St03 |
Peter Kengo |
i. Identify the appropriate primary key for each table. [2]
Table 1 – Dept code, Student Registration No
ii. Explain two benefits of enforcing referential integrity in the database. [4]
19. a) Describe each of the following validation checks as used in data processing.
i. Preserve check [2]
Ignore this question, marks redistributed elsewhere
ii. Data type check [2]
Ensure correct type of data is entered for the field
iii. Check digit [2]
This is a number added/calculated by the computer to a binary number. The check digit ensures correct transmission of the binary number.
b. Write each of the following abbreviations in full:
i) BCD [1½]
Binary Coded Decimal
ii) EBCD [
This question was thrown out and marks redistributed elsewhere
iii) ASCII [1½]
American Standard Code for Information Interchange
c) Using 10-bits binary number system, perform the following decimal operation using two’s complement. [6]
12910 - 12810
+129 = 00 1000 0001
128 = 00 1000 0000
-128 = 11 0111 1111 (ones complement)
+1
11 1000 0000 (Twos complement)
129- 128
00 1000 0001
+ 11 1000 0000
100 0000 0001
Hence = 00 0000 00012 or 12 (the overflow bit is ignored)
The website has a uniform resource locator (URL).
An example of a URL is given.
https://www.google.co.ke/index.html
Complete the table to identify the name of each section of the URL.
https : protocol
google.co.ke: domain name
/index.html: webpage/file name
State two functions of utility software
What is the difference between a logical file and a physical file?
List three other types of software license.