admin@kcseforecast.com

Q&A-KCSE Computer Studies Paper 1

Describe the query criteria given below

 

(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

Question Image

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?

  • the computer appears to “freeze”/”hang”
  • computer won’t respond
  • failure of hardware (stops computer normal functioning)
  • failure of software (stops computer normal functioning)
Question Image

Differentiate between a compiled and an interpreted program

  • A compiled program will only execute on a processor of specific type/family/with same instruction set
  • A program run using an interpreter can execute on a computer with any type of processor
Question Image

Journalists are issued with laptops when they start working at a magazine publishing company. The company only uses free open-source software (FOSS).

  • 2.1.1 Explain the concept of open source in the context of FOSS. (2)
  • 2.1.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.

The laptops are equipped with either an HDD or an SSD.

  • 2.2.1 Users of laptops equipped with HDDs are advised to defragment the HDD regularly.
  • Briefly explain what defragmentation is. (2)
  • 2.2.2 Write out the abbreviation SSD in full. (1)
  • 2.2.3 Explain why an SSD accesses the data faster than an HDD.

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.4 The company takes precautionary measures to protect the magazine's data.
  • 2.4.1 An incremental backup strategy has been implemented to safeguard data. Explain how an incremental backup strategy works. (2)
  • 2.4.2 The company considers installing biometric readers on all the laptops. How would a biometric reader help safeguard the data on a laptop?

 

2.1.1 Explain the concept of open source in the context of FOSS. (2)

  • Is a software whose source available and user can modify and redistribute

Give ONE example of a free operating system the company could install on a laptop. (1)

  • Linux
  • FreeBSD
  • ReactOS
  • Android
  • ChromeOS
  • OpenSolaris

2.1.3 State TWO disadvantages of using free open-source software.

  • Lack of support
  • Security risks
  • Compatibility issues
  • Hidden costs
Question Image

Fibre optic cable is available in either single-mode or multi-mode. Outline the characteristics of each mode.

  • Single-mode fibre consists of a narrow core in which all light pulses travel at the same speed and arrive roughly at the same time at the destination.
  • Supports higher bandwidth with less signal loss over a greater distance
  • Multi-mode Multi-mode fibre consists of a larger core in which multiple light pulses can travel down the core.
  • Supports a smaller bandwidth and signals attenuate at a shorter distance than single mode fibre.
Question Image

What is a Uniform Resource Locator?

  • It is an address to a resource on the internet
Question Image

State the primary function of the Dynamic Host Configuration Protocol (DHCP) protocol.

  • it generates and/or allocates an IP address
Question Image

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)

  • Memory content is lost when the power is turned off

ii) What is normally stored in the non-volatile part of a computer’s main memory                       (1mark)

  • The Computer’s BIOS

b) Explain why having cache memory can improve the performance of the CPU                         (2mks)

  • Frequently used data/instructions are store in the cache; Meaning they don’t have to be fetched from the main memory;
  • Data/instructions stored in the cache memory can be accessed faster (than data/instructions stored in the main memory) MAX 2
Question Image

State advantages and disadvantages of the following system implementation strategies

Phased:
Advantages:

  • only a small part of the operation affected if new system fails
  •  no need to pay for two sets of wages

Disadvantages:

  •  time consuming (each part needs testing fully before expanding system)

Pilot:
Advantages:

  • if new system fails, only that part will be affected
  • possible to gradually train staff on pilot before whole system changes over

Disadvantages:

  •  time consuming (waiting to see how pilot works before rolling out to rest of the organisation)

Direct:
Advantages:

  •  less likely to malfunction since fully tested
  • immediate benefits/less time wasted
  •  reduced costs (only one system so no need to duplicate staff)

Disadvantages:

  • disastrous if the new systems does fail

Parallel:
Advantages:

  •  if new system goes down, there is a backup system in place
  • possible to gradually train staff/staff have time to get used to the new system

 

 

 

Question Image

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

  • Piece of software/code/a program that replicates itself  or causes damage e.g. editing/deleting files

Prevention

  • Running anti-virus/anti-malware software 
  • don’t download from unknown sources
  • don’t click on unknown links

Spyware / malware / keylogger

  • Piece of software/code/a program that records actions/key presses and sends this data to a third party analysis

Prevention

  •  Running anti-spyware/anti-malware software/firewall

Data interception / passive

  • Data is sent to another device and is intercepted by a third party

Prevention

  • Encryption

Phishing

  • An e-mail has a link that when clicked directs the user to a fake website that collects personal data

Prevention

  • Network policy // firewall

Pharming

  • A piece of code installed that redirects user to fake website that collects personal data

Prevention

  • Anti-malware or firewall

Hacker

  • Person attempting to gain unauthorised access to the network/computers/ data/files 
  • unauthorised access and then deleting/editing data/files

Prevention

  • Firewall
  • strong password 
  • biometrics
  • penetration testing
Question Image

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

 

Question Image

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

Question Image

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

Question Image

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)

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

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]

  • Size of the video/format
  • The bandwidth of the media/speed of network/network traffic
  • Type of browser software
  • Background activities running in the computer
  • Restrictions enforced in the computer/firewall/antivirus
  • Speed of the computer/CPU speed
  • Size of RAM

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]

  • Poor network/lack of connection
  • Software failure in the system
  • Hardware failure
  • Lack of access rights
  • System overload/hanging
  • Lack of skills/disability/illiteracy
  • Lack of power supply

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]

  • No record can be added in Table 2 if its corresponding record in Table 1 does not exist
  • No record in Table 1 can be deleted without first deleting the corresponding record in Table 2
  • Reduces data redundancies/ensures integrity
  • Prevents deletion of related table

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)

Question Image

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

 

Question Image

State two functions of utility software

  • Repairing files
  • Compression
  • Defragmentation
  • Back up
  • Anti-virus / anti-spyware / anti-malware
  • Firewall
  • Managing application updates
  • Format disks/drives
  • System analysis tools
Question Image

What is the difference between a logical file and a physical file?

  • 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
Question Image
Give two uses of spreadsheets in a government office concerned with carrying out national census
Tallying population size Establishing demographic trends Drawing pie charts to show population share by gender Doing census budgets

List three other types of software license.

  • Network
  • Commercial
  • Enterprise
  • Proprietary
Question Image