• 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

Some of these calculations can be complex and errors arise. In order to aid efficiency and ultimately save time, the owner of the company would like an automated system whereby quotes can be issued to clients via a PC system through a printed quote.

Extracts from this document...

Introduction

Section 1:        Specification

  1. Description of the Problem

CL Performance Car Insurance Ltd. is a growing specialised sports car insurance company. It deals with exotic and high performance sports cars and has a loyal customer group and has built up a good reputation. At this moment in time, the firm’s records are kept by hand, and all calculations etc. are done using a calculator. Some of these calculations can be complex and errors arise. In order to aid efficiency and ultimately save time, the owner of the company would like an automated system whereby quotes can be issued to clients via a PC system through a printed quote.  

  1. Input, Output and Processing of the Task

INPUT

  • Customer details, including; Forename, Surname, Address, Gender etc.
  • Insurance details, including the Insurance Group (1-20) for the brands of cars.
  • The multiplying factors need to be allocated for the gender, risk, age and the type of insurance the client requires. The multiplying factors are the numbers used and multiplied to calculate the insurance quote for a customer, e.g.: a multiplying factor in this quotation system requires the computer to multiply the age group 17-19 (value: 4.95) by the gender; for example male (value: 1.35). These values are purely estimates.

PROCESSING

  • Details of Insurance Groups need to be looked up from a table.
  • Details of the multiplying factors also need to be looked up.
  • Cost of quote needs to be calculated with and without any no claims bonus.
  • Details are to be stored for future reference, i.e. the addresses of clients etc.

OUTPUT

  • Quote details are to include customer forename, surname, address, car details and cost of insurance with and without any no claims bonus.
  • A customised formatted printed invoice. The invoice will contain the date of issue, expiry date, the company address, telephone number, fax number, e-mail address and the quote details. The invoice will also contain the company logo and it will be signed by a member of staff for verification purposes.
  1. End User Requirements

The following criteria need to be met in order for the quotation system to fulfil the end user requirements:

  1. User must be able to move freely between worksheets.
  2. To issue an accurate insurance quote. This involves details such as customer gender, age and car model all being correct e.g.  All the factors that influence the price of a quote.
  3. Must be user friendly, e.g. be as easy for the user to use as possible.
  4. Completed quotes need to be stored for future reference; these contain customer details and the actual quote details e.g. the car etc.
  5. The quote’s invoice must look professional.
  1. Design
Hard copy output design
  • The printout that will need to be produced is the invoice. A mock example of what this may look like is shown at the rear of this section on blank A4 paper labelled fig 1.1.  
Screen output design

The following worksheets will need to be produced:

  1. Front Page: a simple opening to the system.
  2. Insurance Groups/Cars Worksheet: containing cars, and insurance group costs, which are always subject to change due to fluctuating insurance premiums.
  3. Quotes Worksheet: the interface that the end-user will be working with in order to make quotes.
  4. Multipliers Worksheet: used to make the calculations for a quote, again subject to change.
  5. Customers Worksheet: stored quotes used for further reference.
  6. Data Worksheet: a temporary store of quotes.
  7. Customer Details: a sheet containing the details of prospective clients. This is purely for sample use in the project.
  8. Quote to Print Worksheet: displaying the quote to be printed.

Pencil drawn layouts of each of the sheets mentioned above can be found overleaf on the squared paper. The number next to each sheet corresponds to the numbers above.

Processing design

  • The LOOKUP function will be used on the quotes sheet in order to call up data from the groups/cars worksheet. The data on this sheet will be spit into 2 ranges which will be named to aid calculation.  
  • Details of the multiplying factors also need to be looked up.
  • Cost of quote needs to be calculated with and without any no claims bonus.
  • The customer details that need to be entered into the quotes worksheet will be looked up from a customer number.
  • Details are to be stored for future reference, i.e. the addresses of clients etc.
  1. ICT Skills of the User

The intended end user of this system will have had to have some experience in computer literacy and therefore be fairly fluent in the programs the database uses. So in this case, a sound understanding of Microsoft Excel is essential.

The layout of the worksheets must suit the skill level of the end user. Therefore the layout must be as user-friendly as possible. This means that the layout has to be clear, and simple to understand.

  1. Resources Available
  • To save time and money, a specific printer setting could be saved to enable each quote to look the same as the last one printed.
  • For back up purposes, zip-drives drives could be used as they have more storage capacity than floppy disks and are more durable. A fire proof storage facility would need to be put in place in case of such incidents.

Section 2:         Implementation

  1. Hardware & Software to be Used
  • Hardware that will be required to run the system will be a Windows PC with the minimum requirements being: Windows 98 browser, Pentium 2 Processor, and 32MB RAM. Other requirements include a suitable visual display unit (VDU monitor), a keyboard, a mouse, a 3½ inch and a CD-Rom drive. To prevent eyestrain, a screen filter should be attached to the monitor. In order to aid efficient printing, a printer with approximately a 12 pages per minute (ppm) printing speed should be used. A high quality printer should be used for presentation purposes.  
...read more.

Middle

 worksheet.

iii. Stop recording.

