Microsoft Excel Coursework

1207 Words3 Pages

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.

Open Document