cancel
Showing results for 
Search instead for 
Did you mean: 

Add, Create, or Modify a Calculated or Total Column in the Gradebook

Add, Create, or Modify a Calculated or Total Column in the Gradebook

(3)

 

Being able to calculate things in the grade book beyond adding things up or weighting and adding seems like an absolutely necessary feature.  It seems like one of those that comes up repeatedly under various guises, but keeps getting archived.  But, I keep reading that there are lots of people who do more than just add things up to calculated grades.

77 Comments
kmeeusen
Community Coach
Community Coach

Hi  @thomas-rietz ​, and thank you for submitting this feature idea, and I can see you have done your homework on this one.

Since you are already familiar with the feature idea you referenced, and participated in that discussion, I won't be an old bore with my opinions.

I will recommend that this idea open for voting during the next period. Priorities and needs change with time, and perhaps this time more up-votes will happen.

KLM

Stefanie
Community Team
Community Team

ICYMI,  @thomas-rietz ​, the ability to create an assignment (and thereby add a column to the Gradebook) that doesn't count toward the final grade is currently in beta. [Edited to add: This piece of the feature idea was subsequently removed.]

GideonWilliams
Community Champion

Annoyed I missed this first time as it definitely has my vote. Our MFL Dept would like to move their Shared Gradebook to Canvas from Excel!! Not possible at the moment as they need to carry out averages of key grades across different components. More functionality for calculations in the gradebooks would be amazing!

kona
Community Coach
Community Coach

 @GideonWilliams ​, did you see Stefanie's comment that this feature is currently in your Beta Instance of Canvas and should be in production by August?

Stefanie
Community Team
Community Team

 @kona  ,  @GideonWilliams  : Well, part of the feature is... Smiley Happy The feature currently in beta will allow the user to add an assignment that doesn't count toward the final grade, and of course that assignment will populate the Gradebook with a column. If I'm reading the original idea submission correctly, it actually encompasses two separate ideas, one of which is covered by the beta feature--but the other, to add a calculated column that is in essence going to function independently from the Gradebook, is not. [Edited to add: The first piece of the feature idea was removed.]

GideonWilliams
Community Champion

Indeedy. Assignments not added to the Gradebook is a really good start and compliments the existing feature where you are able to create groups of tasks ;o)

Renee_Carney
Community Team
Community Team

 @thomas-rietz ​

Thank you for resubmitting this idea.  It will open for voting with the September cohort.

I did remove the additional note in your idea which prompted Stefanie's reference.  We require all ideas to be focused and individual, so to move it forward for voting, we had to remove it!  ( I would have had you submit it as new, but as you saw, it is in beta)

rozhussin
Community Participant

I vote up!!! x100 times!!!

biray
Community Champion

This idea has moved to the next stage and will be open for voting among the Canvas Community, from Wed. August 3, 2016 - Wed. November 2, 2016.

Check out this doc for additional details about how the voting process works! Smiley Wink

thomas-berry
Community Member

That is exactly the reason why am using Excel and not the gradebook to calculate grades. I only publish "raw" scores of assignments or exams in the gradebook and tell my students to ignore everything else in the gradebook.

With the proposed changes the gradebook might actually become useful.

thomas-rietz
Community Contributor

It's a start and you can calculate a "true" grade column in excel and post it.  But, if the students are working through things self-paced, the calculated column you post is virtually never current. 

GideonWilliams
Community Champion

I've had a watch of the gradebook presentation on YouTube - Gradebook Futures: Kill All the Clicks! - YouTube and did not see anything that resembles this request or any thoughts about future implementation :O(

I am hoping that this idea might be noticed by the team - of course if we reach 100 then there is an even better chance..

gschultz
Community Contributor

 @thomas-rietz ​

I am trying to better understand the submission idea.  Are looking for the ability to have subtotals for assignment groups and the ability to have a best of graded assignments (such 6 out of 10, or 10 out of 12) where only the top grades count?

thomas-rietz
Community Contributor

Sure. And other things. For instance, I weight grades on group projects by peer evaluations...so a column that multiplies two numbers would be great. Sometimes, when an exam is particularly difficult, the score might be a percentage of the high score in the class, not the total possible on the exam. So, dividing by a number that is not predetermined (e.g., a max) would be nice. In short, people do more that simply assign fixed weights and sum to determine grades. While complicated grading schemes can present problems for students, simple things like these make perfect sense to them.

Tom

Jeff_F
Community Champion

To balance this out I virtually voted down 99 times.  Smiley Wink

My opinion is that this 'feature' will do more harm than good.

ejp10
Community Participant

I understand this is complex, but a lot of faculty do need it. 

GideonWilliams
Community Champion

Add the functionality and make it optional. It frustrates me hugely when there is a perception/judgement about whether new features will/will not work. As a former Moodle user at a K12 school this was a MASSIVELY IMPORTANT feature and one that enabled us to improve our reporting system and reduce workload on staff. 

lroe
Community Member

This would be a valuable feature when we need to calculate a midterm grade in the grade center. Also, can we block assignments by dates? Like create grading groups for midterm?

dbohlmann
Community Member

Egadz, I was flabbergasted when I saw that I could not created a calculated column in the gradebook.  So essential.  In Blackboard (is that a bad name around here?) I always created a running total grade so students could see what grade they would get based on the assignments I had graded (with unsubmitted assignments being marked as '0').  This way they get a better picture of where they are, and it is an indicator for them that they need to do some catch up work.

     IMHO, the 'Total' column currently in there is totally useless; totally.  Pretend I have a 16-week course with 3 assignments each week plus a mid-term and final exams (50 total assignments).  In 'Total', the value calculated is not based on what has been assigned and due, but on submissions.  So if I am in, say, Week 3 (9 assignments due thus far), the Total column shows no difference between a student who has done all 9 assignments and received 100% for all 9, compared to a student who has submitted only 1 of the 9 and gotten a 100% on that - they both show up as 100%.

     If I click the option to convert non-submitted items to a 0, then ALL unsubmitted work -- including the assignments that are not yet due -- are counted as 0... and everyone's grade look poor in the early part of the course.

     I want the students to see a running total.  The assignments included in the running total could either be just the ones that have been due, or ones that I can manually enter to be included in the running total set.  And in either case, an unsubmittal is counted as 0.

btbryant
Community Member

As many have posted before I find unthinkable that you cannot create a new total column.  In the department that I work in the students must reach a certain percentage on their overall exam score average before they can pass the course.  So for the students not to be able to see what their current exam average makes it difficult for the students and for faculty to confirm that they have reached the required score to pass the course.

About Idea Conversations
In the Canvas Community Ideas space, you can share, converse, and rate idea conversations related to software improvements to Canvas products.