<=Back
<=KNEC Diploma in ICT module 1 Computer Applications I past paper:July 2019
Bidhaa Company has created a database file to share details of it’s employees. The database contains the following details for each employee: Name, DOB, IDNo, Passport photo, Gender and residential area.
i)State an appropriate data type for each field
ii).Write an expression that would be used to calculate the current age of an
Employee displayed in years only.
iii)Write an expression that would be used to extract employees whose age is between 22 and 50 years.
i)State an appropriate data type for each field
ii).Write an expression that would be used to calculate the current age of an
Employee displayed in years only.
iii)Write an expression that would be used to extract employees whose age is between 22 and 50 years.
Viewed: 864 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. Explain each of the following terms as used in desktop publishing: i)autoflow ii)Kerning
2. Describe each of the following word processing features; i)insertion-point ii)end-of-document marker
3. Acacia college intends to connect all its computers to the internet. Outline four Hardware requirements to accomplish this task.
4. Explain three transition effects that could be applied to a slide during animation of Objects in a presentation program
5. Distinguish between multi-user and single user operating systems as used in computing
6. Bidhaa Company has created a database file to share details of it’s employees. The database contains the following details for each employee: Name, DOB, IDNo, Passport photo, Gender and residential area. i)State an appropriate data type for each field ii).Write an expression that would be used to calculate the current age of an Employee displayed in years only.
7. Define each of the following terms as used in databases; i)Cardinality ii)Referential integrity
8. The operating system provides a standard interface between a computer user and the computer system for communication. Describe two types of such interfaces.
9. Jonah used fill and mask commands while designing a publication using a DTP Application. Explain each of these commands.
10. Rose used a presentation program to display her progress on a project she carried out. Outline three ways in which she could have started the slide show
11. Explain one way in which a spreadsheet program could be used in each of the following areas; i)accounting; ii)Forecasting.
12. Outline two types of views that could be used to display a publication in a DTP application
13. With the aid of a sketch in each case, distinguish between drop cap and in margin cap as used in word processing.
14. Patrick used different types of layout guides to design a calendar for his company using a DTP program. Describe three types of guides that he could have used to accomplish task
15. With the aid of a diagram, describe a hierarchical database model
16. Joseph used different types of data while creating a worksheet. Explain three types of such data he could have used
17. Explain three types of Action Queries used in a database stating their respective functions.
18. Describe each of the following terms as used in DTP applications: i)snap; ii)flip
19. Explain the function of the clone stamp tool as used in DTP programs
20. Table 1 is a section of a worksheet showing information about diseases in a certain hospital. Use it to answer the questions that follows i)Using a function and cell address only, write a formula that would be used to compute total number of cases reported ii)Write a formula that would be used to calculate consultation amount for malaria and subsequently used for all other diseases, taking that K
21. Explain a circumstance that would require a designer to use each of the following DTP tools; i)lasso tool ii)marquee tool
1. Explain each of the following terms as used in desktop publishing: i)autoflow ii)Kerning
2. Describe each of the following word processing features; i)insertion-point ii)end-of-document marker
3. Acacia college intends to connect all its computers to the internet. Outline four Hardware requirements to accomplish this task.
4. Explain three transition effects that could be applied to a slide during animation of Objects in a presentation program
5. Distinguish between multi-user and single user operating systems as used in computing
6. Bidhaa Company has created a database file to share details of it’s employees. The database contains the following details for each employee: Name, DOB, IDNo, Passport photo, Gender and residential area. i)State an appropriate data type for each field ii).Write an expression that would be used to calculate the current age of an Employee displayed in years only.
7. Define each of the following terms as used in databases; i)Cardinality ii)Referential integrity
8. The operating system provides a standard interface between a computer user and the computer system for communication. Describe two types of such interfaces.
9. Jonah used fill and mask commands while designing a publication using a DTP Application. Explain each of these commands.
10. Rose used a presentation program to display her progress on a project she carried out. Outline three ways in which she could have started the slide show
11. Explain one way in which a spreadsheet program could be used in each of the following areas; i)accounting; ii)Forecasting.
12. Outline two types of views that could be used to display a publication in a DTP application
13. With the aid of a sketch in each case, distinguish between drop cap and in margin cap as used in word processing.
14. Patrick used different types of layout guides to design a calendar for his company using a DTP program. Describe three types of guides that he could have used to accomplish task
15. With the aid of a diagram, describe a hierarchical database model
16. Joseph used different types of data while creating a worksheet. Explain three types of such data he could have used
17. Explain three types of Action Queries used in a database stating their respective functions.
18. Describe each of the following terms as used in DTP applications: i)snap; ii)flip
19. Explain the function of the clone stamp tool as used in DTP programs
20. Table 1 is a section of a worksheet showing information about diseases in a certain hospital. Use it to answer the questions that follows i)Using a function and cell address only, write a formula that would be used to compute total number of cases reported ii)Write a formula that would be used to calculate consultation amount for malaria and subsequently used for all other diseases, taking that K
21. Explain a circumstance that would require a designer to use each of the following DTP tools; i)lasso tool ii)marquee tool
