• 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

    First Name Text(15) Surname Text(15) Address Text(50) Town Combo box Text(50) postcode Text(10) DOB Date/Time Rentals Attribute name Comments Data type and length Validation Customer ID Automatically incremented Long Integer Unique Primary Key Staff ID Automatically incremented Long Integer Unique Primary Key Video ID Automatically incremented Long Integer Unique Primary

  2. I have been asked to come in and help out a holiday company called ...

    * If a customer wants to find out how many places there are available for a certain hotel, then this will also be too difficult because the holidays are all filed in alphabetical order. * When booking holidays it takes too long to sort every thing out because of our all the details are filed.

  1. ICT Coursework (MarcoS)

    Then click on "Insert"; 3. A new window will open, and now select the button "Combo Box"; 4. Click and drag the mouse to create one, then right click on it and select "Format Control", a new window will open; 5. Now you have the possibility to give an "Input range" of data, and a "Cell link".

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

    Step 4 explains how to change the validation rules if they do not meet the criteria of some of your employees. * On Step 7, you may have a problem with the Microsoft Word document not being properly linked to the spreadsheet with your data in.

  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

    To get help you type in help copy. Task 2. Command line features Liked by many programmers because Design (of interface) For a professional like a computer programmer DOS wins because there are no frills so the programmer could get on with his job without thinking about the fancy bits that Windows offers.

  1. Database Coursework

    Not only would it be more organised, but it would also mean that there is much less work for the receptionist and the mechanics. Instead of having to write all the details out onto a record and placing it into the folder, all she has to do is type it in, and it will be stored into the system.

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

    Customers may get angry if there is a virus on the system or the database. This means that all the details could be lost and the customer may suffer a heavy loss. Training Staff There are many ways the staff could be trained. They are listed and explained below.

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