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

An I.T. system for a car fleet Manager

Extracts from this document...


Identify Identification of problem * I have been approached by a car fleet manager and asked to create spreadsheet to calculate bill's for employees who use the cars under your management. * The problem is that the company has been overcharging due to a disorganised filing system, that is why they want it done by computer. * Another problem is that the company has been getting people's files mixed up, so they have asked me to create a spreadsheet so all the files are in order and backed up so they can't get lost. * They have asked me to sort out their files quickly so that they get no more angry customers complaining because they have been overcharged. ...read more.


Microsoft excel allows you to add comments which means that you are able to writ a comment next to a figure to explain what it means, and if there is a blank space you are able to explain why there is no figure in that space just by using this function. Conditional Formatting allows you to make certain figures stand out from the rest, you would want to too this for instance if someone is late with a payment or is paying in instalments and is late with one of them. Microsoft excel allows you to create a look up table which allows you to input a grade for a certain person depending on what their marks are etc. ...read more.


Comparison with alternative I have chosen to do my project in Microsoft excel instead of other packages such as Microsoft Word because Microsoft Excel is by far the easiest package to navigate around. If you choose to do it in Microsoft Word then you will have to create a table and adjust it to the size you want which will take a long time, but in Microsoft Excel it is already done for you. This program has many advantages over Microsoft Word. Although Microsoft Word can do a few of the following: * Entering Formulae * Adding comments * Contitional Formatting * Creating a look up table * Data validation * Using goal seek * Inserting buttons and Macros Analyse Objectives Information requirements and origins Outputs and purposes Processing requirements Plan of action Design Overview of complete system Details of system User requirements File description ...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 Software 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 Software essays


    I achieved this by creating 3 queries to search for particular records. My forth objective was that the Database must have command buttons that can allow the user to easily move from record to record and add and delete records. I achieved this by adding and deleting new records (testing).

  2. The aim of my project is to make the task of the allocation of ...

    To see if the spreadsheet will allow the user to change pricing without causing any damage we will change all numbers, including: pricing of seating, cost of shows, projected profits % and pricing of confectionary goods to zero. This will also tell us if all spreadsheet formulas function correctly.

  1. A Program for a Cinema Manager

    =Sum (C3:G3)-Adds up the content of cells C3 to E3. * The "what if" function. With a series of formulae, it is possible to make changes to figures and see what happens to expenditure and income. The spreadsheet program automatically updating figures does this.

  2. Fix the problem of the car company's storage problem, using either excel or access.

    It seems to have many features which are useful to us and I think this would definitely be the best out of the three.

  1. A new IT system in a Dubai Marauders Rugby Football Club

    City * Postcode * Telephone Number * Type of Membership * Rugby Team The output of this task is to produce a working database containing information on the members of the rugby club. Each column will contain a different criteria and each row will relate to a different member.

  2. Spreadsheet Technical report. My task was to produce a grade book for primary ...

    had achieved 80% or more, they had got a level 6, if the student had achieved 70% or between 70% and 80% they had achieved a level 5, if the student had achieved 60% or between 60% and 70%, they had got a level 4, and if they had got less than 60%, they had achieved a level 3.

  1. Spreadsheet for a basketball company

    Restrict users from entering any anonymous value in the seating area 6. Calculate the company's income and expenditure for every match and based on these results, calculate the total profit for that specific match 7. Automate graphs relative to the company's income, expenditure and both of them in opposition to each other automatically 8.

  2. Spreadsheet. This coursework is based on the work of a spreadsheet, which is ...

    * The spreadsheet should be quicker, by calculating everything. Quick calculations shall be made, as soon as the description of item is keyed in. * Will have formulas that will allow new information to be typed and will affect the profit/loss of the company accordingly.

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