• 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


    My fifth objective was that the database must contain records on Names, Gender, and DOB. This was all achieved (check database) After looking back at my database, I think that I have done a good job, but I believe it could be improved.

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

    Also the spreadsheet allows Mr. Brown to see exactly where each person was sitting, how many of each class of person and their pricing. The fixed costs can also be examined thoroughly as all digits that are taken into account, including percentages, are open for the user to see and change.

  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

    Compute the remaining stocks whenever the items of the income increase. This must be shown in both the expenditure and the income page. 2. Analyse 2.1. Hardware The hardware required is a computer, a mouse, and a keyboard. The operating system used is Windows XP to run the necessary application software for viewing and editing the spreadsheet.

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

    * Should calculate the profit and loss of the company. * Will notify any mistyped data on the system. This will be accomplished by using validation checks. * Retrieve data rapidly TASK C: Spreadsheet coursework page 2 * Clear and simple instructions for both beginners and advanced users.

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