• 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

    It has met all the requirements, but I could have made it more user-friendly by adding a new column in my database entitled 'phone numbers'. As I did a database on a doctor's surgery I should have inserted an extra column named 'phone numbers'.

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

    the VLOOKUP, it displayed the wrong information, and I did not know why. I found this out, by researching VLOOKUPS on the Microsoft Office website, in order to help me. Once I had inserted the correct data, I clicked "Ok."

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

    otherwise be required if the calculations would to be done in a non-ICT solution. To do this we will simply look over the many formulas which prevents the user from requiring a calculator, these include the simple formulas like the total amount of people multiplied by the price of sitting in a certain place and their class e.g.

  2. A new IT system in a Dubai Marauders Rugby Football Club

    Queries must be able to search the files to find certain members. The database must be easy to read and simple to use, as receptionists and secretaries are expected to be able to perform searches on a regular basis. Another, less appealing, option to produce computerised member's files is to make use of a spreadsheet program, such as Microsoft Excel.

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

  2. ICT project - record system.

    All requirements are available on Microsoft access, as it is the more popular version and easier to use. Appropriate Hardware Identified The hardware requirements I will need is simply the PC itself attached with a mouse, keyboard and also a printer in order to create and print the database.

  1. Fix the problem of the car company's storage problem, using either excel or access.

    Are you happy with this system? No, no particularly. The data isn't safe, it can be lost easily. All we can do id make copies, but we don't want the paper to get loose. 3) Are you scared that data might fall in the wrong hands?

  2. A Program for a Cinema Manager

    I will be using numbers and text in the spreadsheet. The spreadsheet will need to calculate prices, incomes and expenditures. It will need to be quick and easily accessed. The formulae and functions. Examples of these formulae are: * Sum function (=sum)

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