• 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

  1. Use of IT in schools

    There are an awful lot of general uses for ICT in education, some of which are student orientated, where as others are to do with administration. The general uses of ICT for students are fairly obvious, but still important. However, theses uses do vary according to age group.

  2. System requirements analysis

    This is my logbook. It shows that a lot of mistakes and errors occurred in process of making a system that functioned appropriately. Date Task Problem Identified Solution Schedule 21-11-06 Should post an appointment. The button does not work, when you click, no effect 21-11-06 Should post an appointment.

  1. Ict Powerpoint Coursework

    The images would be transferred to the PowerPoint presentation via the simple method of copy and pasting. All images would be cropped and resized before added to the PowerPoint. Input The text formatted data will be the first type of data to be inserted into the slideshow.

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

    Hence, this system is very much time consuming. All the expenditure is recorded on a sheet. And used by the librarian whenever a new order is placed. It is prone to being misread and would be better of under a computer-based spreadsheet.

  1. Solving the reprographics problem at St.Mary's College.

    The additional work I will also be doing at home will be on a Q-tech Centaur hauls VIA Samuel 129.OMB RAM. I predict that both PCs home and colleges will be fast enough to run the material 6. Software The reprographics department has a standalone PC that uses Windows 98.

  2. Different types of technology How I use ICT at home and at school

    What it really is doing is stopping me from being as active and attempting to be social as I think I can just escape from it all by 'just being social' on Facebook. But really, I'm just escaping from real life to the internet and building up a fake social life.

  1. Theatre Model

    All these advantages also contribute to saving time. So before lots of time was being wasted (time is money) which could have been used to help the theatre in other aspects and therefore produce more money by having more time.

  2. Excel user guide

    Once you have selected the bar chart icon a dialog box will appear with the title chart wizard. Steps to construct a component bar chart First step - Select column for the chosen bar type. You will be presented with a chart sub type on the right hand side of the dialog box, select the stack format.

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