Exam #2

  (20 points)

  1. Create a Google Sheets document OR a Microsoft Excel file similar to the document shown below. Formulas must be created for the items circled in "red". More specifically, formulas must be used for Total, %, Grade, Average, Number of A's, Number of B's, Number of A's and B's Highest Final Exam, and Lowest Final Exam. Recommendation: Complete Assignments 14-21 before starting this exam.



  2. Include your name somewhere in the spreadsheet. If using Google Sheets, share this document with your instructor: rosener@nsuok.edu

  3. Save your work as "Exam2".

  4. 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 contains row headers, column headers, and data. Document uses borders and possibly shading to enhance the visual impact. 4 0 2 4 __/4
2. Document uses formulas to compute: Total, %, Grade, Average, Number of A's, Number of B's, Number of A's and B's Highest Final Exam, and Lowest Final Exam.
16 0 8 16 __/16
Total points __/20