Computer studies analysis of questions and answers

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

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

MENTION TWO SYMPTOMS OF A COMPUTER INFECTED WITH A VIRUS.

20/7/2021

0 Comments

CHARACTERISTICS OF A COMPUTER INFECTED WITH A VIRUS

slows in processing
programs start to behave abnormally
corrupts files and folders
pop up windows begin to show up
changes default program setup in your computer for most programs
computer crashes
unknown program begin to show up in your computer
passwords change
send or receive mass emails to your account
unknown programs attache themselves to the secondary and primary storage media jamming the RAM
reject any other software installed in the computer especially anti-malware
changes existing files type and properties

MENTION TWO SYMPTOMS OF A COMPUTER INFECTED WITH A VIRUS.

LEVEL: FORM 2
TOPIC: DATA SECURITY AND CONTROLS
SUB-TOPIC: Security threats and control measures

0 Comments

State three ways of transforming a picture embedded in a Desktop Publishing programme in order to fit in a designated space on a document. (3 marks)

3/3/2021

0 Comments

State three ways of transforming a picture embedded in a Desktop Publishing programme in order to fit in a designated space on a document. (3 marks)

Ways of transforming a picture in a DTP

Rotation
Flipping
Cropping
Stretching

0 Comments

Identify four tasks that can be achieved using a Desktop Publishing programme from the following list of tasks.

15/1/2021

0 Comments

Identify four tasks that can be achieved using a Desktop Publishing programme from the following list of tasks.

I. Managing students records in a school
II. Creating a calendar
III. Designing a building structure
IV. Creating a banner
V. Creating a book cover
VI. Processing of examination results
VII. Creating business cards

Creating a calendar.
Creating a banner.
Creating a book cover.
Creating business cards

Identify four tasks that can be achieved using a Desktop Publishing programme from the following list of tasks.

0 Comments

State two ways in which one can create a password which cannot be easily accessed by hackers.

15/1/2021

0 Comments

State two ways in which one can create a password which cannot be easily accessed by hackers.

Password which cannot be hacked.

By including many characters in a password
By combining different characters in a password
Use password generator manager.

State two ways in which one can create a password which cannot be easily accessed by hackers.

0 Comments

State the spreadsheet function that can be used to obtain each of the following values in a worksheet:

15/1/2021

0 Comments

State the spreadsheet function that can be used to obtain each of the following values in a worksheet:

(a) Number of cells with values in a column.
(b) Mean of values in a range of cells.

a) =Count ()
b) =Average ()

State the spreadsheet function that can be used to obtain each of the following values in a worksheet:

0 Comments

State the function of each of the following computer keyboard keys when using a word processor:

15/1/2021

0 Comments

State the function of each of the following computer keyboard keys when using a word processor:

(a) End
(b) Insert
(c) Backspace.

a) End

Used for moving the cursor to the end of the line been typed or already typed.

b) Insert key

Used for changing typing mode from insert mode to type over and vice versa (Accept the description of type over and insertion)

c) Backspace

Used to delete a character to left of the cursor position.

State the function of each of the following computer keyboard keys when using a word processor:

0 Comments

Explain the term proofreading as used in word processing.

15/1/2021

0 Comments

Explain the term proofreading as used in word processing.

Meaning of proofreading

It is the process of using appropriate proofing reading like spelling and grammar checkers and autocorrect features to check whether the document has typographical or grammatical errors.

Explain the term proofreading as used in word processing.

0 Comments

Differentiate between home page and web page as used in the Internet.

14/1/2021

0 Comments

Differentiate between home page and web page as used in the Internet.

Difference between Home page and web page

Home Page
Web Page
It’s the first page that opens when a site is opened using the when the domain name.
It is web document in a website/ Any page on a web.

Differentiate between home page and web page as used in the Internet.

0 Comments

Explain three ways in which an operating system provides data security in a computer system

14/1/2021

0 Comments

Explain three ways in which an operating system provides data security in a computer system

Access control:

Deals with the problem of verifying /authenticating the identity of a user before permitting access to the request resource (e.g. use of passwords, user account);

Encryption

Transforming data into an unreadable format so that they are safely transmitted;

Firewalls

Filters out unwanted data and programs/criminals/hackers/malicoius persons;

Log files

A means by which transactions in a computer system can be recorded thereby detering potential infiltrators;
Alerts
Alerting a user when he/she is about to delete a file/folder.

