• 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
  • Level: GCSE
  • Subject: ICT
  • Word count: 1708

ICT Coursework Task 1b - MODELLING.

Extracts from this document...

Introduction

SYSTEM ANALYSIS Requirement specification and expected outcomes The reason of me producing this system is to be able to generate estimated prices of the hire of a car for LIA Car hire service which is based is based in Luton Airport. Luton Airport has decided, after lots of consideration, they need to expand their services at the Airport. They have decided to open a hire service for Cars. They have everything ready and now all they need is a model which will be able to generate estimated prices for each Car Hire. I have been given this job. The main reasons of wanted a model which will generate the estimated prices is so the system operator will not have to go through all of the calculations and things. If there was not a model which would generate the figures it would be very complicated and very easy for there to be a mistake. The model will generate the prices with formulas. There will be fewer chances of mistakes, it will make the work easier for the operator, and the customer will get a quick estimate of how much they are looking at paying. The users of my system will be the System Manager, his or her job will be to update the system whenever they are needed e.g. ...read more.

Middle

These would be suitable for the task because they are both able to work out formulas and both have the tools which are needed for the task in hand. The software must be able to work out formulas it must be able to have functions like, What ifs, time, Date and so on. A What if is a command which will be able to use two options, e.g. if one value is less then this then the answer is this if it is this value it is that. We will need the date to work out the persons Age. There are loads of formulas involved like simple sums, multiplication, division and subtraction. I have decided to use Microsoft Excel for the model, this is my decision because I think that Microsoft Excel is much easier to use than Database. I say this because I have had much more practise on Microsoft Excel than database. I also chose Microsoft Excel because it has more of the options which I need for the model. So I chose Microsoft Excel over the Database. SYSTEM DESIGN Initial ideas and layout First of all I had to build up the structure of the model on paper. My very first design all of the information went downwards leading on to 2 portrait pages. ...read more.

Conclusion

It produced an invoice automatically, I think that my model was a success because it was user friendly it did what it was supposed to. But if I was given a chance to do it again I would be able to more stuff to make it better I will be able to put more functions. Making my model was not as difficult as I thought it would be, I thought it would take up all of my time, that it would be very difficult with all of those formulas and stuff but I was able to make it all in class I did not have to take it home. So I think that it was not too hard to make my model. The software choice was good because I was able to do everything I needed to do on Microsoft Excel. So it was easy to do it on this program because it had all of the functions which were needed. To improve my system I would try to make the estimate of the car hire more accurate somehow, I would also use a wider variety of cars in my system. I would try to build up my invoice more as well. My software choice was appropriate because it does what I needed to do on it. So in conclusion my system was a success. 1 Ikhlas Raja 10s5 Candidate No.9297 Centre No. 15223 ...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. Different types of technology How I use ICT at home and at school

    Watching TV generally involves being inactive and the more you do it, the more relaxed and habitual it becomes. This generally then makes you very lazy and inactive, causing you to just sit down and watch TV all day. For a child, I need to be more active but I'm not.

  2. GCSE Excel Project ICT

    As you can see, the addition in the formula states a specific sheet and cell (a cell on sheet1). This is to prevent confusion within the formula with the cell B16 on the current sheet (sheet7). With this addition in place, the sheet should look like this: Printouts of each report, with screenshots of each worksheet and showing formulas used.

  1. Manchester airport

    This will include putting a smaller bomb into the chamber along with the bag, which will trigger the larger bomb. If the owner of the bag does not arrive and they cannot be located, then the same process occurs. This is called 'I.E.D in bag procedure'.

  2. Ict coursework full

    It is simple, and I like the way it is laid out. I do think that it would be hard to pull off, without it looking busy and cluttered. I like input page #3, because it fits in well with home page #3 (my favorite of the 3 home pages).

  1. GCSE ICT Coursework Booklet

    * Training may be required to use the system. * Data could by lost from hackers or accidental loss. * The system may slow things down initially. The installation of a new computer system will clearly be an advantage for the shop even though it will cost a lot of money to buy and set up properly with good

  2. Ict Powerpoint Coursework

    There are absolutely no disadvantages for this product. YES I have chosen to go along with this desk set bundle from Microsoft because you need it to run a Pc, its cheap and is very reliable. 2TB Iomega MiniMax External Hard Drive FireWire 34695 This is a 2,000 gigabyte external

  1. Database coursework

    Spreadsheet This alternative is similar to the database but it can be done by a spreadsheet editing program. This alternative requires that the company has a working computer system. And in addition to that a Spreadsheet making program. It will also include that the company purchases a spreadsheet editing program.

  2. Producing documents for a company. Spreadsheet, Invoice and Website.

    * Can sort and search data * Large range of formulas for performing complex calculations * Can produce graphs * Good for large computations * Offers good automation features * Supports User Interface/Menu * Relatively easy to develop and maintain * Complex searches limited and must be physically created each

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