Grades

How do I setup my grade book in Avenue to Learn? https://documentation.desire2learn.com/en/Grades

At the end of the semester you will want to export your grades from your course on Avenue and prepare it for submission to the Registrar as your final grades. This document will guide you through the process of preparing this CSV file as it is exported from Avenue to what Mosaic wants.

From within the course in Avenue that you want to collect grades for export, choose Assessments and in the drop down menu select Grades.

Make sure you are in theEnterGrades menu and select Export.

On the Export Grades page, you will want to consider your options when exporting key fields. You will want BothOrgDefinedID and Username exported. For most students, the Org Defined ID is their student number (in specific cases, some students may have their MacID as their Org Defined ID). The Username is always the student’s MacID. Under User Details, you may want to add the First Name and the Last Name to the export as well. This will help you differentiate similar MacIDs, but the names are not needed for the Import process.

When you are choosing which grades to select for exporting, the only one you will need is either the Final Calculated Grade or the Final Adjusted Grade. Select whichever one you have been using in Avenue for your grades.

When you are satisfied with the information you are exporting, then click Export to CSV or Export to Excel. A pop-up window will appear, and begin to process the CSV (a file that has Comma Separated Values) or Excel file. Once the process is complete you will see a link that contains the CSV or Excel file. Click on the link to open it, or right click to save the file to your computer.

The next few steps will take place in Microsoft Excel 2007. The process will be similar for Microsoft Excel 2003 and Open Office Calc. If you saved the file to a location on your computer in the previous step, open the file now; if you opened the file in the previous step, save the file to a location on your computer now. Now is a good time to double check that the correct student has the correct mark. If there is an issue, you can make changes now to the number in column E.

The first thing we need to do is to change the column headings to conform to what the Online Grade submission expects. The column headings are found in row 1 of the Excel spreadsheet and are highlighted in the picture above. The system will accept OrgDefinedId and Username but needs to have Calculated Final Grade Numerator renamed to FinalGrade (be sure to rename this with no space between Final and Grade). To do this highlight Calculated Final Grade Numerator, and type FinalGrade. You can also select the Last Name, First Name, Calculated Final Grade Denominator and End-of-Line Indicator and delete them.

When complete, it should resemble this:

Click the Windows menu, and Save As, Other Formats, CSV.

Note: For MAC users, please make sure you save as MS-DOS Comma Separated (csv).

The CSV is now ready for uploading to Mosaic.

Please let us know if you have any pedagogical input for this tool.

For questions or concerns, Avenue support is available from Monday to Friday, 8:30 AM to 4:30 PM at (905) 525-9140 ext. 22911 or email support.avenue@cll.mcmaster.ca.