(b)State two instances where observation is not a viable method of gathering data during system analysis stage.

When the analyst wants to collect confidential information,
When there is a large group of people involved in the system,
Where the people you want to gather information from are vastly dispersed

A device used to re-construct data signal during data transmission to its original strength/amplify/boost/regenerate.

II. router.

It is a device used to facilitate movement of data or packets between two or more LANS of different configuration (expansion of networks).
Delivers a packet/data directly to destination computers.
Interconnects different networks/provides network services.

(ii) The figure below shows a network based on the bus topology.

(b)State two instances where observation is not a viable method of gathering data during system analysis stage. When the analyst wants to collect confidential information, When there is a large group of people involved in the system, Where the people you want to gather information from are vastly dispersed (c) (i) State the role of each of the following data communication devices: I. repeater A device used to re-construct data signal during data transmission to its original strength/amplify/boost/regenerate. II. router. It is a device used to facilitate movement of data or packets between two or more LANS of different configuration (expansion of networks). Delivers a packet/data directly to destination computers. Interconnects different networks/provides network services. (ii) The figure below shows a network based on the bus topology.

I. Identify the component labelled P.

The component P is the terminator.

II. State the function of the component labelled P.

Terminator in a backbone is used to prevent data signal from bouncing back/absorb signals.

0 Comments

With the aid of a diagram, describe the Hierarchical Database Model.

13/1/2021

0 Comments

With the aid of a diagram, describe the Hierarchical Database Model.

Data items are arranged in a tree like format.

Access is through a single path and all from one single item called the root component

(b) List three factors that should be considered when developing a database application and give reasons why each should be considered.
Factors

Complexity of data/user needs/user friendliness
Security and integrity
Complexity of DBMS
Volume of data/size
Software compatibility with existing DBMS
Cost of the data base

Reasons

Complexity of data - Complex data requires complex DBMS.
Security and integrity - Data which is intended to be secured in terms of access, can be handled by complex DBMS which provides for such requirements.
Complexity of DBMS - Complex DBMS do require complex skills, hence more training. It is therefore costly to run/use such system.
Volume of data - Voluminous data require to be ran on stable application.
They also take up extra computer system resources.
Software compatibility - enables pre-existing databases to be exported to the new one.

(c) (i) Name three types of validation checks during data entry in data processing.

Field type/data type
Field size
Format
Reasonableness
Range constraint
Presence check

(ii) Differentiate between primary key and index key as used in databases.

Any index key is a database feature used to speed up search and sort operations in a table; whereas
A primary key is a field that enforces uniqueness in a table so that one record is not entered twice or a primary key is a field that uniquely identifies each record.

0 Comments

Distinguish between a formula and a function as used in spreadsheets.

12/1/2021

0 Comments

Distinguish between a formula and a function as used in spreadsheets.

A formula is a mathematical expression that creates a relationship between cells to return a new value while a function is an inbuilt predefined formula that the user can quickly use instead of having to create a new one every time they want to do a calculation

0 Comments

Pesa Tele Company has offices in Nairobi and Kampala connected in a network. The management is convinced that someone is illegally gaining access to the data in their computers. State three ways in which the company can overcome this problem.

12/1/2021

0 Comments

Pesa Tele Company has offices in Nairobi and Kampala connected in a network. The management is convinced that someone is illegally gaining access to the data in their computers. State three ways in which the company can overcome this problem.

Encryption.
Firewalls.
User profiles/passwords/user.
Limit the number of log-in attempts.
Audit trail/tracking.
Physical protection of computers.

0 Comments

Explain two ways in which the use of internet could make reporting of corruption easier

10/1/2021

0 Comments

Explain two ways in which the use of internet could make reporting of corruption easier

(b) Explain two circumstances under which the use of wireless communication would be preferred in data communication.
(c) Figure 2 is an extract of a spreadsheet showing what the students had targeted to score and the actual score in a computer remedial class.

A performance factor is obtained by subtracting the target score from the actual score and dividing the difference by the target score.
Write a formula that uses cell references only that would be entered in cell:
(i) D2 to compute the performance factor.
(ii) E2 to display the statement ‘more remedials’ if the performance factor is less than zero, ‘exempted’ if the factor is greater than zero and ‘optional remedials’ if otherwise.
(iii) D8 to display the best performance factor.

RESPONSES

(a) Ways ¡n which internet makes reporting of corruption easier.

