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.