Assignment #18
(10 points)

  1. Watch Video #5 - "Microsoft Excel: Working With Formulas (Grades)" at one of the following URLs:
    http://www.billrosener.com/teaching/videos/office/2013/excel/ - MS Excel 2013
    http://www.billrosener.com/teaching/videos/office/2010/excel/ - MS Excel 2010

  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. The original file compute-grades-ORIG.xls without formulas can be downloaded from the Assignment #18 subdirectory



  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