Interactiveness: the internet based technology enables real-time dialogue hence instantaneous reporting of cases;
Outreach: the technology allows the coverage of wide areas/can be reported from anywhere;
Social mobilisation: It is easy to use technology to create a network with people or organisations with similar concerns;
Anonymity: With use of the technology, it has become easy to report corruption cases without being known;
Security: The message sent reaches the destination with less risk of being intruded.

(b) Circumstances when wireless is preferred

When the targetted recipients are many and diverse e.g. different platforms, devices, geographical locations.
When the sender or receiver is mobile and it in practical to use wired media.
When there is no space or it is inconvenient to lay cables e.g in a congested town.
When the distance of travel is very big e.g extraterestial communication.

A performance factor is obtained by subtracting the target score from the actual score and dividing the difference by the target score. Write a formula that uses cell references only that would be entered in cell: (i) D2 to compute the performance factor. (ii) E2 to display the statement ‘more remedials’ if the performance factor is less than zero, ‘exempted’ if the factor is greater than zero and ‘optional remedials’ if otherwise. (iii) D8 to display the best performance factor.

Use of the 1F function
First selection & output
Second selection & output
Last selection & output

(iii) = Max (D2:D7)

0 Comments

List two techniques of acquiring electronic images to be used in a desktop publishing program.

10/1/2021

0 Comments

List two techniques of acquiring electronic images to be used in a desktop publishing program.

(ii) Describe two layout guides in a desktop publishing program (DTP) that assist a user to place an object in a preferred position.
(b) Explain three ways of ensuring that data submitted for processing is accurate.
(c)An engineering company requires a computer system to design roads and bridges.
Explain one suitable choice for:
(i) output device;
(ii) software.

RESPONSES

(a) (i) Ways of acquiring images in DTP:

Scanning;
Picture capture via camera;
downloading;
getting from secondary storage.

(ii) Layout guides

Ruler guides: a ruler on the edges of the page that guides a user to position objects and resize them;
Margin guides: used to define page margins so that the user will be prevented from placing objects in non-printable areas of the page;
Column guides: Vertical lines used to divide a page into two or more columns;
Row guides: Lines used to divide a publication page into two or more section to help structure the layout;
Snap points: Positions on the screen where the object is stuck on.

(b) Ways of ensuring accuracy of data during data processing

Data is stored in secondary storage in such a way that access to it is controlled.
Encrypting of data before it is transmitted to minimize chances of it being compromised during transmission.
Use of validation methods to ensure that data is correct at the point of input.
Use of direct data capture methods which eliminates human errors.
Use of verification methods.

(c) (i) Output device: A plotter because it prints large size drawings to high precision.
(ii) A CAD software because it facilitates in the design of engineering drawings.

(ii) Describe two layout guides in a desktop publishing program (DTP) that assist a user to place an object in a preferred position. (b) Explain three ways of ensuring that data submitted for processing is accurate. (c)An engineering company requires a computer system to design roads and bridges. Explain one suitable choice for: (i) output device; (ii) software.

0 Comments

State three reasons why it is important to define datatypes of fields in a database correctly.

8/1/2021

0 Comments

State three reasons why it is important to define datatypes of fields in a database correctly.

Reasons for defining datatypes in databases

Memory use optimisation when the program is loaded;
Assist in trapping errors during data input;
So that appropriate computation can be performed;
Increase speed of processing.

State three reasons why it is important to define datatypes of fields in a database correctly.

0 Comments

A computer technician found it necessary to disable a firewall when working on a computer system. State two reasons that may have necessitated disabling of the firewall.

8/1/2021

0 Comments

A computer technician found it necessary to disable a firewall when working on a computer system. State two reasons that may have necessitated disabling of the firewall.

When firewall is disabled

Testing the communication link;
When upgrading the firewall;
When there is a need to install an application and the firewall is preventing the operation;
When the firewall prevents legitimate communication.

A computer technician found it necessary to disable a firewall when working on a computer system. State two reasons that may have necessitated disabling of the firewall.

0 Comments

Write the acronym MODEM in full.

8/1/2021

0 Comments

Write the acronym MODEM in full.

Modulator Demodulator/modulation demodulation

Explain the purpose of a modem when connecting to the internet.

Convert digital signals to analog format before transmission; and incoming signals from analog to digital before processing.

0 Comments

Figure 1 shows relationships between tables in a database.

7/1/2021

0 Comments

Figure 1 shows relationships between tables in a database.

Identify two primary and two foreign keys used in the relationship.

