• 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


    You failed to enter data in one of the required field!", vbOKOnly, "Student Entry Message:" End If If Range("C2") = "" Then Rows("2:2").Select Selection.Delete Shift:=x1Up MsgBox "The new student has not been added to the system at this time. You failed to enter data in one of the required field!", vbOKOnly, "Student Entry Message:" End If If Range("D2")

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

    * Posters (A3 or Bigger) The primary way to present the output will be the Monitors. This will be used by employees and customers. The secondary way to present the output will be the A4 paper. This will be used for the invoice.

  1. System requirements analysis

    The size is measured diagonally in inches and a typical PC monitor is about 17 inches. Laptop screens are 12 inches. The resolution is measured in pixels or dots and the main sizes are (800x600) medium or a low (640x480)

  2. a level ict project

    soon as the information is entered, if the prices are pre-recorded * Filter techniques, i.e. queries should be available for searching the database for records with specific characteristics * Past data should be as easily accessible as the current data * Processes are performed quickly easily by the user as

  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.

    all the problems below, and these are the problems that they are facing now with the manual system. He has asked me to remove all these problems and solve them: * Corrections that want to be made in the documents are very hard to make, especially on hand written work.

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