KNEC Diploma in ICT module 1 Computer Applications I past paper: November 2013 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

Describe two system utilities that could be used to duplicate information in a computer system. ()

Distinguish between internal and external disk operating commands ()

The following cell references were typed by student during a spreadsheet lesson: I. $A$11 II. A11 III. A$11 Identify each type of cell reference used. ()

A student created an embedded chart in a worksheet. He clicked the printer icon to print the work and he observed that only the chart was printed. I.Outline the most appropriate cause for his observation. II.Outline the procedure the student could follow to print both the chart and the data on the same page. ()

Explain the term template as used in word processing program ()

Table 1 below shows a student details in word processing program. Use it to answer the question that follow. Write function that could be used to: (i)Calculate the total for the first student; (ii)Calculate the average course work mark ()

Explain each the following terms as used in a database program: I. calculated field II. Filtering ()

Outline the benefits derived from creating reports in a database program ()

Juma, an entrepreneur intends to invest in a publishing business. Identify four example of a general purpose DTP application software that Juma could acquire Inorder to start his business ()

10.

Outline the steps that could be followed to insert a word art in a DTP application ()

11.

Figure 1 shows an output produced from a presentation program. Use it to answer the questions that follows (i)Identify the print type depicted in the figure; (1 marks) (ii)Outline the reason for referencing the print type identified in (i) ()

12.

State two uses of macros in a spreadsheet program ()

13.

Figure 2 is an extract from a word processing program. Use it to answer the question that follows. I.Identify four text formatting features applied. II.Identify two paragraph formatting features applied ()

14.

Distinguish between append and insert feature as used in database program ()

15.

Francis, an ICT student created several tables in a database program. With the aid of sketch in each case, describe three types of relationships he could create to link the tables ()

16.

Outline three precautions that a database administrator may put in place to ensure data integrity in a shared database ()

17.

Table 2 shows student details in a database. Use it to answer the question that follows Write a criteria that could be used to extract each of the following: (i)Records all female students; (ii)Records of all student whose balance ranges from 3,000 to 5,000; (1 marks) (iii)Records of all students taking a diploma in ICT. (1 marks) ()

18.

Write DOS commands that could be used to carry out each of the following: I. Create a new directory named KNEC in the root of drive A (1 marks) II.Display all the directories in the drive C horizontally (1 marks) III.Delete a file named student in drive D ()

19.

Distinguish between scandisk and checkdisk commands as applied in dos ()

20.

Describe the term master page as used in DTP ()

21.

State features that make an electronic spreadsheet better than a manual spreadsheet ()

22.

For each of the following scenarios, state the most appropriate spreadsheet chart that could be used: I.Comparing two variables II.Displaying trends over time III.Showing the contribution of a variable to the whole population ()

23.

Figure 3 shows patients’ details represented in a spreadsheet program. Use it to answer the questions that follows. (i)Write a formula that could be used to compute: (2 marks) I.The total bill for Janet II.The balance for Mike (ii)Assuming that a patient is only discharged upon full payment of his or her bill. Write a function that could be used to indicate whether a patient can be discharged o ()

24.

Explain the term custom slide show as used in presentation program ()

25.

Distinguish between animation and transition as used in a presentation program ()

26.

Outline the importance of recording narration in a presentation program ()

27.

Outline the function of each of the following presentation program feature. (3 marks) I.Grayscale; II.Movies and sounds; III.Date and time ()

28.

Prudence, an IT officer in a certain firm observed that one of the computers in the accounting section was taking too long to load a programs I.state one possible cause of this problem. II.Outline two preventive measures which prudence could put in place to minimize the problem ()

29.

ABC Company Ltd. Is carrying out a major maintenance exercise for their storey building which is expected to take about six months. The maintenance section has suggested that IT department may be moved to the basement of the building for that period. Explain two environmental factors that could make this move unwise ()

30.

State the position in a publication where each of the following will be inserted i)Footnote ii)Endnote ()

31.

Outline four ergonomic practices that could be adopted by personnel in a busy publishing firm ()