KNEC Diploma in ICT module 1 Computer Applications I past paper: November 2022 Answers

All answers available

Course Name:  Information and Communication Technology
Also Done By:
NA
Course Level:  Diploma
Sub Level:       Module I
Course Unit:   Computer Application I
Exam body:    KNEC
Share with Friends:

Go Back

Outline three advantages that an organization would get for using Email for their communication ()

Describe each of the following as used in desktop publishing application: (4 mark) (i) bleed; ii) Crop ()

Distinguish between device drivers and firmware as used in computers. ()

Nancy was tasked to design a database for data storage. Outline four types of keys she may use when creating the database fields ()

Outline the meaning of each of the following database concepts: (3 marks) i. Data security; ii) Data quality iii) Data integrity ()

Rose was tasked to design a database for an organisation data storage. outline four properties she may use when creating the database fields ()

A company’s Technician was required to design a network operating system. Explain two types of operating system design he could apply. ()

Joel was tasked to source an internet service provider to supply his college with internet. outline four other than cost the he should consider during the selection. ()

Outline the function of each of the following formula in a spreadsheet program: (i) IF; ii)Len iii)Concatenate ()

10.

Explain one circumstance in each case that would necessitate the use of the following features in a word processing program. (4 marks) (i) Split window; ii)Zoom ()

11.

Distinguish between a ruler guide and a column guide as applied in desktop publishing program ()

12.

Agnes intends to align text in a slide created using a presentation program. Outline four text alignment she could apply. ()

13.

State three reasons for using queries in database management system ()

14.

Explain one function of each of the following database objects: (4 marks) (i) Forms; ii) reports ()

15.

Lydia intends to use a tab stop feature to align text in a document created using a word processing program. Explain four examples of stop tab that she could apply ()

16.

Outline the function of each of the following data types in a database: (3 marks) (i) AutoNumber; ii)Memo iii)Look up wizard ()

17.

Distinguish between rotate and flip operation as used in Desktop publishing applications ()

18.

Figure 1 is a spreadsheet extract showing revenue and expenditure for a country for a period of 5 years. Use it to answer the questions that follows. (i)Using cell addresses, write the formula that would be used to compute Total revenue for the five years in cell G2 (ii)Use If function to write a formula in cell B5 that would Display the comment “PROFIT” if the revenue exceeds the expenditure ()

19.

Patrick created a presentation which he wishes to print. Outline four types of print layout he could use to print the presentation. ()

20.

Explain each of the features as used in spreadsheet program: (i) sort; ii)Filter ()

21.

David intend to include speaker notes in slides created using a presentation program. (i) Outline three items that he may include as speaker notes. ii)Outline two ways he could access the speaker notes during a presentation. ()

22.

With the aid of a sketch in each case, describe the following components of an entity data model in database (i)Attributes ii)Relationships; ()