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

I have chosen to create a spreadsheet, for the use of customers and staff of a 'The Pizza Place' restaurant.

Extracts from this document...

Introduction

Implementation Choice Of Project I have chosen to create a spreadsheet, for the use of customers and staff of a 'The Pizza Place' restaurant. There is a great need a computer system for ordering food within restaurants, as manual, paper ordering system have become out-of-date and many errors are made. I have chosen to use Microsoft Excel to create my spreadsheet, as I feel that Microsoft Access is an inappropriate program to create my spreadsheet on. Initial Design The spreadsheet will contain different pages, on which, information will be displayed on the products available. There will be a sheet, on which, the order is to be made this sheet will contain all the formulae, for the bill to be made. Problems Encountered I had very few problems when creating 'The Pizza Place' spreadsheet. I made many changes with the layout of the pages, to make the pages more attractive for the customers and staff using the system. The page layout also had to be changed to make it possible to view all the options available. ...read more.

Middle

1. Set up the spreadsheet in a way to make it possible to access all information easily. 2. Insert all the required information on to separate sheets under its own heading. 3. Validate all information used in the spreadsheet, use locks on certain sheets. 4. Create a Choices sheet using specific formulas, link with billing sheet. 5. Create a billing sheet to produce a bill of all products ordered, link with the Choices sheet. 6. Insert Macro buttons to link all the sheets to the Main Menu and the Main Menu to all the sheets. How this was done! 1. I introduced new sheets in to the system, by right clicking the mouse at the bottom of the screen and clicking 'insert' and then choosing worksheet. I gave each of the sheets it own heading i.e. Pizza, Topping, Desserts, etc. I did this by double clicking the left mouse button over the tabs displayed at the bottom of the screen and entering the required name. ...read more.

Conclusion

5. The billing sheet contains all the products chosen, once they have been transferred from the order sheet, these are shown in list form under the appropriate category. At the bottom of the sheet the total cost of all the chosen products are shown, this is produced using a simple formula, =SUM(total) this formula adds up all the products displayed in the range of E8:E26. 6. Macro buttons have been used throughout the spreadsheet, on every sheet, creating links between the sheets. The main menu has macro buttons linking you to all the other sheets, whereas most of the sheets only link to the main menu via macro buttons. The sheets Order and choices have macro buttons to create a link between them and to the main menu. A macro button is used on the order sheet to clear the bill, this works by selecting all the cells used by the bill and clearing the text. Macro buttons are used in the choices sheet to transfer information from the choices sheet table on to the order sheet, which are then displayed in the bill. Michael Gilbert The Pizza Place ...read more.

The above preview is unformatted text

This student written piece of work is one of many that can be found in our AS and A Level ICT in Business 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 AS and A Level ICT in Business essays

  1. The Use of Geographical Information Systems (GIS) And International Technology Transfer by Non-Governmental ...

    According to a report of GIS and health by Blom and Saavolainen- Mdntyjdrvi (Markku document Internet 2001). The possible research themes are among others: * Environmental models and GIS for environmental epidemiology; * Visualization, exploration and Modelling tools; * Integration of exposure and space-time models; * Cross-border small area epidemiological

  2. How Technolgy effects some in the work place

    Chris now wastes very little time searching for documents or files. The intranet fulfils his need in a personal way of working. Email Specifications Microsoft Outlook How the technology is used * Sending and receiving messages internally and externally * Using the Internet to send messages * Uses as a

  1. TELEWORKING : A Place for the Introvert?

    Whilst 'remote work' is a generic term for "organizational work performed outside of the normal organizational confines of space and time", telework specifically refers to "work performed remotely augmented by computer and communications technology" [Olsen,1991:p4]. Telework is a technology-enabled phenomenon.

  2. Executive Summary - Ice Dreams

    Cosmetics 356 Leisure Equipment 327 Drink 245 Household Stores 244 Holidays, Travel & Transport 242 Publishing 217 Pharmaceutical 217 Entertainment 182 Institutional & Industrial 142 Government 87 Charity & Educational 49 THE MEDIA National daily newspapers 14 National Sunday newspapers 11 Regional morning newspapers 18 Regional evening newspapers 72 Regional

  1. This report will look at McDonalds as an international business, but also focus on ...

    and equipment layout, the formula and specifications for menu items, use of McDonald's method of operation, inventory control, book keeping, accounting and marketing. A separate franchise lease covers the right to occupy the restaurant premises. In return the franchisee agrees to operate the business in accordance with McDonald's standards of quality, service, cleanliness and value.

  2. Does the merger between Halifax and The Bank of Scotland (HBOS) create value?

    Mergers may also result in reduced operating costs (Standard and Poor's, 1997). Aside from actual or perceived price increases to consumers, it is clear that merger activity has an impact on customer retention. Insufficient emphasis on bank customers and their perceptions may cause them to switch away from the newly merged bank (Morall, 1996).

  1. Dell - The reason for selecting Hong Kong.

    finance - not only focus on electronic money but also new bank-customer relationship through Internet and online/wireless investment etc Shipping, freight forwarding and logistics - electronic data interchange and Internet-based networks to transmit information and documents with traders Wholesale and retailing - installed bar-coding and point-of-sale (POS)

  2. My Chosen Business

    However these types of problems will not occur with my business because I am opening it under a franchise format which means that the company, Game, will decide the price of the products for me. Advertising is a factor that will not be much worry to me because Game already

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