• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

The task that I am going to provide a solution for is to produce a computerised quotation system for S & S Insurances.

Extracts from this document...

Introduction

SPECIFICATION The task that I am going to provide a solution for is to produce a computerised quotation system for S & S Insurances. EXISTING SYSTEM: Thomas Davidson is currently a broker providing insurance for cars. At present he insures through a financial institution, S & S Finances. He is a broker working for the insurance company S & S Insurances. He has worked with many insurance companies in the past trying to find the best deal so that he can earn a good amount of profit. He finally made a deal with S & S Insurances in which he can gain a good amount of commission. His job is to find customers who would like to buy insurance for their cars and he gains a commission of 7.5% for each customer to whom he sells a quote. He started his career as a broker approximately three years ago after being made redundant as a factory worker assembling car parts. He has no employees working for him at the moment. However his wife helps him with the paperwork when she can. Thomas works full- time from his home study, which is located in the heart of Streatham. In the past Thomas has had a lot of experience dealing with customers and clients. He now has a number of devoted customers who frequently contact him when the renewal for their car insurance is due. Thomas usually interacts with his customers over the phone from his study; sometimes however he does conduct business at the home of his customer to their convenience. When Thomas finds an interested client he firstly explains to the client everything that is involved in the quote. In order for Thomas to calculate the insurance quote, he uses a calculator, a record of tables with the insurance ratings provided by S & S Insurances and his diary where he notes all the information down. ...read more.

Middle

* The system should show all the details about the customers such as names, surnames, addresses and other details. * The system should be able to store the issued quotes so that they can be used at a later date. * The system should have drop down boxes so the user can select options quickly and easily. NEW SYSTEM: HARDWARE: In order to computerise the quotation system I will need a Windows XP computer. I will also need a QWERTY keyboard and a mouse in order to input the data into the spreadsheet. I will be using the hard drive to save the spreadsheet on an internal storage. I will also be saving the spreadsheet on an external storage such as CR-RW so that I have a back- up copy of the data in case the original copy is deleted I will still have another copy. I will also be using a VDU (visual display unit) to see the spreadsheet. I will also be using a printer to print out the quotes so that the user can see them and then send them to S & S Insurances. SOFTWARE: In order to produce the car insurance quotation system I will be using spreadsheet software for many reasons. In a spreadsheet I can use many of the features which will enable me to produce an efficient quotation system. I can use macros, list boxes, combo boxes, V Lookup, IF statements and other features in the system. There is other software such as a word- processor or a database but they are not suitable for this quotation system. Although you can make tables and do basic calculations they are only limited as they are not mainly designed for that purpose. I will be using Microsoft Excel 2003 as I do not have any other spreadsheet software available on my computer. I will also use it as I am more familiar with it as I have used it many times in the past. ...read more.

Conclusion

I will be using a check box for the declaration of the extra driver. A spinner is made up of two arrows, one point up and the other down. By clicking on the up arrow increases the value and the down arrow decreases the value. I will be using the spinner to choose the number of years the driver has made no claims. I will also be using IF statements in order to see the values of the check box which will check whether the customer would like an extra driver. * To make the system user- friendly. In order to make the printed quote professional and organised I will be adding the name of the company, address, telephone numbers and the company logo at the top. I will also arrange all the information into sections and add colour to make it look more attractive. I will create the macros into buttons so the user can quickly carry the tasks. I will also add a front end to the system. A front end is the name given to the user-friendly interface that will appear on the screen when the file is loaded. It will provide the user with a number of options. Once the data has been entered I will need to rename the worksheets and insert a defined name for certain data which will be used in calculations. Output: The output will be the full quote details, which will be on the screen of the computer showing the customer name, address, car details, and the cost of the insurance and without the discount. The output on the screen will also show the macros, which can be used to navigate around the system. The other output will be the fully modified and professional printed quote that will show the company logo along with the company's address and contact numbers. It will also show the issue date, all the details about the quote and the expiry date of the quote. ?? ?? ?? ?? Neelam Patel 12F ICT Coursework ...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)

    The efficient, easy use of an ATM machine to withdraw cash can also be a big downside. With the ease of money transfer which is supposed to be securely stored, it might tempt you to withdraw too much for personal needs.

  2. Free essay

    security issue

    to go on and it could led you to harmful viruses that could affect your computer. When turning off your computer spyware can even change your computer settings. Trojan - A Trojan is a computer virus that appears on your computer designed to cause your computer harm.

  1. Benefits of using my IT system in the Travel Agents.

    * Click on Copy so that it copies the details you have selected. * Open your template letter and then place your mouse where the lines/dots are placed. * Then you should Right Click and click on Paste. Saving * First, click on File and then click on Save As.

  2. I am now going to analyse my clients current system in order to get ...

    * If you want an explanation or an extended answer, you can ask an open question. * If it is a private questionnaire, then they may not lie to protect their colleagues' feeling. Disadvantages: * They might not want to upset their colleagues and may end up giving dishonest answers if the questionnaire is done in public.

  1. Producing a database and standard letters - difference between computerised and manual systems

    is only limited but if you go to the company then you can get way more information than you need. Furthermore if you had no access to any to go to the company or library then it will be very difficult for you.

  2. Database Coursework

    Duration of Loan Number Long Integer I have set this as Number. This can be any length as it linked to the duration of loan. Date Due Date/Time ----------------------- This is set to date/time and formatted to short date as date of birth is a special date field.

  1. ICT notes

    Provide health and safety training and information to all staff. There are various health problems associated with the regular use of computers. Here are some of the most common problems and what can be done to reduce the risks: Health Problem Cause Solution Repetitive Strain Injury (RSI)

  2. Travel Agent Database - Effects of New System The new system will affect ...

    Opening a new department for teaching for the employees would be a fantastic idea. This is because the department would be able to cater for many clients at once. This means that this method be very fast and obviously better than the methods mentioned above.

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