• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

GSCE ICT Microsoft Excel Coursework

Extracts from this document...


GSCE ICT Microsoft Excel Coursework Statement of the problem 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. ...read more.


Lee and Mark are also capable of using it on an intermediate level. This would make it easier for them to update the system when the table must be changed on a regular basis. Lee and Mark have already got Microsoft office installed on their computer in the club, this includes Microsoft excel installed on the computer and they would not have to buy any additional software. Microsoft Excel is the software that I will be using ad it does not cost anything extra since Lee and Mark already have it and our knowledge of how to use it is much better than Lotus 1-2-3. The hardware required will consist of a basic processor, monitor, mouse and keyboard. The system will be used by sensei Lee and sensei Mark only using the computer I their office. The monitor can swivel of that the fighter can see their positions in the league themselves. Data Required The data required to build this system will be the information from who has won and lost their bouts. These bouts will be watched by Mark or Lee and then the result recorded onto the spreadsheet. Data Collection The information, which will be the winner and the loser of the fights, can be seen on the clubs Computer which is in sensei Lee's office, sensei Lee or sensei Mark will have to be asked by the fighters to go and view the table. ...read more.


Initial Design An initial design for the system was drawn up as follows: The spreadsheet will calculate the points based on what the senseis enter, a win, loss or draw. The system will then sort the table of figures and the fighters positions will change accordingly. This operation will be done at a click of a button using a recorded macro assigned to it. User Feedback on 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. ?? ?? ?? ?? Microsoft Excel GCSE Coursework Poetry 2005-06 Thomas Rutland ...read more.

The above preview is unformatted text

This student written piece of work is one of many that can be found in our GCSE ICT Systems and Application section.

Found what you're looking for?

  • Start learning 29% faster today
  • 150,000+ documents available
  • Just £6.99 a month

Not the one? Search for your essay title...
  • Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

See related essaysSee related essays

Related GCSE ICT Systems and Application essays

  1. GCSE Excel Project ICT

    mean associating customers to a date, which is a shared value, not something individual like their name, which is the standard arbitrary value. Two alternate software solutions considered There are two computerised options within Microsoft both are within the Microsoft Office 2007 Suite.

  2. ICT Coursework (MarcoS)

    results - what did you find out after talking to the manager and end user about the system * How is the company currently using the system * Discuss the problems with the current system, and why changing it would be beneficial * Recommendations I've interviewed, first, the manager of Middle East Construction Company, Mr.

  1. GCSE ICT Coursework Write-up

    Software Software is computer programs that instruct computers on what to do. I used Microsoft Word, Macromedia Fireworks and Microsoft Excel to produce the final payslip. I designed the logo using Macromedia Fireworks as it gave me the ability to write on letters which I wished to have on my logo.

  2. The impact of ICT on a person with special/particular needs

    Being extremely limited due to Cerebral Palsy, she doesn't go out much regardless of whether or not Facebook replaced her social life. She can't participate much in activities and such with friends and has a very limited social life. Facebook gives her the social life she's always wanted, albeit not exactly ideal but very good for Sarah.

  1. Ict Powerpoint Coursework

    PowerPoint is a very sophisticated piece of software, but the designers and producers - Microsoft have made it simple to use as presenting it as a slide shows format which can be altered with hyperlinks. PowerPoint's features include, image editing, video editing, animations, fonts, different colours, templates and many more.

  2. Database coursework

    It must for example customer names and address. This means also that it must be self existent. produce reports This means that it must be able to produce reports. look up data(Queries) This means that the user must be able to search for data in the database.

  1. Database Coursework

    The most obvious problems in any paper-based system is organisation. The records of individual customer's are not in any particular order and are kept together by a very loose folder, which is stored in a locked cabinet so no one outside the system can get access to it.

  2. IT coursework.

    At the moment P.Y.S has a paper based system which is prone to error, so when the job sheet is filled in for the artist it could result in the wrong things being put on the shoe if it has not been filled in correctly and this would displease the

  • Over 160,000 pieces
    of student written work
  • Annotated by
    experienced teachers
  • Ideas and feedback to
    improve your own work