• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month
  1. 1
  2. 2
  3. 3
  4. 4
  5. 5
  6. 6
  7. 7
  8. 8
  9. 9
  10. 10
  11. 11
  12. 12
  13. 13
  14. 14
  • Level: GCSE
  • Subject: ICT
  • Word count: 3866

Financial Model to help organise the year eleven prom

Extracts from this document...


Financial Model to help organise the year eleven prom Introduction Every year, the Chafford School has a school prom. This year however, the Prom committee has decided that that they want the cheapest and most efficient hall, catering, decorations and music (a D.J) from previous years. Nevertheless they have encountered numerous problems. Problems To find out more about problems, that the prom committee was suffering from. I decided to interrogate a member of the prom committee to find out problems that they were suffering from, so I then could begin to lighten their problems and further their achievement and arrival of the prom (Appendix A). * They would like to have a variety of choices, but unfortunately due to the low budget they haven't got a choice, and up to yet it looks like they are going to have to use last years hall * At the moment only one student has access to the information, which cause a problem when she is not in. Also other pupils only get to see the information when at meetings. The problem is, not enough members of the prom committee have access to the information, so they cannot further their research in their department of the prom. * Ticket prices haven't been decided yet, the reason for this is we haven't found out a price for the factors affecting the prom (hall, catering, decorations, and music). This is difficult because the sums are going to have to be repeated to find the cheapest possible combination of the most efficient places, and firms. * There are 10 people on the committee and for the time being there are 10 tasks. The committee carries out the tasks in pairs, which means at least 2 tasks for each person. The problem with this is that they could have more people on the committee that could help others with different tasks. ...read more.


The overall effect of this is intended to make the user's life a lot easier. As seen below, the actual design of the spreadsheet seems very eye-catching, but yet at the same time it doesn't give the user difficulties to see the writing etc. ` As you can see, certain bits of information boxes were coloured different in order to make the spreadsheet easier to understand, in this case where they actually had to enter details were white outlined boxes which stood out perfectly on a 20% blue background. Formulas I had to use certain formulas in order for the whole system to work, this included "sum", "if" and "vlookup" formulas. I found these to work pretty well, especially the "vlookup" within the "if" formula. This was used with the "in-house catering question as pictured below. I then found that unless you formatted cells, certain formulas wouldn't work. In this case it was with the profit, I found it very difficult to make it work properly until I pressed this then changed the cell into currency and the formula; "=K15-J6" Worked perfectly. This was very much the case with the working out at the bottom of the spreadsheet, all the cost cells had to be currency otherwise you wouldn't get the cost only a decimal as such. I didn't imagine that the formulas would be simple, but I did find that I really didn't have a lot of problems with it, obviously apart from the few mentioned. Nevertheless I needed to test the spreadsheet properly and carefully, so I then I could begin to see where certain aspects had to be changed. Excel has various formulas that I can use to find out certain answers. Such as the 'if' or 'and' formula. E.g. if (`#*`#)+#. ` Is a letter and # is a number. The values of ` and # make up a cell where information is recorded Implement After carefully looking through the spreadsheet, I found quite a few problems that wouldn't make the spreadsheet as successful as I would have preferred. ...read more.


A system that can predict ticket prices and the break-even point based on approximate numbers of pupils that are attending Enter data from research and see if calculations are done automatically by the program "excel". Data was entered and the ticket price was found - Evaluation After I had finished my testing, I needed to consider if the list of tasks to be done have been completed. So after I had seen what they were (see previous page) I then looked through the coursework to find if there was some inkling of them included. Fortunately all of them have been included in my spreadsheet except one! This was 'a ready made system that can give access to the proms committee anytime, but can secure pieces of work with passwords'. However a password protection on a spreadsheet is not easy to do and I really didn't have the time to accomplish that. In order for the system to be kept running properly. I'm going to make a user manual that has step by step guide on how to use the spreadsheet. This can be seen under user manual. The questions I would ask them would be so I could help improve the system further for future years User Manual This is a step by step guide to help the users operate the system for the prom. This is considered to be important because the system needs to be run properly in order to get accurate positive results. Step by step guide Step 1 When opening the system you arrive at a welcome screen and you arrive at a welcome screen. Then there is the option of going to the raw data screen or finding ticket prices. If you decide to go straight to finding ticket prices to step 3. Step 2-raw Data Here you have the choice of seeing data that is already available with all the efficient details needed or entering new data for anyone of the values. This includes venues, catering, decorations, and music. (Evaluation not complete! Items such as appendix, Output and user manual are still to be included) James Greenaway ...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


    It then loads a user form. I chose a user form as the method of entering data as it controls the location of the user enters data and this prevents the user from accessing the student list where they may alter existing records. The user enables the user to enter the student roll number, surname, first name and date of birth.

  2. GCSE Excel Project ICT

    As this objective is completed with just a button click, I assume that this whole process is very easy, virtually idiot-proof and completed well. Objective 3 The aim of this objective was 'The user would like to have his customers view four static tables (where he can edit the prices)

  1. I have been asked to come in and help out a holiday company called ...

    Pinpoint does not offer this feature. Setting up a relational database will avoid the unnecessary duplication of data and make it much easier to update information. The staffs at Air Tours don't have much experience with computers so the new system must be user friendly.

  2. ICT Coursework (MarcoS)

    Customers This is how the Customers sheet should looks like. How to fill in the cells with color * To fill in the cells with color use the tool "Fill Color" in the toolbar, as shown in the picture. Employers * On the Employers worksheet insert the details about the employers, such as name, telephone number and E-mail address.

  1. The impact of ICT on a person with special/particular needs

    Disadvantages (How it does not meet Sarah's needs) The computer does have a few faults though. To do a lot of the things the computer is capable of, you need access to the internet. Without the internet, a computer's abilities are quite limited.

  2. Database Coursework

    It would also save a lot of time. Database System Like a spreadsheet system, a database is also computer based, so it automatically has many advantages over the current paper based system. The database software is excellent for creating tables with all the customers.

  1. I am creating and producing an online interactive guide presentation on Chelmsford to help ...

    edited with arrows and highlighted areas o Music and videos in the presentation o Tables and graphs. Analyse Within this section I will be investigating what new hardware and software is needed to be supplied by the council. Hardware In order to create and use the presentation hardware will need to be required.


    requires any details of a patient very quickly they just fax it to them instead of scanning them onto the computer and then sending them by email or posting them. The Fax machine is a very helpful tool to Orchard Orthodontic as it enables them to transfer and receive any information very quickly.

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