Assignments missing from Gradebook after CSV import

Jump to solution
slhampton
Community Member

What I did:

  • I exported a csv file from the Canvas gradebook
  • Copied in some columns of assignments and scores from another programs csv export
  • Saved the csv file and imported it into Canvas
  • For each of the new assignments when prompted I selected "new assignment"
  • For maximum points I chose 1 because the scores from other program were in decimal format
  • File upload and submission proceeded without error
  • I went to each assignment and checked the box for SIS syncing and set a due date.

Expected Result:

  • To see the assignments and the student grades in the gradebook when I select "Grades" in the course menu

Actual Result:

  • I can NOT see the assignments and student grades in the gradebook when I select "Grades" in the course menu.
  • I CAN see the scores for assignments under "Last 10 graded items" if I select the student name in the gradebook inside the JavaScript window that pops out from the last side.  For example: a 71% on one of the items.
  • I CAN see the student scores for the assignments if I go to the assignment and select the SpeedGrader option for that assignment, the scores are there in the SpeedGrader.  For example on one assignment it has: Grade (0.71 / 1) and below in the box 71% 

What I have checked:

  • I have checked that the assignments are published.
  • They have a point value of 1.  (The decimal point value is what shows in SpeedGrader)
  • The assignment group is assignments
  • Display grade is set to percentage
  • Submission type: no submission
  • Group assignment is NOT checked
  • Peer Review is NOT checked
  • They ARE set to sync to SIS
  • They are assigned to Everyone
  • They have due dates

Anyone have any suggestions for what other settings/configurations that I might check to determine why these assignments are not showing up in the gradebook???

Labels (1)
0 Likes
1 Solution
slhampton
Community Member

I am posting the solution I discovered just in case anyone else runs up against this problem.  The issue has to do with this line above:

  • I went to each assignment and checked the box for SIS syncing and set a due date.

The due date that I set was 1 day beyond the end of the 1st nine weeks.  The view by defalut in the Canvas grade book was of the 1st 9 weeks.   When I was in the grade book and selected View>Filters>Grading Period and then from the the drop down menu to the right selected "All Grading Periods"  I saw my grades I had imported.  They were also viewable in the "2nd 9 Weeks option."  Yippie!  Problem Solved, now I can do CSV script driven export/import. 

View solution in original post

0 Likes