• 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


    Unload UserForm3 UserForm3.Hide Sheets("Front End Menu").Select Range("A1").Select End Sub Data Form (Edit/Delete Student Details) On the main menu, by clicking the edit/delete student details a macro, it will automatically opens a data form which then the usr can edit or delete the details of the students.

  2. Use of IT in schools

    * improve and maintaining ICT infrastructure * Set high standards for training and technical support. These Management Information Systems are an improvement of average school databases that are now starting to be replaced, as they are much more efficient, and make the movement of data much easier.

  1. GCSE Excel Project ICT

    the cells is only text, not formulae: VALUE# error This error is common for any mathematical function as it requires figures to calculate, but if there is a number missing from a selected field, it cannot add a NULL text value.

  2. ICT Coursework (MarcoS)

    Audit * In this worksheet there will be the details transferred from the Order worksheet, and the possibility to calculate the incoming for each month. * First of all copy the headings as show in the picture, and create the macro buttons, but do not record them yet.

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

    It also has a word-prediction system. How it affects Sarah's needs Advantages (How it meets Sarah's needs) Sarah can use the on-screen keyboard to essentially make her computer use much more efficient. While she found it hard to type fast on a physical keyboard, it is much easier on an on-screen keyboard.

  2. Database Coursework

    Rental related objectives * The user ought to be able to record details of a customer buying or renting DVDs in less than 30 seconds, as a receipt. * The user should be able to remove details of a purchase or loan if the customer wants to change the DVD,

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

    My guide presentation has to include: o general information for the people to find out about Chelmsford o hyperlinks to web pages and have pictures o an action button that gets the user back to the homepage so users can get specific information fast o a manipulated map showing Chelmsford

  2. System requirements analysis

    and/or staff * 'Off the shelf' - proven reliable, ready to configure and customize for immediate implementation * Deassign and reassign resources to departments or locations * Multi-booking capability option for a single time slot * Search mechanisms for customers and owners - numerous * Web friendly - can be

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