Computer studies analysis of questions and answers

COMPUTER STUDIES REVISION KITS FORM 1 2022 TERM 2 PAPER 1 MODEL17092022008

17/9/2022

computer_studies_revision_kits_form_1_2022_term_2_paper_1_model17092022008.pdf
File Size:	108 kb
File Type:	pdf

Download File

0 Comments

COMPUTER STUDIES REVISION KITS 2022 TERM 2 PAPER 1 MODEL17092022005

17/9/2022

0 Comments

computer_studies_revision_kits_2022_term_2_paper_1_model17092022005.pdf
File Size:	2108 kb
File Type:	pdf

Download File

0 Comments

COMPUTER STUDIES REVISION KITS FORM 3 2022 TERM 2 PAPER 1 MODEL17092022007-2

17/9/2022

0 Comments

computer_studies_revision_kits_form_3_2022_term_2_paper_1_model17092022007-2.pdf
File Size:	281 kb
File Type:	pdf

Download File

0 Comments

List four areas that would be considered in the requirement specification.

18/11/2021

0 Comments

(a) List and describe four strategies for converting from an old system to a new system. (4mks)

Direct approach
user simply stops using old system and starts using the new one
Parallel approach
old and new system are operated side by side until the new system has shown it is reliable
Phased approach
parts of a new system are phased in separately either at different times or all at one in groups
Pilot approach
entire system is tried out but only by some users

(b) (i) Distinguish between private data and confidential data (2mks)

Private data
belongs to an individual and must be accessed through direct permission from the owner
Confidential data
held by government or organization about people but can be seen by authorized people only.

(ii) What can be done to stop illegal access to a computer laboratory by unauthorized people (3mks)

fit strong metallic grills and locks to doors
don’t welcome strangers into the lab
install alarms
employ guards
burglar proof

(c) (i) List four areas that would be considered in the requirement specification. (4mks)

output specification
in put specification
file /data/tables
hard ware/soft ware

(ii) Name any two areas covered in feasibility report during system analysis and design. (2mks)

Lost benefit analyst
Schedule
Users
Environment
Technology

0 Comments

A computer diskette in drive A has folders for MEMOS for an administrator. Each of these folders is labelled according to the relevant months.

17/11/2021

0 Comments

A computer diskette in drive A has folders for MEMOS for an administrator. Each of these folders is labelled according to the relevant months. The secretary created the folders for each month’s memo for each of access. Study the table below

A computer diskette in drive A has folders for MEMOS for an administrator. Each of these folders is labelled according to the relevant months. The secretary created the folders for each month’s memo for each of access. Study the table below

(a) Assuming that the secondary was working from the diskette, draw the corresponding tree structure (6mks)

(b) (i) The secretary wanted to create a folder to store a memo in Fraud folder. State the path for that folder. (2mks)

A:/MEMO2/Fraud

(ii) Suggest how the secretary can ensure that the work in that diskette is not spoilt. (1mk)

do not drop the diskette down
don’t put heavy objects on top
don’t put near magnets
don’t remove from drive when still being read / written

(iii) The content of the file is not viewed by any other person apart from her. (1mk)

use of password

(c) (i) List any two devices under the control of the operating system. (2mks)

I/O
CPU
memory
secondary storage
communication & ports

(ii) Explain how each one of these devices are controlled by the OS - Operating System

Input/output devices and ports
In most cases, the operating system controls all data input and information output tasks. Because most input/output devices are slower than the processor, the operating system has to control the flow of data from the time of input to the time the user receives it as information. It ensures that the right data reaches the processor at the right time. The operating system also defines the various input/output ports found on the computer e.g. printer port.

The processor
The processor is a scarce resource. It executes tasks called processes. At any one time several tasks may require processing hence creating competition. The operating system arranges the tasks according to priority and has the ability to stop a particular task to allow the processor to service another one.

Main memory(RAM)
At any one given time so many tasks may require the memory so that they can be accessed and processed by the computer.However,because memory is also a scarce resource,the operating system determines which task will remain in memory awaiting for execution and which one will be sent back to secondary storage to wait.

Because the operating system is large and very important, it is usually installed on the hard disk but must be loaded to RAM during the booting process. Not all the operating system can fit in RAM so a small special part that contains the most necessary commands and procedures called the kernel is the one that is loaded.

