1.In this era of Information Technology, youth are vulnerable to many challenges in their life. Assuming you are appointed health prefect of youe school and you are required to make awareness about abstinence;

a) Use a suitable presentation software to design a five-slide presentation about abstinence and include the following information.
     i. Slide 1: The topic, your name and current automatic date
    ii. Slide 2: Introduction and definition of abstinence
   iii. Slide 3: Advantages of abstinence among the youth.
   iv. Slide 4: Youth affected by early sex in 2009 – 20%, 2010 – 30%, 2011 – 27%,2012 – 33%, 2013 – 35%. Represent the data in a tabular form.
   v. Slide 5: Use a column chart to represent the data in slide four

b) Insert relevant graphics in your presentation.
c) Apply suitable animation to your presentation.
d) Insert a footer as your name and personal number
e) Save your presentation as your name and personal number.
f) Print your presentation as handout on one page.

 

2. a) Using an appropriate database program, load the file POPU. Save it as your name and personal number.
    b) Open the table “Nation ” in Design View and adjust the data types appropriately.
    c) Enter the following details in the field IDNo.

N001

N002

N003

N004

N005

N006

N007

N008

N009

N010

N011

N012

N013

N014

N015

N016

N017

N018

N019

N020

d) Delete the default ID field from the table and make IDNo the primary key.
e) Create a query including the fields of NAME, SEX and MARRIAGE to select all those female citizens who are not married. Save the query as Status.
f) Make another query with only the concerned fields to display families living in semi-permanent houses and having the number of members in the family which is 12 and above. Save this query as Semi Permanent.
g) Produce a report showing all fields except the fields; DATE OF BIRTH and MARRIAGE STATUS. Save it as Final Report.
h) Insert a footer as your name and personal number on the report.
i) Save and print your work.

 

3. a) Use a publication software to open the file phone.pub and save it as your name and personal number.
    b) Insert a text box of height 0.791” and width 8.936” on the top most part of the page and do the following:
        i) Type “YUNNO SENIOR SECONDARY SCHOOL”
       ii) Change the font type to Rockwell condensed size 28 and any color.
       iii) Insert a logo of your choice in any appropriate position of the text box.
    c) i) Insert any two pictures from the folder Images, in the positions labeled No1 and No2.
          Resize the pictures to fit in the textboxes.
       ii) Type “Invitation to silver jubilee celebrations” between the two images and change the font type to Old English Text MT size 24.
    d) Group all the layout objects
    e) Type the following text in the area marked z and centre align it.

Dear

Mr/Mrs/Rev/Hajji……………………………………….
             You are hereby invited to attend the schools silver Jubilee celebrations due to take place on

15th December this year at 10:00amat the school’s Rwakanengyerere Square.


f) Type in your name as the recipient of the invitation.
g) Save and print your work.

 

4.a) Using a suitable word processor, create the following table of information belonging to Madiba Enterprises Limited. Save it as your name and personal number.

Name

Age

Sex

Salary (Shs)

Munyagwa

28

M

450,000

Bbaale

30

M

550,000

Bena

25

F

950,000

Namusisi

26

F

380,000

Cosy

27

M

400,000

Daniella

32

F

600,000

Akello

34

F

560,000

Faluk

38

M

760,000

Kiwa

37

M

850,000

Manafwa

25

F

865,000


b) Make a copy of the table onto the next page.
c) Sort the records in the table in descending order of Salary.
d) Italicize the column headings and change them to font size 15.
e) i) Add a row at the bottom of the table.
   ii) Use in –built formulae to find the average age and total salary.

f) i) Insert a column to the right of the table and merge the cells.
   ii) Type the text “Salary is paid on 28th day of every month without fail” and align it vertically in the centre.

g) Insert a row at the top of the table and insert a suitable heading.

h) Align your table in the centre of the page.
    i) Insert a header containing your name and personal number in capital letters.

j) Save and print your work.

 

5. a) Using any spreadsheet program, load the file Data which shows the number of votes obtained by Chairperson Local Council five (LCV) candidates in different countries of a district. Save your work as your name and personal number.
b) Add two columns: TOTAL and POSTION.
c) Using any relevant formula, calculate:
   i) Total Votes
  ii) Position.

d) Skip one row after the last candidate and type the word Highest Votes. Calculate the highest number of votes for each country.
e) In the next row, type the word Total Voters. Calculate the total number of voters per country.
f) Format the table to fit on the page.

g) i) Insert two rows above the first row,
    ii) Type an appropriate heading for the table andcentre it.
h) Insert a 2D stacked line chart for all the candidates and theor votes in the counties EXCEPT county C.
i) Add appropriate chart title and axis titles.
j) Transfer the chart onto another sheet.
k) Insert a header of your name and personal number.
l) Save and print your work.
END