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.