Secondary storage devices
The operating system manages the storage and retrieval of data on secondary storage devices. It also utilizes the free space on hard disks to enhance the performance of the computer by temporarily holding tasks on it that were in RAM ready for processing but have to wait for sometime.

Communication devices and ports
Communication in this case refers to how the various devices and programs in and out of the computer system send and receive messages from one another and from the processor. The operating system controls the overall communication process between various tasks and computers. External communication can be achieved by connecting an external device to a communication port using a communication medium like cables or even wireless communication.

0 Comments

The information below is maintained by the sales lady at the school canteen. Study it and answer the questions that follow.

17/11/2021

0 Comments

The information below is maintained by the sales lady at the school canteen. Study it and answer the questions that follow.

(a) Describe the basic data types used in this spreadsheet (4mks)

Labels
describing items names
Values
describing units on column B and C

(b) Provide a single formula that would be used to
(i) Count the number of items whose units are equal; to 15 (2mks)

=COUNTIF(B2:B5,15) or =COUNTIF(B2:B5,=15)

(ii) Sum the values of items whole units are equal to 12 (2mks)

=SUMIF(B2:B5,"=12") or =SUMIF(B2:B5,"12")

(c) (i) List and describe four areas of application of spreadsheets (4mks)

Accounting
What IF analysis (forecasting)
Budgeting
Calendars
Expense reports
Forms
Time sheets
Invoices
Purchase Orders
Receipts
Schedules

(ii) Explain data range legend and axis as used in spreadsheet charts (3mks)

Axis

A reference line from \which distances or angles are measured in a coordinate system, such as the X-axis and y-axis in the Cartesian coordinate system

Legend

Brief description accompanying an illustration (chart) also known as a caption

0 Comments

List three advantages and three disadvantages of fibre optic cable and Name two types of coaxial cables

17/11/2021

0 Comments

(a) List three advantages and three disadvantages of fibre optic cable (6mks)
Advantages

immune to electro magnetic interference and ear dropping
fast and supports high band width
large distance can be covered because it has low attenuation
can be used in hazardous environment
smaller and lighter than copper

Disadvantages

connecting devices are expensive
installation is difficult
complex to configure
expensive/ difficult to repair

(b) Describe the following signals and state where each is applied in network communication. (4mks)
Analog

made up of continuous varied wave form.
it is transmitted over telephone line.
a codec converts an analog signal to digital for transmission via a digital medium

Digital

made up of non continuous discrete wave form computers
a modem converts a digital signal to analog for transmission over the analog media

(c) Name two types of coaxial cables (2mks)

thin net
thick net

(d) (i) Distinguish between microwave and satellite transmissions. (2mks)

Microwave transmission consists of point to point transmissions meaning a signal is divided through a focused beam from transmitter to receiver while satellite is usually launched into speck

(ii) Give an example of internet protocol (1mk)

ICPIP [Internet Control Message Protocol]
TCP [Transmission Control Protocol]
IP [Internet Protocol]

0 Comments

Describe three methods you would use in error detection during program testing

16/11/2021

0 Comments

(a)When invoicing customers, the invoice clerk has to work out the discounts allowable on each order. Any order over 20,000/= attracts a “bulk” discount of 7%. A customer within the trade is allowed 10%. There is also a special discount of 2% allowed for any customer who has been ordering regularly for over 2 years. Using a flowchart show clerical procedure for working out discount entitlement.

When invoicing customers, the invoice clerk has to work out the discounts allowable on each order. Any order over 20,000/= attracts a “bulk” discount of 7%. A customer within the trade is allowed 10%. There is also a special discount of 2% allowed for any customer who has been ordering regularly for over 2 years. Using a flowchart show clerical procedure for working out discount entitlement.

(b) Name the control structures you have used in the flow chart (2mks)

selection
sequence

Describe three methods you would use in error detection during program testing

error detection methods

desk checking (dry-run)
going through the program while still on paper
using debugging utilities
enter the program editor where syntax errors are detected during translation
using test date
carries out trial runs
various data variations and extreme including good and bad data are entered to see how the program would handle them

0 Comments

Explain the terms computer fraud and alteration.

16/11/2021

0 Comments

Explain the following terms. (2mks)

(a) Computer fraud

