Assignment #18

  (10 points)

  1. Watch the video Microsoft Excel: Working With Formulas: Grades   (CC).

  2. Create a Microsoft Excel document similar to the document developed in the video and shown below. Formulas must be created for Total, % (Percent), and Grade. Download the original file without formulas: compute-grades-ORIG.xlsx.

  3. Insert your name somewhere in the document.

  4. Save your work as "assignment18.xls" or "assignment18.xlsx" when you are finished.

  5. 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. Document uses the "Freeze Panes" option. 2 0 1 2 __/2
2. Document uses formulas to compute: Total, % (Percent), and Grade. 8 0 4 8 __/8
Total points __/10