FOUNDATION DEGREE IN ICT

(UNIVERSITY OF CHESTER)

 

 

Student Number:

Andrew Jones

 

Module:

CO5041

Systems Analysis and Design

 

Module Tutor:

 

Heather Sharrock

Delivering College:

 

Mid-Cheshire College

 

Assessment Number and Title:

 

   ASSIGNMENT 1

 

 

Overview:

  • Assignment covers some or all of the learning outcomes (L.O.) 1-5
  • The assessment method for this module has been split into two to spread student workload.  However, the method of assessment is a single assignment worth 100%.
  • Refer to Module Descriptor for further details

 

Due Date:

 

 

Submitted:

 

Assessor:

 

 

Mark awarded (re MAB):

 

IV assessor:

 

 

 

 

 

 

 

Assessment

 

 

 %

Task 1

Methodical & Planned Approach (LO 4)

 

·         Produce a Gantt Chart to cover all stages of the systems lifecycle for either of the Scenario’s A or B

 

·         Additional marks will be awarded for multi-level tasks, dependencies, critical path & resources

 

10

Task 2

Systems Analysis (LO2, 3)

 

·         Prepare and conduct an  interview on Scenario A

·         In your group design a suitable interview template. 

·         Submit the completed interview template plus your own individual Interview/Meeting Notes from the interview.

 

 

 

 

 

10

Task 3

Systems Analysis (LO2, 3)

 

·         Produce a Feasibility Report for Scenario A and B

·         Each Report should be a single A4 page

·         Include terms of reference, scope (boundaries, constraints), current system, user requirements, possible solutions, costs, benefits, recommendation.

 

 

 

 

20


Gantt Chart


Critical Path Analysis


Systems Analysis

Interview Questions

Interviewee: Liam Bentley, Head of Year

Interviewer: Andrew Jones

Interview Date: 03/12/2009

Interview Location: Handbridge College

Opening

Thank you for agreeing to see me. Hello my name is Andrew Jones and I’m here to interview you about the schools UCAS Application Management System. The interview hopes to cover 10 areas and comprises about 25 questions. If there are any questions that you do not wish to answer or would like more time to answer please let me know. Again, if at any time you feel you would like to stop the interview please feel free to do so.

Background

How many pupils are there in years 10, 11 and 12?

About 300 per year group

Why not move, straight, to the web based system?

We first want a working system that will do the job. We are not geared up for a web based system.

Current System

What happens currently?

The current system is a paper based system, within which the pupils are arranged alphabetically as they complete their application forms and personal statements.

It is a manual based physically managed system, and as such individual students’ records can be misfiled or mixed up with other records.

How many years has the current system been running?

Mr Bentley has been in position for the last five years and the system was already in place when he arrived. At least 6 years.

What do you value most in the current system?

The current system contains all of the information pertaining to the students; it contains all the universities and incorporates the students’ personal statements.

Its’ principle downside is that it is just not readily accessible.

Problems

How long does it take to complete a personal statement?

The personal statements are completed by the students; the head of year only guides and reviews them.

How many people will have access to the system?

Just the head of year in this instance, in future it be that the solution is networked.

Would they be happy using password and user names as security?

Yes, also feel that we should advise on the general and specific levels of security.

What happens to the “Extra” students?

It may be useful in the future to track non university applications

Possible Solutions

What are the most important areas for the new system to deliver to be considered as successful?

Weekly reports: detailing the overall progress of the students.

That the process be straight forwards to use.

What degree of training do think would be appropriate?

Mr Bentley considers himself to be computer literate so feels that: “a short run through” with a good user guide, a detailed help file, about ½ days training and telephone support would be adequate.

Scope

What budgetary resources are available for the project?

The total available for the project is £10,000. This figure is to include everything: hardware, software, the system it’s self and training.

How big do you want the system to be?

A standalone single user access system is all that is required.

Would the web based system be fully internet compatible?

Question not asked

Requirements

Are the reports paper or screen and print?

Both, Mr Bentley would like to review them on screen and print them as required for filing, presentations and the like.

How long do you think the project will take?

In total six months from now.

What do you want most from the system?

The reporting features are the most wanted thing from the new system

What information do you need from the new system that you do not have currently?

None, the current system contains all the information; it’s just not readily accessible.

User requirements

What do you feel are the key or core user requirements?

Question not asked.

Costs

Question not asked.

Benefits

What are, as you see them the core benefits of moving to a new system?

More reliable; and, less time consuming.

Recommendations

Question not asked

What would you recommend as a solution to the UCAS application system?

Question not asked.

Close

Thank you very much for your time and the answers you have provided. The information will be used in the preparation of a feasibility report for the UCAS Application Management System. We can provide a copy of the completed interview if you require it. Do you have any questions for me?


Terms of Reference

The Head of Sixth form will act as the client and we will act as the developer, weekly meetings will ensure that the project runs to schedule and that the requirements detailed in the Requirements Specification are met. The project will be considered successful when all of the Requirement Specification is fully met.

Scope

For the project we will produce a database that will hold all of the students’ details, their personal statements and the details of their university applications progress. The database will produce both adhoc and weekly reports on a number of topics; these are detailed in the Requirements Specification.

The entire project must be completed within 6 months and cost no more than £10,000

Current system

The current system is a paper based system that holds details of all of the students, their personal statements and the university applications that they have made together with the details of offers from the universities. The current system is considered cumbersome as it does not lend itself to reporting and occasionally pupils’ details are mis-filed.

User requirements

