Exporting Grades in Bear Tracks Format
Last modified on 13 December 2022 02:29 PM
You can use eClass to prepare a spreadsheet that can be imported directly into Bear Tracks as a part of the new electronic grade submission process. To use this capability, you must be the instructor or TA of a credit section on eClass.
To perform a Bear Tracks export, your gradebook must be set up and you need to have a column where the students' final grades have been calculated. This column can be any column in the course (ie. it does not need to be the 'course total' column) and does not need to be displayed as a letter grade. You will select the column to be used to calculate the final letter grades during the export process.
If the column with the final score for your students is numeric, the final letter grades will get calculated automatically during the export based on the letter grade boundary distribution that you set up for your course - if you have not already done this, you must do so using the following article: Setting Letter Grade Boundaries.
If instructors are using excel to maintain grades outside of eClass and are making changes their student list based on changes to the Bear Tracks roster throughout the term, please be aware that due to differences in the underlying database storage solutions, there may be slight differences in the default alphabetic sort order of student names. For this reason, instructors should avoid copy-pasting values between spreadsheets arising from the 2 different systems. If such a merge is required into a spreadsheet outside eClass, instructors should ensure that both sheets are sorted on student ID number instead of name before pasting or (preferably) import values between the 2 spreadsheets using the CCID or student ID number as a key value.
Also please note that starting in December 2022, Bear Tracks will no longer accept excel files when uploading grades. Instructors should export eClass grades using the Bear Tracks format (as shown below) or as plain text .csv files. Gradebooks exported as excel files will not upload into Bear Tracks. Instructors should also ensure to save files as .csv (as opposed to the native excel formats (.xlx or .xlxs) if they are using Excel on their local machine to store or adjust grades files.
To export grades in Bear Tracks format:
Note: You will need to verify your letter grade boundaries and check the required box before you are able to click Download to save the file to your local machine.
Once downloaded, you can edit this file (as long as you save it in the same .csv format.) For example, you might do this if you want to manually enter the final letter grades for your students instead of having moodle run the letter grade calculations.
Once you have prepared your spreadsheet, you can then upload this file directly into Bear Tracks following this tutorial.