<=Back
<=KNEC Diploma in ICT module 1 Computer Applications I past paper: November 2013
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
(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
Viewed: 308 times
For Better experience and learning,for video answers, after video ends playing, click next question in the questions list!!!
Share in:
Questions List:
1. Describe two system utilities that could be used to duplicate information in a computer system.
2. Distinguish between internal and external disk operating commands
3. 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.
4. 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.
5. Explain the term template as used in word processing program
6. 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
7. Explain each the following terms as used in a database program: I. calculated field II. Filtering
8. Outline the benefits derived from creating reports in a database program
9. 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
1. Describe two system utilities that could be used to duplicate information in a computer system.
2. Distinguish between internal and external disk operating commands
3. 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.
4. 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.
5. Explain the term template as used in word processing program
6. 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
7. Explain each the following terms as used in a database program: I. calculated field II. Filtering
8. Outline the benefits derived from creating reports in a database program
9. 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
