• 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...


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.


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.


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. Creating a computer system.

    * Excel has sophisticated report facilities with the ability to format text, set margins and page layout, import a company logo and preview before printing. * Using Excel for my system will mean that I can customise menus and toolbars.

  2. System requirements analysis

    For example you can cut and paste lots of things from paint and you can also colour them in and design your own buttons etc. Also Paint is a very common software on many computers and this meant that I could use it on most computers and also Paint is

  1. I will be analysing the problems defined by the management in the old system ...

    * Integration with Windows Explorer lets the user use many common Norton AntiVirus functions from the Explorer menus for easy access. The next software required is Microsoft Internet Explorer 6.0.2600.0000. This is the latest version of the world-famous internet browser and it offers problem-free browsing.

  2. I.T. System for a Newsagents

    be fully compatible with my client Computer as I checked all the system files in their CPU. I have to also install Microsoft excels on his computer as his computer only came with Microsoft word, works, money and autoroute. My targets are benefit both of us, me by being successful

  1. Database management

    Text Variable A Level Subjects Taught Text Variable Physics Subjects Taught (2) Text Variable Maths Picture OLE Object Bitmap Image - Validation Rules: Field Name Validation Rule Validation Text Rate Of Pay <50 "Only a value less than 50 can be entered.

  2. Excel user guide

    A Percentage bar chart is very similar to a component bar chart. The procedures are the same but instead the stacks represent 100% and the components change proportionately within the bar. Below I have a set of data showing the value of output per worker in three different countries.

  1. Create an IT system for my karate club.

    If there is a competition or a special karate event coming up, the Sensei simply announces it in a class and if a person is not present they are not aware of any competition or special event and therefore miss it.

  2. Main aims and functions of Buckingham Bingo.

    * If a customer has a problem an item of food etc. a member has to deal with it until the customer is satisfied. Bar * The main function of this department is to supply the customers with alcohol, snacks and cold drinks.

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