10) Modify Multipliers Macro:

i. Start recording (on Quotes worksheet).

ii. Switch to Multipliers worksheet.

iii. Stop recording.

ii)

image37.png

The formula in the ‘E’ column above calculates the number of years that drivers have not made an insurance claim, i.e. No Claims Bonus. The spinner scrolls through the years (1-6). The VLOOKUP looks into the table range C32:D38, column 2 in the Multipliers sheet. This then adjusts the total cost of the quote accordingly. The spinner is linked to cell D25.

iii)

image38.png

This part of the Quotes worksheet is where the customers’ details appear. The VLOOKUP function has been used again to call up the customer details. This is done by using a customer number system. A range in the Customers worksheet has been named after the sheet and the details have been looked up in this way. So entering the customer number 0115 calls up the following details opposite:image39.png

These can be seen later in the project, in the Customer Details worksheet analysis.

iv)

Once again the VLOOKUP function is used to call up the information for the quote. The named range Groups, mentioned earlier is used to calculate the brand, model, and insurance group for the car. The Multipliers sheet is looked up to calculate the gender, risk area and the age of the driver. It is also used to calculate the type of insurance chosen by thecustomer. An IF statement is used to calculate whether or not the customer is insuring the car with another driver. image40.png

        The totals are calculated easily by multiplying for the total without discount and no claims discount areas, and subtracting these two to find the total cost of the quote.

v)

...read more.

Conclusion

  • Completed quotes need to be stored for future reference

The ‘customers’ worksheet (testing Ref 2.4) in the system allows quotes to be stored for future reference. This sheet can be searched via scrolling through quotes that have been issued. This works very effectively as the end user can view quotes that have been made before and view that particular customer’s details. Storing quotes is very simple and is done by pressing the ‘store quote’ button on the ‘quotes’ worksheet (testing ref 2.1) after a quote has been completed to the customers requirements. The quote is stored permanently in the system via exiting the system and SAVING changes. One factor that could have been improved in this section is that the quotes could have been dated to view the oldest/newest quotes. Although the system works in a way that the oldest quotes are stored towards the bottom as they filter downwards.  

  • The quote’s invoice must look professional.

The printed invoice (Fig 1.2 overleaf from Page 19) looks quite professional in its appearance and overall layout. The invoice does not use excessive colours to try and get the ‘business’ look and feel. If the invoice were to be used in its proper environment, it would need a copy of the invoice attached for the firm’s future reference. This would mean that the printer settings for the printing of an invoice would be set to 2 copies. It would also be printed on much thinner paper giving the invoice ‘feel’. If I had more time on this section I would have added some terms and conditions that many invoices have, e.g. that the prices of insurance quotes are subject to change without notice etc.

...read more.

This student written piece of work is one of many that can be found in our University Degree Computer Science 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 University Degree Computer Science essays

  1. Marked by a teacher

    Cisc v risc. To begin this assignment , I will outline the definition ...

    This can be done in the same amount of time as "mult" from above in cisc but the instructions in risc are less complex and require less transistors of hardware space . also because the instructions execute in a uniform amount of time ( i.e one clock)

  2. Create an online catalogue system that specialises in children's toys and enables users to ...

    * Client and server platforms can be independent of hardware and operating system software platforms. * Since the server is centrally maintained, it means that the integrity constraints have to be validated and defined in only one place rather than each application program performing its own checks.

  1. Develop a Puzzle Website for users of three different age groups, Kids, Teenagers and ...

    5% 95% General functionality - 5% 20% 75% (This test was conducted on 20 people) 8. Possible future enhancements. 8.1 Electronic Mail Service Email is another feature we thought about implementing, as it is another communication medium that would be beneficial to the endeavour of the project.

  2. Phong Shading and Gouraud Shading The standard reflection model in computer graphics that ...

    in the manner of a mirror where most of the light bounces off in a particular direction defined by the surface shape. Specular lighting is what produces the shiny highlights and helps us to distinguish between flat, dull surfaces such as plaster and shiny surfaces like polished plastics and metals.

  1. The project explains various algorithms that are exercised to recognize the characters present on ...

    Thus, this project uncovers the fundamental idea of various algorithms required to accomplish character recognition from the license plate during Template Matching. 1.3. Significance of the Project The main importance of the project lies in the way the various algorithms are implemented to create an automated system for License Plate Recognition.

  2. Geometric Brownian Motion. The aim of this project is to gain an understanding ...

    Historical data is being used in order to estimate future stock prices. Stock prices are observed at fixed intervals of time that will be used in this project including daily, weekly and monthly. Volatility can be estimated by the movement of stock prices.

  1. Training Booking System with ASP. I believe I have displayed the knowledge required ...

    which course they are on, when it takes place and when it was booked. Logout page - This logs you out and offers you a link back to the start. - This page offers no redirection, if it is accessed without logging in, it doesn't do anything except displaying the usual logged out message.

  2. A basic RFID system consists of main two elements an interrogator and a transponder

    like every 3 second for example or once a day depending on how important is the assets, the beacons signal then picked by at least three antennas placed around the location or perimeter of the area were assets been tracked.

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