Assignment #1

  (30 points)

  1. Watch the video Payroll Report Spreadsheet (Microsoft Excel)   (CC).

  2. Create a Microsoft Excel document similar to the document developed in the video and shown below. (Data). Formulas must be created for those cells highlighted in the red circle. In particular, formulas must be created for: Regular Pay, Overtime Pay, Gross Pay, FICA, State Tax, Federal Tax, Net Pay, and Totals. Insert your name somewhere in the document. Rename this sheet "Assignment 1A".



  3. Create a new tab in the Microsoft Excel document created in the previous step. Rename this sheet "Assignment 1B". Create the spreadsheet shown below. (Data). Formulas must be created for those cells highlighted in the red circles. In particular, formulas must be created for: Individual Item Cost, Final Cost, and Total.



  4. Explore the tutorial Lesson 1 - Getting Started with Excel. Convince the instructor that you understand the key concepts in this tutorial by including one or more of the following: a summary of the tutorial, modified formulas similar to those covered in the tutorial, details, examples, charts, tips you learned, etc. Add this information (in a separate tab) to the document created in the previous step. Please make your information easy to read by wrapping the text and displaying your details on multiple lines.

  5. Save your work as "assignment1.xlsx" when you are finished.

  6. Upload this file to YOUR-CLASS-WEBSITE.   Help



Grading Rubric
Required Elements Points Possible Does not meet requirements Meets some requirements Meets or exceeds all requirements Your Score
1. Spreadsheet (Assignment 1A) contains the required row headers, column headers, and data. Document uses borders and shading to enhance the visual impact. Spreadsheet uses formulas to compute: Regular Pay, Overtime Pay, Gross Pay, FICA, State Tax, Federal Tax, Net Pay, and Totals. 10 0 5 10 __/10
2. Spreadsheet (Assignment 1B) contains the required row headers, column headers, and data. Document uses borders and shading to enhance the visual impact. Spreadsheet uses formulas to compute: Individual Item Cost, Final Cost, and Total. 10 0 5 10 __/10
3. Convinced the instructor that you understand the key concepts covered in the tutorial listed in Step #4. 10 0 5 10 __/10
Total points __/30