Computer studies analysis of questions and answers

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

<<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)

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)