Computer Applications I July 2016 Past Paper – KNEC Diploma

Computer Applications I July 2016 Past Examination Question Paper – KNEC

This Past Paper examination was examined by the Kenya National Examination Council (KNEC) and it applies to the following courses

• Diploma in Information Communication Technology – Module I

Note: To easily navigate through the KNEC Past Examination Paper Pdf below, Mobile phone users are advised to use Mozilla or Chrome browsers

THE KENYA NATIONAL EXAMINATIONS COUNCIL
DIPLOMA IN INFORMATION COMMUNICATION TECHNOLOGY
MODULE 1
COMPUTER APPLICATIONS I
2 hours

(a) State the expected output from each of the following spreadsheet functions:

(i)            Round down (2334.978,1);            (1 mark)
(ii)           Roundup (2334.978,1);    (1 mark)
(iii)          Truncate (2334.978,1).    (1 mark)
(b)          Distinguish between report footer and page footer as used in database applications.(4 marks)
(c)           The operating system performs the function of file management. Explain two such functions.               (4 marks)
(d)          Table 1 shows an extract of records of students in the database of a college. Use it to answer the questions that follow.
Table 1

Write query criteria that would be used to extract each of the following statements:
(i)            all students whose names’ start with letter ‘K’ and come from Uganda;      (2 marks)
(ii)           students bom before 6/5/1995 with fees balance less than 50,000.00;         (2 marks)
(a)          Explain each of the following features as applied in word processing applications:
(i)            footnote;            (2 marks)
(ii)           end note;             (2 marks)
(iii)          watermark.         (2 marks)
(b)          (i)            Explain the circumstance that would necessitate a computer user to apply the mail merge feature in word processing. (2 marks)
(ii)           Explain the term referential integrity as used in database applications.        (2 marks)

(c) Figure 1 shows a text placeholder in a DTP program. Use it to answer the question that follows.

State the function of each of the parts labeled (i) and (ii).
(d) Kabana had the following formulas entered in different cells of a worksheet:
(i)            =D29/$D$36* 160;
(ii)           =$D$3 * $F$13;
Explain the cell reference used in each of the formulas.     (3            marks)
(a)          Explain the function of section breaks as used in word processing applications. (2 marks)
(b)          Paul noticed the following errors displayed in different cells of a worksheet.
#DIV/0!
#             REF!
#             VALUE!
(i)            Explain the cause of each of the errors.    (3            marks)
(ii)           Explain the remedy for each of the errors identified in (i).  (3            marks)
(c)           A college management has installed an Internet for its library use. Outline three advantages of this network to the college.          (3 marks)
(d)          Explain the circumstance under which each of the following features could be applied in a spreadsheet program:
(i)            filtering;               (2 marks)
(ii)           sorting. (2 marks)
(a)          Define each of the following terms as used in presentation applications:
(i)            use presenter view;          (2 marks)
(ii)           Slide master.       (2 marks)
(b)          (i)            State the function of input mask as used in database applications. (1 mark)
(ii)           Differentiate between MEMO and OLE data types as in database application, giving an example in each case. (4 marks)
4.

(c) Distinguish between slide sorter and slide layout as applied in presentation programs.
(4 marks)
(d) Figure 2 was transformed to Figure 3 and Figure 4 respectively using a presentation
Figure 2 Figure 3 Figure 4
Explain the feature that was used to get the transformations.         (2 marks)