use of computer to conceal information or cheat other people with the intention of gaining money or information

Explain the terms computer fraud and alteration

(b) Alteration

the legal charging of data or information with the intention of misinforming authorized users or gaining

0 Comments

List four stages in data collection. What is meant by reference and report file

16/11/2021

0 Comments

(a) List four stages in data collection. (2mks)

creation
transmission
preparation
media conversion
input validation
sorting

(b) What is meant by the following (2mks)
(i) Reference file

used for reference or lookup purposes that is required during processing

(ii) Report file

used to store permanent records extracted from the master file or generated after processing operation

0 Comments

List four types of publications that can be designed using DTP software.

16/11/2021

0 Comments

List four types of publications that can be designed using DTP software. (2mks)

Cards,
certificate,
newspapers,
magazines,
pamphlets,
newsletters,
books,
calendars,
Adverts,
Banners
Price lists and Hotel Menus

0 Comments

List three ways by which you can provide a common link or relationship between the tables in a database software

15/11/2021

0 Comments

(a) List three ways by which you can provide a common link or relationship between the tables in a database software. (3mks)

one -to -one
one – to – many
many – to – many

(b) What is referential integrity (1mk)

relationship based on primary and foreign keys
a feature that governs the nature of records in a one – to – many relationship between tables in database

0 Comments

Write an algorithm to computer the area of a circle.

15/11/2021

0 Comments

Write an algorithm to computer the area of a circle. (2mks)

Pseudocode

Start
input
pie = 3.14
area = pie*r*r
print area
end

Start
input
area = 3.14 *r*r
print r, area
stop

Flowchart

Write an algorithm to computer the area of a circle.

flowchart

0 Comments

List four factors to be considered when purchasing an operating system

15/11/2021

0 Comments

List four factors to be considered when purchasing an operating system. (2mks)

hardware configuration
basic design of the computer e.g. IBM, APPLE
applications intended for the computer
user friendliness or HCI
End User Licence Agreement (EULA) and other documentations
Initial cost
Maintenance cost
Expandability/upgradeability

0 Comments

How does an operating system manage computer memory?

15/11/2021

0 Comments

How does an operating system manage computer memory (2mks)

organize the main memory into blocks of sizes called partitions
assigns main memory storage partitions to data and instruction
access to data is given using addressing the partition

0 Comments

State the function of each of the following

15/11/2021

0 Comments

State the function of each of the following

(a) Network Interface Card (1mk)

A device that creates a physical link to the computer and the transmission media

(b) Modem (1mk)

modem converts a signal from digital to analog form for the purpose of transmission over the transmission media

(c) Repeaters (1mk)

receives a signal from one section of a network, clean it to remove any distortion, boosts/amplifies it and sends it to another section

Modem

0 Comments

List three uses of DVDs

13/11/2021

0 Comments

List three uses of DVDs. (3mks)

entertainment – e.g. music, movie
distribution of software
archival storage

0 Comments

Perform the following binary addition, subtraction and conversion to octal

13/11/2021

0 Comments

(a) Subtract 110₂ from 11010₂ (1mk)

(b) Find the sum of binary number 101.101₂ and 110.100₂ (1mk)

(c) Convert binary number 11010110.1001₂ into octal number. (1mk)

0 Comments

Define portability as used in software selection

13/11/2021

0 Comments

Define portability as used in software selection. (1mk)

Portability refers to whether a program can be copied or installed in more than one computer

List four ways of acquiring software in an organization. (2mks)

in-house developed programs
venue at the-shelf software purchase through a vendor
open source

0 Comments

List and describe three guidelines that should be followed when conducting an interview during information gathering

12/11/2021

0 Comments

List and describe three guidelines that should be followed when conducting an interview during information gathering (3mks)

be careful about body language, sitting arrangement, closeness etc.
avoid personal biases in your questions and perceptions;
interviewee must be informed in good time and topic communicated earlier.

0 Comments

Name three responsibilities that are carried out by a network administrator

12/11/2021

0 Comments

Name three responsibilities that are carried out by a network administrator. (3mks)

maintain and enforce security measures on the network
monitor the use of network resources
maintain and troubleshoot network related problems
setup a computer network

0 Comments

State the function of the following keys on the computer keyboard

12/11/2021

