My objectives are to keep track of the financial details of my football team using a database.
GCSE Coursework for <<Tim Vague >>
Project Title: <<Spreadsheet Project>>
Black writing is the headings that you must use for your write up.
Red writing is here to advise you and so can be deleted if you are certain that you have fulfilled the requirement.
- Identify
- Background to the problem and end user
For my project I am going to do a spreadsheet on the transfer details of a football club. I will use the spreadsheet to keep track of what players the club buys and sells and what sort of profit they make. The club needed help in keeping track of all their financial details and how much they are getting from selling players, and how much they are losing in buying players. This is why I am doing this spreadsheet. One sheet will be on the squad and what players they have bought to the club and the profits according. Another sheet will be what players the club has sold and the profits according. The third sheet will be on the total money the club has gained/lost in transfers.
- Possible alternative solutions
There is more than one way of keeping track of financial details like expenditure and profit. You can do a spreadsheet either by hand or on computer, you could use things like an account book as well. I could use word on the computer as well by making a table and keeping the financial details there. These solutions are all well and good but using the computer and Microsoft excel is the best solution as I can do all the calculations on the computer where as doing it manually I would have to work out all the calculations myself and it would be very time consuming.
- Objectives/End user requirements
My objectives are to keep track of the financial details of my football team. I will try to keep track of all the money spent on the players, all the money received from the sales of the players and then to calculate the profit.
- Analyse
- Choice and justification of software
Microsoft Excel is a spreadsheet program and this is the program I will be using. It will allow me to do calculations in the program so I can take the amount I bought the players for away from the amount I sold the players for to give me my profit. I can also make buttons which when I click them can take me to another page. This can be very useful. I could also use word – a word processing program, to keep my data in. This would be quite good but it would not be as good or as easy to use as excel would be. I could create a table in word to keep the data in but I would have to do all the calculations manually and then fill them in myself. In excel I can add all the data or subtract or do whatever calculation is needed in the program and it is so easy. I can fill in data on any cell on the spreadsheet and then add, subtract, divide or multiply them and get the result to appear in a cell that I have selected. Excel has everything I need for this project.
