Dpba 020: Computer Applications Question Paper
Dpba 020: Computer Applications
Course:Computer Applications
Institution: Kenya Methodist University question papers
Exam Year:2008
KENYA METHODIST UNIVERSITY
END OF SECOND TRIMESTER 2008 EXAMINATIONS
FACULTY : BUSINESS AND MANAGEMENT STUDIES
DEPARTEMENT : BUSINESS ADMINISTRATION
COURSE CODE : DPBA 020
COURSE TITLE : COMPUTER APPLICATIONS
TIME : 2 HOURS
INSTRUCTIONS:
• Section A is Compulsory
• Answer any TWO questions from Section B
SECTION A
Question 1
(a) The Central Processing Unit (CPU) is the brain of a computer system. It is responsible for activating and controlling the operations of other units of the computer system. Briefly describe the components of the CPU and their functions. (6 marks)
(b) Describe any four element of a computer system (4 marks)
(c) Provide any three functions of operating system (3 marks)
(d) Quote the major difference between first and third generation of computers. (2 marks)
(e) Describe five applications of computers in our Society today. (5 marks)
SECTION B
Question 2
(a) (i) You have been hired as a secretary at Furaha Company. Your first assignment is to urgently compose similar letters to many company clients. Outline the procedure to follow to come up with the letters required in ms word assuming they are 20 in number and you really want to impress your boss on your speed. (4 marks)
(ii) Immediately you start working your boss calls and inform you that he cannot see both the standard and the formatting bars in his Ms word program. He asks assistance from you. How do you restore this? (1 marks)
(b) Describe how a block of text may be copied or moved in a document. (2 marks)
(c) James a technician enters the following commands in DOS. Explain explicitly what the commands will do
(i) C:/>Dir *.doc
(ii) C:/>Copy A:Person.txt G: (4 marks)
(d) (i) Give any other two type of operating system apart from Windows and DOS. (2 marks)
(ii) What reasons can be associated to the popularity of Windows Operating system in the world (2 marks)
(e) Give two reasons why flash disk is one of the most used storage media nowadays.
(2 marks)
(f) What is main difference between ROM and RAM (2 marks)
(g) What is a utility program? (1 mark)
Question 3
(a) Provide distinct among spreadsheet ,workbook and worksheet (3 mark)
(b) Explain the following cell referencing in Excel using relevant examples.
(i) Single cell referencing
(ii) Absolute cell referencing
(iii) Relative cell referencing (6 marks)
(c) Explain the following cell data types as used in Spreadsheets
(i) Labels
(ii) Values (2 marks)
(d) Using an example, show how you enter a function in a cell (2 marks)
(e) Explain the concepts of spreadsheets-Automatic recalculation (2 marks)
(f) Provide any five uses of Internet (5 marks)
Question 4
(a) Distinguish between the following terms
(i) File and Folder
(ii) System Software and Application Software
(iii) Floppy Disk and Floppy Drive (6 Marks)
(b) How would you achieve the following in ms word 2003 (i) Find and Replace every occurrence of certain words in document.
(ii) Create a password for your document
(iii) Set two columned document (6 marks)
(c) A student in KEMU wanted to get the sum of some two numbers. He input 45*5 in cell A15. What was the answer got? (2 Marks)
(d) What is the function template in ms word (2 marks)
(e) Define the term computer networking and explain three types of computer networks based on geographical span. (6 marks)
Question 5
(a) Discuss four advantages of spreadsheet over a conventional worksheet. (4 marks)
(b) With a well labeled diagram describe the computer hardware. (7 marks)
(c) Describe any three input devices (6 marks)
(d) What is the significance of using headers and footers on a word document (2 marks)
(e) How do you insert headers and footers? (1 mark)
More Question Papers