How can I export only the student name, percent per category, and in-progress grade? I don't necessarily need to export all of the assignments each time I am looking at grades. Thanks so much!
Kristy, as you've discovered, when you generate a .csv export of your Gradebook, it's an all-or-nothing proposition. So, you will need to export the entire contents of the Gradebook every time, and then delete the columns you don't need, in order to view only the name, categories, and current grade. I actually do something like that fairly often when I need to generate a list of student names, and it doesn't take long to eliminate what I don't want on the sheet (and even to format it a bit for use elsewhere).
I can see the case for downloading the Gradebook from time to time, but is there a reason you need to download the grades to a .csv in order to look at students' progress? Are you doing additional work with these numbers outside of the Canvas Gradebook that requires these downloads? Is it a very large class with a large number of assignments? I'm curious as to why this can't be accomplished by navigating to the Gradebook in Canvas, moving the Total column to the front (i.e., immediately to the right of the Students and Secondary ID columns), and sorting and resizing the columns to your liking, rather than using a spreadsheet. For more on this, please have a look at How do I sort columns in the Gradebook?
Thank you for the ideas. Our district uses Infinite Campus for our final quarter grades and semester grades. Canvas and Infinite Campus don't talk with each other, so I have to either have two screens open to transfer grades from one program to the other or hand write or print the grades to transfer the grades. I have been handwriting them over having two screens open to avoid errors in recording grades from one program to the other. I have looked to print the grades with the .csv file, but didn't want to print each assignment with it or work at deleting all of the columns. Thanks again!
Sent from my iPad
Kristy, thanks for this clarification. My school uses Banner for final grades, and we too have to enter our grades manually. Like you, I use two screens (actually, I only have one monitor, but it's big, so I can have two windows open side by side). For what it's worth, I accomplish this by downloading the Gradebook .csv, saving it as an Excel file, and then using the native Excel capabilities to lock and hide columns as needed. I then make the Excel window super skinny so I can place it alongside the Banner input window I have open in the browser. That way, without having to edit the spreadsheet, I can use the scrollbar to get the necessary data while maintaining visibility of students' names.
Retrieving data ...