• 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
  • Level: GCSE
  • Subject: ICT
  • Word count: 6065

ICT car insurance quotation System Coursework

Extracts from this document...


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.


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.


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)

    This makes it easy for a lot of people to transfer money and saves a lot of time. It's located in a lot of ideal and efficient areas, such as outside a supermarket. This allows people to use them when they're in a dire need of money without having to

  2. The impact of ICT on a person with special/particular needs

    As we all know, her limb control is limited and it may be too much for her to try and use a touch screen and some of the iPhone's intricate features. But this is made much easier with a feature such as the voice command.

  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. Ict Powerpoint Coursework

    This computer could also run any software in the world and it could open up gigabytes of memory and still run at a sonic speed with its 12gb DDR3 ram. The only disadvantage is that the Pc is not custom made and not as reliable as manufacture based products like Hp pavilions Pc's.

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

    I can also keep up to date with the latest music on the various music channels there are. This lets me be cultured and have a developed taste on what I like and what I don't like. I can know what's new and use this knowledge to successfully form a conversation surrounding music with people.

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

    Computers help nurses and doctors monitor vital body function of patients e,g heart rate. With equipment with built in microprocessors, Microprocessors are what make the computer work as each computer is full of silicone chips (microprocessors ). Babies are monitored in incubators and readings are taken of heart beat etc

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

    Terminals, input/output, process, database, decision, flow line. Decision trees show all possible decisions and their results. External specification - the appearance of new system Internal specifications - providing technical support to build the system, identify process required by new system, specifications for input data. Information technology - application software may be available e.g.

  2. Impact of ICT on the community

    Before the customers didn't needed to enter their PIN number now the customers has to enter it for security reasons. How does the technology meet the needs of the community? Every bank has its own ATM's machines however the bank card works in every ATM machine.

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