SECTION A
1. Computer system configuration information is stored in . . . . . . . . . . . . . .
A. CMOS
B. BIOS
C. RAM
D. CD-ROM.
2. All files ending with the following extensions are executable except. . . . . . . . .
A. .bat
B. .com
C. .exe
D. .dos
3. A . . . . . . . . . . . .is a computer output device.
A. Light pen
B. Plotter
C. Digital camera
D. Scanner
4. What is the meaning of the term range as used in spreadsheets?
A. Intersection of rows and columns.
B. A reference to a particular cell
C. A group of adjacent cells.
D. A collection of worksheets.
5. The term TCP/IP refers to . . . . . . . . . . . .
A. Translated control Protocol/Internet protocol
B. Translated control protocol/Intranet protocol
C. Translated control protocol/Internet protocol
D. Translated control protocol/Information protocol
6. . . . . . . . . . . . . . . is an example of a presentation program.
A. Excel
B. Lotus 1-2-3
C. Access
D. Power point
7. The device that stores programs and data when working with a computer and is lost when power is switched off is . . . . . . . .
A. CPU
B. ROM
C. GUI
D. RAM
8. Which of the following is necessary for running application software?
A. Operating
B. Network interface Card
C. Utility program
D. Graphical user interface
9. When the pointer on a computer screen does not move well ,what device is more likely to be causing the problem?
A. Pentium processor
B. Keyboard
C. Mouse
D. Monitor
10. Which of the following attaches itself to a program in your computer?
A. Computer virus
B. Computer bug
C. Computer object
D. Computer code.
11. Which of the following statements are correct?
I Each web browser has a unique IP address
II HTTP is a communication protocol
III An internet domain may be referred to as HTML
IV The internet is a network of networks.
A. I & II only.
B. I,II & III only
C. II &IV only
D. II, III & IV only.
12. A . . . . . . . . . . . . .is a term used in web design to connect one document or file to another.
A. Linker
B. Hyperlink
C. Hypertext
D. Hyper web
13. The text which appears in the lower margin of a page is called a . . . . . . . . . . . .
A. Header
B. Gutter
C. Margin text
D. footer
14. Which of the following is not a representation of a type of network topology?
A. Hub
B. Ring
C. Bus
D. Star
15. Files containing highly structured and organized data are . . . . . . . . . . . . . . .
A. Documents
B. Worksheets
C. Databases.
D. Communications
16. An area of artificial intelligence that stimulates certain experiences using special headgear, gloves and software that translates data into images is. . . . . . . . . . . . . .
A. Collaborative technology
B. Virtual reality
C. Hypermedia
D. Shell
17. Tables are primary requirements most applied to. . . . . . . . . . . . . . . . . .
A. word processing
B. Presentations
C. Web publishing
D. Databases.
18. . . . . . . . . . . . . . . invented the tabulating machine that was used in the USA population census in the 18th century.
A. Blaise Pascal
B. Hollerith
C. Napier
D. Aiken
19. Achen wants to get some information from the internet on designing success cards for her Fine Art examination .What kind of software would she need to use to get his information?
A. web browser
B. web authoring software
C. E-mail software.
D. Desktop publishing
20. The points of connection between a computer (motherboard) and its peripherals are . . . . . . . . . .
A. network cards
B. ports.
C. cables.
D. sockets.
SECTION B
21. (a) Describe the term evolution of computers.
(b) Mention four main characteristics of the first generation computers.
(c) How do the second second generation computers differ from fifth generation computers? List down four differences.
22. The database below contains data about items that have been ordered from various suppliers.
|
SUPPLIER |
CODE |
DELIVERY DATE |
PRICE ($) |
|
AD12 |
2146 |
28/09/07 |
44.99 |
|
CO35 |
3724 |
30/09/07 |
249.50 |
|
MO18 |
5613 |
05/10/07 |
98.15 |
|
LO47 |
5613 |
11/10/07 |
102.75 |
|
PO29 |
7215 |
17/10/07 |
127.50 |
|
RO16 |
4639 |
19/10/07 |
22.89 |
(a) State the data type of the fields in the given table.
(i) SUPPLIER. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
(ii) CODE. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
(iii) DELIVERY DATE. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
(iv) PRICE. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
(b) The following search condition is input
(CODE =5613) AND (PRICE ($)<100)
Write down the output using only the SUPPLIER field.
(c) Write down a search condition that will search for all items with a price more than $ 50 that will be delivered in October.
(d) Write down using only the SUPPLIER field if the records were sorted in descending order.
1. (a) (i) What is a spreadsheet ?
(ii) Give three examples of spreadsheet software.
(b) Name three types of data that can be placed in a spreadsheet cell.
(c) What is a chart in spreadsheets?
24. (a) in relation to computers, explain the meaning the meaning terms.
(i) Intranet. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
(ii) Internet. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
(b) (i) Outline three benefits of networking computers.
(ii) Outline three demerits of networking computers.
(c) What is a server in a computer network?
25. (a) A computer system is a composition of several components. List any four components that make up a computer system.
(b) Briefly, explain the function of any three components you have given in (a) above.
26. (a) (i) Explain what is meant by the operating system.
(ii) Give any two features of a graphical interface.
(b) (i) Describe as precisely as possible the use of each of the following features':
List Box . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
Drop down list. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
(ii) Clearly state one example where anyone of the above features in (b) (i) can be used.
SECTION C
27. "Computers are a necessary requirement." How do computers affect people in everyday life?
28. (a) Explain what is meant by volatile and non volatile when referring to primary memory.
(b) Explain the advantages and disadvantages of using primary and secondary storage devices.
29. What are the possible characteristics of the future generation of computers?