The following documentation demonstrates how to export your final grade book and format the .CSV file for upload into the Registrar's web grading system at the end of the semester. The Registrar's web grading system only accepts letter grades for students, so a change to the Letter Grades grading scheme may be necessary. To learn more about Grade Schemes please visit the Understanding Grade Schemes page.
To change your courses grade scheme to Letter Grades:
*NOTE: Be sure to double check that values for Letter Grades are consistent with the values you decide for your course (e.g. A = 94%-100%). To learn how to create your own custom grading scheme visit the Understanding Grades Schemes page.
Log into your course and from the Assessments drop-down menu click on Grades.
For the Export Options only select:
Choose either Final Calculated Grade or Final Adjusted Grade (if you have manually entered adjusted grades).
A new window will appear and display a link. Click on the link to download the file and save in a location on your computer.
Open the .CSV in Excel.
Select all of the End-of-Line Indicator column, right click and select Delete.
Select all of the first row, right click and select Delete. The file cannot contain a header row, only Student Ids in column A and a Roster Grade in column B.
Next the # sign must be deleted from the Student ID column. To do this for all IDs click on the Edit drop-down menu and select Replace.
*Note: For Windows users, with Office 2010, click on the Find & Select (binocular icon in Home tab) drop-down menu and select Replace.
Do not put anything in the Replace with: column and click the Replace All button.
Save the file in the CSV (Windows Comma Separated) format. Give your file a short name (e.g. JOUR1001-100.csv), as upgrade (Web Grading) can occasionally produce an error message if a file name is too long. Once you have named your file you can upload it to upgrade (Web Grading).