Assignment #17

  (10 points)

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

  2. Create either a Google Sheet or 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 "Assignment17" when you are finished. If using Google Sheets, share this document with your instructor: rosener@nsuok.edu

  5. Upload your MS Excel file or embed the Google Sheets link on 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