# Community

cancel
Showing results for
Show  only  | Search instead for
Did you mean:
New Member

## Final Score vs. Current Score

When I export completed course information into Excel, I get a Current Score % and a Final Score % that are different. What are the differences between the two and any thoughts as to why they are different?

Tags (2)
1 Solution

Accepted Solutions
Community Coach

The current score is the score that is calculated for all graded activities.  It does not include any assignment, quizzes, etc, that have not yet been submitted or graded.  If there is a null value (--)  it simply ignores it in the calculation. The Final Score calculates all graded activities whether or not it has been given an actual grade.  If there is a null value (--) it treats this as a zero.  In most instances the Current Grade will be higher than the Final.

Robbie

13 Replies
Community Coach

The current score is the score that is calculated for all graded activities.  It does not include any assignment, quizzes, etc, that have not yet been submitted or graded.  If there is a null value (--)  it simply ignores it in the calculation. The Final Score calculates all graded activities whether or not it has been given an actual grade.  If there is a null value (--) it treats this as a zero.  In most instances the Current Grade will be higher than the Final.

Robbie

Community Member

Theoretically then, if one checks, "treat ungraded as zero" and then exports to Excel, then the "final grade" should equal the "current grade," no?

Community Team

boles​, no, that is not the case. "Treat ungraded as zero" is a Gradebook view; it calculates grades as if the student received a zero for ungraded assignments, but does not actually enter grades of zero for those assignments. Please refer to this Canvas lesson for a detailed description: How do I treat ungraded assignments as zero in the Gradebook?

If you want your Gradebook export to accurately reflect zero grades, you must first enter zeros for those students who should receive them. You can do that by entering a default grade of 0 for each assignment column and choosing not to overwrite the existing grades. The Canvas lesson that describes that is here: How do I set a default grade for an Assignment?

Community Member

Thanks for the reply...and so quickly! I'm not sure I understand the difference, or that there is a difference. If the Gradebook does not actually enter a zero, as you say, but treats an ungraded assignment as a zero when that option is checked, then there doesn't seem to be any difference in terms of the "Final" grade that appears in the Gradebook the web page -- what you refer to as "Gradebook view," (or in the exported Excel file after the "treat as zero" option is checked), as to whether a zero is entered or not. In other words, regardless of whether or not a zero is entered, checking the "treat as zero" option will produce the same Final Score, won't it?

- Elson

Community Team

boles, the "treat ungraded as zero" is a hypothetical exercise that allows you to see what your students' final grades would look like if they did not complete any of the outstanding assignments and received zero grades for those assignments. In order for your students to see accurate grades, the zeros must actually be entered, either manually or using the default grade method I described earlier.

This is the relevant part from the first guide link I referenced earlier; I've put some sections in bold for emphasis.

As an instructor, you can view student grades as if all ungraded assignments as worth zero points in the Gradebook. This feature called Treat Ungraded as 0 is located in the Gradebook Settings and is only a visual change that does not actually affect any grades—it only helps you see the change in Gradebook calculations if ungraded assignments were given scores of zero. Enabling this option has no effect outside of the Gradebook; students cannot see any difference in their grade pages.

When the Treat Ungraded as 0 setting is enabled, assignments that do not have a grade will be treated as if a student received a score of zero. You can disable this setting in the Gradebook at any time. Even when this setting is enabled, Canvas will not populate zeros in the Gradebook. Dashes will still display for each student submission.

Hope this clears up any confusion.

Community Member

Yes, I get your point. Mine is different as I was not referring to what students see in Canvas, nor was Derek and Robbie in their posts. The question is the difference between the Current Score and Final Score that appears in the exported Excel file. Knowing the difference important for myself (and apparently Derek too), since that is what I use to determine letter grades (for input to our local system). It is also not clear from Robbie's post whether or not selecting "Treat Ungraded as 0" for "Total" has any effect on Final Score seen in the Excel file. She writes, "The Final Score calculates all graded activities whether or not it has been given an actual grade. If there is a null value (--) it treats this as a zero ." The question I'm asking, is whether or not it actually does treat it as zero, regardless of whether or not one has selected, "Treat Ungraded as 0"?

As for students, presumably the "Total" that they see is the equivalent of Current grade in the exported Gradebook in Excel.

- Elson

New Member

The "treat ungraded as zero" is one of the most misunderstood features, at least in our school district.  It took some time for us to understand that it is a gradebook view only and not actually calculating zeros in the grade.  We have hidden / disabled the feature because too many of our 8K teachers get confused by it.

Community Team

boles, my quick test--downloading two Gradebooks, one with "treat ungraded as zero" not enabled, and one with "treat ungraded as zero" enabled--showed no difference between the .csv export files. In other words, the view toggle doesn't have an impact on the content of the .csv file. In each case the "Current Score" was higher than the "Final Score," as  @Robbie_Grant ​ stated. (By the way, Robbie is a guy. )

So getting back to your original question:

Theoretically then, if one checks, "treat ungraded as zero" and then exports to Excel, then the "final grade" should equal the "current grade," no?

The answer is no, that is not the case. And, assuming that you do indeed treat ungraded assignments as zero in calculating your final score, you would indeed use the Final Score for reporting purposes--but if you want your students to see what final grade it is that you're going to submit, you would need to enter zeros for ungraded assignments. Otherwise, as you rightly point out, they are seeing the Current Score, not realizing that that is not their actual final grade--unless they, too, have disabled the "Calculate only on graded assignments" setting in their own Grades view: How do I view my grades in a current course?

@joseph_allen ​'s observation in this regard is right on point. It's a Gradebook view only, and it is confusing. It has been the subject of numerous feature ideas, one of which remains open for voting and is in the "Gathering Info" stage-- --so by all means, please add your votes and a description of your use cases there.

Community Member

Hi Stephanie -

This is very helpful! Thanks for taking the time to test it out. I did too and I found that comparing the Current Score and Final Score was useful for me to catch the ungraded/uncompleted assignments that I still needed to enter a "zero" score for. When the two scores matched, I knew that the students "Total" in Gradebook and my "Total" were the same. Tedious. I'm casting my vote now!!

- Elson