Eca0001:Computer Applications Question Paper
Eca0001:Computer Applications
Course:Diploma In Civil Engineering
Institution: Meru University Of Science And Technology question papers
Exam Year:2012
(a) Define the following terms as used in computers: (3 Marks)
(i) Computer
(ii) Operating system
(iii)Hardware
(b) Describe three key features of the third computer generations. (3 Marks)
(c) Differentiate between application software and system software. (2 Marks)
(d) State three disadvantages of using voice input devices. (3 Marks)
(e) State four types of publications that DTP software can help you produce. (4 Marks)
INTERNET TECHNOLOGY
he Internet is a global connection of computers. These computers are connected via a
huge network of telecommunications links such as wires, cables and satellite. The
Internet allows you to access to a whole resource of data and information stored at
different sites and locations all around the world. Each computer connected to the internet can
act as a host. A host computer provides information for other people to access and retrieve.
Internet has the following benefits:
? Speedy communication
? Inexpensive communication
? Convenient communication
T
2
(f) Identify six formatting features from the above test. (6 Marks)
(g) State three examples of DTP software. (3 Marks)
(h) Use the information in the table below to answer the questions that follow
A B C D E F G
NAME COMPUTER COMM.
SKILLS
TECHNICAL
DRAWING
TOTAL AVERAGE MAXIMUM
3 Juliet Karimi
4 Purity Makena
5 Jacob Njiru
6 Jasmin Abdulla
(i) Write an Excel formula for calculating the total marks for Purity Makena. Indicate
the cell number where the total will be displayed. (3 Marks)
(ii) Write an Excel formula for calculating the average marks for Jasmin Abdulla.
Indicate the cell number where the average will be displayed. (3 Marks)
QUESTION TWO – (15 MARKS)
(a) John designed a pamphlet and an architectural drawing. State the most suitable output
device he could use for each item. (2 Marks)
(b) Explain how you would insert a picture in Ms-word (5 Marks)
(c) Differentiate between a workbook and a worksheet as used in Ms-Excel. (2 Marks)
(d) Mrs. Yusuf, the school librarian is not very technically inclined but is determined to make
better use of the computer facilities at her disposal in the media centre and library. She
will, however, need a lot of tender, patient, loving care and a healthy dose of advice from
you! Recently, she purchased a new PC for the library with the following specifications:
Intel Pentium CPU 3.1 GHz
128 MB RAM
40 GB Hard Disk Drive
52x DVD drive
Ergonomically designed optical mouse
104 Soft key Palm QWERTY Keyboard
PS/2, USB, Parallel & Serial Ports
56 Fax/modem
Clearly state and explain the following to her with reference to the above specifications:
(i) The speed of the PC (2 Marks)
(ii) Memory capacity of the computer (2 Marks)
(iii)The acronym USB and DVD. (2 Marks)
3
QUESTION THREE – (15 MARKS)
Table 1 show various input devices and the nature of data that may be used with each device.
Use the table to answer the question that follows;
Input device Nature of data
Digital scanner Records to be entered in database
Optical Mark Reader Printed graphics/pictures
Keyboard Cheque
Magnetic Ink Character Reader Pencil shaded forms
(a) Match each input device against its appropriate data. (4 Marks)
(b) Describe how you would merge table cells in an Ms-Word document. (4 Marks)
(c) State and explain three purposes of DTP soft wares. (3 Marks)
(d) Differentiate between the following terms: (4 Marks)
(i) Header and footer
(ii) Superscript and subscript
QUESTION FOUR – (15 MARKS)
(a) Write the following abbreviations in full. (4 Marks)
(i) MICR
(ii) COM
(iii)WYSIWYG
(iv) CD-ROM
(b) Differentiate between a standard toolbar and a formatting toolbar. (2 Marks)
(c) Digital computers are termed as Two-State Machines. Explain. (3 Marks)
(d) State two orientations used in Ms-Word. (2 Marks)
(e) Explain two disadvantages of using spreadsheets. (2 Marks)
(f) Explain the function of the following elements as used in Ms-Excel. (2 Marks)
(i) Cell pointer
(ii) Worksheet tabs.
More Question Papers