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

    The power arcxhitecture is still in use today and ibm have launched many version from power 1 to the latest power 8 which is still under development from ibm today. Thye power one included a 8kb instruction cache and either a 32 bit or 64 data cache.

  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 ...

    It discusses various capabilities and features of the board. Moreover, this chapter also discusses about various functions that are required for the implementation of license plate recognition Chapter 5 presents the design results including simulation and DM6437 hardware implementation. It also discusses about various optimization techniques that are taken to improve the performance of the design.

  2. Information systems development literature review. Since the 1960s Methodologies, Frameworks, Approaches and CASE ...

    Reference access is limited therefore factual validity is difficult to determine. However through the use of other resources similarities were distinguished regarding the descriptions provided for methodologies included. Usefulness: This paper provides a clear overview of the Waterfall, Prototyping, Incremental, Spiral and Rapid Application Development (RAD)

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

    and will be used to calculate the main objectives which are GBM and V-a-R values. 'Loops' and 'for statements' will be applied in VBA in order for the software to run smoothly and for calculations to be done correctly. Validation will be put in place to reduce errors.

  2. 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.

  1. Lifecycle Management Of Information Technology Project In Construction

    of project. To the large extent, each ta?k work? with the type of information model that reflect? that ta?k'? unique view or per?pective, with little integration between the?e different information view?. Thi? wide range of di?parate information view? add? to fragmentation of the?e ta?k?. With the few exception? (?uch a?

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

    Active RFID system A tag which have its own transmitting system and usually not always have there own source of power, it can be a battery or some of them could draw energy from the sun using solar cells or other source of energy, the active tags broadcast signals containing information stored on the microchip.

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