Moving Data between Stellar and Gradescope
Some classes might use an external tool called Gradescope for assignment grading in conjunction with Stellar and Learning Modules. Please note that any automatic Gradescope grade migration into Stellar is not supported by IS&T at this time. However, there are ways to move data in bulk between the two systems manually by exporting and importing spreadsheets or CSV files.
To set up student membership lists in Gradescope using data from Stellar:
- Go to Membership.
- Click the "Download CSV" button to export a CSV file of the student roster for the class.
- Open the CSV file in an application such as Excel to view or copy the necessary roster data.
- Use the data from the CSV file to create a CSV file suitable for Gradescope import. Gradescope instructions and column formatting can be found under "Adding students and staff" here: https://www.gradescope.com/help#help-center-item-course-memberships-index.
To transfer assignment grades from Gradescope to Stellar:
- Go to Gradebook and click on the desired assignment.
- Click the "Download XLS" button to export a Gradebook compatible grade sheet for that assignment.
- Export the corresponding assignment grades from Gradescope as described here: https://www.gradescope.com/help#help-center-item-course-scores-export.
- Open the Gradescope file, and make sure the students are sorted alphabetically by last name (this is how the students are sorted in the corresponding Gradebook file).
- Copy the grades from the Gradescope file.
- Select the open cells in the "Points" column of the Gradebook file, and paste in the grades.
- Compare the Gradebook file to the Gradescope file to ensure the grades are all paired with the correct students.
- Save the file, and return to the assignment page on the Gradebook site.
- Press the triangle button next to "Download XLS".
- Click "Upload Assignment Detail XLS", and upload your updated Gradebook file.