[ARCHIVED] Is there any way to get a column entitled student's grade (9, 10, 11, 12) in the Canvas Grade Export?

[rpsimon]

I will soon be doing grade exports for non-senior students (grades 9-11) and then just for seniors (grade 12).  Most of the Course Names in Canvas have the grade in which students are enrolled. So by using the "Text to Columns" feature in Excel, I can filter out those students by grade level.  I am trying to find a more efficient way to sort and filter the students by grade level.  Is there a way to do so?  It would be helpful if there was a column entitled "Student's Grade" where either a 9, 10, 11, or 12 would appear.  Thanks!

[Chris_Hofer]

Hi there, rpsimon...

I'm not sure how the students are set up and/or enrolled in your course, but one thing that came to mind was utilizing "Sections" in your course.  Would it work to create separate sections called "Grade 9", "Grade 10", "Grade 11", and "Grade 12"?  How do I add a section to a course as an instructor?  Then, you would go into your "People" page of the course and assign each of your students to a section based on their current grade level.  How do I edit sections for an enrollment in a course?  Next, you would go to your Gradebook and export your student roster to a CSV file.  Looking at the screen shots in this Guide, How do I export grades in the Gradebook?, the CSV export file appears to have a column for "Section" (column "E" in the screen shot under "Edit Scores").  Would that work for your needs?

[rpsimon]

Thanks so much for this @Chris_Hofer!   It’s definitely something to think about.  However, sometimes there are courses with 11 and 12 grade students in it.  In addition, how long would this take?  Is there a way to enter the information for an entire class at once while using a SIS import?  To do this student by student would just take forever. 

[Chris_Hofer]

Hi rpsimon...

I'm sure there is...though I'm not much of an expert when it comes to SIS imports.  I'll share your question with the Canvas Developers‌ group in hopes that your question gets some additional exposure.

[rpsimon]

That would be great!  The only thing that I can think of at this point in time would be to take the course name in the csv file and use the "Text to Columns" feature in order to break it up into columns where one column shows the actual grades from which students are enrolled in the course.  (Sorry for the run on sentence!). I would then use the sort and filter option in order to sort the data based on the grades of which students are in.  It will take some time, but at least I will have the data.  The trickiest part will be those courses in which 11th and 12th grade students are enrolled.  For those classes, I would have to research the students individually (either by name or SIS ID) and go from there.  I am determined to do a practice run before I have to do the real thing so I will know exactly what to do.  If the developers can in fact add this column to the spreadsheet/export, that would be so amazing!!!!

[rpsimon]

So I just spent some time using the Sections feature in Settings.  I created two sections in one course and went through the people in the course one by one and added them to their respective sections.  I wish there was a way that I could open a section in the course, and then put a check box next to each person and add them to the sections that way.  This would go much faster.  I can see myself doing this for those courses that have both juniors and seniors and don't have the course grades in the course.  I will start with those.  If I have to, I will then work on those courses with both juniors seniors and have the grade in the course name.  I know this will take me awhile to accomplish, but it will most definitely help in the long run.  However, if the developers could add check box feature to check all of those people - or add them all by SIS ID etc rather than going through each person manually, this would most definitely help.

[Chris_Hofer]

rpsimon...

Thanks for the update.  You might want to consider submitting those suggestions as Feature Ideas here in the Community.  I'm not sure if any similar Feature Ideas already exist, but you might want to do that first before creating a new Feature Idea.

• How does the feature idea process work in the Canvas Community?
• How do I create a new feature idea in the Canvas Community?
• What is the feature development process for Canvas?