• 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. System I designed in order to produce a promotion package for her newly formed ...

    How can I get data from another program into Word without starting the source program? By default, when you insert database information or attach it as a mail merge data source, Word uses DDE to read the data file. DDE automatically starts the source program (such as Microsoft Excel)

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

    Three of these macros will be used to open the reports so what they can be printed. One other macro will be used to simple maximise each from when it is loaded. SQL statements: As I will have to update the stock level after each item has been booked out I will be using some short but complex SQL statements.

  1. The Global Positioning System

    Every satellite transmits almanac and ephemeris data. The almanac data tells the receiver where to look for other satellites in the sky, given its last known position and the time of day, in order to speed up getting an initial lock on four satellites.

  2. Evalutation of a Spreadsheet

    This is much easier, quicker, and effective way than the traditional method. * Graphs and charts can be produced quickly - Excel is an effective tool when producing graphs or charts and these are produced instantaneously and accurately. * Data validation - this is a good feature to use because

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

    or a new home base is a city for example but overall I feel that a website would be perfect as well as cost effective. A website can offer a range of things, firstly a quick ordering system that almost everyone can access from home; on top of that there will be a constant string of advertisement for the business.

  2. Unit 6 - Advanced Spreadsheet Skills

    The team employ 5 staff members. 3. Suppliers: All the produce is supplied locally from farmers and growers who have to provide evidence their there crop is grown to organic standards. For this to happen they have to be subject to regular rigorous checks every week.

  1. supermarket database-computer coursework

    Information can be transferred immediately computer can do most of the jobs. Less workers are employed Old system Computer system Space needed to keep the records more Much less Back up Very difficult Very easy error High possibility Low possibility Search data Very complicated Very convenient mail Slow and expensive

  2. Firewall Protection

    is installed, is "how much time each advertisement is shown, which was the hosting adware, and whether the user clicked on the advertisement. This is important so that the advertisements server will be able to know how much money to get from each of the advertised companies, and how much from it to deliver to each of the adware maintainers.

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