Computer studies analysis of questions and answers

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

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 hardware devices that may be required to connect a computer to an existing local area network.

7/1/2021

0 Comments

A) State three hardware devices that may be required to connect a computer to an existing local area network. (3 marks)

A network adapter/network interface card
Network medium/cable
RJ45 connectors/BNC/ST connector/SC connectors/Fibre local connector
Data points (sockets to plug in the cable)
Switch/Hub
Access point/TP link

B) A publisher intends to use a desktop publishing programme to create a publication which is to have many graphics. State three ways in which the graphics may be acquired for this purpose. (3 marks)

Using digital camera
Scanning the graphics from other sources
Downloading from the internet
Drawing from scratch/Drawing tools
Clip art
Another file

C) Interpret each of the following spreadsheet formula:

(i) = countif(D2:D9, “>“&B4) (2 marks)

(ii) sumif(B3 :B 11, “4M”, D3 :D11) (2 marks)

(i) = Countif (D2 : D9, “>“ & B4)

Count those value in the range D2 :D9 with values greater than the value in cell B4).

(ii) = Sumif (B3 : B11, “4M” D3 : D11)

Sum the values in the cell range D3 : D11 for records whose
corresponding values in cell range B3 : B11 equals to “4M”

(D) The following are the fields of products table in a database created to store records of products manufactured in a factory:

product number
product name
price
product description

I. State the appropriate data type for each field. (2 marks)
II. State three properties to be put in place during table design to ensure integrity of the data entered. (3 marks)

I) Product Number — Number/Autonumber/Text

Product Name — Text/string
Price — Currency/Number
Product Description — Memo/Text/String

(II) Properties that can be set in the table design

Data type
Validation/Validation rule
Input mask
Setting required/null value status
Field size
Caption

(D) The following are the fields of products table in a database created to store records of products manufactured in a factory:

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

Explain the term search engine as used in the Internet

4/1/2021

0 Comments

(a) (1) Explain the term search engine as used in the Internet. (2 marks)

(i) Search-engine
It is a web-based application used to locate for an item or information from world wide web.

(ii) Peter intends to download a movie from the Internet. State the three factors that may determine the total time taken to complete the download. (3 marks)

Factors that affects duration of download

The size of the video
The band width of the media used
Availability of network
Other activities that may be running in the computer.
Other restrictions enforced in the computer
The restrictions by the ISP
Speed of computer

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

Name two methods of paper orientation

31/12/2020

0 Comments

(a) Name two methods of paper orientation (1mk)

Portrait
Landscape

(b) Name two keys used to delete text in a document (1mk)

Del
Backspace

0 Comments

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

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)

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.

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.

State three hardware devices that may be required to connect a computer to an existing local area network.

A) State three hardware devices that may be required to connect a computer to an existing local area network. (3 marks)

B) A publisher intends to use a desktop publishing programme to create a publication which is to have many graphics. State three ways in which the graphics may be acquired for this purpose. (3 marks)

C) Interpret each of the following spreadsheet formula:

(D) The following are the fields of products table in a database created to store records of products manufactured in a factory:

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.

Explain the term search engine as used in the Internet

(a) (1) Explain the term search engine as used in the Internet. (2 marks)

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

Name two methods of paper orientation

(a) Name two methods of paper orientation (1mk)

(b) Name two keys used to delete text in a document (1mk)

Categories

Archives

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

​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

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

​A) State three hardware devices that may be required to connect a computer to an existing local area network. (3 marks)

​B) A publisher intends to use a desktop publishing programme to create a publication which is to have many graphics. State three ways in which the graphics may be acquired for this purpose. (3 marks)

​C) Interpret each of the following spreadsheet formula:

​(D) The following are the fields of products table in a database created to store records of products manufactured in a factory:

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.

​​(a) (1) Explain the term search engine as used in the Internet. (2 marks)

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

​(a) Name two methods of paper orientation (1mk)

​(b) Name two keys used to delete text in a document (1mk)

Categories

Archives

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) State three hardware devices that may be required to connect a computer to an existing local area network. (3 marks)

B) A publisher intends to use a desktop publishing programme to create a publication which is to have many graphics. State three ways in which the graphics may be acquired for this purpose. (3 marks)

C) Interpret each of the following spreadsheet formula:

(D) The following are the fields of products table in a database created to store records of products manufactured in a factory:

(a) (1) Explain the term search engine as used in the Internet. (2 marks)

(a) Name two methods of paper orientation (1mk)

(b) Name two keys used to delete text in a document (1mk)