A system that is easy to use and lends itself to reporting on all details of the students, list students who have yet to complete their personal statements, details of students yet to apply to university, provide a full listing of university applicants, together with details of offers made to students and details of students yet to receive an offer.

Possible solutions

There are a number of possible solutions to the problem of the schools UCAS Application Management System, these include the procurement of an off the shelf package, the hiring of a developer to create bespoke software, the opportunity of outsourcing the entire process, or the customisation of a Microsoft Access database.

Costs

The overall budget for the project is £10,000 which has to cover all of the one off costs: software and hardware, and any reoccurring costs involved in the project.

Benefits

A computerised database would ensure that the clients reporting needs are met and eliminate the mis-filing and other errors that currently occur. The implementation would improve data handling accuracy and lead to time savings for the client. It would also provide timely warnings when students’ applications are likely to miss the cut-off date.

Recommendations

We recommend that the Head of Sixth Form agree to the proposal for the implementation of a customisation of a Microsoft Access database for the schools UCAS Application Management System. Because it is the most cost effective, technically uncomplicated solution which can be almost immediately implemented, it also capitalises on the clients’ current familiarity with other Microsoft Office applications.

Terms of Reference

The Head of Years 10, 11 and 12 will act as the client and we will act as the developer, weekly meetings will ensure that the project runs to schedule and that the requirements detailed in the Requirements Specification are met. The project will be considered successful when all of the Requirement Specification is fully met.

Scope

For the project we will produce a database that will hold all of the students’ details, details of the employers, the start and end dates of placements and contact information. The database will produce both adhoc and weekly reports on a number of topics; these are detailed in the Requirements Specification.

The entire project would be expected to complete within 6 months and cost approximately £10,000

Current System

The current system is a paper based manual system that has grown overtime to become a lumbering behemoth; managing approximately 600 students and has grown to be a full time management role. The system often misses contact details and letters of thanks to the employers for participating

User Requirements

The system must produce details of students who will not be present during the week of their placement. Placements start and end dates, contact details for the placement mentor, list of students yet to find a placement, letters sent to employers and students detailing placement arrangements, letters of thanks to employers and details of contact e.g. dates of visits or dates of phone calls.

Possible Solutions

There are a number of possible solutions to the problem of the schools Work Experience Placement Management System, these include the procurement of an off the shelf package, the hiring of a developer to create bespoke software, the opportunity of outsourcing the entire process, or the customisation of a Microsoft Access database.

Costs

It is envisaged that a budget of £10,000 would cover development of the database management system, software and hardware for the project, the one off costs and cover any reoccurring costs that may be accrued.

Benefits

A computerised database would ensure that the clients reporting needs are met and eliminate the mis-filing and other errors that currently occur. The implementation would improve data handling accuracy and lead to considerable time savings for the client. It would also provide timely warnings when students’ have failed to find a work placement, together with ensuring that all employers receive a letter thanking them for their participation.

Recommendations

We recommend that the Heads of Years 10, 11 and 12 agree to the proposal for the implementation of a customisation of a Microsoft Access database for the schools Work Placement Management System. Because it is the most cost effective, technically uncomplicated solution which can be almost immediately implemented, it also capitalises on the clients’ current familiarity with other Microsoft Office applications.


Appendix A

Interview Questionnaire Template

Systems Analysis

Interview Questions

Interviewee:

Interviewer:

Interview Date:

Interview Location:

 

Opening

Thank you for agreeing to see me. Hello my name is Andrew Jones and I’m here to interview you about the schools UCAS Application Management System. The interview hopes to cover 10 areas and comprises about 25 questions. If there are any questions that you do not wish to answer or would like more time to answer please let me know. Again, if at any time you feel you would like to stop the interview please feel free to do so.

Background

How many pupils are there in years 10, 11 and 12?

 

 

 

 

 

 

 

 

Why not move, straight, to the web based system?

 

 

 

 

 

 

 

Current System

What happens currently?

 

 

 

 

 

 

 

How many years has the current system been running?

 

 

 

 

 

 

 

What do you value most in the current system?

 

 

 

 

 

 

 

Problems

How long does it take to complete a personal statement?

 

 

 

 

 

 

 

How many people will have access to the system?

 

 

 

 

 

 

 

Would they be happy using password and user names as security?

 

 

 

 

 

 

 

What happens to the “Extra” students?

 

 

 

 

 

 

 

Possible Solutions

What are the most important areas for the new system to deliver to be considered as successful?

 

 

 

 

 

 

 

What degree of training do think would be appropriate?

 

 

 

 

 

 

 

Scope

What budgetary resources are available for the project?

 

 

 

 

 

 

 

How big do you want the system to be?

 

 

 

 

 

 

 

Would the web based system be fully internet compatible?

 

 

 

 

 

 

 

Requirements

Are the reports paper or screen and print?

 

 

 

 

 

 

 

How long do you think the project will take?

 

 

 

 

 

 

 

What do you want most from the system?

 

 

 

 

 

 

 

What information do you need from the new system that you do not have currently?

 

 

 

 

 

 

 

User requirements

What do you feel are the key or core user requirements?

 

 

 

 

 

 

 

Costs

 

 

 

 

 

 

 

Benefits

What are, as you see them the core benefits of moving to a new system?

 

 

 

 

 

 

 

Recommendations

 

 

 

 

 

 

 

What would you recommend as a solution to the UCAS application system?

 

 

 

 

 

 

 

Close

Thank you very much for your time and the answers you have provided. The information will be used in the preparation of a feasibility report for the UCAS Application Management System. We can provide a copy of the completed interview if you require it. Do you have any questions for me?