Computer studies analysis of questions and answers

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

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

Figure 1 and figure 2 show icons representing commands used to manipulate graphics in a desktop publishing package.

6/1/2021

0 Comments

Figure 1 and figure 2 show icons representing commands used to manipulate graphics in a desktop publishing package.

Explain the use of each of the icons labelled figure 1 and figure 2.

Figure 1: Bring to front or bring to back

Used when the target graphic is hidden by other objects. When clicked, the target graphic is brought to the front.

Figure 2: Text wrap

It is used when a graphic is placed within the text area and the user needs to
define how the text flows around the graphic.

0 Comments

Explain why a DTP application would be preferred to a word processing application when designing a publication.

6/1/2021

0 Comments

Explain why a DTP application would be preferred to a word processing application when designing a publication.

Explanation of DTP preference over word processor in designing a publication.
DTP is designed with facilities to support and manipulate graphics that are not found in
traditional wordprocessors. e.g. the facilities are such as page layout, colour libraries and object layering.

0 Comments

Write each of the following acronyms in full as used in computing.

6/1/2021

0 Comments

Write each of the following acronyms in full as used in computing.

(a) CAD - Computer aided design.
(b) DVD - Digital video disk/ digital versatile disk.
(c) WORM - Write once read many.
(d) POS - Point of sale/point of sale terminal.

0 Comments

The figure below is a toolbar for a DTP package.

5/1/2021

0 Comments

The figure below is a toolbar for a DTP package.

State the functions of the tools labelled A, B and C.

A: Selection tool - used for selecting/choosing/highlighting objects on the work area.
B: Text tool - used for enabling typing/editing or insertion of text.
C: Cropping tool - used for trimming graphics.

0 Comments

The word race is appearing several times in a long story document composed using a DTP package. How would this word be safely replaced with the word content?.

3/1/2021

0 Comments

The word race is appearing several times in a long story document composed using a DTP package. How would this word be safely replaced with the word content?.

Invoke the search and replace command button.
Insert appropriate words in the find and replace fields on the dialog box.
Create a space before and after each word in the two fields

0 Comments

In relation to DTP. state the: purpose of frames; and difference between an inside margin and an outside margin.

31/12/2020

0 Comments

In relation to DTP. state the:purpose of frames; and difference between an inside margin and an outside margin.

(a) They are used to help with page layout.
Holding text clearly.
(b) Outside Margin is the white space around the edge of the printing on each page, while Inside
Margin is the left margin and the outside margin is the right margin.

0 Comments

List four types of publications that can be designed by using desktop publishing software.

29/12/2020

0 Comments

List four types of publications that can be designed by using desktop publishing software.

Posters
Banners
Newsletters
Cards
Magazines

0 Comments

Distinguish between the following sets of terms as used in spreadsheets. Worksheet and workbook, Filtering and sorting

29/12/2020

0 Comments

Distinguish between the following sets of terms as used in spreadsheets. Worksheet and workbook, Filtering and sorting

b) State one way in which a user may reverse the last action taken in a spreadsheet package.
c) The following is a sample of a payroll. The worksheet row and column headings are marked 1, 2, 3, . and A, B, C. respectively

Use the following expressions to answer the questions that follow:

Basic pay = hours worked x pay per hour
Allowances are allocated at 10% of basic pay
Gross pay = basic pay + allowances
Tax deductions are calculated at 20% of gross pay
Net pay = Gross pay – tax deductions.

Write formulae using cell references for the following cells;
i) D2
ii) E4
iii) F10
iv) G7
v) H5
d) i) State three ways of moving round the page in a Desktop Publishing window.
ii) State two ways on how information & Communication Technology (ICT) can be used to reduce the spread of HIV/AIDS

EXPECTED RESPONSES

(a) Distinguish between the following sets of terms as used in spreadsheets
(i) Worksheet and workbook

Worksheet – The working area in an electronic spreadsheet on which a
user enters the spreadsheet data.
Workbook – A spreadsheet file. A workbook can obtain several worksheets

(ii) Filtering and sorting

Data filtering is a way of organizing spreadsheet data for ease of analysis. Often spreadsheet filters are used to “hide” rows of data that do not meet certain specified criteria. This allows you to analyze (e.g. count, observe etc) only certain “Filtering” groups of data.
Data sorting: Is a way of arranging record according to one of the fields in either ascending or descending order.

(b) State one way in which a user may reverse the last action taken in a spreadsheet package
Use the undo command (ctrl + z)
(c)The following is a sample of a payroll. The worksheet row and column headings are marked 1, 2, 3, and A, B, C respectively

Use the following expressions to answer the questions that follow

Basic pay- Hours worked x pay per hour
Allowances are allowed at 10% of basic pay
Gross pay- Basic pay + allowances
Tax deductions are calculated at 20% of gross pay
Net pay-= gross pay – tax deductions

Write formulae using cell references for the following cells

(i)D2 = B2 * C2
(ii)E4 = 10% * D4 or 10% * (B4 * C4)
(iii)F10 = D10 + E10
(iv)G7 = 20% * F7
(v)H5 = H5 – G5

(d) (i) State three ways of moving round the page in desktop publishing window

Use cursor keys
use mouse scroller
Use scroll buttons (horizontal and vertical)

