• 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. Powerpoint review project

    Above shows the second part of the transitions menu. As you can see it is named 'Modify Transition and 'Advance Slide' these are two options that allow you to edit the transitions. The modify section allows you to choose the speed and sound of the transition whilst the advanced slide area allows you to choose whether the slide advances by a mouse click or automatically after a set time.

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

    click on the square which contains the previous amount and change it to the new amount, this will then do so without any other changes and should not result in anything becoming non-functional. Also the spreadsheet allows Mr. Brown to see exactly where each person was sitting, how many of each class of person and their pricing.

  2. In the following report, I will describe, using screenshots, the advanced features of Microsoft ...

    I saved the workbook as a template by selecting 'File' and 'Save As', which opens the 'Save As' dialogue box (below) In the 'Save As Type' box, I selected 'Template', typed 'Recruitment Form' as the 'File Name' and then clicked 'Save'.

  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. Appropriate Software To do this project I am going to use excel because ...

    The end user: Mr. Robert who sets the target Employees The staff that Mr. Robert employs The end user: Mr Robert who employs the staff Cost of the Employees The wages of the employees The end user: Mr Robert who employs the staff Units Sold The number of units sold for each product.

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

    To do this, I first had to create a nested If function to tell me what grade the child had actually achieved, depending on their percentage. To do this, I did the following: 1) I clicked on the cell I wanted to create the formula in, and then clicked the "Fx" icon next to the formula bar.

  2. 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.

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