• 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

    User's Skill Level Ms Elone uses a Pc to write letter and so is familiar with word. Ms Elone is also familiar an account package, excel with she has used in the past and Outlook express but has never used Access before.


    U Red 0% U Red Test 1 16 Test 2 15 Test 3 13 Other data that I will use is to convert numerical values to percentages. Each test they will take will have a minimum and maximum marks. E.g.

  1. Computer project Alevels

    1800 MHz CPU(Central Processing Unit) Reason - Fast loading of programs. Fewer computer crashes. At present people are used to computers with a processor more than 2500 MHz, but in the proposed Medi Care Hospital system it doesn't need much speed because it uses simple application which are being used in daily life.

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

    Because a barcode reader merely captures and translates the barcode into numbers and/or letters, the data must be sent to a computer so that a software application can make sense of the data. Barcode scanners can e connected to a computer through a serial port, keyboard port, or an interface device called a wedge.

  1. 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

  2. GCSE Excel Project ICT

    In addition, an error could be made in the reading of a component, (the same example applies) which can be quite tiresome as it would involve the computer incorrectly made to be scrapped and rebuilt causing further loss of revenue.

  1. Database project

    5 Ernst Rohm 036 5436 3565 21/07/1948 66 Hitler Way Berlin T7 873 6 Joseph Gobbels 064 6546 5634 11/07/1964 11Hitler Way Berlin T7 873 7 Joe Cole 090 6932 5860 29/09/1962 1 Kick Street London W1 4AR 8 Eider Gudjonson 090 8567 6098 30/08/1981 1 Goal Road London W1

  2. ICT Project 1A

    He is the oldest on the band at the age of 20 and is also the tallest. He says his main inspiration for playing the bass guitar is Flea from the Red Hot Chili Peppers. Gustav Sch�fer was born on the 8 September 1988.

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