(ii)State two ways on how information & communication technology (ICT) can be used to reduce the spread of HIV/ AIDS

Through advertisements on the Internet
Through creation of posters
Through discussion groups on the internet

0 Comments

One of the functions of an operating system is job scheduling. Explain what is mean by job scheduling.

29/12/2020

0 Comments

List two examples of:Third generation languages and Object oriented languages

b) List and explain three types of user interfaces.
c) Describe the following categories of software:
i) Firmware
ii) Proprietary software
d) a new company XYZ intends to go into the business of desktop publishing. Advise the company on three computer hardware system specification features to consider as a measure of enhancing performance.

(a) One of the functions of an operating system is job scheduling.
Explain what is meant by job- scheduling
Running of a particular job/ task under a system of priority, computer resource availability, time allocated to user etc.
(b) List and explain three types of user interfaces

Command driven- Command language dialogues are those in which the user types instructions to the computer in a formally defined language
Menu driven- These allow the user to issue commands by selecting choices from a menu of displayed alternatives
Graphical User interface- These are those in which the user manipulates, though button pushes and movements of pointing devise such as a house, a graphic or iconic representation of the underlying data.

(c) Describe the following categories of software

(i) Firmware
Soft ware that is burnt in computer ROM chips, usually system software
(ii) Proprietary Software
Any software as opposed to freeware, which is available freely

(d) A new company XYZ intends to go into the business of desktop publishing. Advise the company on three computer hardware system specification features to consider as a measure of enhancing performance.

Consider RAM capacity
Consider speed of computer
Consider hard disk capacity

One of the functions of an operating system is job scheduling. Explain what is mean by job scheduling.

0 Comments

Explain the following graphic terms: Rotate and Crop

29/12/2020

0 Comments

Explain the following graphic terms: Rotate and Crop

Rotate- to turn an image through an angle
Crop – to trim the edges of an angle

0 Comments

State two application areas of a desktop publishing software.

29/12/2020

0 Comments

State two application areas of a desktop publishing software.

Vertical Divider

Posters
Book publishing
Card design
Brochures, flyers, and posters
Booklets
Newsletters
Business cards and letterhead
Forms
Financial documents
HR documents
Invoices, inventory sheets, memos, and labels
Greeting cards
Iron-on transfers
Candy wrappers
Postcards
Digital scrapbooks
Decorative labels
Family calendars

0 Comments

Types Toolbar for DTP Package

7/4/2020

0 Comments

ANALYSIS OF KCSE COMPUTER STUDIES TOPICAL QUESTIONS & REVISION KITS

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

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

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

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

Figure 1 and figure 2 show icons representing commands used to manipulate graphics in a desktop publishing package.

Figure 1 and figure 2 show icons representing commands used to manipulate graphics in a desktop publishing package.

Explain the use of each of the icons labelled figure 1 and figure 2.

Explain why a DTP application would be preferred to a word processing application when designing a publication.

Explain why a DTP application would be preferred to a word processing application when designing a publication.

Write each of the following acronyms in full as used in computing.

Write each of the following acronyms in full as used in computing.

The figure below is a toolbar for a DTP package.

The figure below is a toolbar for a DTP package.

State the functions of the tools labelled A, B and C.

The word race is appearing several times in a long story document composed using a DTP package. How would this word be safely replaced with the word content?.

The word race is appearing several times in a long story document composed using a DTP package. How would this word be safely replaced with the word content?.

In relation to DTP. state the: purpose of frames; and difference between an inside margin and an outside margin.

In relation to DTP. state the:purpose of frames; and difference between an inside margin and an outside margin.

List four types of publications that can be designed by using desktop publishing software.

List four types of publications that can be designed by using desktop publishing software.

Distinguish between the following sets of terms as used in spreadsheets. Worksheet and workbook, Filtering and sorting

Distinguish between the following sets of terms as used in spreadsheets. Worksheet and workbook, Filtering and sorting

One of the functions of an operating system is job scheduling. Explain what is mean by job scheduling.

List two examples of:Third generation languages and Object oriented languages

Explain the following graphic terms: Rotate and Crop

Explain the following graphic terms: Rotate and Crop

State two application areas of a desktop publishing software.

State two application areas of a desktop publishing software.

Types Toolbar for DTP Package

Categories

Archives

ANALYSIS OF KCSE COMPUTER STUDIES TOPICAL QUESTIONS & REVISION KITS

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

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

Figure 1 and figure 2 show icons representing commands used to manipulate graphics in a desktop publishing package.

Explain the use of each of the icons labelled figure 1 and figure 2.

Explain why a DTP application would be preferred to a word processing application when designing a publication.

Write each of the following acronyms in full as used in computing.

The figure below is a toolbar for a DTP package.

State the functions of the tools labelled A, B and C.

The word race is appearing several times in a long story document composed using a DTP package. How would this word be safely replaced with the word content?.

In relation to DTP. state the:purpose of frames; and difference between an inside margin and an outside margin.

List four types of publications that can be designed by using desktop publishing software.

Distinguish between the following sets of terms as used in spreadsheets. Worksheet and workbook, Filtering and sorting

List two examples of:Third generation languages and Object oriented languages

Explain the following graphic terms: Rotate and Crop

State two application areas of a desktop publishing software.

Categories

Archives

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