An I.T. system for a car fleet Manager

There are many good features in Microsoft excel and these are as follows:

* Entering Formulae

* Adding comments

* Conditional Formatting

* Creating a lookup table

* Data Validation

* Using goal seek

* Inserting Buttons and Macros

These are key functions I will be using when I create our virtual spreadsheet. The first key function enables you to input formulae into your worksheets to calculate the maximum, minimum, average and total for what ever you are promoting, in this case it is to calculate the bills for the employees who use the cars under your management.

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.

Data validation stops you from making mistakes with prices or marks. If the cars are all between a certain price say 0-10,000 it prevents you from entering any prices above those figures stated.

Microsoft excel allows you to use goal seek as well. This means that you are able to find out how much money you need to pay in case you miss a repayment and want to find out how much money you need to pay in order for you to have repay all of the money in time.

Inserting buttons and macros means that once a person has finished repaying a payment you may want to start a new spreadsheet every time the person has finished paying.

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