SECTION A

1. (a) (i) Type the following information as it is (use font size 14)

The time table will be out by the beginning of next academic year. It should be copied and filled with relevant subjects.

SENIOR FOUR TIME TABLE 2010

 

8:00 am

_

9:00 am

9:00am

_

10:00am

B

 

R

 

E

 

A

 

K

10:30am

_

11:30am

11:30am

_

12:30pm

L

 

U

 

N

 

C

 

H

2:00pm

_

3:00 pm

3:00pm

_

4:00pm

MON

           

TUES

           

WEDN

       

F R E E

THUR

           

FRID

           

SAT

         
                   

NOTE: The outer boarders are (3) triple lines

(ii) Put a footer as your name and index number.

(iii) Colour "Senior Four Time Table 2010", BREAK, LUNCH and FREE" green.

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

(v) Print your work.

(b) The following students sat for their term two examinations in Mathematics (mat), Computers (comp) and Commerce (com) and obtained the following marks:

John got 40 in mat, 20 in comp and 50 in com. Mary got 90 in mat, 60 in comp and 30 in com. Tania got 70 in mat, 65 in comp and 90 in com. Samuel got 55 in mat, 40 in comp and 80 in com. Paul got 50 in mat, 20 in comp and 35 in com. Albert got 50 in mat,60 in comp and 50 in com.

(i) Enter the data given in spreadsheet. All names should be in column A.

(ii) Use a formula to complete the total for each student and put them in column E

(iii) Sort the data entered in column E in descending order.

(iv) Put the titles for column A,B,C,D and E in orientation 45

(v) Boarder your data and give it a professional look.

(vi) Draw a bar / column graph for the students marks in the three subjects.

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

(viii) Print your work.

 

SECTION B:

2. (a) Create a table using design view with the following fields: NAME, DATE OF BIRTH, SEX, RELIGION AND FEES BALANCE. Set the NAME field as the primary key and save the table as 'candidates table'.

(b) Create a form to enter the records below and save the form as "Candidates form'

NAME

DATE OF BIRTH

SEX

RELIGION

FEES BALANCE

Tina T

Jan/02/90

F

Catholic

40000

Golfer J

Feb/20/89

M

Moslem

60000

Bob Baller

Mar/13/88

M

Protestant

55000

Alice Cricketer

Apr/04/89

F

Pentecostal

20000

Sam Big

Jun/03/90

M

Catholic

25000

Jennifer J

Feb/04/87

F

Adventist

90000

Klez B

Jul/05/98

M

Catholic

40000

(c) Create a query displaying all the students whose names begin with letters B and T. Save it as BT query.

(d) Create another form in Design view with all the available records in the given table in (b) Name it "Design view form"

(e) Generate a report for the above table with FEES BALANCE in descending order. Use columnar layout and portrait as the form orientation. Name this report "columnar Report 1".

(f) Save your database as your name and index number.

3. you are required to make a presentation to a group of web design students about the following multimedia features, namely

(i) Video

(ii) Hyperlink

(iii) Sound.

Include the following information about each of the components.

Video/Movie clips.

Video clips are added to enhance your presentation. This can show authentic movement, which makes the presentation more interesting. Movement is either by click of mouse or automatic.

Hyperlinks

A hyper link is an element in an electronic document or to an entirely different document .typically, you click on the hyperlink to follow the link .Hyperlinks are the most essential ingredients of all hypertext systems, including the World Wide Web.

Sound

Sound as with video or movie clips, is added to enhance your presentation. If for example, your presentation is about weather, a sound clip of thunder can be added. Clicking on the sound clip will activate the sound.

(a) Create a presentation in which each concept (i) (ii) and (iii) is on its own slide. Enhance this with a graphic of your choice.

(b) The first slide should contain links through action buttons to each other slide.

Note;

Each slide must contain a link to the first slide, through an action button.

(c) Include your name and index number on each slide and save your work.

(d) Print your slides.

4. Using any available web publishing software, design a web site about your personal information.

(a) Create a home page for your personal information with appropriate links to other following pages.

(b) Create other pages with following information:

Page I: Page title, Bio-data e.g. name, age, nationality and religion.

Page II: A table of schools attended, period of attendance and qualifications acquired.

Page III:A bulleted list of activities and responsibilities held e.g. head prefect.

Page IV: Hobbies and special skills.

Note:

(i) Create a moving (marquee) page title

(ii) Use appropriate graphics.

(iii) Insert a personal email address (email hyperlink) on the home page.

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

(v) Print your work.