KNEC Craft certificate in ICT Module 1: Computer Application I theory past paper July 2017 Answers

All the answers required by KNEC have been provided and elaborated as much as possible for better understanding

Course Name:  Information and Communication Technology
Also Done By:
N/A
Course Level:  Craft Certificate
Sub Level:       Module I
Course Unit:   Computer Application I
Exam body:    KNEC
Share with Friends:

Go Back

1.

With the aid of a diagram, differentiate between landscape and portrait page layouts as used in word processing documents ()

2.

Explain the term worksheet as used in spreadsheet programs ()

3.

Explain the function textbox feature as used in word processing programs. ()

4.

Explain the term data validation as applied spreadsheet programs ()

5.

Explain a reason why a database administrator would use a table template when creating a new database ()

6.

Linet intends to restrict access to part of the worksheet she was working on. Explain a spreadsheet feature she could apply to achieve her objective ()

7.

Explain the function of the Esc key of a computer keyboard ()

8.

A company with many branches prefers to use video conferencing to a boardroom conferencing. Outline two reasons for their preference. ()

9.

Differentiate between primary and secondary files as used in a mail merge feature of a word processing program ()

10.

Explain a circumstance under which a many-to-many table relationship would be established in a database program ()

11.

Table 1 shows an extract of a spreadsheet document showing the details of staff payroll in a manufacturing company. Use it to answer the questions that follow a)Write a formula that would be used to compute the Gross salary for Joseph b)Suppose the manager wanted the data in the worksheet arranged from the highest to the lowest paid staff and then alphabetically by Staff Names. Describe a spreadsh ()

12.

An examination database stores details of students who sat for an exam. Each record has the following fields: (2marks) -Student ID Number -The student passport sized photo -Scores for each subject. -Total Fees Balance. State suitable data type for each of the fields ()

13.

State the function of each of the following folders in an email program i)inbox ii) spam ()

14.

Explain the function of the slide sorter feature as used in presentation programs ()

15.

A company which deals with the importation of second hand motor vehicles has a website with various hyperlinks. Explain the function of this feature on the website ()

16.

Gerald intends to print a spreadsheet document with no gridlines shown on the print out. Describe the feature he would use to achieve his objective ()

17.

Cate intends to change the object in figure 2 to resemble the object in figure 3 Describe a presentation program feature she would use to achieve her objective ()