Exporting Grades in Bear Tracks Format
Article Last Updated May 2018
You can now 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. 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.
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 format.) For example, you might do this if you want to manually enter the final letter grades for your students and not have moodle run the letter grade calculations.
Once you have prepared your spreadsheet, you can then upload this file directly into Bear Tracks following the tutorial available from AIS here.
To access this training, you will need to login with your CCID and password to gain entry to the Peoplsoft training. Once your login is successful, you should see a step by step tutorial for Uploading a Learning Management System (LMS) final grade file.
The Faculty of Extension has put together a tutorial for uploading and submitting grades (Step 1 will not apply if you have exported your grades from eClass) here.