John, this lesson will get you partially there: Tinderbox Training Video 46 - Simple Gradebook Part2.
I have a question out to the community on step two of this, i.e. how do you update a student’s record one they’re already in TBX from values from a newly imported spreadsheet. I’m not sure if it an be done, but I’ll try to figure it out.