admin@kcseforecast.com

Q&A-KCSE Computer Studies Paper 1

What is social engineering?
The act of soliciting for sensitive information from unsuspecting users. According to study.com, it is the use of various forms of technology to deceive people into divulging private information:study.com
Question Image

At which stage of the system development life cycle does the changeover to a new system take place?

  • Implementation
Question Image

The operators who enter the data into the files sit at keyboards to do their work.
Discuss

(i) the potential health hazards of this type of work,
(ii) the ways that management can help to overcome the effects of the health hazards.

(i) the potential health hazards of this type of work,

  • backstrain due to long periods of immobility
  • eye strain due to long periods of staring  at the screen
  • RSI- continual use of the same muscle group

(ii) the ways that management can help to overcome the effects of the health hazards.

  • Move around regularly
  • use ergonomic chair
  • use anti-glare screen
  • use of wrist pads
Question Image

Data integrity in a database can be divided into three categories: referential integrity, domain integrity and entity integrity.

(a)Outline the meaning of each of the following.

(i) Referential integrity

(ii) Entity integrity

(b) Describe how data integrity can improve the process of database management. (2 marks)

(i) Referential integrity

  • Two entities that are related require that a foreign key must have a matching primary key

(ii) Entity integrity

  • Entity integrity specifies that the Primary Keys on every instance of an entity must be kept, must be unique and must have values other than NULL

(b) Describe how data integrity can improve the process of database management. (2 marks)

  • Data integrity is the maintenance of, and the assurance of, data accuracy and consistency over its entire life-cycle and is a critical aspect to the design, implementation, and usage of any system that stores, processes, or retrieves data
  • The overall intent of any data integrity technique is the same: ensure data is recorded exactly as intended (such as a database correctly rejecting mutually exclusive possibilities)
Question Image

Explain why a developer, who is good at both low-level and high-level programming, would normally use high-level languages when writing programs.

  • High-level languages have built-in functions;
  • High-level languages have built-in libraries;
  • High-level languages have more support/help;
  • High-level languages have structures (such as selection and iteration);
  • High-level languages can be less machine-dependent/more portable;
  • It (usually) requires fewer lines of code to be written;
  • It is (usually) quicker to develop code in high-level languages;
  • It is easier to find mistakes in code;
  • The code is easier to maintain//understand;
  • It is easier to structure code in high-level languages;
Question Image

Give a reason why microwaves are commonly used for point-to-point communication

  • their small wavelength allows conveniently sized antennas to direct them in narrow beams, which can be pointed directly at the receiving antenna
Question Image

What is a referential integrity constraint?

  • It requires that a foreign key must have a matching primary key or it must be null
Question Image

Describe the purpose of a data dictionary, using an address book database as an example.

  • when designing a database a data dictionary provides the description and purpose of the fields/attributes of the database table(s). For example the field name (i.e. “phone number”), the data type (text); the size of the field (10) etc.
Question Image

What is a backup?

A backup is a copy of data that can be used if the original data is lost.

Question Image

IT technicians are setting up a new file server for a school. Describe the benefits and drawbacks of using a command line interface (CLI) rather than a graphical user interface (GUI) to set up a new file server.  (4marks)

Benefits

  • The user is not restricted to the predetermined options//the GUI uses icons and set menus
  • The user has more control over the computer settings//in GUI computer settings are protected from the user
  • Uses less memory than GUI
  • Requires less processing power for the interface
  • More processing power is made available for the task

Drawbacks

  • The commands used have to be learnt
  • The commands used have to be remembered
  • The commands used have to be typed in/entered exactly
  • Have to remember the exact path/correct name of application
  • More prone to errors on data entry Commands have to be typed in//in a GUI can use touchscreens/mice
  • Tends to be used by specialist people//GUI is more user-friendly and can be used by non-experts
Question Image

What situations are likely to call for the use of Direct Changed Over?

  • where the new system is completely different from the old one
  • if there has been extensive testing of the system and the system analyst has confidence in its functionality
  • If the system is not critical
Question Image

Joelle’s parent also uses the firewall to limit the websites that Joelle can access.
Explain how the firewall is used to limit the websites that Joelle can access

(The parent can) set criteria for the websites she is allowed to visit such as a whitelist/blacklist of websites. The firewall will examine the data/traffic incoming and outgoing from her computer. If data is sent from a website that is not allowed, it will be blocked

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

Describe and give an example of one syntax and one logical programming error.

Syntax
• An error that occurs when a command does not follow the expected syntax of the language, e.g. when a keyword is incorrectly spelt
• Incorrect: IF A ADN B Then
• Correct: IF A AND B Then

Logical
• An error that causes a program to output an incorrect answer (that does not necessarily crash the program)
• An algorithm that calculates a person’s age from their date of birth, but ends up giving negative numbers

Question Image

Explain a situation when each of the following Desktop Publishing programs features may be used when creating a document

(i) Crop - used when handling a graphic and there is a need to remove some of the portions in the graphic

