admin@kcseforecast.com

Q&A-KCSE Computer Studies Paper 1

Describe what is meant by a clock speed of 3.8 GHz.

  • The number of FDE cycles run per given time/second
  • the frequency that the clock ‘ticks’
  • 3.8 billion cycles/instructions per second
Question Image

State the functions of the following protocols

POP -Stands for post office protocol

  • used to download emails from email servers

SMTP- Simple Mail Transfer Protocol

  • used to send emails to email servers and transfer emails between servers

FTP - Stands for the file transfer protocol

  • handles file uploads and downloads
  • transfers data and programs and not viewable content

 

State the functions of the following protocols

POP -Stands for post office protocol

  • used to download emails from email servers

SMTP- Simple Mail Transfer Protocol

  • used to send emails to email servers and transfer emails between servers

FTP - Stands for the file transfer protoc

Question Image

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

State THREE reasons why binary is used in developing digital electronic systems                                                                                                                                                   (3marks)

  • Simple technology is needed to develop both hardware and software.
  • Digital devices are more reliable, small in size and use less power as compared to analog devices.
  • Devices that read, process or output data in digital form are used in computers and other digital devices such as calculators.
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

Differentiate between action query and select query

An action query is used to modify, add, or delete data in a database whereas a select query is used to retrieve data from a database based on specified criteria but does not make any changes to the data.

Question Image

State two reasons for the increased use of computers in offices                      (2 marks)

  • They are small and fit in a small storage space
  • They are portable hence can be carried when need to be used outside the office
  • Low power consumption
  • Have rechargeable batteries
Question Image

A company has decided to use a computer for stock control. Describe the process of systems development from the time the decision was made to proceed with computerisation until final testing.

specify output requirements
design documents/screen displays
data for input/storage
form design
storage devices
file structures/access/design
data security/back up files
systems flowchart etc.
implementation i.e. pilot/intermediate/parallel running
testing strategy
training
hardware/software
programming/algorithms
validation
user manual
technical documentation
entering data into system

Question Image

Briefly describe the following

Multitasking - the  capability of an operating system to enable users to run two or more programs at once on a single computer

Real time processing - data processing system in which the time interval required to process and respond to inputs is so small that the response itself is useful for controlling the physical activity of a process

Time-sharing processing  - a processing mode in which the central processor serves two or more users with different processing requirements (tasks)

On-line processing - is that type of processing where the result of data processing transaction is available immediately

Question Image

List Three file organisation methods in a computer

  • Sequential
  • Random
  • Serial
  • Indexed-sequential
Question Image

Name three types of cables used in data communication

Twisted pair cables

Coaxial cables

Fibre optic cables

Question Image

Explain how the techniques of

(i) verification,
(ii) validation
are used to ensure that the stored data is as accurate as possible.

Dual input of data

  • Two inputs are compared by the system and any discrepancies are reported (and not stored.)
  • Data input once, either printed out or checked on the screen and  errors corrected

 Rules are given to the processor

  • Only accept A, B, C, D, E, F, G i.e Any other input rejected.

Drop-down list/radio buttons

  • Provides only valid inputs, so no other validation is required
Question Image

Differentiate between modulation and demodulation as used in data communication

Modulation refers to the process of converting a digital signal to analog signal at the transmission end while demodulation is to converting analog signal to digital signal at the receiving end

Question Image

Give one example of wireless technology

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
Question Image

Compare the use of a compiler with the use of an interpreter to translate code

Both translate source code written in high level programming languages into machine code.
Compiler: Produces a single executable file that is portable between machines
Interpreter: Source code needs a special environment to run
Compiler: Needs to be compiled for a particular architecture
Interpreter: Can run on any architecture that has the translator/interpreter
Complier: Entire source code file is translated at once
Interpreter: Code is translated line by line
Compiler: Provides error report at the end of the compilation
Interpreter: Errors more obvious in the sequence
Compiler: The program source code is not available (so helps protect IP)
Interpreter: Source code is available
Compiler: Only has to be translated once (affecting the speed of execution)
Interpreter: Has to be translated each time, therefore (affecting the speed of execution)
Compiler: Requires two files to be maintained (one for execution and for editing purposes)
Interpreter: Requires only one file to be maintained
 

Question Image

Explain the difference between
(i) serial and parallel,
(ii) simplex and duplex
modes of data transmission.

  • Serial is the transmission of data one bit at a time/through one wire
  • Parallel is the transmission of data more than one bit at a time/many wires
  • Simplex is the transmission of data in one direction only
  • Duplex is the transmission of data in both directions simultaneously
Question Image

What is an Operating System?

  • It refers to a system software that provides a platform for installation and execution of an application software and also manages the computer hardware
Question Image

Give any three advantages of computer networks

  1. Enable resource sharing
  2. Facilitate remote communication
  3. Enable distributed processing
  4. Provide better data security and management

Give two other uses of hexadecimal in computer science.

  • colour codes // colour in HTML/CSS
  • error messages
  • locations in memory
  • memory dump // debugging 
  • IP(v6) address
  • ASCII // Unicode
  • assembly language
  • URL.

 

Question Image

Ochieng manages a network for an organisation.
(a) Two computers are assigned the same IP address.
Explain why Ochieng must change the IP address of one of the computers.

  • Devices must have a unique IP address because otherwise, a switch would not know which of the two was the correct device to send packets to

(b) Identify the network topology that requires a server.

  • Star topology

Ochieng manages a network for an organisation.
(a) Two computers are assigned the same IP address.
Explain why Ochieng must change the IP address of one of the computers.

  • Devices must have a unique IP address because otherwise, a switch would not know which of the two was the correct device to send packets to

(b) Identify the network topology that requires a server.

  • Star topology
Question Image