Explore a wide range of computer studies questions and answers for KCSE exams, along with valuable resources and study materials

In a computer based information system, state the purpose of the following files and give one example where such a file may re required in a school

28/12/2020

(a) In a computer based information system, state the purpose of the following files and give one example where such a file may re required in a school (8mks)

(i) Report life

A summary file from the main file

(ii) Backup file

Backup also called a security file – are copies of files kept in case the original master file is damaged or lost and cannot be used.

(iii) Reference file

This is a file with a reasonable amount of permanency. Examples of data used for reference purposes are price list, tables of rate of pay, names and addresses.

(iv) Sort file

This is a temporary file that holds records organized in a particular order

0 Comments

State three ways in which computer technology may affect employment patterns in organizations

28/12/2020

0 Comments

(a) State three ways in which computer technology may affect employment patterns in organizations

Job replacement
Job displacement
Job creation

0 Comments

The diagram below represents the essential features of a computer system. Study the diagram and answer the questions that follow:

28/12/2020

0 Comments

(a) The diagram below represents the essential features of a computer system. Study the diagram and answer the questions that follow:

(i) Name the components: (4mks)

0 Comments

The following car details are to be entered in a database: Make, date of manufacture, colour and cost.

28/12/2020

0 Comments

The following car details are to be entered in a database: Make, date of manufacture, colour and cost.

(a) Prepare a suitable database structure showing field names and their field types (5mks)

0 Comments

What is meant by each of the following terms: Pseudocode and Flowchart

28/12/2020

0 Comments

(a) What is meant by each of the following terms:

(i) Pseudo code (1½Marks)

Pseudo code (or structured English) describes module design in words using syntax like programming language. It aims at proving programmers with clear and unambiguous process specification.
(ii) Flowchart

A flowchart is a diagrammatic or pictorial representation that illustrates the sequence of operations to be performed to get the solution of a problem.

(b) A program is required to list the first 1000 numbers in the series 2, 4, 6, 8, 10 ……. Draw a flowchart and write a program that can be carry out this task (12mks)

0 Comments

Define the term structured programming

28/12/2020

0 Comments

Define the term structured programming (2mks)

A program is broken down into smaller sections called modules. The modules are linked together.

Diagram that demo structured programming

0 Comments

Explain how a paragraph can be removed form one place to another in word- processing

28/12/2020

0 Comments

Explain how a paragraph can be removed form one place to another in word- processing (2mks)

1. Highlight/ select the paragraph

Highlight/ select the paragraph

0 Comments

Give one difference between internal and external commands in Disk Operating System

28/12/2020

0 Comments

(a) Give one difference between internal and external commands in Disk Operating System (2mks)

Internal DOS commands are part of a file called command that stays resident in memory (RAM)
External DOS commands are stored on secondary storage and are only loaded onto RAM when required

(b) Name two DOS commands that may be used for checking disk errors (1mk)

CHKDSK,
SCANDISK

0 Comments

State two differences between Disk Operating System (DOS) and WINDOWS operating system.

28/12/2020

0 Comments

(a) State two differences between Disk Operating System (DOS) and WINDOWS operating system.

DOS is command driven while Windows is GUI driven
DOS is difficult to learn and use while Windows is easier to learn and use.

MS DOS operation window

(b)
(i) Define the term application Software

Software with a specific function, such as word processor or game. It is meant to benefit the end user.

(ii) Give one example of application software (1 mk)

Word processor e.g. Ms Word
Spreadsheet e.g. Ms Excel

0 Comments

Describe the functions of the following computer hardware components: Mouse and Scanner

27/12/2020

0 Comments

Describe the functions of the following computer hardware components:

computer mouse

Mouse

This is an input device that works in conjunction with a pointer on the screen. It is used for selecting and other input functions.

flatbed scanner

Scanner

This is an input device that captures text and images directly into the computer by the use of light, magnetism or electrical signals.

0 Comments

List any four tasks that an electronic spreadsheet should be able to perform other than calculations

27/12/2020

0 Comments

(a) List any four tasks that an electronic spreadsheet should be able to perform other than calculations.

Production of graphs
Automatic recalculation
Projection of growth curves through what-if analysis
Have editing and formatting features that can be used to change appearance of data and make necessary changes.
Have features of a database therefore they can be used to filter, sort, validate data and remove duplicates.
They can import and export data from other programs and platforms.

(b) Explain what is meant by automatic recalculation as used in a spreadsheet.

Feature of electronic spreadsheet system which runs anytime a cell is updated, causing all formulas, functions and macros which depend on that cell to automatically update their computations

0 Comments

Explain the impact of information on organizations in each of the following areas: Competition, Pace of growth

27/12/2020

0 Comments

Explain the impact of information on organizations in each of the following areas:

(a) Competition

An organization that has access to quick and relevant information will obviously be ahead of its competitors and can therefore strategize itself accordingly. Information is a powerful tool in a competitive environment

(b) Pace of growth

Organizations need to advertise themselves therefore information is a very important ingredient to their pace of growth. An organization that advertises itself accordingly will be known and will therefore be ahead of its competitors.

zoo bus

0 Comments

Give three advantages of separating data from the application that use the data in database design.

27/12/2020

0 Comments

Give three advantages of separating data from the application that use the data in database design.

There is data independence i.e. one can make changes to the underlying table structures without changing the end- user’s views
There is improving security and privacy. The end user only sees what is relevant
There is improved productivity in from data independence

0 Comments

The first column in the table below contains the formulae as stored into the cell F10 of a spreadsheet.

27/12/2020

0 Comments

The first column in the table below contains the formulae as stored into the cell F10 of a spreadsheet. Enter the formulae, as they would appear when copied to the cell M20 of the same spreadsheet.