(ii)Transparency - used when there is a need to make background of a graphic visible

Question Image

What is a Uniform Resource Locator?

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

Describe how the denial of service strategy works to compromise the security of networks.

  • A denial of service strategy usually works flooding the target host or network with traffic until the target can’t respond or crashes. The targeted systems operations are affected when users are unable to access information systems and or network services
Question Image

Describe two features you would expect to see in the expert system’s interactive user interface.

– multiple choice/yes-no answers
– easy to understand interface e.g. use of icons/drop down menus etc.
– output shown as % probabilities of fault

Question Image

KCSE 2003 COMPUTER STUDIES

SECTION A (40 MARKS)

Answer all the questions in this section

1.Computer systems are built from three types of physical components: processors,memories and 1/O devices.

  a) State two tasks of a processor                                                            (2 mks)

  b)State function of 1/O devices                                                               (1 mk)

2. Threats to the safety of computer systems take many forms such as:  white-collar crime, natural disasters, vandalism and carelessness.Give on way as to how each of these forms of threats can be controlled.    2 mks)

3.a) Explain the term nibbles as used in data representation in computers

   b)Perform the following binary arithmetic giving the answers in decimal notation.     (3 mks)

       i)1110.01111 + 11010001 .011

        ii) 1001011.011 - 111.111

     4  a)  Distinguish between machine and assembly language           (2mks)

         b) State the type of translator necessary for a program written in:         (2mks)

            i) High level language

           ii)Assembly language                                                    

5. Briefly explain the purpose of the following types of program documentation: (3mks)

    a)  User manual

     b) Reference guide

     c) Quick reference guide

6. State any two features of a user-friendly program.      (2mks)

7 a) Distinguish between labels and formulae with respect to spreadsheets (2mks)

   b) Consider the entries in the cells below.

 

Cell

B2

B3

C10

C11

C13

Entry

200

100

B2

B3

C10

State the value displayed in cell C13                                      (2 mks)

8.List three differences between wide area Networks (WAN) and Local Area Networks (LAN)      (3mks)

9. Study the flowchart segment below and state the last value printed from the flowchart.         (2 mks)

10.  a) What is an expert system                                                        (1mk)

      b)State any two components of an expert system                     (2mks)

11. give two reasons why optical disks are better storage media compared to floppy diskettes  (2mks)

12.What are the Dos commands used for the following?                       (2mks)

            a) Changing directories

            b) Viewing directories

           c)  Renaming directories

            d) Deleting a directory

13. Distinguish between copying and moving text                                  (2mks)

14. a) Name two methods of paper orientation                                (1mk)

     b)Name two keys used to delete text in a document   (1 mk)

15.Name two features a Database package                                             (2mks)

SECTION B (60 MKS)

Answer question and any other three questions from this section

16.       Study the flowchart below and answer the questions that follow.

 a)Write a high-level language program for the above flowchart (7mks)

 b)List the outputs of the flowchart above                                 (5 mks)

 c) Modify the flowchart so that it adds up all its outputs and displays the sum obtained  (3mks)

17. A computer specification has the following details:

  •  Pentium II
  • 1.44 MB floppy disk drive
  • 20 GB hard disk
  • Full multimedia
  • 17” SVGA monitor
  • Pre-installed operating system
  • Pre-installed office suite

     a)  What is meant by

       i)  1.44 MB floppy disk drive?

       ii)20 GB hard disk?

      iii) 17” SVGA monitor

     b) Which operating system might be pre-installed in this computer and why?         (2mks)

     c) List three multimedia components                                          (3 mks)

      d) i)  what is meant by computer aided manufacture?        (2 mks)

          ii)  Give two examples of computer aided design software.       (2mks)

18. a)Give three examples of network software                                          (3mks)

     b)List any three items that may be referred to as data terminal equipment in a network     (3 mks)

     c)Briefly explain the following terms as used in networking   (4mks)

      i) Remote communication

      ii)Distributed processing

      d) State three advantages and two disadvantages of mesh network topology. (5mks)

19. a)  a company has decided to computerize their operations.  They have decided to purchase package instead of developing their own programs.  Give three advantages and two disadvantages of this approach. 5mks)

      b) i) explain why a value such as 611233444555 may be displayed as ######### When typed in a cell of a spreadsheet (2mks)

       ii)  How can the problem in b (i) above be corrected?      (2mks)

      c) With reasons, briefly describe the most appropriate type of printer output device for the output of:  (6mks)

      i) Customer invoices on multi-part stationery

     ii) Letters to customers

     iii)Detailed engineering designs

20. a)  Distinguish between the following pair of terms                                (6mks)

      i) Data verification and data validation

      ii)Data encryption and passwords

            

Question Image

State three functions of  a network  operating system

  • Allows creation and management of user accounts
  • Helps in troubleshooting of the network
  • controls access to network resources
  • Provides communication services
  • configures network resources
  •  

 

Question Image