Export Gradebook to Excel

Q. 


I want to download/export my grade book to an Excel file, how? Can I have my gradebook as an Excel file for archival purposes?

A.


Moodle allows you to take data from your gradebook and export it to your own computer. Moodle exports grades in the following formats: Excel, Plain text file, XML file, or OpenDocument spreadsheet. The export will also include First name, Last name, ID number, and Email address. Read on to learn how to download the gradebook.

1. In the Settings block, click Grades. The Grader report will open.




















2. Click the drop down menu and select your preferred export format.















3. Under Options, select the settings for your download (i.e. how you want numerical values formatted).

Under Grade items  to be included, check the boxes for the columns you wish to download. By default, every column in your gradebook will be included. At the bottom of the list, you can click Select all/none to make selecting columns more efficient.

Click Submit.




















4. After you click Submit the Export preview will open showing a preview of the columns included and the formatting for the final exported document.

The number of rows included in the preview is limited and is intended as a quick check before processing the download file.

Click Download to start downloading your file. 





No comments:

Post a Comment