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

Introduction

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.

Middle

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.

Conclusion

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. Financial Model to help organise the year eleven prom

    different scenarios that have been stored in "raw data" and have room for more data to be entered This has plenty of room for new data to be entered for future years (A system that can be re-used for next years pupils.

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

    * First, you should go on Microsoft Access. * Then, you should go on Blank Database. * After that, you should Right Click on Table and click on Design View. * Furthermore, you click on Postcode. * Finally, you click on Input Mask and type in (LL0\ 0LL).

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

    This is because colour attracts costumer and makes the invoice nicer. It must also support text. This is because it is easier to understand and follow if it has text. It must be user-friendly It must be easy and straight forward to manipulate E.g.

  2. ICT notes

    Data Security To prevent the loss of patient's records etc the health centre needs to ensure that regular back-ups are made of the data on the system using suitable backing storage (also known as secondary storage). Types of Backing Storage Name of Device Advantages Disadvantages Hard Disks * Large storage capacity - 20 gigabytes or more.

  1. IT investigative process

    As I mentioned previously in my design brief, the characteristics which produce a positive image of Colombia are most probably the country's natural paradises, and therefore are the ones that deserve to be investigated. What makes Colombia such an excellent option for tourism is the variety of natural regions that it has.

  2. System requirements analysis

    The calendar that is shown above shows all the data that the system stores such as the data and the days etc. Also I can have data protection if I have more time. Data protection ensures that the data cannot be deleted and it cannot be viewed unless you have specific instructions to do so.

  1. ICT car insurance quotation System Coursework

    6-The time taken to retrieve a quote. From observing other insurance companies I went down to another local franchised Vauxhall Dealers in the Merseyside, and conducted an interview, where I asked them the following questions about their online quote system: How will the customer's information be entered?

  2. The new system is required to calculate the costs of a new car as ...

    The current system relies on staff writing down details of what the customer would like in terms of the trim, paint, interior etc. personal details such as name, address and date of birth are collected should the customer decide to continue with the transaction.

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