EOY ASSESSMENT SENIOR TWO

EOY ASSESSMENT SENIOR TWO

INFORMATION TECHNOLOGY P/2

ATTEMPT ALL QUESTIONS

(a) Ms Sylvia is a house teacher in Kyesibe High School. Her school will be holding its inter-house MDD competitions soon: Being a Day school, Ms, Sylvia needs to put in extra time to perfect most of the activities. She intends to send special letters requesting parents to release their children on non-schooling day for practice.

The contents of the letter will be the same for all parents except for the parents’ personal details and titles; below are the letter to be sent and a table showing the personal details of the different parents

Kyesibe High School

P.O. Box 35,

KAKIIRI

20^th September 2020

THRU: THE HEADTEACHER

TO: Parent/Guardian of: <<STUDENT’S NAME>>

<<PARENT’S NAME>>

<<PHONE NUMBER>>

Dear <<TITLE>>

RE: REQUEST TO RELEASE YOUR CHILD ON SATURDAY 23TH NOVEMBER

As the annual Inter-house MDD competitions draw nearer, our hose is devising means of increasing time for practice.

I hereby request you to release your <<GENDER>> on the above-mentioned date, to enable us polish his/her performance as a <<CATEGORY>>.

We will be grateful for your positive response.

Yours faithfully,

………………..

Mrs Sylvia Apia

HOUSE MISTRESS-UGANDA HOUSE

Required

1. Type the letter and save it as permit Letter-Your name               
2. Create the table and save it as permit table-Your name               
3. Include a header of your name and index No on the letter           
4. Insert current date and time in the lower bottom Centre of your letter and update it automatically.                                                                   
5. Insert three lines 3-point page border on your document (letter)
6. Using appropriate word processing feature link the table to the letter so as to generate 5 letters to be sent to the respective parents of the participants in Mrs Sylvia’s House. And ensure that all merge fields inserted should be bolded.                                                                                        
7. Insert a printed water mark of your Name in the entire document.                   
8. Make the reference (Ref) appear in blue color font size 14 Arial Black style and the rest of the text 14 font size and in Black times Roman        
9. Change line spacing of the entire text to 1.5

2. The table below shows examination results of Senior two ICT students. Study it and answer the questions that follow:

Required:

a) Enter the students’ data in a spreadsheet program.

b) Determine the final mark for every student by use a formula.

c)  Insert in the table the title “STUDENTS’ PERFORMANCE”.

d) Get the average using marks for paper one and paper two

e) Plot a bar graph of the final mark against the STUDENT’S NAME.

as GRAPH.

i)  Save your work as your name.