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

My spreadsheet was designed to help the company Rapid Cars with their ordering system. In addition, it was intended to reduce paperwork, time and discrepancies that could occur during the process.

Extracts from this document...


Evaluation My spreadsheet was designed to help the company Rapid Cars with their ordering system. In addition, it was intended to reduce paperwork, time and discrepancies that could occur during the process. The system requirements were: * Include a user-friendly data entry form, which would require not much knowledge about computers e.g. by using titled boxes for data input, validations to prevent mistakes. * Aid in accuracy for example by using drop-down menus whenever possible. * Update the modifications required by the customer in a small amount of time. * Calculate the costs quickly, including the prices of the modifications and the cost of the labour (by the hour) * Store the customer details on a separate sheet * Calculate the total cost by the click of a button * Create an invoice, which includes the customer details, the car details and the details of the modification. This should be printed by the click of a button * The data in the system must not be able to be modified or deleted such as titles and logos * The system should be able to provide an analysis chart/table of the products sold. ...read more.


The formula contains a section where the price of the labour time is added. The value is generated done very quickly. 5. The customer details are transferred by a macro onto a database, which also contains the details of the car and the car modifications. All this is on a separate sheet and this can be useful if the customer comes later for their car to be modified. In addition, this information can be useful to send customers newsletters if the company decides to produce some. 6. The total cost is calculated instantly as the modifications are selected. This is due to formulas that work out each section of the modification category. There are also discounts and these are calculated during the process of calculating the total price. 7. I have created an Invoice where the user does not have to type anything as all values are updated by a macro or a formula. This would reduce the time as the data does not need to be entered again and it would aid in accuracy. ...read more.


In addition, there is not a lot of paperwork due to the formulas and macros. With new technology, this system can be sent via e-mail as off site back-ups. Even though the spreadsheet is quite large the transfer only takes under a minute on broadband connection and around five minutes on 56k connection, but this depends on the time of the day you are on the e-mail. The system I have created meets and fulfils the requirements. It is simple and fast to use. More support is added by me creating a user manual. The system takes less time than I expected to calculate and do everything else. User entry is very straightforward with the notes. Limitations The only limitation of this system is that the user could accidentally move the checkboxes and unprotected cells that are updated by a macro could be accidentally changed. Both of these limitations will be outlined in the user manual with solutions if they occur. Although this is not a limitation but had I the knowledge, to create a sheet with a timetable where the customer's appointment for their car to be modified would go in the next free slot, I would have done it. ...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 notes

    fire safety system. Word Processor I/P Process O/P GUI General office purposes. Patient letters and mail shots. Control Systems A control system is a system of hardware and software that's used to control the operation of a piece of equipment. Two types of control systems: * Dedicated: these are basic systems that carry out a pre-programmed set of instructions e.g.

  2. ICT car insurance quotation System Coursework

    Implementation: First I had to open Microsoft Excel. To do this I clicked on START and then highlighted Excel and left clicked to OPEN it. Or alternatively you can click 'Start' then 'All Programs' and then 'Core Programs' where Excel will be located.

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

    * Should use drop down list * It should use VLOOK UP7 * It should do calculation automatic This would make the document more user friendly. Products and services must be find easily This means that the tables and menus should be clear and easy to use.

  2. System requirements analysis

    The system also stores each of the staff's details a well such as their name and the job that they do in the hospital as well as their salary and the amount of salary that they get paid and also the number of hours that they have worked in the

  1. Financial Model to help organise the year eleven prom

    Then they would be able to take over, and the system would run better. Specification for the computers at the school > Pentium 3 733Mhz > 10 GB Hard Disk Drive > 128MB SDRAM Specification for the network server > SCSI Pentium 3 1Ghz > 8 GB Hard Disk Drive

  2. Benefits of using my IT system in the Travel Agents.

    After that I would choose the amount of copies I need and I would choose the printer that I want the file to be printed from. Finally I am going to click on print. The logo was printed successfully but the only error was that it printed out in the wrong colour.

  1. This project is designed to help non-computerized library to easily keep track of their ...

    book which indicates that it is a book of this library * When a member wants to borrow a book he takes out the book card from the pocket of the book he manually writes his name, the issuing date and his ID number.

  2. Chessington Motor Centre (CMC) Information Technology System

    * Be usable such that a user with limited ICT skills can use it. * Be easy to operate and generally user friendly. Data flow diagram of the current system Record of Invoice Stock List System Boundries The dashed line surrounding part of the data flow diagram, indicates the part

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