• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

Renaissance Choir Finance Management System

Extracts from this document...

Introduction

Renaissance Choir Finance Management System Introduction I will be making a system for the accounts of Renaissance Choir. Renaissance Choir are based in Emsworth and have 29 members. They sing at many events throughout the year and sometimes in Chichester Cathedral. They meet weekly. Statement of Problem Renaissance Choir require a system to manage their finances. It must be flexible and easy to use, so that anyone could come along and use it, without previous knowledge. Schedule of Activities Section Weeks Specification 1.5 Implementation 3 Testing 1.5 Evaluation 1 User Documentation 1 Total 8 Background The current system is based on two books containing input and output for the choir. All entries are written into the book by hand, and the books have to be carried to meetings when necessary and this is not very convenient, and rather slow. A computerised system would be more efficient. The system needs to deal with petty cash, as a constant amount is usually kept as a float or for occasions where cash is required and not a cheque or other method of payment. ...read more.

Middle

This has given me much background and other useful information, that can be used to help produce the system. Volume of Data The system will be updated on a weekly basis, so it must be relatively easy to add, delete and change records, as it will be used so frequently. However, cheques need to be paid in at random intervals, and the system will need to recalculate totals and other formulae after each of these events. It must also be able to cope with petty cash, which can fluctuate. Problems with the Current System Problems with the current system are its inability to transfer data easily between the two books and the balance sheet, the fact that it is slow and rather inefficient, due to having two heavy books to carry around. Hardware Full Potential To get good performance from the system, the requirements would be: 200 MHz processor speed 16 MB Ram 16 Bit colour graphics or better Software Full Potential The features of Excel that I will use to create the system are: macros, buttons and controls, formulae, charts, pivot table reports, visual basic, linked workbooks and Input and Output The user will enter data every week. ...read more.

Conclusion

Also, anything that shouldn't be altered (e.g. integral system parts) will be protected to prevent alteration. There will be macros to do things like moving between sheets and adding records. Objectives to Perform My end user wants the system to be able to: * Hold both income and expenditure in one place * Cope with petty cash that is used for floats at events and other purposes * Be able to transfer data between sections easily * Produce graphs and charts of the data * Produce summaries of the data Performance Indicators * Must be able to open relatively quickly, even on lower spec machines * Must be able to contain a large volume of data while still retaining a file size below 100 kilobytes * It must be relatively easy and quick to enter data or perform other operations * It must be relatively difficult to make mistakes while entering data (using drop-down lists, buttons, macros etc) * It must be easy to get to specific sections * It must be foolproof- e.g. impossible to alter critical system aspects * It must be possible to alter the structure of the database when necessary * * * * ?? ?? ?? ?? John Morgan ...read more.

The above preview is unformatted text

This student written piece of work is one of many that can be found in our GCSE ICT Systems and Application section.

Found what you're looking for?

  • Start learning 29% faster today
  • 150,000+ documents available
  • Just £6.99 a month

Not the one? Search for your essay title...
  • Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

See related essaysSee related essays

Related GCSE ICT Systems and Application essays

  1. System requirements analysis

    the data gets destroyed or lost by the system then the second computer can be used. The doctors, nurses and the receptionists of the hospital can only view the system. Each one of these members has their own account login and password and they can only view the files that are relevant to them.

  2. drum kit costing system

    Observation I went to Drum Gurus to see for myself how the old system works. As I suspected, the system performed poorly and was slow at loading prices. They recently set up a website which is an improvement on the manual system he used to use, but it is still not sufficient.

  1. Excel user guide

    Below I have a set of data showing the value of output per worker in three different countries. 1992 1996 2000 France 128 120 118 Germany 108 109 109 Japan 103 106 97 Once you have inputted data in the spreadsheets highlight the data and click on the bar chart icon as you did for the simple bar chart.

  2. Creating a computer system for Divine foods

    Amount of data Mrs. Rachel currently has about twenty customers, and she constantly produces about ten different kinds of products. Her customers are constantly ordering these products. Therefore this new system will hold all these information. Record keeping This new system will be able to hold all her customers details, her product details, and all the orders been made by her customers.

  1. Creating a computer system.

    I will be required to generate a number of ideas relating each idea to the targets set out in the analysis. I will need to state how this design meets the targets and how they can be achieved. I must take into account the structure of the current system and ways I can improve it.

  2. Main aims and functions of Buckingham Bingo.

    to do a stock check and then re-order if he has too. * The money is then totalled up and handed in to the cash office. Floor * This is where most of the money is made. This department is split into four sections which are; the cash desk; the

  1. Creating an IT system for Rileys an American pool and snooker hall.

    be much easier if the data was stored in a database on a computer making it easier and secure to store members personal information, giving each member of staff a password for each time they access the information, it will also not take up much space.

  2. Adam Property Maintenance - System analysis.

    example: * Can be expensive * Node failure breaks transmission * Expansion is difficult * Unidirectional Transmission APM have a network which allows users to log on through a Windows 2000 platform with different user levels for security and data protection reasons.

  • Over 160,000 pieces
    of student written work
  • Annotated by
    experienced teachers
  • Ideas and feedback to
    improve your own work