You can export the current view of your Gradebook to a comma-separated value (.csv) file, which you can then open in any spreadsheet application. Doing so will allow you to take advantage of standard spreadsheet functions such as calculating mean, medium, average and other statistical calculations. Exporting the current view of the Gradebook also provides you with final grades in a format that you can turn in to your administration and keep as a back up for your records.
Step 1: Click the Gradebook tab in the Author mode.
Step 2: Click the Export Current View button in the right corner of your screen. A new screen appears.
Step 3: Select the data format in which you'd like to export the current Gradebook view:
Letter and Number Grades
Number Grades Only
Letter Grades Only
If you choose to export letter and number grades or just letter grades, make sure you've actually assigned letter grades in your Gradebook. If you have not assigned letter grades, an empty column will display in your exported Gradebook file.
Step 4: Click Export. A File Download window appears.
Step 5: Select Save this file to disk and click OK. A Save As window opens in which you can select a location for the exported Gradebook file. Select a location and click Save. The current view of the Gradebook file is saved with a .csv file extension in the location you specified.
Step 6: Use any spreadsheet application to open the Gradebook file