Ilford cricket team data analysis project Essay

The problem I am investigating is the process in which information from a play snap is analysed in view of the scores recorded from a match. The problem is that the cricket aggroup maestro and civilize have a really hard task to falsify t deportics during a match, and subsequently a match. Things such as runs per over, runs infallible for victory etc be all ask during a match for tactics, and after a match to see what went misemploy. They mustiness do many an(prenominal) manual of arms calculations to cast give away such things and this scre pull throughg ca purpose many defects, as human error is inevit competent-bodied. as well they goat non draw graphs of information to analyse the info easily, beca give this requires skill and time. This problem can lede to many problems such as wide of the mark analysis, and therefore error in judgement over tactics. This can inevitably have an overall gear up on the feeble as losing and hitning a game can rely on thi s. This can all be solved with the use of computers. feasibility Study Realistic appraisal of the feasibility of potential dissolving agents. The feasibility stage of my realise involves five main sections these sections include the Technical, economical, Legal, Operational, and Scheduler sections.These mental testingament have to be considered onward the analysis to see if this project pull up s blasts be a feasible for the cricket group. I must consider the current softw atomic number 18 and computer hardw ar the cricket squad already has unattached to him. Technical Feasibility Technical feasibility destines investigating whether the technology exists to allow for a computer placement such as the one I have proposed. Clearly the technology is available and so this means that this project is technically feasible.This project leave alone require on the shelf softwargon, so this is easily available and economic compared to bespoke software. similarly the actual ha rdware requirements are not real demanding and could be already available to the group. This is all extremely important because this is such a big step for the team. Economic Feasibility Economic Feasibility is to view the costs and benefits of the potential body, both running costs and initial costs and therefore see if the benefits are greater than the costs, which if it is, means that the project is economically feasible.As the team is losing a give come forward of time through having to record scores manually, and is often fashioning mistakes, it will mean that the advanced brass will practice it much efficient and worthwhile. Which will mean information is analysed quicker and so the passenger vehicle and the captain can quickly change tactics and hopefully upkeep better tactics and win games. I have already mentioned this project is sensibly economic in its initial costs, as the hardware and software are very cheap. Legal Feasibility.Legal feasibility means tha t your outline should comply with the entropy protection act and the warranter rights of any entropy used in your project. The schema of rules should overall comply with the rules of the data protection act. In order to do this the system should be password protected so only authorised personnel can access the system. So if the system is created in this way, so the system will be legally feasible. Operational Feasibility Operational feasibility considers the social factors, which will pret balance the everyday working of the people using the system.This will not be too more of a change for the cricket team because they have manually been doing the job, so it will mean that they can fairly easily ope ordinate the raw system. This system is operationally feasible because the team is already trained on using the current system and so knows how the cricket game is scored. The only problem might be the level if computer literacy that the cricket team has, but because of the si mplicity of the system, the team will be able to ope set the system with very little training. at that placefore very in brief the team will be able to ope gait the systems efficiently and so this means that the system is operationally feasible. However a drug exploiter manual will be requireed, in order to provide the basic instructions on how to use the system. Schedule Feasibility Schedule feasibility looks at the time span needed to introduce the new system and whether after its introduction there will be enough time to learn how to use it and use it efficiently. The answer to this is very obvious.Due to the fact, that it will take very little time to set-up this system as the software and hardware is available immediately and the training needed to use the system is very small, so the system will be ready to use very quickly after it has been made. And so means that this project will be feasible, in terms of schedule. The team will be hoping that the system can be built as soon as come-at-able as the team is soon losing a lot of valuable time and would like to become more efficient as soon as possible. Investigation and Analysis.I started my investigation by offset printingly posing a questionnaire to the Ilford cricket group captain, Inam Arif. Questionnaire Question 1 I Are there any problems with the current system? YES/NO II If yes. Outline the problems below.Analysis of Questionnaire The interview that took place with the cricket team captain of Ilford cricket team, Inam Arif, on the eleventh of November, in which I posed the above questionnaire to him, was very helpful for both him and me.It made me aware of the look at specifications that my system will need, to maximise the benefit for Inam and his team. It was a very lucky interview as I do not now need a minuteary interview as all aspects of what I needed to know have been covered, however a contact number for Inam has been taken and if there are any further questions I can contact hi m to query him further. A copy of the answered questionnaire can be seen in the appendix. acknowledgement of the prospective user (s), and identification of users needs and acceptable limitations (using take over methods summarised as necessary).The prospective user of the system will be the team captain and the coach, the coach will use the system to analyse data from a match and pass the information to his captain to act upon it. The coach will need full access to the system because he will need to foreplay information into every part of the system. The captain will not need access into the system, because the coach will be verbally telling him actions to take, however if the captain does wish to see his teams position during the game, then he can be allowed view only access to the data, in a shortened form, with only the becharm data which he needs, set out for him.To work out what the needs and acceptable limitations are, I needed to do some investigation myself into the po ssible problems a cricket team could face I had to do some cricket analysis myself. From the interview, I knew that his team were in constant problems of not knowing where his team stood during a match and if they were going at the ask speed that they should be playing or if they had to change tactics to win the game. They did not know at any stage, if their run rate was at the required rate or if they had enough wickets in hand to start to attack or if they should defend.They withal did not know at what stage the otherwise team was at the same time, when they were batting or bowling. To work out these things, he and his coach were constantly doing manual calculations working out run rates, come up runs at individually stage of the game, and total wickets and plotting these on a graph. He said what they needed was a system where all they did was input the runs and the wickets taken each over and for a computer system to work out the run rates of each team and the total runs man hattan, and total wickets, and for the computer to output trio outputs in which they could tell these tierce things in the form of a graph.So to further decide on how I would go about implementing what Inam required. I decided to watch the Ilford cricket team play, I decided to keep score of the game and then analyse the game, working out such things as runs per over and runs needed for the other team etc. I discovered that I faced the following problems using this manual method 1. I had the problem of not knowing at any one stage of the game, which team was in a stronger position and what kind of particular each team was in, so it was not possible for the captains and the coach to change tactics etc. 2. Also mistakes were a constant problem.I kept making mistakes in calculations and not putting the right data where it belonged. 3. I could not analyse the scores very easily, as there was no other forms of presenting the data other than just simply reading score scores, there was no graphs etc. 4. I could not create interesting links between the data and make no comparison, as there was not sufficient information or presentation of data to do this. 5. I could not stop in the middle of the game and predict who was winning the game or who had a better chance of winning, I just knew at the end who had won and who had lost.6. The confirmation and validation of my work was very hard and time consuming, but was necessary to insure that everything was very stainless. 7. Also backing up data can be a very hard process, because it involves writing up everything or photocopying everything again, which is very time consuming and also means that if anything is wrong once then it is wrong again and all the time is spent on copying it is yearnd. 8. Also the writing can be worn out and can rub off leading to inaccurate results.All these problems just lead to uncertainties and errors in judgements and an inefficient use of time and resources, which can be stopped by the use of computers. From my enquiry I have concluded that the Ilford team need a system which can tell them the situation of each team at any certain stage during the match, so they need outputs which show the gain during certain stages of the game. In order to resolve all these problems, and looking at the best form of the effect for this problem I have decided to create a spreadsheet for the Ilford cricket team.So that the captain and the coach can easily predict things during a match and then accordingly change tactics and hopefully improve their game. There are many possible ways in which I can spirit my spreadsheet to meet the specific requirements for the Ilford cricket team. First I looked at the possible courses I could use to envision my answer just in case the spreadsheet was not my ideal solution. The programs that are available for me to design my system are 1. Microsoft Word This program is a very powerful word processor that allows you to create reports, letters, and other documents.I will not be using this because this program is for writing documents, and it is not intended for reckon data and making graphs and outcomes. 2. Microsoft PowerPoint This is a presentation program that can be used for presenting work and ideas. PowerPoint is able to show slides one after another, and make it into an animation that helps put ideas across better. It is not intended for construct my system, because it does not have the necessary tools 3. Microsoft outperform This is a spreadsheet that is very powerful at computing abstruse financial related calculations.It is mainly used for creating various kinds of graphs from inputted data. This program would be ideal for my project as my project included inputting complex data in to a spreadsheet and getting outcomes using complex calculations and also creating various graphs to show data in an easier to understand form. 4. Microsoft Access This program is a database, this means it was created to parentage vast amounts of data, which can be sorted and searched. This would not be a suitable program for intention my scoreboard as it does not carry out complex calculations nor does it create graphs. Justification of chosen solutionSo overall I have concluded that this task will need the use of a spreadsheet, a computer will be used as filing cabinets get old and rusty and they take up space where as the computer takes up less space and looks professional. Secondly it is not scant(p) to edit and store things on paper and filing cabinets where as the computer can store things neatly and efficiently, and also the data does not get misplaced. Finally its not easy to make backups of information on paper because it will require a lot of time and work, whereas on a computer it is much more time efficient and easy to make backup on a computer.Using a tape drive and/or any other form of storage. The spreadsheet will have minimal inputs and many outputs in order for me to work out outcomes/pred ictions and forecast the game to change tactics etc. This would be very useful to the team because their work will be cut substantially and they will need less labour to work on the score analysis, so it will cut costs. Using the spreadsheet program MS Excel I will be able to carry out my work more efficiently and accurately because it will organise my work.I will be able to insert rules into my spreadsheet, which will do all the calculations for me and therefore will leave me with no mistakes in calculations. Also MS Excel will create all graphs and outputs to forecast the game for me leaving me with no need to employ deft workers whom know how to make graphs. So overall it will be cost effective efficient and very productive to use the spreadsheet on a computer and go ahead with the project. A template of a scoreboard with all the appropriate formulas already inserted in the spreadsheet will be given to the coach.After the scores are input into the spreadsheet, the spreadsheet w ill automatically create graphs and tables to show progress and comparisons and analysis of the scores, for the coach to use and need to his captain in order to change his tactics to benefit his team. This problem to predict what happens abutting requires a method of forecasting which can be used in a spreadsheet by entering the formula in to next cells, which is related to the formula before. This can help to predict things, which can happen next by inputting a thing into one cell and looking at the outcome, and then predict what can happen next.This is done by finding the next number in the series from the results and the trends of the previous results. Also the spreadsheet can be used to predict if the predicted target is what the team achieved and if not what was the difference in them stretching this target. Using the spreadsheet you will be easily be able to see anticipated results and what actually happened and also be able to predict instantly what is happening in between a game and who is in the stronger position of the ii teams. This is all what is needed by a coach and captain of a team to improve his quality of work and also his tactics and hopefully win games.Data Flow plot Current System SYMBOL blusher = ENTITY = PROCESS = info FLOW FIGURE 1. 1 butt on Flowcharts Data Flow Diagram Proposed System SYMBOL tombstone = ENTITY = PROCESS = DATA FLOW = DATA STORE FIGURE 1. 2 Process Flowcharts Entity Relationship Diagram Current System SYMBOL KEY = ENTITY = ATTRIBUTES FIGURE 2. 1 File Structure Table Entity Relationship Diagram Proposed System SYMBOL KEY = ENTITY = ATTRIBUTES FIGURE 2. 2 File Structure Table Explanation of DFDs and E-R draws throw 1. 1 and hear 1. 2 both show data turn tail diagrams of the current and proposed systems.Figure 1. 1 shows the data flow diagram of the current system, it shows the processes and the data flows. Figure 1. 1 shows that the data source is the coach and the cricket scores, and it shows the term is t he cricket team captain and his team this is the same data source and destination for the proposed system DFD aswell. Figure 1. 1 shows that the cricket scores are received by the coach and are calculated manually, and then analysed and passed on to the team captain so he can change his teams tactics to try and win the game.Figure 1. 2 also shows that the coach receives the data from the cricket scores, but then inputs this data into the new system, which calculates and analyses the information for him and produces outputs, which he views and then tells his captain if his team are ok and should carry on doing what they are doing now, or they should change their tactics, the captain the relays his orders to his team, so that they succeed in the game. Figure 2. 1 shows the entity relationship diagram of the current system and figure 2.2 shows the entity relationship diagram of the proposed system, they are almost the same, there is a one to one relationship with the team and set of ba tting and set of bowling results. However fellow the proposed system able to output a set of results analysis, in the form of graphs etc. There is a third one to one relationship between the team and the set of cricket results analysis. Objectives of the report There are many objectives of the report. Successfully working system No bugs User friendly system Helps team to win more games Helps team to change statistics in the best way.Fufill the requirements of Inam Arif, the cricket team captain of Ilford Cricket Team. 1) The main aim is to find the best possible solution for the captain and the coach of the team. This meant that I had to make a spreadsheet which will find the predictive outcomes as accurate as possible the more accurate the better. The spreadsheet will also be the better if it is able to do more and more of the calculations needed for the spreadsheet for the user. 2) To put to death my aim I will use the most features available to me as possible to overcome my pro blem. 3) The solution I choose must(a) Predict the matchs outcomes efficiently, thus allowing the coach to gain an sagacity of the game, and hence change tactics to benefit his team. (b) Be easy to use, so that the coach does not waste time trying to work out how to use some parts of the program and so he/she can, quickly learn how to use it, and gain a better understanding of the match being play and enjoy it more. (c) Make the cricket team more efficient in their tactics during a match. This should mean that they play better and hopefully win more games. The trine outputs needed from the system in the end to make it successful should beA graph of the run rates per over, showing the run rate each over of the whole match. A scoring manhattan type graph showing the runs made each over and overall runs during the match. A graph showing the wickets taken during the match at what point in the match the team was losing the wickets. All the above objectives have to be covered, to make m y system a successful one. Design Overall System Design rendering of modular structure of system (not detailed algorithmic program design) Identification of suitable algorithms for data transformation (not detailed algorithm design).There are 3 worksheets and 3 graphs in total. The first worksheet has twain tables in it. The bowling first and batting first tables. The bet on worksheet has two tables in it aswell. The bowling second and batting second tables. The third worksheet has 3 tables, these are comparisons of Run rate per over, total runs, and total wickets between the two teams. The three graphs are outputs from the data in all three worksheets, the first graph is a graph showing the run rates per over for both teams, the second one shows the total runs for both teams, and the third one the total wickets for both teams.The tables in worksheet 1 are made out of formulae where you enter the runs per over and wickets per over, and the computer works out the rest of the dat a, i. e. the run rate per over, the number of wickets taken and total runs for you. The tables in worksheet 2 are made up of some data from worksheet 1. The batting second table has a target column and this is made from data in worksheet 1 showing total runs for the batting first team, because the batting second team must reach the total runs made by the batting first team. The third worksheet is made up of data from both the first and worksheets.The data for comparison of run rates per over, total runs and total wickets, are taken from the first two worksheets. The total runs and run rate per over figures are taken from the batting first and batting second tables. The total wickets figures are taken from the bowling first and bowling second tables. All this data is joined using macros into worksheet 3 and then sheet 3 is used to output the 3 graphs. The data from the three comparison tables in worksheet 3 is used to create the three graphs. Below a illustrated version of how the w orksheets and graphs are linked is shown.Figure 3. 1 Symbol Key = Worksheet = Table = Graph = think between the tables = Links between the tables and the graphs Definition of data requirements, such as input and output data types and formats Data types were numbrs, ouputs r graphs, etc. Identification of appropriate storage media and format Print outs, hard disk and floppy Identification of any validation required Sample of data validation, illustrating the operation of error messages Maximum figures, screen shots of the validation, and outlawed data. User interface design including input / output forms and reports.Inputs-runs per over, and wickets per over, and overs happened. Input forms sheet 1 and sheet 2 3 colums each Sheet 3 all done formulae And outputs r graph 1 2 3.. Run rates per over Total runs Wickets Good HCI design Considers The User type of use and setting e. g. business or home User needs/Usability Input/output devices choice of and appropriateness of Dialogue s to be relevant, simple and clear Colour use of and colour combinations Icon usage and presentation 3D personal effects and depth perception Provides Feedback Exits clearly marked On-line help Shortcuts Helpful error messages.Prevents errors occurring Minimises the amount the user has to remember Sample of planned data capture and entry Data capture in to the sheets,on the comp straight, and if bak up needed, then scores written on paper in this data form. but input later,then calculated. Description of record or database structures Screenshots of the records of each cell, properties etc. Sample of planned valid output The three graphs. three outputs. File organisation and processing forgot Database design including E-R model Entity relationship diagram Description of measures planned for security and integrity of dataDescription of measures planned for system security (access control) Security, passwords etc Overall test Strategy conk down, bottom up Black-box testing. White- box testing. Identify suitable test strategies and select and document suitable test data. unit of measurement testing, Integration testing, System testing, Acceptance testing. Test solution and document the results of testing. Technical Solution Write up and discussion of technical solution could refer to other sections Copies of code listings (preferably in the appendix) Details of software adapt (evidence may be in the systems maintenance section).System Maintenance Develop and document a solution for maintainability. For maintainability a solution should be evaluated in terms of the ease with which it can be corrected if an error is encountered, adapted if its environment changes, or enhanced if customer changes requirements. Use my project to make a keep on how to maintain this thing. System Testing Use wat I made in excel to test in the testing thing. User Documentation Talk about how to use the system. Appraisal Evalutation of the objectives outlines b4 Sheryar Majid 13D/C O 28/04/07.