SECTION A
1. The scientific milestone of using Integrated Circuits (IC) was a characteristic of the
A. First generation
B. Second generation
C. Third generation
D. Fourth generation.
2. What major invention defined the second generation of computers?
A. Magnetic cores
B. Machine language
C. Micro processor
D. Transistors
3. A device that interprets and executes the instructions in the computer and also called the brain of the computer is the
A. System unit.
B. Base Unit
C. CPU
D. ALU
4. In which computer classification is a mainframe categorized?
A. process
B. Size
C. Process power
D. Purpose
5. Which of these factors does not affect internet speeds?
A. Band width
B. Type of media
C. Traffic
D. World Wide web
6. Which one of the following is a set of impact printers?
A. Inkjet printers
B. Bubble jet printers
C. Line printers
D. Thermal printers.
7. One way of protecting the information on a computer is . . . . .
A. Defragmenting the disk
B. Formatting the disk
C. Sorting the data on the disk
D. Backing up the data onto different media.
8. Computer programs used in tasks such as removal of viruses or data compression can be categorized as
A. Word processors.
B. Desktop publishing.
C. Utility programs.
D. Communication programs.
9. Which one of the following is not a word processor?
A. Microsoft word.
B. Word wrap
C. Word perfect
D. Lotus word pro
10. The contents of an entire text file can be referred to as a
A. Document.
B. Word processor
C. Paragraph
D. Page
11. A mega byte is equivalent to . . . . . . . kilobytes.
A. 1024
B. 1048576
C. 11534336
D. 104857600.
12. . . . . . . . . . . . . are programs that manipulate numbers and figures and also perform advanced chart drawing.
A. Word processors.
B. Databases
C. Spreadsheets.
D. Presentations
13. This networking protocol does not relay information out of a LAN.
A. HTTP
B. TCP/IP
C. TELNET.
D. NETBEUI.
14. . . . . . . . . . . . . . is a local area network of computers whose users use web pages and transmission protocol to communicate with each other on the network.
A. Intranet
B. Extranet.
C. Client server
D. Internet
15. The basic use of a primary key in database is to
A. Uniquely identify a record.
B. Act as an alternative identifier.
C. Sort records
D. Modify a file structure.
16. In . . . . . . . . . Software, a field is the entire column that contains similar data.
A. Word processor
B. Database.
C. Spreadsheet.
D. Presentation
17. The primary purpose of presentation software is to . . . . . . . . .
A. Create awareness, documents, letters and reports.
B. Design, create and edit slides for overheads
C. Create and edit graphics.
D. Create newsletters, brochures and booklets.
18. The process of computing data entered in a database with a set of predefined rules or values to check if the data is acceptable is known as
A. Browsing.
B. Validating.
C. Sorting
D. Querying.
19. Rights enforceable by law accorded to a developer of software is called
A. Copyright
B. Patent rights
C. Trade secret right
D. Trade mark
20. The future generation of computers will be characterized by advanced robotics, computer vision-based mobile robots and
A. low processing systems
B. expensive computer systems
C. expert systems
D. mechanical systems.
SECTION B
21. (a) State any three advantages and three disadvantages of dot matrix printers over laser jet printers.
(b) Identify any three advantages of display devices such as monitors over printers.
( c) (i) Distinguish between primary and secondary storages .
(ii) Give an example of each type of storage in (c) (i) above.
(iii)Identify one disadvantage of a hard disk over a floppy disk.
(d)State a device that should be acquired along with a computer to help a user save work when electricity is switched off.
22. (i) what do you understand by the terms below in reference to word processing ?
Formatting
Editing
Saving
(ii) Give two advantages of a hard copy over a soft copy.
(b) Identify four advantages of using a word processing software instead of an ordinary typewriter.
( c) describe one situation where it is more beneficial to use Desktop publishing software instead of word processing software.
( d) Name the labeled bars on a word processing screen below
X....................................................................
Y....................................................................
Z....................................................................
23. The worksheet below shows company bills (in dollars) paid for the months of July, August and September:
|
|
A |
B |
C |
D |
E |
F |
|
1 |
|
July |
Aug |
Sept |
Total($) |
Average($) |
|
2 |
Rent |
72 |
72 |
106 |
250 |
83.33 |
|
3 |
Electricity |
24 |
0 |
66 |
90 |
30.00 |
|
4 |
Telephone |
96 |
90 |
114 |
300 |
100.00 |
|
5 |
Stationery |
48 |
38 |
64 |
150 |
50.00 |
|
6 |
Total |
240 |
200 |
350 |
790 |
|
(a) Write down the formulas to calculate ;
(i)Totals for the month of July, August and September
Rent................................................................................
Electricity.......................................................................
Telephone......................................................................
Stationery......................................................................
(ii) Average for the months of July, August and September
Rent................................................................................
Electricity.......................................................................
Telephone......................................................................
Stationery......................................................................
(b) It was an error to enter zero (0) in cell C3 .State the cells in which the values would change automatically when the correct amount is put.
(c) List the values in the range B3:D4 in the above table
(d) Shade on the worksheet above the cells that must be used to create the pie chart below:
24 (a) Explain the following terms;
(i) Hyper link
(ii) Web browser (give examples)
(iii) Web master
(iv) web site
(b) (i) write URL in full and state its use.
(ii) Give an example of URL.
(C) (i) What is an ISP in full in relation to internet ?
(ii) State the use of an ISP.
(iii) State any three factors that should be considered in choosing an ISP.
25 (a) Describe briefly the functions of the following views as used in presentation software:
(i)Outline view
(ii)Slide sorter view
(iii) Notes pages view
(b) What is Auto Content Wizard in presentation software?
(c) (i) What is a slide show as used in presentations?
(ii) Explain the following terms as used in a slide show:
Transitional effect
Timing
(d)What is a Master Layout is as is used in presentations?
26. (a) (i) What is a Database Management System(DBMS) ?
(ii) Give any three examples of (i) above.
(b) Various DBMS use different data types .Specify any five data types used in DBMS.
(c) State any five advantages of using database management Systems instead of manual databases.
SECTION C.
27.Describe the various categories of computer application software available today.
28. Reasonably predict the future in computing; from the perspective of the past and the present development in the technology and use of computers.
29. Describe the merits and demerits of using internet.