• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

Identify Terence Findlay.

Extracts from this document...


Identify Terence Findlay Problem Pantry Pride Pizza Delivery is the best pizza delivery and restaurant in the East Sussex area, which is run by Mr. David. Mr. David has a problem with his staff and the orders. Because the restaurant is the best in the area it is very busy, especially on Friday and Saturday evenings and there are no computers and the staff take the orders and addresses to deliver to down with a pen and a piece of paper, so sometimes the orders got mixed up or the wrong orders were written out or sent to the wrong house and when it came to calculating the prices the staff found it very hard to work out total prices and take off the discounts, and they had to copy the receipts by hand and they often get lost during the delivery. Considerations of the solution to problem The pizza delivery could get a computer right by the phone so that the member of staff who picks up the phone can type in the information and add up the prices and take off the discounts on computer and this would be neater so the people can read it and it would be more accurate so they would charge the right price to customer and deliver the pizzas to the rite people. ...read more.


Collecting Data The data that was collected was carefully calculated and considered by my own judgement and experience in pizza and drink pricing. There will be a menu of all the varieties of things available in stock and the code number of the item will be displayed on the page next to the item. * Price of drink * Variety of drinks * Code number of drinks * Size of pizza * Price of pizza * Flavour of pizza * Code number of pizza And all the rest of the data like the sum of the total amount and the discount that was calculated were all done on the spreadsheet and calculated by the spreadsheet. Processing the data The user enters what food or drinks are being sold into the spreadsheet using v-lookup. The spreadsheet then totals the different food and drink up. The user is given an option to give a 10% discount if the price is over a certain limit, so I will use an If statement, in conjunction with a formula that will work this out. Conceptualise Mr. David thinks the spreadsheet should have a maximum of three pages, and I thought that I would have one with the links to the two other pages of which one will contain the datasheet which contains all the information about the pizzas and there prices and the other will contain the order sheet which will calculate the prices and discounts of all the orders made by the user.. ...read more.


I don't think that I could have made it any better than it is now, so I am quite happy with the way it turned out. - the system should print out the invoice within 10 seconds This worked with the right printer and caused no problems. I could have made this better by getting a faster printer but this would be too expensive. - the price automatically appear with the name of the pizza This worked perfectly as excel is designed to do this with the right formula. I don't know any ways to make this better on the sheet. - the sheets should be protected to avoid anyone accidentally deleting any information or formulas This worked well. I added in two passwords for Mr. David, one to enter the file and one to modify so it would be very difficult for someone to change any of the information on the actual sheet. - the system should have a sheet that looks good and contains the company logo, and stores information of the available pizzas and their prices and another one to do all the working out of the prices and the taking off of discounts and any other adding up that needs to be done This has been achieved as you can see in my implementation stage and it has been done do the satisfaction of Mr.David. ...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


    ' ' mcrexit Macro ' Macro recorded 12/29/2006 by OFFICE 'Loads a userform asking the user if they are sure they want to exit Load UserForm1 UserForm1.Show End Sub I did not come across any problem when creating and designing this sheet.

  2. Producing documents for a company. Spreadsheet, Invoice and Website.

    Software * Windows Vista(tm) Home Premium(plat form ) * Necessary drives to additional hardware (mouse,keyboard,USB sticks ) * Graphic software * Web-browser * Microsoft Excel 2007 The software that will be used for the creation of this spreadsheet will be Microsoft Excel.

  1. System requirements analysis

    Centre are two main types and these are LCD's TFT's and CRT's Before that, I shall be discussing VDU's, which stand for Visual Display Units, and there are two ways in which they can differ from each other and this from size and resolution.

  2. a level ict project

    well as the computer system * The information created must be of high quality to maintain the business' integrity * The database must be easy on the eye, i.e. attractive, to discourage boredom and promote enjoyable use * Access to system must be obtained with minimum obtrusiveness Quantitative Objectives *

  1. Produce a net cash flow for an Italian restaurant called The Pizza Palace.

    I have not chosen any of the above methods but have decided to use the ICT method as it is much more reliable, dependable and has a lot less chance of losing or damaging work. Hiring an accountant is an expensive method and because the company is already losing money, this isn't a good idea.

  2. Develop a spreadsheet application for the Ibis Hotel.

    to him to allow me to update all his present manual administrate work into a technological system. He has accepted this accordance made by me to the manager. The written letter back to me was telling me that he had accepted the offer, he had written back and listed me

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