Using a spreadsheet, instructors can import student grades directly to the AsULearn gradebook. This data can be imported into existing grade columns for activities, or into new grade items created during the import process. You cannot import directly into category totals or the Course total column. This page describes how to format a grading spreadsheet, and then import this student data into AsULearn.
Prepare a data file for import
To successfully import data to the Moodle gradebook, the import file must:
- Be saved as a comma separated values (CSV) or tab delimited text (TXT; use when importing comments)
- Have a header row containing a name for each column, with no duplicate headers
- Have a column containing unique identifiers for each student (either Banner ID number or email address)
- Have data only for students you intend to update (otherwise you may unintentionally override scores, even if cells are blank)
- Be free of duplicate students and empty cells (e.g., blank rows/columns, cells containing data other than student grades)
For best results, we suggest you first go to the AsULearn gradebook for the course and Export the gradebook to use as a template to be imported back with new data. This will ensure you have the correct unique identifiers to match data to the correct students.
Open the exported file and add your grade data.
If importing grades for an existing grade item, values must fit within the Grade range or Scale established in the activity settings.
To create new grade items in the gradebook, add new columns to the spreadsheet document. Remember to label the column header. Note: Grades added in this manner will, by default, have a maximum value of 100 points and cannot exceed that value.
Import file to gradebook
Open your course gradebook in AsULearn and click the Import tab. The CSV file page will open.
In the Import file area, drag and drop a file from your desktop or click Choose a file.... The File picker will open. Use the File picker to select a file from your computer. Once your file is uploaded, the file name will be displayed.
For Separator:
- Leave the option set to Comma if uploading a comma separated values (CSV) file
- Change the option to Tab if uploading a tab delimited text (TXT) file
Leave other settings at defaults.
Click Upload grades. If the upload is successful, the Import preview screen will open.
In the Import preview area, review the sample grid and verify the uploaded data.
Note: Data should appear in columns with headers above each column. If data is not displayed in a table with columns and rows, this indicates a problem with the reading of the file. Make sure the file is saved in the correct format and then repeat the upload.
The Identify user by section is where you match the unique identifiers in your spreadsheet to students in AsULearn.
- To match users by Banner ID, set both the Map from and Map to options to ID number (default).
- To match users by email address, set both the Map from and Map to options to Email address.
Note: Map from should be the field names in the CSV file. Map to should be the identifiers in AsULearn.
The Grade item mappings section is where you match columns in your spreadsheet to grade items in AsULearn. The column headings from your imported file will be listed at left, with a drop down menu to the right listing existing grade items in the course gradebook.
To import a column to an existing grade item, select the grade item name from the grade item mapping drop-down. Note: This will overwrite existing data in the gradebook for each student in your spreadsheet.
To add a new grade item, select New grade item (at top of drop down list). Note: Each new grade item created in this manner will have a default maximum value of 100 points (If needed, you can adjust the maximum value after import).
To skip a column, and not import its data, leave the drop down menu set to Ignore.
To import written feedback for a grade item, map the spreadsheet column to the Feedback for a grade item (not to the grade item itself, nor as a new grade item). Note: Feedback is grouped at the bottom of the grade item mappings drop downs.
Click Upload grades at the bottom of the screen. The upload will begin. If the upload is successful, you will see a Success message.
Click Continue to return to the Grader report view of your gradebook. Make sure the new data is properly inserted in the appropriate columns.