• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month
  1. 1
  2. 2
  3. 3
  4. 4
  5. 5
  6. 6
  7. 7
  8. 8
  9. 9
  10. 10
  11. 11
  12. 12
  13. 13
  14. 14
  15. 15
  16. 16
  17. 17
  18. 18
  19. 19
  20. 20
  21. 21
  22. 22
  23. 23
  24. 24
  25. 25
  26. 26
  27. 27
  28. 28
  29. 29
  30. 30
  31. 31
  32. 32
  33. 33
  34. 34
  • Level: GCSE
  • Subject: ICT
  • Word count: 3720

AutoPlastics I.T. System

Extracts from this document...


Problem Statement The company which I have decided to do my project for is AutoPlastics, a company that deals primarily with the supply and repair of plastic car bumpers to both the public and insurance companies. The owner of the company is my end user. The company is currently experiencing problems with its ordering system. When a person phones and places an order or asks for a quote their details are taken and written into a book. A customer is then contacted within a day and provided with a quote and the company then arranges a suitable delivery time with the customer. The quote given to the customer is based upon the price at which the bumper must be purchased from the manufacturer if they do not currently have it in stock. If a bumper must be ordered from the manufacturer, 15% is added to the price to cover the cost of ordering and installation of the bumper. The problem occurs when the price of a bumper in stock is required that is currently in stock as the company have such an extensive range. The prices of the more popular models vary frequently (in order to meet with the competition), and are entered from memory. As a result mistakes are often made resulting in inaccurate quotes being given to customers. If an individual feels that they have been overcharged the result will be an unhappy customer who may choose not to use AutoPlastics again, and the companies overall profits will decrease. The paper based system currently employed also makes it difficult to keep track of orders made by customers and keep an accurate record of the most popular bumpers and frequent customers. ...read more.


the information within a workbook * Macro create a new workbook using a standard design * Macro to print a receipt * Protect/lock cells to prevent heading/formulae from being accidentally altered by user Existing customer: * Create a mocro which gives the user the option to open a customers spreadsheet Delete customer: * Create a macro which will enable the user to delete a customers file when no longer required Spreadsheet design for 'Auto Plastics - Order form' Main menu design I will create a user form for my end user which will enable them to carry out the following functions: New Customer - Create an account spreadsheet for a new customer Existing Customer - Place a new order for an existing customer Delete customer - Remove a customer's spreadsheet from the company database Cancel - Closes the Front End Macro designs for the main menu Name Brief description Steps involved Method of activation new_customer This macro will load a blank copy of the AutoPlastics order form ready to be filled in This macro will load the Auto Plastics order form. The user must then enter the required data using, then save button on the Auto Plastics order form. A button labelled 'New Customer' will be used to activate this macro. Name Brief description Steps involved Method of activation existing_customer This macro will allow the user to load a customers spreadsheet and will create a new workbook in which their new order will be filled in This macro loads a customers spreadsheet and creates within the spreadsheet creates a new workbook. The user must then enter the details of the new order into the new workbook and save the file when finished. ...read more.


Totals Totals will be calculated at high speeds using formulae within the spreadsheet instead of manually as in the previous system. This will increase accuracy and now enable the customer to see prices exclusive of V.A.T. Testing AutoPlastics Order Form The results of my questionnaire seem to indicate that my system meets the needs of my end user. It met any and all criteria specified by them and appeared to be faster than the previous system at calculating a total which could be given to the customer. In order to test this, the times taken to enter 6 orders were taken, 3 using the previous system and 3 using the new one. The times were as follows: Previous system New System Test number Time taken Test number Time taken 1 6:00 1 2:05 2 5:00 2 2:32 3 5:30 3 2:58 As the table clearly indicates there has been a clear time improvement which will ultimately result in less time spent calculating and more time spent in other areas of work. Testing the formulae of AutoPlastics Order Form - quantity, price per unit and Total test The best way to test the formulae will be to enter a variety of different values and to check whether the values are as they should be. Cells Used Data entered Reason Result G14, H14 3, �120.00 Test the formula entered within cell J14 A correct result of �360 was given indicating that this formula and the rest down the row were also correct. Testing the formulae of AutoPlastics Order Form - V.A.T values Cells Used Data entered Reason Result G30, I30, B30 =SUM(J14:J27) [�360] =G30-B30 [�359.83] 17.5% To test that the V.A.T exclusive value formulae (I30) is correct. �297. This indicates that the formulae are functioning properly. ...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


    I can also monitor that the macro doesn't work just for one value and then not another. The last test I will do is to let my user use the new system, by doing this it will help to see if I have achieved the user requirement and also whether the objective of the system has been met.

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

    Create Logo I am going to open paint then I am going to use the tools of my choice and finally I am going to create my logo.

  1. Computer project Alevels

    To enter fields from the tables you have to click on the 'Field List' button and then you can drag and drop the fields that you want to use on the form, on to the form. * EDITING THE SWITCHBOARD - Here it can be edited in the same way as a usual form.

  2. Create and check a multi-sheet spreadsheet solution to meet specified user needs that uses ...

    Using calculator manually: Week 2: I cross-checked this by using a calculator: =458.73+1,583.12+1,440.97+1,500.21+429.57+2,623.95+1,770.23+863.46+922.29+1,367.24+374.25+1,231.44+3,162.87+809.10+1,033.53+629.10+569.43+563.53+779.48+1,824.27 =23936.77 Week 3: I cross-checked this by using a calculator: =1087.36+1097.39+1049.25+1196.37+279.72+2898.84+827.64+879.45+532.59+1511.16+179.64+901.59+1875.33+656.27+1341.39+740.94+509.49+791.34+839.44+2349.06 = 21544.26 Week 4: =1070.37+2392.67+1049.25+1272.33+699.30+2224.11+942.59+287. 82+688.47+1852.97+219.56+1429.35+2295.18+638.29+1605.27+552.21+479.52+275.77+989.34+2299.08 = 23263.45 Total sales for week 2,3 and 4 Function: Week 1: I calculated the total week 1 sales, by entering this formula in the function bar "=SUM (A4:A23)".

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

    I will make a list of the reference numbers in that cell. Security How will the data be secure? Software One way to keep my data secured is to prevent other accessing it by using passwords. This can be done with Microsoft Excel, as it has protect function(protect sheet function).

  2. GCSE Excel Project ICT

    49 secs* Data collection (Data required, source, and method of collection) Products The only data needed for the invoice is the product names some detail (specifications) of the product and the price. This will be obtained from Alex, as some of the products he offers he makes himself, which runs under the name 'WARLORDTF'.

  1. ICT Project 1A

    Firstly there was the lack of webpage's actually available about them. When I started I was quite lost and was just looking for general information. When I typed in Tokio Hotel Band Google found little over 350,000 websites. Though this seems like quite a lot when I searched for other

  2. ICT specification

    �183.00 Peugeot 106 4 �183.00 Renault Clio 4 �183.00 This is the data on the medium class of cars that are designed to hold four passengers. The price on all five of these cars is set at �183.00 which is very adequate because it can allow the customer to choose

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