0 Comments

State the function of the following keys on the computer key board (2mks)

(a) Insert

Used to switch between the two typeover modes i.e.

insert mode and;
typeover mode

(b) Delete

Delete characters from the cursor position from left to right

State the function of the following keys on the computer keyboard

0 Comments

State two practices to be observed in order to ensure the safety of the computer user

12/11/2021

0 Comments

State two practices to be observed in order to ensure the safety of the computer user. (2mks)

Computer room should be well lit to avoid eye strain
Avoid over bright wall paints that reflect too mush light causing eye strain
Adjust brightness of the computer monitor until the eyes feel comfortable before using the computer
Use/fit the monitor with radiation filter screens
Avoid using flickering monitor
Seat for the user must be comfortable and have a straight backrest that allows someone to sit upright
Take frequent breaks while working with a computer

0 Comments

Complete paper 1 computer studies Form 3 term 2 Jan.2021 with marking scheme UI-26202101.

6/2/2021

0 Comments

Read/Download Question Paper

complete_paper_1_computer_studies_form_3_term_2_jan.2021_with_marking_scheme..pdf
File Size:	323 kb
File Type:	pdf

Download File

Marking Scheme

0 Comments

A school has been advised to employ a database administrator. State three responsibilities of this personnel in the school.

15/1/2021

0 Comments

A school has been advised to employ a database administrator. State three responsibilities of this personnel in the school.

(b) Explain two ways in which computers can be used in the transport industry.
(c) Mary was advised to partition a hard disk for her computer. Explain two reasons that may have necessitated this.
(d) Explain a reason for conducting each of the following studies in systems development:
(i) Schedule feasibility;
(ii) Technical feasibility.

RESPONSES

a) Possible responsibilities of a database admin in a school

Carrying out school database backups.
Recovering of lost school data incase of system failure.
Ensuring the security and integrity of the school system.
Adding new users to the school system and managing the user’s accounts.
Designing and developing database application for the school.
Updating or maintaining database for the school.

b) Ways in which computers can be used in a transport industry.

Use of GPS to track vehicles, flights etc.
Bookings to different destinations can be done through the use of computers ( online booking).
The computers can also be used to reduce the speed of vehicles and bring sanity in the industry.
Managing human resource involved in the industry.

c) Reasons for partitioning hard disk

For security purposes, incase one partition fails the second partition remains functional.
If she requires backup copies to be stored in the same hard disk.
If she intends to install more than one operating system.

