admin@kcseforecast.com

Q&A-KCSE Computer Studies Paper 1

Distinguish between a PAN and a LAN

A PAN exist around a single person whereas a LAN covers a larger area

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

Describe how the database can be recovered from a system failure

  • backups/dumps of files
  • copy of files on CD/tape streamer
  • file generations
Question Image

There are four change-over methods used in the implementation stage of the system development life cycle (SDLC): direct change-over, phased, parallel and pilot.

Direct Change-Over

  • A date is chosen for the shutdown of the old system, then at that time, the old system
    is turned off and the new system is implemented

Phased

  • Parts of the new system are implemented in stages or for a period of time, both the old and the new system are running together until all parts of the system are implemented.
Question Image

Define the term variable as used in programming

A variable is a memory location used to store a value

Question Image

Distinguish between real time processing and interactive processing

  • Real-time processing is where data is processed as it is received and the output is made available immediately to influence the ongoing activity
  • Interactive processing is computer processing in which the user can modify the operations appropriately while observing results at critical steps
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

Maranda 2024 Mock CRE Paper 2

1. a) Based on Deutro-Isaiah, describe the Messiah. (7mks)

The Messiah would be despised/ rejected

The Messiah would be treated harshly/ arrested/sentenced to death

The Messiah would be reconciling people through His suffering

The death of the Messiah would bring forgiveness of sins of humankind

The Messiah would endure suffering/humiliation without complaining/ would suffer innocently

The Messiah would have nothing attractive

The Messiah would be humble/simple

The Messiah would be highly honored

The Messiah would succeed in His work

He would be despised, rejected, wounded oppressed and afflicted 

He endured pain and suffering which would have been ours. 

Because of our sins he was wounded 

We are healed by the punishment he suffered He was treated harshly but he never said a word 

He was put in the grave with the wicked 

He was buried with the rich even though he did not commit a crime 

He took the place of many sinners and prayed that they might be forgiven.

 

Question Image

State what is meant by Computer Aided Design (CAD).

Give three different applications that make use of CAD.

Name three specialist input/output devices used in CAD.

– software that can be used to design new products/amend existing products
– makes use of features such as 2D, 3D, wire frames, library of parts, links to CAM

Give three different applications that make use of CAD.

– aerospace
– architecture
– designing cars
– designing consumer goods
– chemical/nuclear plant design
– designing electronic circuit boards
– ergonomic design
– landscape/garden design

Name three specialist input/output devices used in CAD.

– large monitor/screen with hi-res
– touch screen
– plotter
– space mouse/space ball/4D device
– 3D glasses (in some applications)
– light pen
– graphics tablet
– 3D printer
– 3D scanner

Question Image

Define what is meant by a ‘network protocol

  • An agreement / set of rules / standard for how computers should communicate or how data is sent/received/transmitted on a network
  • Example of what could be agreed in the protocol (e.g. speed / error checking / etc.)
Question Image

Your friend wishes to install a wireless network in his office. Explain to him the difference between guided and unguided media

  • Guided media uses cables to connect to computers whereas unguided media uses waves.
Question Image
Name four data management tools used in spreadsheets. (2 marks)
- Filtering - Sorting - Input validation - Subtotals - Data entry forms
Question Image

Explain what happens in the computer during the booting process

The booting process is the sequence of events that occur when a computer is turned on or restarted. It involves a series of steps that allow the computer's operating system to initialize and become functional. Here's a simplified explanation of what happens during the booting process:

  1. Power-On Self-Test (POST): When the computer is powered on, the first thing it does is perform a Power-On Self-Test. During this step, the computer's hardware components, such as the CPU, memory, and storage devices, are checked for proper functioning. The POST verifies that all essential hardware components are present and operational.

  2. Bootloader: Once the POST is completed, the computer looks for the bootloader. The bootloader is a small program stored in the computer's firmware or on the bootable device (such as the hard drive or a USB drive). It is responsible for loading the operating system.

  3. Loading the Operating System: The bootloader locates the operating system's files and initiates the loading process. It may display a boot menu allowing the user to choose the operating system if multiple options are available. The selected operating system's core files are loaded into the computer's memory.

  4. Kernel Initialization: The operating system's kernel, which is the central component responsible for managing system resources, is initialized. The kernel sets up essential components such as device drivers, memory management, and process management.

  5. System Initialization: After the kernel is initialized, the operating system proceeds with system initialization. During this stage, various system services and processes are started, and hardware devices are initialized and configured. The operating system loads essential system files and prepares the environment for user interaction.

  6. Login/Graphical Interface: Once the system initialization is complete, the user is presented with a login prompt or a graphical user interface (GUI). The user can then log in with their credentials or interact with the GUI to access the computer's functionalities.

Question Image

Computer System Questions

  1. (a)State what is meant by the terms:

