• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month
Page
  1. 1
    1
  2. 2
    2
  3. 3
    3
  4. 4
    4
  5. 5
    5
  6. 6
    6
  7. 7
    7
  8. 8
    8
  9. 9
    9
  10. 10
    10
  11. 11
    11
  12. 12
    12
  13. 13
    13
  14. 14
    14
  15. 15
    15
  16. 16
    16
  17. 17
    17

Excel Coursework - Engineering Hours Accounting System.

Extracts from this document...

Introduction

Excel Coursework - Engineering Hours Accounting System Analysis 2 Introduction 2 The Current System 2 Objectives of The New System 2 Performance Indicators 2 Design 3 Choice of Software 3 Systems Overview 3 Detailed Design 3 Workbook and Sheet Discussion 10 Data entry and Validation 11 User Aids to Operation 12 Protection 12 Macros 13 Data Flow Diagram 14 Analysis Introduction Avitronics is a medium sized engineering company that produces components for the aerospace industry. Employees keep track of the hours they work on different projects and at the end of the week turn in a timecard with this information on it. The company can take up to roughly 12 contracts a year; each of these contracts is assigned a 'Job-Code'. The Current System At present each employee keeps track of their hours using their own system. This could be as informal as a rough tally on a scrap of paper. At the end of the week, the employees fill their hours into a formal timecard, which is handed in and tallied by a clerk. Objectives of The New System Mr. Salomon (the chief accountant) would like a system with data entry forms so that each employee can input their own hours into the system at the end of each week. He would like to have pull-down menus for the job-codes, so that clumsy engineers entering complicated codes do not make mistakes. Hours should be rounded to the nearest quarter-hour. Data entry should be quick and simple. Each individual employee should not be able to see the hours worked by everyone else. The information should be sent to a database from Mr. ...read more.

Middle

I am choosing to use a drop down box as there are few options for the employee to choose from. Job-Code - This will be selected from a drop down box to prevent typographical errors being made. If it were a plain cell, with no validation or input aids, if an error was made it could cause unwanted consequences throughout the system. Monday - Employees enter their hours by typing the number in the correct cell. Any number they enter will later be rounded up to the nearest quarter hour, by the use of a ceiling formula. The validation on this cell will be that it has to be a number between 0 and 20. Tuesday - Employees enter their hours by typing the number in the correct cell. Any number they enter will later be rounded up to the nearest quarter hour, by the use of a ceiling formula. The validation on this cell will be that it has to be a number between 0 and 20. Wednesday - Employees enter their hours by typing the number in the correct cell. Any number they enter will later be rounded up to the nearest quarter hour, by the use of a ceiling formula. The validation on this cell will be that it has to be a number between 0 and 20. Thursday - Employees enter their hours by typing the number in the correct cell. Any number they enter will later be rounded up to the nearest quarter hour, by the use of a ceiling formula. The validation on this cell will be that it has to be a number between 0 and 20. ...read more.

Conclusion

3. Test the 'Submit Hours' button. 4. Add data as outlined in test data set 2. 5. Test the 'Clear Form' Button. 6. Add data as outlined in test data set 3. 7. Test the 'Submit Hours' button. 8. Test the 'Exit System' button. 9. Reopen the spreadsheet. 10. Try entering data from test data set 4. 11. Try entering data in a locked cell (eg. The cell containing the word 'Group' and the cell containing the word 'Totals'). Admin Function Tests: 12. Open my spreadsheet. 13. Test 'Admin Options' button, enter password from test data set 5. 14. Test 'Admin Options' button, enter password from test data set 6. 15. Test the 'Enter New Employee' button. Enter the data as outlined in test data set 7. 16. Select cell 'F19', Test the 'Delete Job Code' button. 17. Select cell 'B11', click the 'Delete Job Code' button. 18. Test the 'Enter New Job-Code' button, enter the data as outlined in test data set 8. 19. Test the 'Enter New Job-Code' button. 20. Test the 'Create Contract-Chart' button. 21. Test the 'Employee Report' button. 22. Test the 'Change System Password' button. Enter the password as outlined in test data set 9. 23. Test the 'Protect System' button. 24. Test the 'Admin Options' button. Enter the password as outlined in test data set 6. Error massage should appear. 25. Test the 'Admin Options' button. Enter the password as outlined in test data set 9. 26. Test the 'Change System Password' button; enter the original password again as outlined in test data set 6. 27. Test the 'Start New Year' button. 28. Click 'File' then 'Exit' please do not save any changes to the spreadsheet. Jonathan Stamp - ICT Excel Coursework Page 1 of 17 Jonathan Stamp - ICT Excel Coursework Page 1 of 17 ...read more.

The above preview is unformatted text

This student written piece of work is one of many that can be found in our AS and A Level Computer Science 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 AS and A Level Computer Science essays

  1. Smart Card System

    * Compatible with Existing Smart Card Standards - The Java Card API is compatible with formal international standards, such as, ISO7816, and industry-specific standards, such as, Europay/Master Card/Visa (EMV). 3.2. What are Smart Cards and Their Benefits? Smart cards a card similar by size to today's plastic card, that has a chip embedded on it.

  2. Computerised accounting system.

    Data Input Process Data Output Type of data processing: 1. Batch processing Transaction data are accumulated until a large volume can be processed at one time. Eg. Payroll, customer account and general ledger 2. On - line processing Processing transaction as they occur so that a user can obtain current information at any time.

  1. System I designed in order to produce a promotion package for her newly formed ...

    It was also easy to do datasheets because the software is very good at guiding you through the processes. I used the Internet to find relevant information, including data structures and layouts of them. The hardware I used helped me very much.

  2. Infernowear is a new company run by a self-employed creative designer aiming to producing ...

    Other media storage options including Zip drive, CD Rom drives and a CD re-writer. He also has a basic 1.44mb floppy drive. He has many software packages but the ones that need mentioning are: * Word 2000 * Access 2000 * Visual basic 6.0 As I have mentioned before Mr

  1. The Global Positioning System

    orbit at 3.877 x 103 ms-1, or 1.3 x 10-5 of c, the speed of light, time dilation (moving clocks run slow, as described in special relativity) occurs, as does time dilation caused by changes in the earths gravitational potential, described in general relativity.

  2. Evalutation of a Spreadsheet

    Filing a lot of paperwork would be difficult - when filing a lot of paperwork, it may be difficult to keep it organised and on top of.

  1. AS ICT Corsework - Mr Brookes K-Fit Ltd

    has to be easy to use for both customer and employee's alike. The reason a lot of work is being lost is down to the fact that customer's just simply live to far away from our work range and advertising range so if there was anyway to improve this which is cost effective would be excellent.

  2. Unit 6 - Advanced Spreadsheet Skills

    The hold meetings to decide what produce will go in each box they do this twice a week. They pass their decisions on to the marketing department who will then advertise the new boxes available. The department currently employs 5 staff.

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