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

    data loss and I will store the original and back up file themselves into a folder which will be named 'PowerPoint'. This strategy will help me to find the files and to open them safely. I will avoid losing my work by saving the presentation and other work every 5

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

  1. Excel - Analyse

    DDR (double data rate) SD (Synchronous Dynamic) * Expensive * Does not work as efficiently as DDR. * Half the processing power of DDR rams. * Expensive * Fast access * Cheaper then SD ram * There are no advantages of SD ram over DDR.

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

    of paper that will be reinforced by the hard disk, and a floppy disk for backup. My flow chart (Fig 1) represents the steps for me to use the spreadsheet that I have produced. Acquainting the fact that my coursework is based on the VAT results, and to calculate the


    Description Saved query name Table(s) to be used Fields to be shown Criteria used Sort order Simple query to find all Males All Males "Search for patients" Title Surname Other names Gender= "Male" Ascending Complex query to find Last check ups made by patients for 01/02/2006 General checkups on 1st Feb 2006 Medical Information Surname

  2. Library system

    Author Text Text Up to 30 If you don't have its number you will still be able to find it Publisher Text Text Up to 30 If you don't have its number you will still be able to find it Date published Date Number Up to 10 This helps the

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

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

    To fill the top cells of each result table, you do the following: 1) High-light the cells you want to colour, and click on the icon showing a picture of a pouring paint bucket(the fill colour icon,) this is situated in the top right hand corner of the toolbar.

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