PAPER 1

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?

PAPER 2

SECTION A

1. (a) You the secretary to the schools Funds for funds" program and you are required to send out acknowledgement letters to people who have so far made contributions towards the program .the letter contents are the same for all the persons except the addresses ,names and nature of contributions .

Below is the letter to be sent and a table of people who have made contributions.

Mukisa senior secondary school,

P.o.Box 21146

IGANGA.

12th / June, 2007

[ADRESS]

Dear [NAME],

Thank you for your contribution of [NATURE OF CONTRIBUTION] towards the "Funds for Food "program.

This project is in its inaugural year but it has been a resounding success.

The learners and staff agree that it should become an annual event. The principal would like to thank you and hopes for more support in future.

Thank you very much.

. . . . . . . . . . . . . . . . . . . . . . .. . . .

PRINCIPAL

NAMUKASA FLORENCE.

NAME

ADRESS

NATURE OF CONTRIBUTION.

1

Lugayizi John

P.O.BOX 14,KAMULI

$430

2

Musiime Molly

P.O.BOX 92,MBARARA

500,000/=

3

Nsibambi Eriya

P.O BOX 160, BULOBA.

20Kg of maize

4

Nakasolya Juliet

P.O.BOX 1413,KAMPALA

40bags of rice

(i) Use an appropriate method in any word processing program to make a letter to be sent to each person in the table.

The address and names should be bolded and the contribution in italics.

(ii) Save your work as your index number.

(iii) Print each of the four letters.

(b) (i) Enter the data below into a suitable application program and save it as "raw- marks".

A

B

C

D

E

F

G

1

2

3

STUDENT NUMBER

NAMES

TELEPHONE NUMBER

TEST A

%

TEST B

%

4

01

Lule Nabil

0414-372 475

34

43

5

02

Okello Oryem

0712-312 130

56

22

6

03

Nantongo.F.

0414-421 666

76

34

7

04

Sempa.H.

0414-927 384

54

67

8

05

Senabulya.S.

0414-991 622

34

65

9

06

Kato .P.

0782 421 333

67

34

10

07

Semujju K

0414 696 471

89

56

11

12

13

14

15

16

17

18

19

20

21

(ii) Copy the work in (i) and paste it in worksheet 2 of the same workbook. Name the worksheet 2 as "percentage -marks".

(iii) Given that test A and test B are marked out 90 and 70 respectively , enter appropriate formulae to calculate the percentage marks for both tests using "percentage-marks" worksheet.

(iv)Use functions to obtain the difference between the highest and the lowest percentage marks in Test A in cell E21.

(v) Calculate the average mark for the Test B in cell G21

(vi) Save your work

(vii) Print your work.

SECTION B

2. The table below shows books in a library.

DATABASE OF BOOKS IN THE LIBRARY.

CODE NUMBER

TITLE

NAME OF AUTHOR

PAPER BACK (P)

Or

Hard BACK (H)

BORROWER NUMBER

DATE DUE BACK

2043

The Great Gatsby

F.Scott

P

15234

01 June 08

5284

Jane Austen-A life

C.Tomalin

H

11356

02 June 08

4033

Harry potter and the Philosopher's Stone

J.K.Rowling

H

16582

26 May 08

0549

Northern Lights

P.Pullman

P

12982

28 May 08

DATABASE OF BORROWERS

Borrower Number

Name of borrower

Address of borrower

Borrowers 'Phone number

11356

Tobias Ahendra

658,Uhuru Highway,

P.O BOX 2809

0772-344 567

16582

Carlos Moyes

12,Avenue De Lupin,

P.O Box 65432

0712-417 398








Computers are now widely used in libraries. Using a database management systems program:

(a) Create a table of books and enter the data.

(b) Create another table of borrowers and enter the data.

(c) Sort the records in part (a) in descending order of code numbers.

(d) Using fields :code number,title,name of author, paper back and or hard back ,date due back, create a query showing borrowers number that is above 12506 using table in 2(a).

(e) Create a query, showing only books with Hard back and the names of the author. The names of the authors should be in ascending order.

(f) Create a relationship between the books' and borrowers' tables.

(g) Put your name and index in the header and put the current date and time in the footer of both tables.

(h) Save the database as "library database".

3. You have been selected as the web -master for the school's Computer Club" to design a website for the club .In your planning stage you decide to include the following features on the website:

(i) Membership

(ii) Organizational structure of the club

(iii)Activities

(iv)News

(v)Feedback

Design the website including a logo to make it professional .Include also the source, date when written, contact of author, last update and references where necessary.

4. Road accidents are very rampant in Uganda. Many people have lost their lives in road accidents. You are required, using presentation software to educate Ugandans about road accidents. Create four slides as indicated in parts (i)-(iv).Every slide should:

  • use minimal graphical effects to make the presentation entertaining.
  • be able to convey the appropriate message to the community.
  • run with a click of the mouse.
  • have your name and index number as a footer

(i)Slide I - Should include the title, your name and your school name.

(ii)Slide II _Should include the actual causes of road accidents in Uganda.

(iii) Slide III_ should include the contribution of the traffic police in the prevention of road accidents.

(iv) Slide IV_ should include the preliminary precautions to avoid road accidents.

(v) Save the presentations as "Road Accidents".

(vi) Print your slides.