The first column in the table below contains the formulae as stored into the cell F10 of a spreadsheet

Expected Response

0 Comments

A 3 by 4 matrix M is to be added to another 3 by 4 matrix array N so as to give a third 3 by 4 matrix array P.

27/12/2020

0 Comments

A 3 by 4 matrix M is to be added to another 3 by 4 matrix array N so as to give a third 3 by 4 matrix array P. Using a high level programming language, write a program segment that assigns the sum of M and N to P.

Program add matrix (input, Output);
Type
Matrix = Array (14, 13) of integer;
Var
A, B, C: Matrix;
I, J: Integer;
Producer add (Var X, Y, Z: Matrix);
Begin (add)
For I: to 3 do
Begin
For J: 1 to 4 do
Z [l,J]: X [l, J] + Y[l,J];
End
End; {add}

0 Comments

List any four high level programming languages

27/12/2020

0 Comments

High level programming languages

Visual basic
Basic
Pascal
Java
C
C++
Python
Ruby
C#
Objective C
Delphi Pascal
Scala
VB.NET
ASP.NET
Perl
VBA
Prolog

C# sample program

0 Comments

Explain what is meant by batch processing

27/12/2020

0 Comments

What is batch processing?

Transaction are accumulated over a period of time and then processed at a pre-specified time to produce a batch of output

In batch processing, data is accumulated as a group (batch) over a specified period of time e.g. daily, weekly or monthly.
The batch is processed at once. E.g. in a payroll processing system, employees details concerning number of hours worked, rate of pay, and other details are collected for a period of time, say one month. These details are then used to process the payment for the duration worked.

other areas where batch processing can be applied include:

Processing bank cheques
Printing of bank statements
Updating of a stock database

Explain what is meant by batch processing

Give one advantage and one disadvantage of batch processing

Advantages

Simple to develop
Timing of the reports is not necessary

Disadvantages

Time lag between origination of the transactions and the information availability
Late information is not suitable for situations where instant decisions are required

Why is it necessary to have a UPS in a computer laboratory?

27/12/2020

0 Comments

Functions of the UPS

Uninterruptible Power Supply

To regulate/limits amount a voltage entering computer equipment.
To supply equipment with power temporarily while normal power is not available.
Alerts the user when main power is switched off.

0 Comments

Compare the two types of diskettes used in microcomputers in terms of physical size and densities.

27/12/2020

0 Comments

Compare the two types of diskettes used in microcomputers in terms of physical size and densities.

3 ½ Floppy diskette

Small in size
Bigger in capacity 1.44 MB

5 ¼ floppy diskette

Bigger in size
Smaller in capacity 1.2 MB

0 Comments

COMPUTER STUDIES QUESTIONS WITH ANSWERS

​(a) In a computer based information system, state the purpose of the following files and give one example where such a file may re required in a school (8mks)

(i) Report life

(ii) Backup file

(iii) Reference file

(iv) Sort file

​(a) State three ways in which computer technology may affect employment patterns in organizations

​​(i) Name the components: (4mks)

​(a) Prepare a suitable database structure showing field names and their field types (5mks)

​(a) What is meant by each of the following terms:

(i) Pseudo code (1½Marks)

(ii) Flowchart

(b) A program is required to list the first 1000 numbers in the series 2, 4, 6, 8, 10 ……. Draw a flowchart and write a program that can be carry out this task (12mks)

​Define the term structured programming (2mks)

Explain how a paragraph can be removed form one place to another in word- processing (2mks)

1. ​Highlight/ select the paragraph

(a) Give one difference between internal and external commands in Disk Operating System (2mks)

​(b) Name two DOS commands that may be used for checking disk errors (1mk)

​(a) State two differences between Disk Operating System (DOS) and WINDOWS operating system.

(b) ​(i) Define the term application Software

​(ii) Give one example of application software (1 mk)

Describe the functions of the following computer hardware components:

Mouse

Scanner

​(a) List any four tasks that an electronic spreadsheet should be able to perform other than calculations.

​(b) Explain what is meant by automatic recalculation as used in a spreadsheet.

​Explain the impact of information on organizations in each of the following areas:

​(a) Competition

(b) Pace of growth

​Give three advantages of separating data from the application that use the data in database design.

Expected Response

A 3 by 4 matrix M is to be added to another 3 by 4 matrix array N so as to give a third 3 by 4 matrix array P. Using a high level programming language, write a program segment that assigns the sum of M and N to P.

High level programming languages

What is batch processing?

Give one advantage and one disadvantage of batch processing

Advantages

Disadvantages

Related Searches

Functions of the UPS

3 ½ Floppy diskette

​5 ¼ floppy diskette

Categories

Archives

(a) In a computer based information system, state the purpose of the following files and give one example where such a file may re required in a school (8mks)

(a) State three ways in which computer technology may affect employment patterns in organizations

(i) Name the components: (4mks)

(a) Prepare a suitable database structure showing field names and their field types (5mks)

(a) What is meant by each of the following terms:

Define the term structured programming (2mks)

1. Highlight/ select the paragraph

(b) Name two DOS commands that may be used for checking disk errors (1mk)

(a) State two differences between Disk Operating System (DOS) and WINDOWS operating system.

(b)
(i) Define the term application Software

(ii) Give one example of application software (1 mk)

(a) List any four tasks that an electronic spreadsheet should be able to perform other than calculations.

(b) Explain what is meant by automatic recalculation as used in a spreadsheet.

Explain the impact of information on organizations in each of the following areas:

(a) Competition

Give three advantages of separating data from the application that use the data in database design.

5 ¼ floppy diskette