Information Systems Analysis and Design: Allsports Club System

This report details the development of an information system for the Allsports Sports Club, addressing operational challenges faced by the club president in managing member information and the weekly newsletter. The report begins by outlining the chosen Agile methodology and justifying its selection for the project. It then specifies the primary and non-functional system requirements, followed by a cost-benefit analysis demonstrating the project's financial viability. A detailed project schedule, including a Work Breakdown Structure and Gantt chart, is presented to illustrate the project timeline. Furthermore, the report explores system information requirement investigation techniques, identifying key stakeholders and the usefulness of various investigation methods. The report concludes with reflections on the chosen methodology and the project's overall feasibility.

COT20248
:
Informatio
n System
Analysis
and Design
August 20
2017
Allsports
Sports Club
System
Development

Allsports Sports Club System Development
COIT 20248: Information Systems Analysis and Design
Term 2, 2017
Assessment 1 - Systems Development
Lecturer: Lecturer Name
Tutor: Tutor Name
Prepared by:
Student Name
Student Number

Allsports Sports Club System Development
Table of Contents
1. Introduction.......................................................................................................................................1
2. Approach to Systems Development..................................................................................................2
Approach to rectify existing system...................................................................................................2
Justification for chosen approach of system development...............................................................2
3. Systems Requirements......................................................................................................................3
Primary required functions to develop Allsports Sports Club System...............................................3
Non-functional requirements to develop Allsports Sports Club System............................................3
4. Project Cost Benefit Analysis.............................................................................................................4
5. Project Schedule................................................................................................................................5
6. System Information Requirement Investigation Techniques.............................................................7
Stakeholders......................................................................................................................................7
Investigation techniques and its usefulness......................................................................................7
7. Reflections and Conclusions..............................................................................................................8
8. References.........................................................................................................................................9
List of Tables
Table 1: Project Allsports Sports Club System Development – Cost Benefit Analysis............................4
List of Figures
FIGURE 1: Work Breakdown Structure..................................................................................................5
FIGURE 2: Gantt chart............................................................................................................................6

Allsports Sports Club System Development
1. Introduction
Allsports Sports Club is a place where many outdoor games like cricket, football and even
athletics are conducted along with some indoor games like table tennis and others. The club
is very much popular in the vicinity. There are many thousand members of the club who
comes to play these games on daily basis. A weekly newsletter is being released here on
every Wednesday with articles on sports and few advertisement of outside business. The
hitch is the release of this newsletter which is being supervised by Club President.
The main objective of the report is to solve few technical and operational issues being faced
by Club president on daily life to release the newsletter on timely basis. For which the owner
has awarded us the contract to provide the solution.
Page 1

Allsports Sports Club System Development
2. Approach to Systems Development
Approach to rectify existing system
For the releasing of newsletter on every Wednesday, it is the duty of editor to collect and
publish the articles based on the sports activities happened till last Saturday and moreover
every week the editor need to change and every member need to be given equal
opportunity of becoming the editor. But it remains the responsibility of Club president to
see that all the members are getting equal chance. President is having only the word and
spreadsheet as the software to manage the information related to many thousand
members. President had to face many issues on daily basis to manage such big database.
Few issues are listed below:
Who among the members not commented on any article or newsletter
He members who has not yet ever got chance to become editor
Who all are the members who has not provided article even once
The list of members with no e-mail id registered
So maintaining these information in spreadsheet needs vigorous and accurate filtering and
maintain such dynamic information where every day the activities or the database need to
be updated then only the next course of action can be finalised. So in such dynamic situation
where daily there are comments and the whole system requirements changes accordingly
the only methodology which fits in this situation is the Agile methodology of developing the
system.
Justification for chosen approach of system development
The selected method that is Agile methodology for developing the information system of
Allsports Sports Club is the best approach because it is a people centric project where every
moment some comments need to be updated an again modify the system to generate the
desired result (McLaughlin, 2017). So the merits of this methodology can be used with for
below betterment of the system are:
The sutomated system can be used to store an manage all the information
related to thousands of stakeholders
This methodology is the best option for this kind of changing conditions
So Agile methodology option is the best approach to develop the desired system
Page 2

