Assignment #18

  (10 points)

  1. Watch the video Creating a Grade Spreadsheet (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 Average, Average (Weighted Final), Average (Dropping Lowest), Average, Minimum, Maximum.



  3. Insert your name at the top of the document.

  4. Save your work as "Assignment18". If using Google Sheets, share this document with your instructor: rosener@nsuok.edu

  5. Submit Your Work.   Help



Grading Rubric
Required Elements Points Possible Does not meet requirements Meets some requirements Meets or exceeds all requirements Your Score
1. Document contains row headers, column headers, and data. Document uses borders and shading to enhance the visual impact. 2 0 1 2 __/2
2. Document uses formulas to compute: Average, Average (Weighted Final), Average (Dropping Lowest), Average, Minimum, Maximum. 8 0 4 8 __/8
Total points __/10