• 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

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

    I inserted the data into the specific criteria boxes: The "Lookup_value" is the cell you want to look up e.g. you may put a student surname in that cell and want it to look it up. The "Table_array" is the cell range your data is in, for it to look it up e.g.

  2. Powerpoint review project

    The disadvantage of using books is that it is time consuming and does not always have enough information. Data Collection/Input The data will be input by firstly connecting the camera to the computer so that it will appear onto the screen.

  1. Spreadsheet for a basketball company

    Mainly phone but post and e-mails are also other ways. Seating Plan The court designer and Mrs Suprabha, the manager The manager gave me a diagram of the seating plan with essential depiction. Cost price and selling price of tickets according to their type Mrs Supru, the accountant Mrs Supru

  2. Excel - Analyse

    * Lifespan is not bad for the price that is paid. The ball mouse seems like a bad choice because there are several disadvantages, I am planing to use wireless mouse because it removes the clutter of cables, and the latest ones are accurate because based on Optical technology.

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

    The spreadsheet itself will function by the member of staff typing in the valid details of the description of item he wishes to sell. The computer will thereby automatically search for the necessary price of the item, and will check the validity of the quantity sold, and whether the company has to restock that specific item.


    ID Surname Address - 1st Line Medical History Last Check up Prescriptions Subscribed Final design ID Title Surname Other names Date of Birth Gender ID Surname Address - 1st Line Address - 2nd Line Here is my new and improved design, as you can see I have added an ID

  1. Library system

    Data size Why is this data important Book ID Auto number Number Up to 100, 000 Each book has to have its own unique number to identify it in the database. Book title Text Text Up to 100 Each book must have a name in order for you to save time looking.

  2. In this project I will produce a spreadsheet for a successful and potential company

    I will also be asking about the network they use and the type of software that is available to me this will be researched by interviewing the technical director of the company. I will also be conducting a survey for the staff at employees asking what they would like to

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