Exporting or Importing grades, using a spreadsheet
If you prefer to import your grades to the Grades tool in Avenue to Learn, we recommend creating a template by exporting a .csv file from the Grades tool.
If you haven’t done so already, create the grade item(s) in the grade book in avenue to learn (if you are unsure of how to create grade items in avenue, refer to the Avenue Grades Workshop or the Grades article), then go to the grades tool, click enter grades, then click the export button. From there you can select the criteria that you want to distinguish/recognize each student.
In the ‘Choose Grades to Export’ section, only select the checkbox for your grade item(s) you want to import back into avenue. Then click on the button for ‘export to csv’.
Once you have that downloaded csv file to use as a working template, you can copy and paste from your source csv/spreadsheet file to that working template, and then finally go back to ‘enter grades’, ‘import’, deselect the checkbox for ‘Create new grade item when an unrecognized item is referenced’, and then continue through the process with the import. If there are any discrepancies to this process, please consult the vendor documentation links below.
Refer to the vendor documentation on how to export grades, as well as this helpful video:
If needed, also consult the vendor documentation on how to import grades .