[#SAK-16979] Exported Gradebook shows incorrect Course Grade

Sakai

Exported Gradebook shows incorrect Course Grade

Created: 16-Sep-2009 13:46 Updated: 10-Dec-2009 09:11

Component/s:

Gradebook

Affects Version/s:

2.5.x, 2.6.x, 2.7.0

Fix Version/s:

2.6.1, 2.7.0

Time Tracking:

Not Specified

File Attachments:

gradebook1_cleaned.csv (0.6 kB)
2.

gradebook2_cleaned.csv (1 kB)

Image Attachments:

1. Screenshot1.png
(69 kB)

2. Screenshot2.png
(72 kB)

Issue Links:

Relate

This issue relates to:

~~SAK-15144~~ Points with Categories and Weighting: csv file created from Export Gradebook incorrectly calculates course grade

2.6.x Status:	Resolved
2.5.x Status:	Merge
2.4.x Status:	None

Description

« Hide

When exporting a gradebook, the course grade in the CSV is different than the course grade shown in the site. Two examples (screenshot, csv) are attached.

Example 1:
Course grades in CSV appear to be an average of some sort but does not match what is shown on the course site.

Example 2:
Course grades in CSV appear to be =sum(all course grades) / 2.

All

Comments

Work Log

Change History

Subversion Commits

git Commits

Sort Order:

[ Permlink | « Hide ]

Megan May added a comment - 16-Sep-2009 17:56

Changing component to JIRA, bumping up priority - if this is a problem with grades it should be looked at asap.

Assigning to Michelle Wagner for analysis

[ Permlink | « Hide ]

Carl Hall added a comment - 16-Sep-2009 19:01

Refreshed screenshots and data to have as little student information as is possible but still be able to have row identifiers.

[ Permlink | « Hide ]

Michelle Wagner added a comment - 17-Sep-2009 05:31

Hi Carl,
It looks they are using weighted gradebooks. Could you let me know which assignments are in which category and what the weight of the category is? Could you also check to see if there are any Course Grade Overrides on the Course Grades page for these students?

Thanks!

[ Permlink | « Hide ]

Michelle Wagner added a comment - 17-Sep-2009 05:38

I found a jira that looks related but was only worked on in a branch. ~~SAK-15144~~

[ Permlink | « Hide ]

Michelle Wagner added a comment - 17-Sep-2009 05:42

No need to dig up that info, Carl. I was able to reproduce with trunk gradebook locally. It looks like the "Course Grade" in the export is actually just the sum of all of the points earned, not the calculated course grade.

[ Permlink | « Hide ]

Michelle Wagner added a comment - 17-Sep-2009 06:58

r66553

[ Permlink | « Hide ]

Sam Ottenhoff added a comment - 29-Sep-2009 17:14

Confirmed that the Course Grade column in trunk is a simple sum of points.

[ Permlink | « Hide ]

Jean-François Lévêque added a comment - 06-Oct-2009 05:07

Sam, it seems your comment is telling us the problem is not fixed.

[ Permlink | « Hide ]

Sam Ottenhoff added a comment - 06-Oct-2009 07:06

Sorry, you are correct. I tested again. I received identical results when viewing in Sakai (All Grades) and when viewing the exported spreadsheet.

1) I setup Categories and Weighting
2) First Cat: 25%, Second Cat: 75%
3) Assigned grades to 3 students
4) Viewed in All Grades, categories were weighted correctly.
5) Export Gradebook
6) Course Grade column was identical to All Grades calculation

[ Permlink | « Hide ]

Jean-François Lévêque added a comment - 07-Oct-2009 03:32

2.6.x merge r67293

[ Permlink | « Hide ]

Seth Theriault added a comment - 10-Dec-2009 09:08

Has anyone been able to verify this fix in a 2.5.x instance?

[ Permlink | « Hide ]

Carl Hall added a comment - 10-Dec-2009 09:11

GT has included the patch and pushed it to production with success. We're on 2.5.