SIS ID column in Gradebook

This idea has been developed and deployed to Canvas

For more information, please read through Canvas Release Notes (2020-01-18) 

At present, the SIS ID is not available via browser view of the Gradebook. It shows up as a column in Excel when instructors export the gradebook, but it would be extremely useful to have access to this information without the trouble of exporting and then importing.


Instructors who grade anonymous paper submissions, for example, would be able to input grades a great deal more efficiently. Aside from the student name column, the only other student identifier is a column for login ID, which is some version of a student’s name. Thus, there’s currently not a useful way to match students to anonymous paper submissions. While adding a “Notes” column and hand-entering SIS IDs does function as a workaround, doing so introduces many possibilities for error and is inconvenient for instructors.

Coach Emeritus

Hi  @lisa_ward 

I am not sure how your enrollments are managed, but the credentials entered into Canvas rosters is typically a result of how the enrollment integrations are configured. For example, here is a screenshot of the second column in one of my gradebooks....


That secondary ID is our SIS ID numbers which are also our Canvas User Login ID.

I think that Canvas is able to display whatever it is fed in this regard, and would suggest talking with the Canvas admins at your school; who, in turn, may need to talk with your SIS and Integration vendors.


New Member

Hi, Kelley!  I'm actually submitting this feature idea on the advice of my admins. For us, the secondary ID can't be the student ID number; students have a separate, distinct Login ID that our institution must use. Thanks for your help, though!


Community Contributor

The secondary id in the gradebook is the user's 'SIS login ID' (what is used to login into canvas), which is a different value from the user's 'SIS ID'. The SIS ID is not shown in the gradebook, but is shown on the People page, if the person viewing the people page has the 'Read SIS data' permission. Additionally, the SIS ID is shown in the export of the gradebook as 'SIS User ID'.

What, I believe, Lisa asking for is the SIS ID that is in the People page and gradebook export is also included in the gradebook itself as a column.

Disclosure: I am a Canvas admin at Lisa Ward's institution.



New Member

Thanks for the clarification, Anthony!

Community Coach
Community Coach

If this is implemented, can i also suggest a way for teachers to hide the login/sis columns?  I know some find them valuable, but for others, they just add clutter to an already busy page, causing the need for additional horizontal scrolling.

New Member

Maybe an option to show the SIS ID, or the SIS Login or both or none, would be great. Smiley Happy

New Member

I completely agree with adding an additional SIS_something_ID field for grading, but I'd like to stress that this should be a field from the User object, not (one of) the (related) Login objects. A student is one person, with, in this case, one unique identifier. If a field from the Login object would be chosen, the behaviour would be depending on the number of Logins per User, the order in which those Logins were added, etc.

New Member

In our previous LMS, the gradebook had a 'setup' option with a list of fields that could be displayed in the gradebook entry for a student including: the section id, the student number (SIS ID), the login id (which is separate from the SIS ID at our university), the Name (in two formats: FirstLast and LastFirst), and official university email address. That allowed instructors and TAs to find and grade by any and all of those identifying attributes.  Our instructors are asking for these options to be available again.

Community Member

An excellent idea and would be a great improvement to the grade book/marks page. We are currently facing the same issue at our University were we populate the Student/Staff number as the SIS ID and the email address as Login/Secondary ID for users.

Our academics find it hard to identify the student when there are multiple students with the same name. We populate the secondary ID field with the email address of the student which does not help to identify the student (not always you know the email address of the student). The principle relationship for an academic to determine the student would be the student number.

Populating an additional column to show the SIS ID would help resolve the problem. Academics can use either SIS ID or Secondary ID in the mark/grade book if we allow the option to view both, this does not break the use of Secondary ID field for someone who is using this currently.

P.S: Please consider also updating the filter to use the SIS ID.


New Member

This is a surprising discovery for our institution. We need the student numbers in our gradebook - not the loginid.

New Member

Having just implemented Canvas, our administrators have commented that the inclusion of the SIS User ID would be extremely useful on this screen as we use this for our Student Number. Does anyone know what stage this request is at now, given the request was made back in February initially ? 

Community Champion

 @lisa_ward ‌, the SIS ID is Secondary Info you can display with the Student Name in the 'New Gradebook'. So you should be good to go sometime in 2018. Check the video by Christi Wruck from InstructureCon ... New Gradebook Phase 1

Community Contributor

A faculty member just requested this functionality as an SIS only login. He likes to do blind grading and analysis using the student's SIS ID as the only identifier on the paper. I agree that providing faculty the option to switch the identifiers off and on would be a good approach to solve this for different use cases. 

Community Participant

We've also been trying to implement a solution for this for a while now.

We can't use the secondary ID column, as that's used for our eppn from the SHIBBOLETH login (basically and changing this would be big.
After many iterations of varying success and failure, we hope to have struck gold in our newest idea.
We have decided to use the Sortable Name to hold the the Sortable Name plus the BannerID.
In our initial test, we set sortable_name to only use BannerID but we realized that Canvas sorts by sortable_name, regardless of the option being active.  This caused a lot of alphabetizing inconsistencies.
So we are now updating all users with BannerID's as:
If record does not have banner id it will consist from lastName_firstName_
The Sortable Name gradebook option is set to Allow at the root and at the sub-account level, so we're not forcing this change to anyone.
Those who don't want to use it won't see any change.
Those who do want to use it, and we have a good number of those, can simply change the setting in their course whenever they want to.
When enabled, you can see it in the GB.
And it exports as well!!
We know that there are a few steps to filter the data in Excel or similar if people want to remove names, but it will be so much easier using this method than anything else we've tried or heard about.  And takes a lot of the manual process and eye-balling out of the equation! Very tiresome.
We've done testing and it seems to be going well.  We're planning to put it in production next week.
We've also talked with Instructure about this and they feel it's a comfortable solution too.
Hope this helps some some issues for you all.
** Also note that we don't allow users to edit their name. **
** We are also explicitly stating that this is NOT a method for anonymous anything **
Ed Casey
Lead Instructional Technologist
Academic Technology, CIS
Brown University
New Member

We'd also like this  for our context in Australia.  We have two unique IDs for students which have arisen of the years with one being a more administrative SID and the other being an ID used to login to our LMS.  Being able to display either, both, or neither in Marks would be incredibly valuable to us.  I've up voted and hope this feature comes to fruition.

Community Participant

Quick update:

We removed the underscores.  Now it's LastName, FirstName BannerID

Oddly enough, some third party integrations were using the sortable_name.

All seems good again.


New Member

We used to have this column, and it went away in the "New Gradebook". It was very useful, because all our grading mechanisms have been using login ID for decades, and so everything can be in the correct order for quick entry of grades (since you can sort by that column). The "New Gradebook" allows you to include the ID as a secondary display item, but without it being sortable, it doesn't help me.

Community Contributor

I was demo-ing the New Gradebook today and just realized that the New Gradebook does not have the SIS ID. Why would they have removed a feature folks have come to count on?

Community Champion

Nancy, if you mouse over the 'hamburger' at the right corner of the Student Name field, you can enable the SIS ID ...


Community Contributor

Thanks!! I had just located it Smiley Happy. Whew.  Good news Smiley Happy  I am trying to convince my pals on the academic side to adopt new gradebook and I did not need another issue. Thanks!!!