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

ICT system analysis and modelling.

Extracts from this document...

Introduction

ICT Coursework Task 1b -  MODELLING

SYSTEM ANALYSIS

Requirement specification and expected outcomes

I had to produce a model which will be used for LIA Car Hire Ltd. It had to be able to intake customer details and financial information.

The users of the system will be the system manager and the operator working in the company.

The information will be presented on screen to the customer but also an invoice will be printed out for the customer if necessary.

The information that will be collected by the customers will be personal information, financial information and also vehicle information. This is such as name, age, address for personal. Price, rental charge etc for financial data and make, model, red, mileage for hire.

The invoice is produced when information is input on the final draft and it transfers the information on to the invoice draft.

Todays Date

Vehicle Data

Hire Data

Customer Data

Reg No

Date Hired

Surname

Make

Insurance Costs

Name

Model

Price Per Mile

Address

Colour

V.A.T

Town

Engine Size (cc)

Rental Cost

County

Milage Begin

Total Days Taken

Postal Code

Mileage End

Mileage Cost

Home No

Mileage Total

Total Insurance Costs

Mobile No

Total Rental Costs

Date of Birth

Sub Total

Age

Total VAT

Total inc. VAT

Software selection

...read more.

Middle

Price Per Mile

£0.07

V.A.T

17.50%

Rental Cost

25

Total Days Taken

14

Mileage Cost

70

Total Insurance Costs

140

Total Rental Costs

350

Sub Total

420

Total VAT

73.50

Total inc. VAT

493.50

The mileage cost was a simple equation =(F14*I9)which is the mileage total times by the price per mile. It was a simple formulas used to find out the mileage cost. Another formulas ised is shown below.

=IF(F11>1600,30,K10)*I12

Hire Data

Date Hired

13/01/2003

Insurance Costs

10

Price Per Mile

£0.07

V.A.T

17.50%

Rental Cost

25

Total Days Taken

14

Mileage Cost

70

Total Insurance Costs

140

Total Rental Costs

350

Sub Total

420

Total VAT

73.50

Total inc. VAT

493.50

This was used to find out the total rental costs. This formula is called ‘if command’. And does basically two sums in one. It basically mean if the f11 engine size is larger than 1600 then the price is 30 otherwise the times k10 25 by i12 total days taken which is 14.

Final model

...read more.

Conclusion

SYSTEM EVALUATION

System improvements

I had to produce a model which will be used for LIA Car Hire Ltd. It had to be able to intake customer details and financial information. I did not have many problems whilst producing the model but I did have some obstacles on the way which I overcome. I could improve my model in many ways. I could have it more sophisticated so that users will enjoy using it and also by having more help option to the user to guide them on how to use the system. I could add more aspects on the model so it will make it more user friendly. I would do all of these tasks if I had more time to do so. I chose Microsoft excel to make my model as it was easy to use and I was familiar with the program. I think I need to learn to use Microsoft access as it has more features available on it to make my model better to use and make it user friendly.

On the whole my model was a success.

Zahid Mahmood 11w2

...read more.

This student written piece of work is one of many that can be found in our GCSE T-Total 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 T-Total essays

  1. T-Shapes Coursework

    + 1} (Substituting p as described above) 2 n{w - 1 + 1} wn B) Justification of Sum of Tail This is the same justification as in Section 4, but the "10"s have been replaced with "g"s. [Sum of Tail] = + [Sum of Tail] = 2 x [Sum of Tail] = 2 x [Sum of Tail]

  2. Maths Coursework T-Totals

    One simple change needs to be made to my horizontal translation equation, that as "a" was also used for the figure by which to translate (the same as the vertical translation), we have to substitute "a" with "b" in the horizontal equation otherwise we can only move the T-Shape, is fixed diagonal positions.

  1. Maths coursework

    t-shape for N14 is in grid one and the t-shape for N16 is in grid two. T in grid 1 = 28 T in grid 2 = 38 Here it shows that (2/0) is 10 more than (0/0). Therefore the formula here is T2 = 5N - 7G + 10

  2. I am going to investigate how changing the number of tiles at the centre ...

    This tells you the formula is based on N�. The second difference is 4 and you divide this by 2, to get 2. This is the multiplier of N�, so you should now have 2N�. You will then need to find the second part of the equation, this will be

  1. For this task we were required to create a model that can be used ...

    This should give you the bill amount. This is how a standard model bill is worked out. There is another bill, which works differently to a standard model. This model works by having two different costs per unit. A split value is needed, such as 182 units for npower.

  2. Pay Role Model.

    The second change I did was changing Bryson's total hrs from 70 to 50. So this is a decrease in the total hours Bryson works so his overall net pay will decrease The third change is the same as before I changed the hours worked.

  1. The T-Total Mathematics Coursework Task.

    Thus the above basic formula can be generated. If we say that 20 is t and t can be any T-Number, we get: T = t + t - 9 + t - 19 + t - 18 + t - 17 To prove this we can substitute t for the values we used in our table, we

  2. Modelling - Using a spreadsheet.

    4000 Security Staff Wages 5000 Paramedic Team Wages 4000 Stadium fee 50000 Income Ticket Sales =B2*B3 Food sales =B2*B4 Merchandise Sales =B2*B5 Total =SUM(E3:E5) This is the amount of tickets sold times the price per ticket, the amount of tickets sold times the estimated amount spent on food per person,

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