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

    A lot of credit card fraud is negated this way. Summary * Negates the need of the prolonged method of going to a banker * Quick, fast and simple to use * Located in a lot of areas allowing you to withdraw money in a large variety of places *

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

    This is the largest database held on the police national computer with over 48 million records of vehicles and their owners. The data is constantly updated by the vehicle Licensing authority that handles all the vehicle licences. With the latest software called vehicle online descriptive search(VODS), offers around the country

  1. OCR Nationals Unit 21 - Task 8

    This helps the purpose of attracting the Target Audience to the Offer being advertised. I made 7 key frames, as there are 7 words that I will add first. Between each key frame there is one frame so that the speed can be good and steady.

  2. System requirements analysis

    as I have using Microsoft Office as it is only compatible with Microsoft Windows. When buying/installing software, consumers need to check whether it is compatible with the operating system, but usually this is not a problem as most software are compatible with both and it is just a case of different methods of installing software.

  1. I will be analysing the problems defined by the management in the old system ...

    processes are going on in the system and how it is responding. I will also add Norton Antivirus 2003. This is by far the world's most trusted anti-virus solution. It repairs common virus infections automatically, without interrupting your work. It scans and cleans both incoming and outgoing email, and defends against script-based viruses even between virus definition updates.

  2. Introduction to information skills and system. An information system is a system that accepts ...

    E.g. hard disk / floppy disk. Uses random memory access. Optical media uses laser technology to read and write on CD, CDR or CDRE. Written with high power laser to create lots of tiny holes on disk. Flash memory is erasable memory chips e.g. USB, SD card, memory stick etc.

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