• 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. GCSE Excel Project ICT

    in D13 Pass WarlordtfGC1TB Go to sheet1 select insert value '7' in D13 Pass WarlordtfGC1 Go to sheet1 select insert value '4' in D13 Pass WarlordtfGC2 Go to sheet1 select insert value '5' in D13 Pass WarlordtfGC5TB Go to sheet1 select insert value '8' in D13 Pass WarlordtfGC900 Go to

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

  2. Computer project Alevels

    Then you must place the button where you please on the form. Then 'command button wizard' will open up you can follow the wizard to make your command button do whatever you want it to do. * Change the heading of the form To change the heading of the form

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

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

    Excel is excellent spreadsheet creating software. * Microsoft excel (2007) this software are well known and trusted. The tools that I think that I will need are the IF FUNCTION and the programs outstanding use of cells and formulas as well as VLOOOKUP.

  1. ICT Project 1A

    When trying to find this specific information I needed to use many different sites to get ALL of the information. For example when trying to find out information about the music they have released and the CDs they have released.

  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