Page History

To get an Excel file of your A great way to get a customized local copy of your gradebook, including your students' first and last names, Banner IDs, and email addresses, you can export a roster from AsULearn. If you select grade items, it's also a great way to get a local copy of your gradebookis by exporting a spreadsheet from AsULearn's Grade Reporter.

Step-by-step guide

1. From the main course page, click the gear icon (top right) and click Gradebook setup in the menu.
   select the Grade tab.
   
   Image AddedImage Removed
   
   
2. On the Gradebook Grade Report setup page, click the Export link.
   Image Removed
   Grader Report drop down menu option. Scroll down to the bottom and click on Export.
   
   Image Added
   
   
3. Now you can select the file format by clicking on the Export As drop down menu.
   
   Please Note: Excel Spreadsheet is the most common option to select, but this is up to your preference.
   
   Image Added
   
   
4. Under Grade items to be included, select the check boxes for the items you want to include in your export.
   

   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. 
   
   To wrap up, scroll down to Export Format Options and click the Download button and the file will export to your computer based on your browser settings: either to your default Download folder, or you will be prompted where to save the downloaded file, such as to your Desktop.
   
   Please Note: Under Export format options, users can also select to include feedback comments or adjust the decimal display.

   
   Image AddedClick the Plain text file tab to export to a CSV (comma-separated values) file which will open in Excel, Google Sheets, and most spreadsheet applications.
   Image Removed
   The tab lists all graded activities in the course. Activities with the boxes checked will be exported; unchecked items will not. 
   
   

   Info
   title TIPS
   If you want to export just a roster of students, click Select All/None at the bottom to toggle the check boxes off for all the grade items. The exported Excel file will include students' first names, last names, Banner IDs, and email addresses. If you are exporting the gradebook as a template to Import Grades from a spreadsheet, export just the activities you want to import.

   Click the Download button at the bottom of the page. The file will download to your computer based on your browser settings: either to your default Download folder, or you will be prompted where to save the downloaded file.
   To return to the main course page click the course name at the top of the drawer menu on the left (open with the hamburger icon top left) or in the breadcrumbs navigation.

   
   

Related Articles

Search Knowledge Base   

Submit a Service Request

We value your feedback! Click HERE to suggest updates to an existing article, request a new article, or submit an idea.

...