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

    ATM machines are strategically located outside casinos so when people gamble, they might be tempted to withdraw more money, especially with how easy it would be. Summary * Easy to fraud despite the need for a pin * Fake ATM machines placed in random locations by thieves and con artists

  2. Different types of technology How I use ICT at home and at school

    I can also simply figure out what type of music exactly I enjoy most to become more of an individual person. TVs are found in almost every single household. This means that nearly everyone watches TV often, keep up with certain programs, become fans and acquire tastes.

  1. GCSE Excel Project ICT

    Now, click enter on the cell and check the value within: This is not the value we wanted, this is because the active formula within the cell was: =VLOOKUP($D$4,Shells,1). The logical assumption would be an error in the properties of the formula, which would be the correct assumption the specific

  2. The use of ict has changed the way in which people work. Explain the ...

    In the same way that fingerprints found at the scene of the crime can lead to a conviction so too can minute samples of DNA when analysed and coded by the forensic team. In the autumn of 2000, the police DNA database reached 1 million records.

  1. The Social, Moral and Cultural Effect of Introducing ICT to a system

    This is to stop other Internet users from getting the information and using it. All this software will be helpful for the leisure center, because it will prevent any unwanted information from other companies or web sites and also it will be much safer having it, because there will be a less chance of losing any data.

  2. Impact of ICT on the community

    These machines meet the needs of the community as people are able to withdraw money at any time. It is also quick to withdraw money as if there weren't any ATM machines it would have taken much time queuing in a lane and getting cash from the bank.

  1. OCR Nationals Unit 21 - Task 8

    I aslo put the same effect 'Blur' on the big 'Special Offers' writing right at the top of the avdertising banner. Now I have to add the text that explanins what the offer actually is. The offer has to be: 'Fly 10 times on any SRL Route and receive a

  2. a level ict project

    The CD can still be used as a fundamental backup medium, in case of a system restore9 operation, etc. the CD can be kept to start over again or even compare to any future systems that may be developed.

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