To find out what the best solutions will be for Westwood Hockey Club’s systems, in a group we investigated the requirements for each type of system and we documented these sources of information.
A system to store and process club members’ records
For this research I found a spreadsheet for Bamber Bridge United Junior Football Club’s member records from Ross the manager. This is how the club keep track of all their members and their details. It has columns for Name (for which the surnames have been deleted for privacy), Phone Number, Email Address, Address and Comments.
It is useful that it stores information such as Phone Numbers and Email Addresses because then the club will have ways of contacting parents if there is a need to. The Comments column is also very handy as it includes things that may affect the children health wise (e.g. Asthma) and arrangements made in regards to their safety. It is set out in a simple organised way which is easy to read but it lacks some information that could be helpful. For example the Age of the children could be added; which team they belong to (e.g. Under 10s); Parents’ Names and when they attend club meetings if there is different days to go. This would make the club more organised and it would make it easier for them to run.
Although for the most part the spreadsheet serves its purpose, the information could be better stored in a database as databases have certain features that are valuable for storing this information that spreadsheets don’t have (e.g. An ID Key automatically assigned to each member which would be beneficial for sorting it).
Person M interviewed Ross the manager for BBUJFC about the spreadsheet he created that is shown above which he kindly gave me a copy of. The interview shows what Ross, who has to use the spreadsheet, thinks about it and also why he decided to store it that way. This source gives greater insight into the spreadsheet.
Ross finds that the spreadsheet is useful