d) (I Schedule feasibility

To determine if the proposed solution can be developed within the required time.

(ii) Technical feasibility

To determine if the system can be supported by the available technology.

(b) Explain two ways in which computers can be used in the transport industry. (c) Mary was advised to partition a hard disk for her computer. Explain two reasons that may have necessitated this. (d) Explain a reason for conducting each of the following studies in systems development: (i) Schedule feasibility; (ii) Technical feasibility.

0 Comments

<<Previous

​(a) List and describe four strategies for converting from an old system to a new system. (4mks)

(b) (i) Distinguish between private data and confidential data (2mks)

(ii) What can be done to stop illegal access to a computer laboratory by unauthorized people (3mks)

​(c) (i) List four areas that would be considered in the requirement specification. (4mks)

​(ii) Name any two areas covered in feasibility report during system analysis and design. (2mks)

​A computer diskette in drive A has folders for MEMOS for an administrator. Each of these folders is labelled according to the relevant months. The secretary created the folders for each month’s memo for each of access. Study the table below

(a) Assuming that the secondary was working from the diskette, draw the corresponding tree structure (6mks)

(b) (i) The secretary wanted to create a folder to store a memo in Fraud folder. State the path for that folder. (2mks)

(ii) Suggest how the secretary can ensure that the work in that diskette is not spoilt. (1mk)

​(iii) The content of the file is not viewed by any other person apart from her. (1mk)

(c) (i) List any two devices under the control of the operating system. (2mks)

​(ii) Explain how each one of these devices are controlled by the OS - Operating System

​The information below is maintained by the sales lady at the school canteen. Study it and answer the questions that follow.

​(a) Describe the basic data types used in this spreadsheet (4mks)

​(b) Provide a single formula that would be used to (i) Count the number of items whose units are equal; to 15 (2mks)

​(ii) Sum the values of items whole units are equal to 12 (2mks)

(c) (i) List and describe four areas of application of spreadsheets (4mks)

(ii) Explain data range legend and axis as used in spreadsheet charts (3mks)

(a) List three advantages and three disadvantages of fibre optic cable (6mks) Advantages

​Disadvantages

​(b) Describe the following signals and state where each is applied in network communication. (4mks) Analog

​Digital

​(c) Name two types of coaxial cables (2mks)

(d) (i) Distinguish between microwave and satellite transmissions. (2mks)

​(ii) Give an example of internet protocol (1mk)

(b) Name the control structures you have used in the flow chart (2mks)

Describe three methods you would use in error detection during program testing

​Explain the following terms. (2mks)

​(a) Computer fraud

​(b) Alteration

​(a) List four stages in data collection. (2mks)

​(b) What is meant by the following (2mks) (i) Reference file

​(ii) Report file

List four types of publications that can be designed using DTP software. (2mks)

(a) List three ways by which you can provide a common link or relationship between the tables in a database software. (3mks)

(b) What is referential integrity (1mk)

Write an algorithm to computer the area of a circle. (2mks)

Pseudocode

Flowchart

​List four factors to be considered when purchasing an operating system. (2mks)

How does an operating system manage computer memory (2mks)

​State the function of each of the following

(a) Network Interface Card (1mk)

(b) Modem (1mk)

(c) Repeaters (1mk)

List three uses of DVDs. (3mks)

​(a) Subtract 1102 from 110102 (1mk)

(b) Find the sum of binary number 101.1012 and 110.1002 (1mk)

(c) Convert binary number 11010110.10012 into octal number. (1mk)

Define portability as used in software selection. (1mk)

​List four ways of acquiring software in an organization. (2mks)

​List and describe three guidelines that should be followed when conducting an interview during information gathering (3mks)

​Name three responsibilities that are carried out by a network administrator. (3mks)

​State the function of the following keys on the computer key board (2mks)

​(a) Insert

​(b) Delete

​State two practices to be observed in order to ensure the safety of the computer user. (2mks)

Read/Download Question Paper

Marking Scheme

A school has been advised to employ a database administrator. State three responsibilities of this personnel in the school.

Categories

Archives

(a) List and describe four strategies for converting from an old system to a new system. (4mks)

(c) (i) List four areas that would be considered in the requirement specification. (4mks)

(ii) Name any two areas covered in feasibility report during system analysis and design. (2mks)

A computer diskette in drive A has folders for MEMOS for an administrator. Each of these folders is labelled according to the relevant months. The secretary created the folders for each month’s memo for each of access. Study the table below

(iii) The content of the file is not viewed by any other person apart from her. (1mk)

(ii) Explain how each one of these devices are controlled by the OS - Operating System

The information below is maintained by the sales lady at the school canteen. Study it and answer the questions that follow.

(a) Describe the basic data types used in this spreadsheet (4mks)

(b) Provide a single formula that would be used to
(i) Count the number of items whose units are equal; to 15 (2mks)

(ii) Sum the values of items whole units are equal to 12 (2mks)

(a) List three advantages and three disadvantages of fibre optic cable (6mks)
Advantages

Disadvantages

(b) Describe the following signals and state where each is applied in network communication. (4mks)
Analog

Digital

(c) Name two types of coaxial cables (2mks)

(ii) Give an example of internet protocol (1mk)

Explain the following terms. (2mks)

(a) Computer fraud

(b) Alteration

(a) List four stages in data collection. (2mks)

(b) What is meant by the following (2mks)
(i) Reference file

(ii) Report file

List four factors to be considered when purchasing an operating system. (2mks)

State the function of each of the following

(a) Subtract 110₂ from 11010₂ (1mk)

(b) Find the sum of binary number 101.101₂ and 110.100₂ (1mk)

(c) Convert binary number 11010110.1001₂ into octal number. (1mk)

List four ways of acquiring software in an organization. (2mks)

List and describe three guidelines that should be followed when conducting an interview during information gathering (3mks)

Name three responsibilities that are carried out by a network administrator. (3mks)

State the function of the following keys on the computer key board (2mks)

(a) Insert

(b) Delete

State two practices to be observed in order to ensure the safety of the computer user. (2mks)