Parallel data transmission

 

  • 8 bits/1 byte/multiple bits sent at a time  
  1. using many/multiple/8 wires/lines

 

Serial data transmission

  • one bit sent at a time  
  • over a single wire

b) Give one benefit of each type of data transmission.

  • Parallel - faster rate of data transmission

Serial

  1. -more accurate/fewer errors over a longer distance
  2. -less expensive wiring  
  3. less chance of data being skewed/out of synchronization/order

Give one application of each type of data transmission. Each application must be different

Parallel

  • sending data from a computer to a printer
  •  internal data transfer (buses)

Serial

  • connect computer to a modem

State what is meant by the term USB

  • universal serial bus

Describe two benefits of using USB connections between a computer and a device.

  • -devices are automatically detected and configured when initially attached
    • Impossible to connect device incorrectly/connector only fits one way
    • has become the industry standard
    • supports multiple data transmission speeds
    • lots of support base for USB software developers
    • supported by many operating systems
    • backward compatible
    • faster transmission compared to wireless

 

 

 

DVD - optical media which use one spiral track; red lasers are used to read and write data on the media surface; makes use of dual-layering technology to increase the storage capacity

ROM - non-volatile memory chip; contents of the chip cannot be altered; it is often used to store the start-up routines in a computer (e.g. the BIOS)

SSD/ Solid State Drive/memory (SSD): a non-volatile memory device that uses NAND flash memories (which consist of millions of transistors wired in series on single circuit boards)

Blue Ray -  optical media that uses blue laser technology to read and write data on the media surface; it uses a single 1.1 mm polycarbonate disc

 

Viruses, pharming and phishing are all examples of potential Internet security issues.
Explain what is meant by each of these three terms
.

 

 

Virus

  • - program/software that replicates/copies itself
  • – can delete or alter files/data stored on a computer
  •  – can make the computer “crash”/run slow

Pharming - malicious code/software installed on a user’s hard drive/actual webserver

 – this code redirects users to a fake website (without their knowledge)

 – to obtain personal/financial information/data

Phishing - legitimate-looking emails sent to a user – as soon as the recipient opens/clicks on the link in the email/attachment,  the user is directed to a fake website (without their knowledge) – To obtain personal/financial information/data

 

control bus- this bus carries signals used to coordinate the computer’s activities

address bus - this uni-directional bus carries signals relating to memory addresses between processor and memory

data bus - this bi-directional bus is used to exchange data between processor, memory and input/output devices

 

The seven stages in a von Neumann fetch-execute cycle

  • the PC (program counter) contains the address of the next instruction to be fetched
  • the address contained in the PC (program counter) is copied to the MAR (memory address register) via the address bus
  • the instruction is then copied from the memory location contained in the MAR (memory address register) and is placed in the MDR (memory data register)
  • the entire instruction is then copied from the MDR (memory data register) and placed in the CIR (current instruction register)
  • the value in the PC (program counter) is then incremented so that it points to the next instruction to be fetched
  • the address part of the instruction is placed in the MAR (memory address register)
  • the instruction is finally decoded and is then executed

 

Modern LCD monitors and televisions use LED-backlit technology.
Give two advantages of using this new technology compared to the older cold cathode fluorescent lamp (CCFL) method

  • no need to warm up
  • – whiter tint/more vivid colours/brighter image
  • – higher resolution
  • – much thinner monitors possible/lighter weight
  • – more reliable technology/longer lasting
  • – uses much less power/more efficient

 

Question Image

What is block operation as used in Microsoft word?

An editing or formatting procedure that is carried out on a selected block of text in a word-processing document.

A formatting or editing operation that is applied to a block of text after selecting. The block of text can be a paragraph, line, word, page or the whole document. It is much easier to apply editing or formatting to a block of text than to apply it to every single character

Question Image

Describe two possible causes of computer failure. In each case state how it could have been prevented

  1. Hardware failure
  2. Corrupted software files
  3. Hacking into the system
  4. Power failure
Question Image

State two ways in which data validation is implemented on an input form of a database application

  • By setting the validation rule for the input controls on the property sheet in design view
  • By use of VBA to restrict user inputs for a given control on a form
  • By use of queries to restrict options available for the user in a combo box or listbox
  • Setting correct data types for the fields in table the design
  • Enforcing referential integrity in database relationships
  • Use of input mask for the controls on the property sheeet in design view
Question Image

Give a reason why HMTL is not regarded as a programming language

  •  It does not have declaration part
  • It does not  have control structures
Question Image

State the functions of the following features in word processors

  • Thesaurus - Is a feature in a word processor that suggest words with the similar or opposite meaning to the one selected
  • Comments: a feature in a word processor that allows a user to attach a remark about the selection
Question Image

What is a primary key?

  • an attribute/combination of attributes chosen to ensure that the records in a table are unique
Question Image