Since grades can be calculated in GauchoSpace, the instructions below gives information on formats for uploading your grade file into eGrades. Please note, you will need to finalize your gradebook calculations and come to a final Course Total for these methods to be most effective. See our Gradebook Setup documents for more assistance.
Uploading Grades into eGrades
Method 1, if you have your eGrades Classlist
- Log in to eGrades with your UCSBnetID and password and download a classlist for your class.
- Save this eGrades Classlist file on your computer with the same file name.
- Log in to GauchoSpace and enter your course site.
- In the Administration Block, click Grades.
- Click the Export tab. This will take you to the default tab (Excel) to export.
- De-select everything but the Course Total.
- Under Export format options, choose Letter. Note: Letter grades are what is required for eGrades.
- Click Download.
- Open the spreadsheet you downloaded from GauchoSpace gradebook and open your eGrades Classlist spreadsheet, arrange the students in the same order for both files.
- Copy the Course Total grades from your GauchoSpace gradebook spreadsheet and paste it into the grade column of the eGrades Classlist spreadsheet.
- Save the file as a CSV (.csv, Comma Separated Values) and return to eGrades to import the grades.
Method 2, if you are using your GauchoSpace Gradebook spreadsheet
- Use this method if you have already downloaded a spreadsheet from your GauchoSpace gradebook with only the Course Total as a letter grade. See instructions (steps 3-8) above for more information on exporting a gradebook spreadsheet.
- You will need to rename and rearrange the following columns before uploading to eGrades:
- eGrades column order: Enroll Code, Perm Number, Grade, and Units (if this is a variable unit course).
- Note: the import will ignore all columns after the first four listed above.
- After you have made these changes, save the file as as a CSV (.csv, Comma Separated Values) and return to eGrades to import the grades.