admin@kcseforecast.com

Q&A-KCSE Computer Studies Paper 1

Define an end user license agreement (EULA).

  • An end user license agreement (EULA) describes a contract (agreement) between a software developer and a user of that software.
     
Question Image

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

  • Computer systems use binary/ones and zeros/voltage on or off;
  • Sound is analogue/continuous;
  • Computers use digital data/discrete values
Question Image

A web server has an internet protocol (IP) address. Give three characteristics of an IP address.

  • consists of values between 0–255 / 0–FFF
  • values are separated by full stops/colons
  • it is a unique address
  • can be static or dynamic
  • can be public or private
  • can be IPv4 / have four groups of digits
  • can be IPv6 / have eight groups of digits
  • in IPv6 :: can replace groups of zeros.
Question Image

Distinguish between Incremental and Full backup


Incremental:

  • Only the changes need to be backed up
  • The software/OS/settings are unlikely to have changed between backups
  • Small number of files likely to be used/edited between backups
  • Take less time to backup
  • Each backup will take less memory space to store

Full:

  • Backup all the data/files and software
  • It might not take a significant time to back up entire system
  • He might only have a small number of files to be backed up each time
  • Safer as have more past versions to revert to
  • User may have changed settings on computer
  • Faster to restore the backup
  • Needs to do a full before he can do an incremental
Question Image

State the types of storage devices used in a computer

  1. Primary Storage (Memory):

    • Random Access Memory (RAM): This is a volatile memory used to store data and instructions that the CPU (Central Processing Unit) can access quickly. RAM is essential for running applications and the operating system. However, its contents are lost when the computer is powered off.
    • Read-Only Memory (ROM): ROM is a non-volatile memory that stores essential firmware and instructions necessary for the computer's boot-up process. It retains its contents even when the power is turned off.
    • Cache Memory: Cache is a small and fast memory located closer to the CPU. It stores frequently accessed data to speed up the processing.
  2. Secondary Storage (Mass Storage):

    • Hard Disk Drive (HDD): HDDs use magnetic storage to store data on rotating platters. They provide relatively large storage capacities and are commonly used in computers and laptops for long-term data storage.
    • Solid-State Drive (SSD): SSDs use NAND flash memory to store data, offering faster read and write speeds than HDDs. They are more durable and consume less power, making them increasingly popular in modern computers.
    • Optical Discs: CDs, DVDs, and Blu-ray discs are examples of optical storage media. They are mainly used for distribution of software, music, movies, and archival purposes.
    • USB Flash Drives: Also known as thumb drives or pen drives, these portable storage devices use flash memory to store data and can be easily connected to a computer's USB port.
    • Memory Cards: Memory cards, such as SD cards and microSD cards, are used in various devices like cameras, smartphones, and tablets to store data, photos, videos, etc.
    • External Hard Drives: These are HDDs or SSDs contained within an external enclosure, allowing users to expand their computer's storage capacity or create backups.
Question Image

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:

  1. 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.

  2. 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.

  3. 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.

  4. 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.

Question Image

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

 

Question Image

Differentiate between Physical and logical topologies

  • Physical topology deals with the placement of nodes
  • Logical topology deals with the data flow  in the network
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

Give two characteristics of each of the system development methodologies listed below.

(a) Linear/Cascade/Waterfall

(b) Iterative Methodology

(a) Linear/Cascade/Waterfall

  • a project is divided into stages or phases
  • it is sequential, each stage needs to be completed before moving on
  • clear goals are set for each stage

(b) Iterative Methodology

  • effective in producing a working prototype in a short period of time
  •  involves extensive user input and testing
  • based on build – test – evaluate process, the philosophy is re-build until users are completely satisfied
  • features user input throughout the process which enables ongoing, responsive changes to be made to the design.
Question Image

What is a Uniform Resource Locator?

  • It is an address to a resource on the internet
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

Explain each of the strategies listed below.

(a) Phishing

(b) DoS

 

(a) Phishing

  • Phishing is a strategy that encourages a computer user to part with sensitive information such as bank details hence the term ‘phishing’ – i.e. fishing – trying to catch someone out. For example, a perpetrator sends a user an email that appears to be genuine, for example, pretending to be a bank or a lawyer requesting that the user verify bank account details or send money to assist in the completing of a legal case.

(b) DoS

  • DoS is a means of attack on a specific user/system/website which involves overloading a target with too much network traffic resulting in system slowdown, shutdown or a violation of security.
Question Image

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

Question Image

Explain one benefit to a user if the program is distributed as free software

  • The user can access the source code  so, they can tailor the software to their needs and they can fix any bugs in it
  • the source code could be studied for educational purposes
  • The user can redistribute the software/program  but this must be done under the same terms as the original software
Question Image

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

  • URL is clicked/typed into a web browser address bar. The page is requested (by the web browser) so HTML and files are fetched from a web server and the browser collates the page, which is then displayed on the monitor.
  • OR
    URL is clicked/typed into a web browser address bar (1). The browser locates the IP address either in cache or using a DNS server and the browser sends a request to the web server with that IP address web server uses HTTP to send back the requested web page and the browser displays the content of the page .
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 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

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

  • User friendly
  • No need to know command language as commands are executed by clicking on icons
  • Allows multitasking as several programs open at the same time therefore easier to switch between applications
  • Selecting an item using a mouse is easier and faster than entering commands

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                

  • Unemployment
  • Need to retrain
  • No longer need to do hazardous or tedious jobs
  • Employment of skilled staff who will manipulate the robots

Or any other correct response

Effect @ 1 Mark

Total = 2 X 1 Mark

= 2 Marks

Question Image

KCSE 2007, COMPUTER STUDIES PAPER 1

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)

  • It is taking a longer time to start-up;
  • It is often hanging;
  • Applications are taking longer to load.

 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)

  • Data
  • Axis
  • Legend                       

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)

Question Image