PAPER 1

SECTION A

1. The following is a group of processors.

A. 80284, 80486, Pentium 0,Pentium I

B. 80286, 80486, Pentium I, Pentium II.

C. 1286,1486, Pentium 0, Pentium II

D. 1286, 1486, 80286, 80487.

2. What is information technology?

A. It is the central processing unit and monitor

B. It is the tangible components of a computer system.

C. It is all the types of equipment and programs used in processing.

D. It is the combination of software and programs.

3. Which of these does not fully represent computer classification by function?

A. Mainframe, micro, mini computers.

B. Mini, personal, analog computers.

C. Digital, mainframe, micro computers.

D. Personal, analog, micro computers.

4. Which drive letter usually represents the hard drive?

A. A

B. B

C. C

D. D

5. Which one of these became used commonly in offices in the third generation of computers?

A. Mainframe computer.

B. Ananometer

C. Supercomputer.

D. Microcomputer

6. What is the function of a MODEM? It

A. Blocks digital signals from leaving the computer.

B. Converts digital signals to analog and vice versa.

C. Converts analog signals to the atmosphere.

D. Modulates digital signals to mechanical motions.

7. Back up refers to

A. Storage of files on a secondary storage device.

B. Taking in data for rearrangement in order.

C. Programs designed to check specific parts.

D. Combining data from more than one file.

8. Which one of the following is not an operating system?

A. Windows 3.1

B. DOS version 6.22

C. Unix

D. Microsoft word

9. Formatting in word processing refers to

A. Preparing a new floppy diskette for use.

B. Cleaning diskettes for storage.

C. Enhancing the appearance of text in a document.

D. Erasing all data on a diskette.

10. The backspace key:

A. Deletes any letter towards the right.

B. Erases any character towards the left.

C. Moves the cursor to left without deleting any character.

D. Deletes a character at the cursor position.

11. A work book is a

A. publication.

B. data type entry.

C. range of cells.

D. collection of worksheets in a single file.

12. Which of the following is not characteristic of spreadsheets?

13. E-mail stands for

A. electrical mail

B. surfing mail.

C. electronic mail.

D. browsing the net.

14. A computer network refers to

A. information storage.

B. linking of computers for resourcesharing.

C. connecting a computer system to a backup device.

D. sharing a computer by many people.

15. In Database,a field is

A. the way information is displayed.

B. a particular listing with in a file.

C. the entire collection of data.

D. each bit of information in a record.

16. Databases perform the following functions:

A. sorting of slides,retrieving and formatting.

B. formatting , organizing and retrieving pictures.

C. creating, organizing and managing collection of related data.

D. entering data,saving,retrieving,drawing graphs.

17.URL stands for

A. uniform resource locator.

B. universal resource link.

C. an email address

D. a web publishing software.

18. Which of the following best distinguishes a WAN from a LAN? The

A. number of computers connected.

B. distance between connected computers.

C. model of computers connected.

D. type of operating system used in the network.

19. WWW refers to

A. web worldwide.

B. world words web

C. wild world web

D. World Wide Web

20. A problem that is most likely to occur due to future advancement of computers is

A. underdevelopment.

B. under population

C. unemployment

D. insecurity.

SECTION B.

21. (a) write the following abbreviations in full.

(i) LSI

(ii) COBOL

(iii) BASIC

(b) Distinguish between mainframe and mini computers.

(c ) Name two types of instructions that computers use to do their works.

(d) List down any five components that make up a complete system unit.

(e)(i) What is a CD-ROM?

(ii)Mention one advantage of a CD-ROM over a hard disk.

22.(a)Mention any three safety/security measures taken in a computer laboratory.

(b)What is system software in a computer system?

(c)Name three examples of system software.

(d)Mention any four functions of utility programs.

(e)What do you understand by the following terms?

(i)Editing . . . . . . . . . . . . . . . .

(ii)Saving . . . . . . . . . . . . . . . .

(iii)Trouble shooting . . . . . . .

23.(a)What is a computer spreadsheet?

(b)Name any four functions of a spreadsheet software.

(c)List three types of entries in spreadsheets.

(d)Mention three types of graphs created in spreadsheets.

(e) (i)What is a computer virus?

(ii)Mention two ways in which a computer can be infected by a virus.

24.(a)Write the words below in full.

(i)FTP . . . . . . . .

(ii)WAN . . . . . .

(b) State any three factors that affect communication speed on the internet.

(c)Distinguish between the e-mail and the internet.

(d)What is a server?

(e)List any two functions of a server?

(f)Give four differences between the hard disk and the floppy diskette.

25.(a) What is a database?

(b)Distinguish between Microsoft Access and database.

(c)List four examples of data which can be used to create a database.

(d)Mention three examples of database management software.

(e)Give four advantages of electronic databases over manual databases.

26.(a)Explain the following terms as used in presentation software:

(i)Slide show

(ii)Slide sorter

(iii)Slide layout

(b)Explain the importance of presentations.

(c)Describe one function of a slide master.

