• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

ICT - Specification.

Extracts from this document...


1. Specification 1.1 Introduction Miss Harvey owns a Taxi & Limousine firm and wants to keep a breakdown of the income from each driver and calculate her total income. She needs to calculate each driver's weekly wage plus any bonuses or commission. She earns a percentage of the total income of all of her drivers. The firm consists of 20 drivers and each driver has their own car. Their rates charged are related to the quality of their car - it's age, prestige etc., and the limousine drivers demanding the highest rates. Through my research I feel that the introduction of a system on a computer would make it easier for Miss Harvey to work out each driver's weekly wage and any bonuses they have earned. Hopefully the new system will reduce the amount of paper they use at the moment. 1.2 Current System At the moment a calculator does all calculations and the wages of each driver is written down on paper and then stored. They have a piece with all the cars and how much it costs to hire them. This is used to determine how much the driver is likely to get paid. ...read more.


* The Duty Pay of the driver is calculated by multiplying the Days on Duty multiplied by the Hire Cost of the car. * The Total Income of the driver is calculated by adding Duty pay to Total Bonus Income. * A Tax of 15% should be subtracted from the Total Income if it is equal to or less than �80. * Data from the Calculations worksheet can be transferred into another worksheet amongst past records for future reference. * Data from the Calculations worksheet will also displayed in another worksheet, which consists of a template ready for a presentable printout, with the simple click of a macro. 1.6. Output requirements * Full income and work details on screen * A printout of a driver's income and work details (days on duty, car used, mileage etc.) * A printout of all of the drivers' wages, which have been recorded. * Visual Indications of a driver who earns less than �80, over �300, and in between. * Averages of all of the drivers Income, and highest and lowest values. 1.7. Objectives of the new system 1. A system is needed to keep a track record of each driver's income and be able to calculate Miss Harvey's (the boss) ...read more.


This system will be implemented using Excel 97. This ideal as is includes many features that can be used in customising the application, such as: * Ability to create a blank template * Ability to link product details entered in one workbook with invoice details entered in a second workbook through a table lookup. * Pivot tables to create monthly summaries * Sophisticated report facilities with the ability to format text, set margins and page layout, import a company logo if desired and preview before printing. * Charting facilities including the ability to add a trend line * Ability to protect worksheets and workbooks so that the user cannot accidentally destroy formulae or headings. * Formatting to help make it clear to the user where to enter data. * Macros to automate various functions. That will execute automatically on opening and closing workbooks. * Customised menus and toolbars. * Auditing tools to help ensure that there are no errors in the workbook. 1.10. User's Skill Level There will be Ms Harvey and the accountant using the system. The person who does the accounts is very computer-literate and generally has a good basic knowledge of Excel. With my computer system they will only need a basic knowledge of Excel because my system will be very simplistic and easy to use. ...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 ICT Systems and Application 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 ICT Systems and Application essays

  1. Different types of technology How I use ICT at home and at school

    Disadvantages (How it does not meet my needs) While it did have a massive price drop from the original PS3 to PS3 slim, this still kept its position of being the most expensive console out of the big three (Xbox 360 and Nintendo Wii).

  2. ICT Report 2b: ICT in Organisations

    breaking the mouse and forcing Boots to buy a new one which will have equal chances of being destroyed. However Boots surpasses this problem as I will mention with the use of mice with USB ports. All in all, the PS/2 port is helpful to Boots as it allows the

  1. GCSE Excel Project ICT

    The formula I am going to use is this: =IF(B16="None","None",IF(B16="Vista Basic","Microsoft",IF(B16="Vista Premium","Microsoft",IF(B16="Vista Ultimate","Microsoft",IF(B16="XP Home Edition SP3","Microsoft",IF(B16="Medusa","WarlordTF",IF(B16="Mackintosh","Apple Inc.",""))))))) As the formula checks the cell for the value "None" if the value is found then insert none into the value of the cell, however, if the cell does not contain the information

  2. The impact of ICT on a person with special/particular needs

    An analogue signal is essentially a broadcast signal which is continuous in terms of amplitude or frequency. These are very inefficient and require an aerial to pick up the signal and can often result in the picture being unclear. These were the main form of television until digital television was discovered.

  1. I am going to be looking at Tesco. I will be focusing on what ...

    Laser scanners take very little time to use, meaning that the time it takes for the transaction to be completed is significantly shorter than you would expect from another method. This increases the number of customers that one person can get through in a day, in turn increasing profit.

  2. A Design Specification for an ICT System Introduction Going places is one ...

    Staff will also need to use my database, and will be able to: * Browse available holidays/registered users' details; * Search available holidays/registered users' details; * Update available holidays/registered users' details.

  1. ICT specification

    need of a trip therefore renting a car or is arriving at a new city or country and needs a pickup from the airport or wants a car to roam around the city with. Also there could be customers that are tired of driving the same car every day and

  2. Computer Studies Past paper definitions

    (a) batch processing (processing) doesn't start until all data collected any reference to JCL no need for human interaction uses computer during "quiet" time/overnight examples payroll system, billing, cheque processing [2] (b) interrupt a signal generated by a device/program causes a break in execution of the program examples e.g.

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