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

    This is the first step CCTVs do in reducing crime. The fear of being caught on camera stops the crime from happening in the first place. If a crime is captured, then it can be used as evidence in a court case.

  2. ICT notes

    Inputs Processing Outputs Employee payroll number, name, address, DOB, marital status, N I number, hourly rate/annual salary, pension details, holiday entitlement, days off sick etc * Employee record will be read by the system. * Each employee will be paid by the system.

  1. Free essay

    security issue

    It has been know to be similar to a worm. Some Trojans may not cause harm to your computer but the six main types of Trojans are ones that cause remote access, data destruction, download, get on to a server, anti - viruses software disabler and denial of service attack.

  2. OCR Nationals Unit 21 - Task 8

    in the screenshot, and then pressing on F6 at the top of the keyboard. Doing that increased the duration, and I knew it worked because the the frame became grey as it stretched out from the 1st to the 60th.

  1. System requirements analysis

    This monitor is also quite cheap, being only �79.00. This would be suitable for the health care centre as it is a new practise and has a low budget. Unlike the TFT and the LCD monitors, is not that fragile. The screen of the monitor is not at a high risk of being damaged or scratched, the cost of repairing a TFT or LCD monitor is also, quite high.

  2. Creating a computer system for a video rental shop

    This is better than fonts such as Algerian which although is fancy, is difficult to read. Forms Methods of Data Entry The user only needs to enter data into the database about the customer, parcel, destination and order. To make data entry easy I have written instructions for the user

  1. ICT car insurance quotation System Coursework

    3-How easy it was to use as an end user 4-The background or colours used (which would have an effect on the end user(s) mood) 5-How clear the instructions were for the end user. 6-The time taken to retrieve a quote.

  2. Creating a computer system.

    > The company name and address. > A text box for customer details (name, address, telephone number). > A box at the top right hand side of the page, with the invoice number, date and customer ID. > There will also need to click on buttons related to font sizes, styles and colour themes.

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