• 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


    McrenterAssignment/MaximumMark Sub iboxAssign() Dim value Range("G22").Select value = InputBox("Enter assignment mark", "Marks tracker") ActiveCell.value = value 'Dim value Range("H22").Select value = InputBox("Enter maximum mark", "Marks tracker") ActiveCell.value = value End Sub McrfrontMainMenu Sub mcrfrontendmenu() ' ' mcrFrontendmenu Macro ' Macro recorded 12/28/2006 by OFFICE ' 'Select main menu Sheets("Marks No").Select Sheets("Front End Menu").Select Range("A1").Select End Sub McrArchiveMark Sub mcrArchiveMark()

  2. This project is designed to help non-computerized library to easily keep track of their ...

    This would be very dangerous to the outlet. * In restocking, the librarian has to write a lot of letters to each of the suppliers which is time consuming and irritating. * Cards have to be prepared by the librarian manually for each of the book which is tiring.

  1. Use of IT in schools

    When they go to a more advanced level, they start learning to program, using applications such as Microsoft Visual Basic. One increasingly common use of ICT in terms of administration is Management Information Systems (MIS). This is computer software that is implemented to improve the store and use of information

  2. Ict Powerpoint Coursework

    is also for safety and it is for updating reasons as well when the weekly updated slide has to be updated. The PowerPoint should show all necessary information The PowerPoint has shown all the necessary information I planned to enter, this included high definition pictures so the users of the PowerPoint slideshow are informed of what the products S.A.

  1. Database Coursework

    This is incredibly fast; it is one of the fastest processors. The price of this processor is approximately between �800-�3000. This is very expensive, but if you're looking to save money on a processor, then it's very likely that the one you get for lower prices are slow.

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

  1. GCSE IT Coursework

    cabinet, the data can be stored and protected by passwords, so confidential data such as people's address. Since the information is kept in one place, it can be more secure. * The ability to modify the data held in the database, in case customers move or change details, if a

  2. GCSE Excel Project ICT

    and price. The information will be inserted onto static tables, which are referenced from by other sheets. Data flow diagrams the explanations of what happens to the data between input and output. Alternative methods of output considered Display (on Screen)

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