• 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
• Level: GCSE
• Subject: Maths
• Word count: 1222

# 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

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

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

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

# Related GCSE T-Total essays

1. ## T-Shapes Coursework

Because a mean is the sum of a set of numbers, divided by the number of terms in that set, we can find the sum of the set by multiplying the mean by the number of terms: Mean = Sum of Set Number of Terms Sum of Set = Mean

2. ## Maths Coursework T-Totals

origin T-Shape has a T-Total of 187, and the translated T-Shape has a T-Total of 67, using the equation we will try and generate the Second T-Total to prove our theory correct, CHECK YOUR RULE WITH EXAMPLES t=((5x41)-(2x9))-(3(5x9)-5x3) t=(205-18)-(135-15) t=187-120 t=67 My equation has been proved correct using this translation

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. ## Using Formulas In Microsoft Excel.

=MIN (B2:B11) Before starting the list of names you had to think about using a heading for each specific section of the chart. You could use any style of font or colour scheme. This would be my example: Name Age Shoe size After completing that task, you move onto thinking

1. ## Maths coursework

at the base of the t-shape N- 9: this is the number above N and in each case, to get back to N you have to minus 9 N- 19: this is the number left of N - 18 and in each case, to get back to N you have

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

2. ## To prove that out of town shopping is becoming increasingly popular with shoppers, and ...

Accessibility has improved over the years so much so that people hardly think about a place being inaccessible. Also lorries can deliver goods to shops quicker so that a wider range of goods is available. Bulk buying is when shoppers go for a shopping trip once a week or month.

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