(d)Outline how you would create a transitional loop?

SECTION C

27."Computers have destroyed our culture!"What are your arguments for and against this statement?

28. Outline what you expect the role of computers to be in future.

29."Information Technology has done more good than harm to education."Give your arguments in favour and against the statement.

PAPER 2.

SECTION A.

1. (a ) Type the document below as it is, and save it under the name "My work 1"

Comper expert calls for IT course in schools.

Uganda's youg generation neds to be taught to apreciae the rise of Information Technology (IT) in their day-to-day lives, Sultan Awan , the managing director, silicon compuer series said.

The website www.Uganda schools.org, for a fe of shillings 30, 000, school wil publish information abut themselves on the site. There is a separate pge for every school.

By John Ricks Kayizzi

(Monitor Publications).

You are required to:

(i) Change the heading to uppercase, bold and underline it

(ii) Correct any misspelled word(s) in the document.

(iii) Replace the fee of shillings 30,000 by shillings 40,000.

(iv) Add your name and index number as a footer.

(v) Save the document a "My work 2"

(b)The following rates were quoted by some forex bureau in Kampala, for some currencies sold in Uganda shillings. Enter this table into spreadsheets.

Bureaux.

Dollars.

Pounds.

Euros.

DM.

A

1808

2600

1560

800

B

1808

2605

1605

_

C

1805

2600

1600

_

D

1803

2650

1645

_

E.

1807

2600

1600

_

You are required to:

(i)Create a pie-chart representing Forex Bureau A entries in percentages. Put the legend at the bottom.

(ii)Add a title to the pie-chart in (b)(i).Place the chart as an object below the table.

(iii)Add your name and index number below the pie-chart.

(iv)Save the work sheet as "My chart."

SECTION B

2. (a)Students of computer studies in a certain secondary school are to design their database with the following fields.

Surname of the student, first name,age,district of origin ,sex,index number, whether the student is an orphan or not, marks scored in a mathematics test.

(i)Use the above information to design a structure using the following format:

Table name . . . . . . . . . . . . 9state it)

Field name

Data type

Size/Length

(ii)Create a table of five records

_Name the appropriate key field (primary key).

(iii)Save the database as "My file".

(b)A recent survey showed the following data. Enter the information below in the table called "survey".

Reg.No.

Surname

First Name

Sex

Age

District

0006

Okello

Rose

F

15

Tororo

0010

Opio

John

M

62

Tororo

0007

Masaba

Patrick

M

40

Mbale

0127

Mukasa

Alex

M

20

Masaka

0053

Lwanga

Lydia

F

34

Masaka

0080

Abaho

Kate

F

52

Bushenyi

0008

Mugisha

Joseph

M

6

Kabale

0021

Akot

Aisha

F

22

Lira

0458

Uwimana

Jane

F

45

Kisoro

0500

Namubiru

Grace

F

31

Masaka

(i)Create a query to show people from Masaka.

(ii)Given that all the males and females above 18 and below 60years of age pay graduated tax, write a query which will display only tax payers.

(iii)Create a report for all females showing their names and their districts.

Save as "My report."

3. Using a web design software of your choice, design a website for your former primary school which includes:

(a) An index page with the name of the school and picture of an important feature in the school. .(The picture does not have to be the actual one but should be closely related).

(b) One page on the

(i) Different subjects offered.

(ii) School administration.

(iii) Sports and co-curricular activities,

(iv)neighboring community.

(c)In the website

(i) Write your name and index number at the end of the last page.

(ii) The pages should be well linked.

(iii)Save as 'My preschool"

4. The ministry of Health has appointed you as a Health Educator. You are required to give a talk on "The role of sex Education in schools".

You are required to:

(a) Design 3 slides as follows:

(i)Slide I should have the introduction of the topic.

(ii)Slide II should have the content of the topic.

(iii)Slide III should have the relevancy of sex education in schools.

(b) Include your name and index number at the end of each slide.

( c)Save your presentation as "My slide".

(d)Use minimal graphical effects.

5. Dynamic Roses, a flower farm which produces red and white roses, red and purple carnations, sells its products both locally and abroad. It has 4 managers namely;

General Manager _ in charge of overall management

Personnel Manager _in charge of human resources and is responsible for welfare of the employees.

Production Manager _responsible for growing and packing flowers.

Marketing Manager _responsible for selling, transportation and collection of revenue.

Imagine you have been approached to design a website for the company.

Create a website consisting of:

(a) An index page with links to all departments with a company logo.

(b)a page on the ;

(i) Production department detailing the varieties of flowers produced.

(ii)Marketing detailing the different managers and their roles.

(iii) Marketing detailing where the products are sold.

(c)A photo gallery showing pictures of different products and functions of the company.(use only three pictures)

(Note: The pictures do not have to be real ones but must be closely related)

(d)In the website;

(i) Include a feedback provision where a visitor to the page can send an e-mail.

(ii) Write your name and index number at the end of the last page as a footer.

(iii)Save the file as "Rose farm".