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

Introduction

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.

Middle

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

Conclusion

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

    converting it, thus bringing its size up more and possibly adding some playback errors. It's not entirely reliable. A lot of PS3 games are violent. While this may not be too much of a problem as they usually have age restrictions, these age restrictions are usually disregarded.

  2. ICT Report 2b: ICT in Organisations

    Speakers are helpful for Boots as a company because it allows for information to be presented to numerous workers at once audibly. It helps their suppliers because if the email or internet is down, the company can phone the suppliers directly to pass over the order in this way.

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

    Sarah, however, can watch the news, learn about latest celebrity gossip and other such events using the channels provided on Sky. She can feel much more in touch with reality and feel less out of place in a world she feels she doesn't want to be in or doesn't belong in.

  2. GCSE Excel Project ICT

    and printed three times (Objective 2) one for the customer, one for the accounts and one for the computer construction. Analyse (9 marks) Appropriate Software identified The software being used is part of the Microsoft Office suite (Microsoft Access and Microsoft Word and Microsoft Excel)

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

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

    into the till PC. Details such as the name, size and manufacturer are all transferred. It works by shining a harmless laser beam at the barcode on the product in question. A barcode is a series of vertical lines that represent a certain number.

  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