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

    Parents can look up education and find the best schools to go to in the area for their children using the site. They can find which school would fit their exact location and needs. This is extremely useful and helpful to children as parents can choose which school would suit their child best.

  2. OCR Nationals Unit 21 - Task 8

    After I Previewed it, I was satisfied, but I thought that the effect was too short. I used the Timeline to increase the duration of the effect, and decided for it to last 60 Frames. I done this by clicking on the 60th Frame on the Background Layer as shown

  1. IT system for local video store.

    * A password must be on the system so that no unauthorised personnel can access it; there must also be the facility to change the password if necessary. * The system must be user friendly, so a graphical interface is necessary.

  2. Creating an I.T. System for the Al Shabah Publishing Group

    software: * Documentation is hard to understand * Mistakes made during the creation of the tables affect the whole database; in the effect of fields being altered or deleted the forms must be redone together with the reports. * If a records are deleted that have Auto Number fields in

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

    Finally I will click on validation text and type in (Enter "MALE" or "FEMALE" only please!). etc. The method for using validation rules and validation text worked really well. The only change should be that it would be easier if there was screenshots or images.

  2. ICT notes

    * Have regular eyesight tests. * Take regular breaks. Back/Circulation problems * Poor posture. * Sitting all day in front of a computer. * Ensure posture is correct. * Take regular breaks and walk to improve circulation. The use of ICT when Paying Staff WagesStaff at the health centre are paid using a computerised system and their wages are paid straight into their bank account.

  1. Create an IT system for my karate club.

    added together to find the amount owing by one member. This system has to be reusable as it needs to be able to be updated on a regular basis (the system actually will need to be updated every three months as people go a belt higher then and some children might move to the adults classes etc).

  2. The system chosen for this application is the computerised system. This computerised system works ...

    They are used by users that are using computers for the first time and if the system is not too complex. 3. Custom designed. This software are designed by analysts and engineers. This takes time as the system analysts have to prepare all the programs on flowcharts and then have to actually design the system.

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