Primary keys

TermiD
StudentiD

Foreign keys

TermCode
StudID

0 Comments

The following is an extract from a document created using a wordprocessor.

7/1/2021

0 Comments

The following is an extract from a document created using a wordprocessor.

Identify six formats that have been applied on the extract.
(b) State three tools in a wordprocessor that would help a user to minimize spelling mistakes when creating a document.
(c) The following is an extract of a spreadsheet created to manage sales. Use it to answer the questions that follow.

(i)Write a formula that will compute the number of items whose unit price is more than 10,000.
(ii) If the formula = $R2 * C$2 was placed in cell D2, state the output if it was copied to D3.
(d) A school administers examinations to all students in sciences, humanities and languages. Use the entities; EXAMINATIONS, STUDENTS, SCIENCES,HUMANITIES and LANGUAGES to illustrate a network database model.

RESPONSES

(a) Formats applied

Bold. strikethrough, underline, italics, centre alignment, dropcap, bulleted list, line height / spacing, 2 column paragraph. column break, casing, font type, left alignment, column separator.

(b) Tools for proofreading

Spell checker and grammar/ dictionary;
Autocomplete;
Autocorrect;
Thesaurus.

0 Comments

State two ways in which hardware failure is a threat to data security.

7/1/2021

0 Comments

State two ways in which hardware failure is a threat to data security.

Insecurity arising from hardware failure
Data loss due to total system failure e.g. HD crash;
The experts called upon to repair can access critical/valuable information;
Data recovery software may be used to make unauthorised backups.

0 Comments

State two items that an electronic mail should have for it to be sent.

7/1/2021

0 Comments

State two items that an electronic mail should have for it to be sent.

Items that an email must have:

the email address of the recipient;
the content or message being communicated.

State two items that an electronic mail should have for it to be sent.

0 Comments

<<Previous

Atika School Provides Computer studies questions and answers for KCSE preparations and Computer Science for CBC.

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

​Explain the following terms. (2mks)

​(a) Computer fraud

​(b) Alteration

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)

CHARACTERISTICS OF A COMPUTER INFECTED WITH A VIRUS

​State three ways of transforming a picture embedded in a Desktop Publishing programme in order to fit in a designated space on a document. (3 marks)

Identify four tasks that can be achieved using a Desktop Publishing programme from the following list of tasks.

​I. Managing students records in a school II. Creating a calendar III. Designing a building structure IV. Creating a banner V. Creating a book cover VI. Processing of examination results VII. Creating business cards

State two ways in which one can create a password which cannot be easily accessed by hackers.

State the spreadsheet function that can be used to obtain each of the following values in a worksheet:

(a) Number of cells with values in a column. (b) Mean of values in a range of cells.

State the function of each of the following computer keyboard keys when using a word processor:

(a) End (b) Insert (c) Backspace.

Explain the term proofreading as used in word processing.

Differentiate between home page and web page as used in the Internet.

Explain three ways in which an operating system provides data security in a computer system

With the aid of a diagram, describe the Hierarchical Database Model.

Distinguish between a formula and a function as used in spreadsheets.

Pesa Tele Company has offices in Nairobi and Kampala connected in a network. The management is convinced that someone is illegally gaining access to the data in their computers. State three ways in which the company can overcome this problem.

Explain two ways in which the use of internet could make reporting of corruption easier

List two techniques of acquiring electronic images to be used in a desktop publishing program.

State three reasons why it is important to define datatypes of fields in a database correctly.

A computer technician found it necessary to disable a firewall when working on a computer system. State two reasons that may have necessitated disabling of the firewall.

Write the acronym MODEM in full.

Explain the purpose of a modem when connecting to the internet.

Figure 1 shows relationships between tables in a database.

The following is an extract from a document created using a wordprocessor.

State two ways in which hardware failure is a threat to data security.

State two items that an electronic mail should have for it to be sent.

Categories

Archives

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)

Explain the following terms. (2mks)

(a) Computer fraud

(b) Alteration

State three ways of transforming a picture embedded in a Desktop Publishing programme in order to fit in a designated space on a document. (3 marks)

I. Managing students records in a school
II. Creating a calendar
III. Designing a building structure
IV. Creating a banner
V. Creating a book cover
VI. Processing of examination results
VII. Creating business cards

(a) Number of cells with values in a column.
(b) Mean of values in a range of cells.

(a) End
(b) Insert
(c) Backspace.