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

ICT car insurance quotation System Coursework

Extracts from this document...

Introduction

Specification: Introduction: The business which I'm going to produce my system for is a franchised Vauxhall Dealers. The businesses main operation is selling and financing Vauxhall cars and vans to business customers and the wider community. The size of the business is average at the moment, but is predicted to grow through its main franchisor Vauxhall. Who offers great car for reasonable prices. Their cars appeal to most families, businessmen plus younger and older drivers. There are previously only four employees at the moment but they are recruiting, because of their predicted growth. Statement of problem: The dealers already have an online ordering system for customers to order their car from. But at present do not have an online Insurance quote system. The dealers suffer from a lack of organisation. The dealer's use a pen and paper method of taking car insurance quotes from customers. The quotes are filled in a filing cabinet until they are to be processed. The problem that the business has is that they do not have an insurance site yet, but have to relay on processing the quotes to the main Vauxhall PLC's website, so the dealer which is franchised from Vauxhall PLC is not making any profits from the insurance, however the dealers do send the car orders to Vauxhall PLC for the cars to be produced. But they hope to have their own insurance system so they can offer insurance to customers and subsequently retrieve those profits from those customers. Task Iam going to solve: The task which Iam going to provide a solution for is to produce an online insurance quoting system. The system will provide up to date quick and efficient calculations, so the end user will get a fast reliable quote each time they use the system. Research: The benefits of research for my system is to get an incite of how other online quote system appear and operate. ...read more.

Middle

I set up the row headers like shown below. Setting up the printout worksheet: I set up a new sheet and called it printed quote. Here I set up a page that would take the relevant information from the quote worksheet and could be used as a print out for customers and for the end user. On the print out I have set a formula that will put today's date on it, so that the date will be correct on each printout, and will not have to be done manually. I then typed in formulas that would copy the customer's title, name, address and phone number from the quotes worksheet and show up the relevant information on the printout worksheet. I then set up formulas that would duplicate the customer's make and model of car, age, sex, no-claims discount and type of insurance. I then set up a formula that copied the final quotation price from the quotes worksheet. Customising the interface and adding final touches: My original interface looked like this: I have customised this interface to look like this using the drawing tools in Excel and the company logo: Setting up a macro to automate the filling of the quotes into the customer: First I recorded a macro like above, this time I called the macro save quote. This macro takes along time to record as it involves copying each of the necessary cells form the quotes sheet, then pasting the cells onto the customer's worksheet. I did this by selecting the first black row on the customer's worksheet, clicking insert, rows. I did this so every time a new quote is saved it will be Added in at the top, without replacing old quotes. I then switched back to the Quotes sheet by using the toolbar at the bottom of the screen. I subsequently selected the relevant cell, clicking Edit Copy, then switching to the customers sheet, clicking the relevant cell and finally Edit, paste Special. ...read more.

Conclusion

However any other user can use an ordinary standard ink-jet printer, mono or colour. This is because the output page is just information and does not include any pictures, except the company's logo, so the page does not have to be printed in colour. The end user does not have to own a scanner any other input device to get the full benefit from my system. This is because my system does not need any things being inputted to the computer to process a quote, just the data input from the user by a keyboard and mouse. The end user just needs a moderately powerful computer with windows XP (includes Excel 2003), a printer and access to the internet. End user skills: The age of my end users vary from the minimum driving age (17 yrs) to 60 years. End users who have difficulty in focusing on the information from the output page, can increase the font size by clicking on the font size indicator symbol at the top left of the page. The only end user who will be using Excel (related to my system) is either myself or the dealers to modify the system before reposting it back to its internet page. Security: The formulas for the system will be password protected so that no users accidentally change or delete any formulae. The data that the end user inputs are not very personal, but may be personal to some users such as: date of birth or address. So this is why the system will have an option of the user opening their own account with the dealers to access their past quotes or save new quotes safely to their account. My system strictly and legally abides the data protection act 1998, The act requires personal information to be: * fairly and lawfully processed; * processed for limited purposes; * adequate, relevant and not excessive; * accurate; * not kept longer than necessary; * processed in accordance with the user rights; * kept secure; * Not transferred abroad without adequate protection. ?? ?? ?? ?? ICT Coursework 1 ...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. Marked by a teacher

    The impact of ICT on the local community. I live in the borough of ...

    4 star(s)

    might be used * Easy target for theft if seen coming from an ATM machine * Can tempt you to spend too much, especially if placed outside something such as a casino Conclusion ATM machines can be seen as being essential to a community as they allow the community to transfer money much faster and stops banks from being overcrowded.

  2. GCSE Excel Project ICT

    to prevent the customer 'accidentally' selecting a different number. Therefore, with the buttons inserted the modifiable invoice looks like this: As you can see, the boxes where you input the data is totally covered enabling the user to remain totally impervious to the background user functionality. Now the OS cell (B16:D16 (merged))

  1. Impact of ICT on the community

    The host computer may be owned by a bank or financial institution, or it may be owned by an independent service provider. Bank-owned processors normally support only bank-owned machines, whereas the independent processors support merchant-owned machines. Use of ICT in the banks > CCTV > Database > Security Alarm Evaluate

  2. OCR Nationals Unit 21 - Task 8

    I used the text tool to add the text onto the advertising banner. - Text Tool As I planned in Task 7, I will make each word appear one at a time after another. So for me to do it on Flash I have to create many Key Frames with each one having a new word added to it.

  1. a level ict project

    Adding a new user and modifying a password As the business grows and the work load increases, new employees may need to be employed consequently they need to be given appropriate levels of access to the system. The following steps describe how to add a new user and assign/modify passwords.

  2. Tennis Tournament UNIT 1 GCSE ICT coursework

    They then enter the number of entries. This number must be a whole number, higher than 0. If they do not enter the correct number they will be taken back a stage until they enter correctly. Formula Design Once I have formatted the spreadsheet I will add the formulae I need for the calculations.

  1. System requirements analysis

    Microsoft Windows was the first to provide this service and Macintosh needed to get permission to compete with Microsoft. The two operating system providers are both very successful and have regular updates in the standards to ensure that all customers are satisfied and the software is up to date.

  2. Creating a computer system for a video rental shop

    Tables and relations : I will be creating a relational database where tables work collectively rather than individually. For this to happen there is a need for links between the tables, the links need to be between one key field in a table and a foreign key in another.

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