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

Excel Project

Extracts from this document...


Identify Background detail, user I have been asked by the manager of the restaurant named Eastern Pride to create a system for them. Eastern Pride is a restaurant which serves a range of foods, from Indian, Chinese, Thai and much more. Statement of the problem Mr. Rajesh Patel explained how they are currently performing all calculations for the business manually. This is unreliable and may have errors as people may write down the information and make mistakes and have results which are incorrect. They are completely disorganised and lose important records for the business. Therefore, he has asked me to create a computer system in order to keep all the information and the business will be more efficient. The system requirements are: * Automatically add up all the takings each month * Spreadsheet should display the profits made * The spreadsheet should be password protected so that it won't be tampered with and will remain safe. * The system should be easy to use and straightforward * Staff should be able to print out price lists of the items A computer will be the ideal solution to create the system because it is fast, easy and efficient. ...read more.


* In normal usage, the keyboard is used to type text or numbers into a word processor, text editor or other program. * In computing, a mouse is a pointing device that functions by detecting two-dimensional motion relative to its supporting surface. Physically, a mouse consists of an object held under one of the user's hands, with one or more buttons. It sometimes features other elements, such as "wheels", which allow the user to perform various system-dependent operations, or extra buttons or features can add more control or dimensional input. The mouse's motion typically translates into the motion of a pointer on a display, which allows for fine control of a Graphical User Interface. * The central processing unit, or CPU, is that part of a computer which executes software program instructions. In older computers this circuitry was formerly on several printed circuit boards, but in PCs is a single integrated circuit. Nearly all PCs contain a type of CPU known as a microprocessor. The microprocessor often plugs into the motherboard using one of many different types of sockets. * In computing, a printer is a peripheral which produces a hard copy (permanent human-readable text and/or graphics) ...read more.


It will remain safe and can be used whenever needed. Security strategy Data can be lost, corrupted, altered, deleted and even hacked into by unauthorised users. To ensure that the work and documents aren't tampered with, I will use passwords so that access to data by anyone other than me, is restricted. And also, I can log off or lock terminals when the computer isn't being used and keep files on my personal USB which no one else uses. Design User feedback Dear _________, I am writing this letter in order to inform you of my personal thoughts and opinions on the designs you showed me. Firstly, I'd like to mention that, on the pages for the system, instead of having the logo on the top corner, I think it would look better if you put the business name in the top centre. And for the receipt, I want the items to be left align and the prices to be align right. And also, miss a line after the list of prices and leave it for the total amount. Thank you Mr. Rajesh Patel Manager of Eastern Pride Subtasks 1. get file from manager 2. open excel, and input title and headings 3. list items and prices 4. create combo box 5. create macros, buttons 6. add borders and colours ...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. ICT Project - Statement of the Problem

    There is a Supplier Orders and Payments All the supplies that need to be ordered will be ticked of on the order sheet. The order sheet will then be printed and sent of to the suppliers with a check. When the suppliers are delivered, it manager or assistant manager will then tick it off that it has been delivered.


    Sheet 2-Enter Marks This system will contain list boxes, Vlookups and input boxes which will enable the user to choose each student personal details, enter assignment marks and maximum marks. The assignment and maximum marks will have an input box that will enable the user to enter the individual marks, which will be locate to a certain student.

  1. GCSE Excel Project ICT

    Another issue we have is the calculating part of the invoicing, as Alex hand writes the invoice and checks prices and writes them onto the invoice and at the bottom end he then has to count up the numbers to form a total, being human he may make a mistake and over (or under)

  2. Computer project Alevels

    It is cheap when compared with other processors which work at the same speed. Can open multiple programs without getting the system crash. (E.g.: Can open the calculator while working on the proposed system) ? RAM - 256 MB DDR 1 Random Access Memory.

  1. In this (2b) report I am going to investigate software application, Input and Output ...

    And the disadvantages which Sainsbury found are: an external mouse requires space, making it nearly impossible to use on an airplane. A mechanical mouse needs to be cleaned regularly or it will get clogged with lint and dust. The cord on most mice can get hung up and drag, making the mouse difficult to use.

  2. GCSE Database Project ICT

    Access it good at many things, which makes it the ideal choice for database software as multiple criteria, enables easy manipulation of data and it makes easy work of large amounts of data. Three Quantitative objectives 1. The user needs to search and print patient information for a reminder letter

  1. Database project

    22/03/2006 06/04/2006 No Processing To satisfy user needs I will need to create: 1. 3 related tables; customers, planes, rentals. 2. 3 forms for entering customers, planes and rentals record 3. 3 queries, to search for: a) Current rentals (planes on loan to customers)

  2. ICT Project 1A

    In 2006, a third and fourth single, "Rette Mich" ("Rescue Me") and Der Letzte Tag (The Last Day), were released; both reached #1 as well. Tokio Hotel gave their first concert in the United Kingdom on 19 June 2007. Ready, Set, Go!

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