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

am going to set-up a Computer Systems Maintenance Company called 'RR Payroll System,' which provides a range of support for its customers, which are all businesses.

Extracts from this document...


Title - GIGO Systems - Payroll System Student Name - Student Number - Centre Name - Centre Number - Date - Contents - Analysis * Introduction * Specification * Interview With * Data Flow Diagram * Module Map * Hardware And Software Requirements * User's Skill Level ANALYSIS: Introduction I am going to set-up a Computer Systems Maintenance Company called 'RR Payroll System,' which provides a range of support for its customers, which are all businesses. Each customer is allocated to an Account Manager. A team of Account Managers are employed to handle the needs of existing customers and to find new business. The Account Managers receive a basic salary, initially between �10,000-�12,000 per year. They also receive a commission depending on their total sales of maintenance contracts in a month: � If the value of the contracts sold in any month is below �1000 no commission is paid. � For sales of �1000 or more, but less than �5000 the commission will be 3% of that month's sales. � For sales of �5000 or more but less than �10,000 the commission will be 4%. � Sales of �10,000 or greater will earn commission of 5%. A monthly target is set for each Account Manager and if they are more than 20% below this then a warning letter is generated. ...read more.


* Is there any other advice that you can give me to help me towards producing my system? He insisted I should produce macros {buttons} such as 'Exit, Print and Main Menu,' etc, which when pressed onto by the Account Managers will do the following which is stated on the button. He told me to produce a back-up of the system because the system may get damaged due to a virus and the Managers will require their system back which will be notified to them, plus more through the 'User Guide.' Specification 1. My system will be able to store details of the following; - Details of a minimum of six Account Managers, each consisting of; Employee ID, Title, First Name, Surname, Basic Salary, Monthly Target, etc. - Tax, National Insurance and Commission Rates, etc. 2. My system will be able to enter monthly Sales Contracts details and to validate data appropriately when it is entered. Use appropriate default values to minimise user entry. - calculate the monthly commission - calculate who gets the bonus for that month 3. My system will be able to produce two main types of output; - Produce a warning letter issued to those Account Managers performing below 80% of target set. ...read more.


He/she will have to help the individual Account Managers on any difficulties they encounter or they should use the 'User Guide,' which will be linked to 'RR Payroll System.' The employees who have been employed are on a high level of work as they are 'managers,' so they should be able to resolve the basic problems, which they encounter. DESIGN: Choice Of Software This system will be implemented using 'Microsoft Excel 97.' This package is ideal as it includes many features which 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, page layout, import a company logo and preview before printing. * Charting facilities including ability to add a trend line. * Ability to protect worksheets and workbooks so that the user cannot accidentally destroy formula or headings. * Formatting to help make it clear to the user where to enter data. * Macros which 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. ?? ?? ?? ?? GIGO Systems - Payroll System ...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. Creating a computer system for a video rental shop

    Customers are automatically numbered. For this reason automatic incrementation is used. This form will be accessed from the editing form, which is reached from the main form. There will be a button to add customers and delete customers and also a find button.

  2. Bin-IT User Guide. The software on this CD provides a system to make ...

    This is a bespoke software which is tailor made for your use. There are on screen instructions for installing your software but this user guide will provide more information with in-detail instructions, troubleshooting help and a glossary. Instructions: Basic instructions to run the software: 1.

  1. Computer Systems Assignment 3

    It is possible to steal whole identities to be used in a fraudulent manner. Con-artists have become sophisticated in the art of cyber crime with key trackers which can be an internal or external programme. The internal programmes would be things like Spyware which tells the person everything you have

  2. Computer Systems Assignment 2

    Speed For physical speed, DOS wins. For speed of use, Windows beats it hands down, especially if you have any sort of disadvantage. Memory requirements DOS wins on memory requirements because it is basic whereas Windows takes longer to load up because it has all the helpful, personal bits to load.

  1. Database Coursework

    Age Rating Text 3 Letters I have set this as Text and the salesperson can only type in a valid Age rating. This is only 3 Letters long as "12A" is the highest. Genre Text 10 Letters I have set this as Text and the salesperson can only type in a valid Genre.

  2. Travel Agent Database - Effects of New System The new system will affect ...

    However, the disadvantage to this is that the course may take a long time to complete. 4. Design a booklet which includes instructions and illustrations of how to use a computer. This is a good method of teaching the employees because the booklet shall be designed by the company itself.

  1. Describe a wide range of technologies used by an adult in employment, with evaluation ...

    Yes; it meets her needs because without VPN it will be very hard for her to get all the information from her work computer. Mobile Phone Blackberry The blackberry is like a mini computer, it has all the information you need that you can get from a computer.

  2. Designing an IT system for an A level Student.

    The scanner optically scans images, handwritten text, or objects and recreates them as digital images John can print the flyers for the conservative party and pictures that he took from his camera Intel Core 2 Quad Q2800 This is a component within the PC and is necessary for it to function.

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