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

Introduction

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.

Middle

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.

Conclusion

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. ICT PROJECT PRESENTATION

    My second objective was that the database must be able to generate reports and mail merge documents; I achieved all this when I created clear reports and mail merged letters. My third objective was that the Database must have Queries to allow the user to search for records.

  2. Appropriate Software To do this project I am going to use excel because ...

    Colour printers themselves are quite expensive and having a black and white one would cost less. In conclusion I think a colour printer would be the best option as it offers certain aspects which are extremely useful to the spreadsheet.

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

    This icon is used to represent formulas; formulas are often very useful as they work out specific calculations which speed up certain tasks which are required in your job for example, an if statement allows you to type in the criteria you want so that it can say a certain

  2. Powerpoint review project

    I am going to use Microsoft PowerPoint because it is easy, fun, and exciting to use because of its features such as: Custom Animations and slide designs. It would also be the most interesting software to use as the audience like the presentation to be interesting as well as providing useful information.

  1. Spreadsheet for a basketball company

    2.3. Data Input Data Needed to Solve Problem Where is this data coming from? How is this data going to be collected? Customer details: Seat No., Seat Type, Surname, First name, Address, Contact No., E-mail Address (if appropriate) The customer themselves but the preface ones were kept in a paper file.

  2. Excel - Analyse

    * Not able to write on a CD. * It can read a large amount of data * The CD's are portable * Fast Access, the read speeds are above 48x. RAM To run Excel the computer requires Random Access Memory, so it can create temporary files which allow the programs to run smoothly.

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

    HEADINGS OF DATABASE Date Description of item Quantity Price Total/Sub-Total VAT Profit /loss Trade price/retail price Validation check (whether entry is possible) Restock Overflow Stock bought Purchases TASK C: Spreadsheet coursework page 4 WHAT SPREADSHEET WILL CALCULATE Total/Sub-Total VAT Profit /loss Restock Overflow (whether too many unlikely items are sold e.g.

  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

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