Computer Applications Question Paper

Computer Applications

Course:Diploma In Information Technology

Institution: Mombasa Polytechnic question papers

Exam Year:2003

DIPLOMA IN INFORMATION TECHNOLOGY (MODULE 1)
Computer Applications
Answer any Five Questions
1. (a) Outline four types of operating systems. (8 marks)
(b) (i) Define the term command. (2 marks)
(iii) Distinguish between internal and external commands. (4 marks)
(c ) Explain three functions of an operating system. (6 marks)
2. (a) In reference to word processors, explain the skills in document formatting as applied in:
(i) Page formatting
(ii) Text formatting
(b) Explain the application of the following features in wordprocessor:
(i) Thesaurus
(ii) Mail merging process
(iii) Document templates
( c) Outline Three circumstances where OLE is applied in wordprocessor. (3 marks) 3. (a) Define the following terms as used in spreadsheets.
(i) cell
(ii) formula
(iii) labels
(6 marks)
(b) The following is a simple payroll:
A----------B-----------C---------D---------E-----------F----------G--------------H---------I
1. Name------Hours-----Hourly----Basic ----Gross----Tax--------NSSF----Allowance---Net
2. -------- Worked --- Rate ---- Pay------Pay---Deducions-Contributions----------Pay
3.---------------------------------------------------------------------------------------------------------
4. John----------8----------200
5. Peter---------12--------450
6. Sam----------22--------300
7. Njogu--------30--------286
8. Mary--------16---------220
9. Sally--------45---------468
10. Jane-------15----------150
11. Tina-------3------------280
12.--------------------------------------------------------------------------------------------------------
Required:
Write a formulae using cell names for the following expressions, state where the formulae is placed:
(i) Basic pay = hours worked x hours rate
(ii) Allowances are allocated at 10% of the basic pay
(iii) Gross pay = basic pay + allowances
(iv) Tax deduction is calculated at 20% of the gross pay
(v) Net pay = gross pay - tax deductions
(10 marks)
(c ) List Four types of information that can be inserted into a cell. ( 4 marks)
4. (a) Distinguish between the following terms in relation to a database:
(i) DBMs and database
(ii) Records and fields
(iii) AND and OR operators (6 marks)
(b) Explain Three types of database models. (6 marks)
(c ) (i) Define the term sorting. (2 marks)
(ii) Explain Three major concerns in database systems. (6 marks)
5. (a) (i) Explain the Desktop Publishing (DTP) system. (3 marks)
(ii) State Five features in desktop publishing. (5 marks)
(iii) List Two areas of DTP application. (2 marks)
(b) (i) Define Computer Aided Design (CAD). (2 marks)
(ii) List Five features of CAD. (5 marks)
(iii) List THREE CAD application areas. (3 marks)
6. (a) State Six reasons for preferring graphical representation of data. (6 marks)
(b) Explain the terms:
(i) Accounting in reference to financial application
(ii) General ledger in reference to financial applications
(iii) Address book in reference to record keeping
(iv) Diary in reference to record keeping. (8 marks)
(c ) Explain Three cell data types in spreadsheet. (6 marks)
7. (a) State any two areas where computer aided design is applied in the society today (2 marks)
(b) (i) Explain the term "Orthographic projection". (2 marks)
(ii) Distinguish between 1st angle and 3rd angle projection. (4 marks)
(c ) Explain each of the following:
(i) Exploded view of an object.
(ii) Computer graphics. (4 marks)
(d) Describe how computing has been applied to each of the following areas:
(i) Transportation systems
(ii) Educational systems
8. (a) (i) With reference to computers define the term "Artificial intelligence". (2 marks)
(ii) Outline Three areas in which artificial intelligence is applied. (3 marks)
(b) Define the following terms with respect to the internet:
(i) Website
(ii) Upload
(iii) Access provider (6 marks)
(c ) Explain the following areas of application in office automation: (i) Word processing
(ii) Electronic mail
(iii) Video conferencing. (9 marks)

📘 Access 10,000+ CBC Exams With Marking Schemes

Computer Applications Question Paper

More Question Papers

Exams With Marking Schemes

End Term 3 Exams

Mid Term Exams

End Term 1 Exams

Opener Exams

Full Set Exams