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

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

<<Previous

COMPUTER STUDIES TOPICAL QUESTIONS AND ANSWERS FOR REVISION

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

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

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.