Allsports Sports Club System Development
3. Systems Requirements
Primary required functions to develop Allsports Sports Club System
The primary required functions required to develop Allsports Sports Club System are:
Unique registration ID is must for all users: so that the users who all are
logging and for long they are logged in can be tracked, so that the exact work
hours can be defined for the staffs to develop the publication.
Verification of users: need to be done to prevent entry of any unwanted
person in to the system and all the personal data shall remain intact.
System must be accessible from all locations: so that members need not
come to club physically for writing the articles and they can sit anywhere and
write it, even after writing either they can upload in the system or e-mail to
editor for further action.
Proper functioning of the large database: is must to show desirable
information.
Window view wise access: is required to be provided depending on the
person. The administrative access must be available with Club President to
enable access to all folders.
Generation of proper notification and follow-up system: is required for timely
releasing of newsletter
Always show pending tasks for the week: for developing the newsletter on
time
Highlight next week’s editor name from 1 week before itself: to help club
president in communicating with him well in advance
Common format of newsletter: need to be maintained to save last minute
run for the format arrangement
Non-functional requirements to develop Allsports Sports Club System
The non-functional requirements for developing Allsports Sports Club System are:
Secured enough: the system need to installed good quality firewalls to
prevent from any probable attack and preserve the information related to
users.
Accessible from all devices: to provide flexibility to users and ease of
developing the articles
System must be well understandable: for proper optimum use of the
software.
Page 3

Allsports Sports Club System Development
4. Project Cost Benefit Analysis
As per (Wrike, 2017) the cost benefit analysis in the field of project management is a great
tool which can provide information regarding the comparison between the investment
made Vs the benefits incurred due to the investment. In this technique, all the expenditures
are calculated together and arranged in time phase manner, then similarly the profits or
benefits are also calculated and tabulated (refer table 1). Then the difference between both
the expenditures and the benefits can provide NPV (Net present value), IRR (Internal rate of
Return), ROI (Return on Investment) and Pay-back period. The more NPV, IRR & ROI are
positive and the less Pay-back period is good for the project and is advisable for investment.
As observed in table 1, NPV = $ 25,044, ROI= 21.46% and Pay-Back period = 3.48 years. The
investment is advisable.
Table 1: Project Allsports Sports Club System Development – Cost Benefit Analysis
Cost-Benefit Analysis
0 1 2 3 4 5 TOTALS
Net cost benefit -$ 25,500$ 36,000$ 36,000$ 36,000$ 36,000$
Discount Rate 6% 100% 94.34% 89.00% 83.96% 79.21% 74.73%
Pv Of Benefits -$ 24,057$ 32,040$ 30,226$ 28,515$ 26,901$
NPV of all BENEFITS $0 24,057$ 56,096$ 86,323$ 114,838$ 141,739$ 141,739$
One Time Costs 60,000$
Maintenance Cost -$ 10,200$ 14,400$ 14,400$ 14,400$ 14,400$
Discount Rate 6% 100% 94.34% 89.00% 83.96% 79.21% 74.73%
Pv Of Maintenance Costs -$ 9,623$ 12,816$ 12,091$ 11,406$ 10,761$
NPV Of All Expenditures 60,000 69,623$ 82,439$ 94,529$ 105,935$ 116,696$ 116,696$
Overall NPV 25,044$
Overall ROI = (Overall NPV / NPV Of All Costs) = 21.46%
Break-Even Analysis
Yearly NPV Cash Flow -$ 14,434$ 19,224$ 18,136$ 17,109$ 16,141$
Overall NPV Cash Flow 60,000$ (45,566)$ (26,342)$ (8,206)$ 8,903$ 25,044$
Project break-even occurs between the year 3 and 4
Use 1st year of +ve cash flow to calculate break-even fraction (17,109-8,903)/17,109= 0.48
Actual Break even at 3.48 years
Year of Project
Project Allsports Sports Club System Development – Cost Benefit Analysis
Page 4

