PAPER 1

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.

PAPER 2

SECTION A

1. (i) Type the text below using a word processing program:

CHOOSING WORD PROCESSING SOFTWARE

Word processing is using the computer to enter, store, manipulate and print in letters, reports, books and so on.

Once you have used word processing, you will probably wonder (like a million others before you) how in the world you ever survived without it.

As more word processing packages come on the market, choosing the right software can become confusing.

Nevertheless, there is probably a word processing package that will serve your needs. As you begin looking, ask yourself these questions:

I What types of documents am I now producing?

II what types of features do I need?

Want?

Document types can range from simple letters and memos to proposals, reports, legal documents, books, newsletters, scientific papers, form letters and so on. The point is, match the features you need with the features you need with the features in the software package. For example, if you write articles that require references, you will need the footnoting feature; if you develop a newsletter, having the multicolumn layout feature would be handy; if scientific notation is needed, you will want superscripts (X2+Y2) and subscripts (A21); and if you send "personalized" form letters the mail-merge feature is a necessity.

A number of add-on programs are available to enhance the functionality of word processing packages. These include:

On-line thesaurus

Spelling checker

Grammar checker

Style checker

Idea processor (outliner)

What you can do with word processing is limited only by your imagination and willingness to learn the system.Goodluck in your Computer-assisted writing adventures-now and in the future!

(ii) Insert in the header the word: Tips on the left hand corner and "Word processing" on the right hand corner.

(iii)Bold the heading font size 22 point, underline and centre it.

(iv)Block indent paragraph one by 1 inch in the right and left margins.

(v)In the paragraph starting with "Document" bold the second sentence.

(vi)Make 2 the superscript of X and Y in the expression (X2+Y2) and 21 the superscript of A in the expression (A21).

(vii)Insert bullets on the list of functionality of word processing packages given in the text.

(viii)Insert a footnote of your name and index number on the left and page number on the right hand corner.

(x)Save the work as choosing software and make a print out.

(b) (i) Create a worksheet and enter the data below;

SCHOOL CANTEEN

Q1/2006

Q2/2006

Q3/2006

Q4/2006

YTD

Sales Revenue

22500

38000

52800

85700


Cost of goods sold






Gross Margin






Variable Expenses






Fixed Expenses

6000

6000

6000

6000


Net Profit















Note: Q1, Q2, Q3, Q4 are four quarters of the year.

Complete the worksheet using the following information.

(ii) The cost of Goods sold and variable Expenses for the school canteen are 55% and 10% of the sales Revenue respectively.

(iii)Enter a formula for each quarter to calculate the gross margin which is equal to sales Revenue minus Cost of goods sold.

(iv)Net Profit is equal to gross Margin minus Variable and fixed Expenses.

(v)Add a column called YTD that totals the figures from the four quarters.

(vi)Draw a bar graph for net profit for the four quarters.

(vii)Add a title "School canteen Net Profit"and label the x-axis as "quarterly net profit "and the Y-axis as "Amount in shillings".

(i) Save your worksheet as your surname and print.

SECTION B:

2. The table below gives information on some staff members of a computer school called "COMTECH ACADEMY"

EMP

NO.

SURNAME

FIRST NAME

SEX

TITLE

DEPARTMENT

SALARY

(shs)

DATE OF BIRTH

CA001

ADUWO

JANE

F

DEPUTY

ADMINISTRATION

620,000

17-06-36

CA050

HOLOWO

MOSES

M

TEACHER

BUSINESS

510,000

06-08-77

CA061

WAPAKABULO

JAMES

M

TEACHER

BUSINESS

600,000

05-06-70

CA150

NAKUMUSANA

MARY

F

SECRETARY

INFORMATION

2275,000

20-07-36

CA168

KOMAKECH

MIKE

M

TEACHER

BUSINESS

500,000

15-06-63

CA170

MUTEBI

JOHN

M

DIRECTOR

ADMINISTRATION

1,000,000

17-07-66

CA190

NDAULA

SARAH

F

CASHIER

ADMINISTRATION

600,000

14-04-68

CA201

OKELLO

JOHN

M

DRIVER

ADMINISTRATION

265,000

16-05-63

CA215

ALIYO

JOYCE

F

SECRETARY

COMPUTING

275,000

20-08-70

CA307

NASSUNA

HARY

F

LIBRARIAN

INFORMATION

310,000

07-11-74

NOTE:EMP NO.represents Employee number.

(a) (i) You are required to design a suitable database to manage the above information,namethe database EMPLOYEE DATABASE.

(ii) Create a table using Design view ,and name it EMPLOYEE TABLE .

(iii)Create a form called Employee Entry Form and enter the above records.

(b) (i) Create a query displaying all the fields in the above table to filter out only employees from the department of information .save it as INFORMATION DEPARTMENT.

Print the query and its output

(ii) Create another query displaying all the fields of employees with salary less than 300,000. Name it "salary scales employees less than 300,000."

Print the query and its output.

(iii)The academy 's retirement age is 55years.Create a query to filter out the employees whose ages are above 55years.Name it "RETIREMENT AGE"

Print query and its output.

(iv)Create a report using the employee table and group the records by department and name it "REPORT BY DEPARTMENT"

Print the report and the query.

3. You have been contacted to design a website for Human Local Government Administration which includes the following:

(a) An index page with the title "HUMA" and heading "HUMA LOCAL GOVERNMENT ADMINISTRATION".

The page should have:

(i)Provision for inserting the administration block photograph. The building is still under construction.

(ii) Six local government department i.e.

_ Administration department

_ Finance department

_ Human Resource department

_ Health department

_ Education and sports department

_ Security department

(iii)The following three column table:

First name

Last name

Department

James

Okello

Finance

Hellen

Mukisa

Human Resource

Isa

Lutalo

Health

(b) Create a link on the Education and sports department in (a)(ii) above which will lead you to a page explaining what the department does.

(c) Include the districts's mission statement at the bottom of the index page .

(d) Provision should be made for originality,creativity,innovation and appropriate use of graphics.

(e) Save your work in your name and index number.

(f) Print your work.

4. Create a suitable 7-slide show presentation for your school,with the following items:

NOTE: Your slide should :

(i)Use appropriate animation schemes to view your presentation.

(ii) use appropriate transition for your show

(iii) apply clips and word art where applicable.

(iv)apply appropriate Design templates and background colour.

(v)have a header as your name and index number.

(a) A title slide with the name of your school

(b) A text slide with the departments in the school

(c) A text slide with the subjects taught in the school.

(d) A two column text slide with the names of teachers in the school.

(e) A text slide with co-curricular activities in the school.

(f) A tabular slide with ten (10) imaginary senior four candidates with their imaginary marks in end of term two computer studies test.

(g) A line graph for analyzing performance of the candidates in (f) above.

(h) Save your work as your name and index number.

(i) Print your slides.

5. East African community (made of Uganda, Tanzania and Kenya-UTAKE) is gradually moving into political, economical and social federation. The three countries are determined to form the most powerful economic giant on the African continent.

Using any available web publishing software, design a web page for the East African Community. Make sure your home page is impressive, creative and has appropriate graphics and not slow to download.

(i)The home page should have a short story about East Africa of about 100 words.

(ii)The homepage should have a link to each of the three countries; Uganda, Tanzania and Kenya.

(iii)Each linked page, in (ii) should have a short story about that country.

(i) Indicate your name and index number as a footer.

(ii) Save your work as HEAC-surname.

(iii) Print your work including your links.