Microsoft Excel Coursework

Microsoft Excel Coursework

Sensei Lee Griffin and sensei Mark Seat are the owners of the North

London jikishin jiu jitsu association. They train some of the best jiu

jitsu fighters in Britain and both Lee and Mark regularly enter

competitions. They begin to teach the Japanese martial art to many

young children and also to adults. Their training area is state of the

art and the facilities are wonderful, one of questions that their

students ask them is "where am I in the club rankings?" Currently

sensei Lee and sensei Mark are not able to answers these questions,

they simply do not have anyway of showing their fighters who is the

best in the club. This is a problem because each club from the south

east if England gets an opportunity to enter just one fighter into the

biggest regional competition of the year, this competition is

Southend.

All of the fighters in the North London jiu jitsu club strive to be

the best at the club so that they can enter south-end and hopefully

bring the regional championship to their club. Sensei Lee currently

has sent the same fighter for the past three years, some of the other

in the club want a chance to enter Southend so they have suggested

that a record of the fights that have taken place in the club are

kept. They want to employ a points system and the fighter with the

most points at the end of the summer will be entered to represent the

North London jiu jitsu club at south-end. Both sensei Lee and sensei

Mark have approved and think that it will be a fair way of choosing a

fighter to represent the club at the Southend competition.

Consideration of Alternative Solutions

...

... middle of paper ...

...n Initial Designs

Sensei Lee said that he liked the simplicity of the table, this he

said would make it easy for either himself or Mark to use the system.

Sensei Mark said that he would like to see some colour to make the

column headings stand out from the names of the actual fighters. This

change was easy and quick and the change was made within minutes.

Final Design

Implementation of table:

* Inset formula, sum of win lose and draw to make the total fights

fought.

* Created a macro to automatically add up the points gained from

won, lost and drawn fights.

* The macro was created by going to tools-macro (named the macro) –

went back to tools-macro- stop recording, then I created a text

box and gave the macro a title, and finally I assigned the macro

to the text box.