• 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. GCSE Excel Project ICT

    (Above is the test for Objective 1) In addition, the print-off (Objective 2) will be situated after this page and does include the same values as the previous replications. When errors occurred, explain how they were corrected The errors that have occurred, have been rectified and checked within the implement

  2. a level ict project

    entered correctly or accurately, as a result errors will be more frequent and miscalculations can be made when charging prices, sending information to customers or providing financial accounts. The solution is also limited to one form of output, written format, results cannot be presented as tables, graphs or diagrams, plus,

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

    As stated before, Sarah doesn't go out much. However, despite this, she feels the need to be a normal person. She can't go out but she gets her experiences and 'stays in touch' with real life using TV. She can get an idea and keep up with the world outside by watching and keeping up with the current and latest TV shows.

  2. System requirements analysis

    The VB code method does not list the patients' names in the diary slot but fills them up with a different colour. To insert the patients' records into my booking software I had to 'import' the data form a database that was provided.

  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. Different types of technology How I use ICT at home and at school

    I can download PDF files and put them onto my blackberry, eliminating the purpose of books. I can carry lots of PDF files in my blackberry which is much easier than carrying the same amount of books. I can read them anywhere I want on my blackberry.

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

    You can find and sort data more easily on a database, and they are usually better to look at and more clearly displayed. My system will allow any users to perform many tasks. Customers will be able to: * Browse various holidays they might be interested in; * Print out

  2. Computer Studies Past paper definitions

    Video conferencing any two from: meeting between two or more participants (at different sites) using computer network/WAN/Internet to transmit/receive audio and video data each participant has a video camera/webcam/microphone/speaker images appear in real time (on a window on the participant's monitor)[2] (c)

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