Allsports Sports Club System Development
5. Project Schedule
FIGURE 1: Work Breakdown Structure
WBS or the Work Breakdown Structure is a hierarchical structure being developed to
breakdown the total scope of work to a meaningful level which can be tracked and
controlled easily and supervised (Gordon and McDonough, 2016). This tool is mainly useful
for the senior management or the project sponsor to look at the progress of the project at a
single sheet. So here the total scope of system development is divided in the project
management processes, that is ‘Initiation’, ‘Planning’, ‘Execution’ and ‘Closing’. Then in next
stage these levels are further divided in to work activity level.
On the basis of this developed WBS, further scheduling is done to develop Gantt chart (refer
figure 2) for detail.
Page 5

Allsports Sports Club System Development
FIGURE 2: Gantt chart
Now once the Gantt chart is developed, we can observe that there are merely 4 activities out of
critical path, so the whole schedule is almost critical and all the activities need to be controlled
properly to void any delay in the overall duration of the project. The total project duration is 3.5
months.
Page 6

Allsports Sports Club System Development
6. System Information Requirement Investigation Techniques
Stakeholders
The people who are anyways related to the project’s success or failure or can influence are
known as the stakeholders of the project (Miller, 2017). Majorly the stakeholders can be sub
divided in two parts; one is ‘Internal Stakeholders’ and the other ‘External Stakeholder’.
Internal Stakeholders External Stakeholders
Owner Consultant
Club president Advertisers
Member Local authorities
Club Staff
Investigation techniques and its usefulness
The investigation techniques are required for proper tracking and confirming the process
involved in the project life cycle are running well and the product shall be delivered well
within time and budgeted cost.
Three types of investigation techniques are:
Audit of document and processes: this is the technique where the documents and the
processes of projects are being checked thoroughly to find any lacunas; the audit is also
scheduled at regular interval to check the system correctness and for further improvement
too.
This method is useful for the system development, as we are using Agile methodology and
after some point of time Agile has a tendency to run out of budget if not checked at every
step.
Interview of individuals: it is the process of obtaining correct and unbiased information
regarding the project progress or some issues. Here one to one interview is conducted with
some pre- set questionnaires.
It is useful for the system because the questionnaires are set by some expert in the same
field and the collection of unbiased response can really help in finding any issue or the rrot
cause.
Discussion by organising a meeting: it is the organised official meeting being conducted
between the subject experts to provide their point of view and then other can debate and
after some pint of time the team of experts can reach to a common and best consensus.
It is very much useful if the participants have good exposure of the topic of discussion.
Page 7

Allsports Sports Club System Development
7. Reflections and Conclusions
The chosen methodology of the system development procedure is the real achievement of
the report, as Agile can be the best fit for the type of project it is. Moreover, the
investigation techniques are very strong so that each step can be verified well before
providing further.
Currently there is no constraint, but the budget can be constraints after some progress of
the project, since Agile has a tendency to overshoot the budget due to continuous
development and a clear budget cannot be finalised at very beginning of the project.
It is to conclude that the schedule time and budget as o now seems to be achievable and the
project is very much beneficial at this point.
Page 8

Allsports Sports Club System Development
8. References
Gordon, Ann and Michele McDonough. 2016. What is a Work Breakdown Structure? [online].
[Accessed 20 August 2017]. Available from World Wide Web: < HYPERLINK
"http://www.brighthubpm.com/templates-forms/2645-what-is-a-work-breakdown-structure/"
http://www.brighthubpm.com/templates-forms/2645-what-is-a-work-breakdown-structure/ >
McLaughlin, Mike. 2017. What Is Agile Methodology? [online]. [Accessed 20 August 2017]. Available
from World Wide Web: < HYPERLINK "https://www.versionone.com/agile-101/agile-
methodologies/" https://www.versionone.com/agile-101/agile-methodologies/ >
Miller, Mike. 2017. Project Stakeholders: Definition, Role & Identification. [online]. [Accessed 20
August 2017]. Available from World Wide Web: < HYPERLINK
"http://study.com/academy/lesson/project-stakeholders-definition-role-identification.html"
http://study.com/academy/lesson/project-stakeholders-definition-role-identification.html >
Wrike. 2017. What is Cost Benefit Analysis in Project Management? [online]. [Accessed 20 August
2017]. Available from World Wide Web: < HYPERLINK "https://www.wrike.com/project-
management-guide/faq/what-is-cost-benefit-analysis-in-project-management/"
https://www.wrike.com/project-management-guide/faq/what-is-cost-benefit-analysis-in-project-
management/ >
Page 9