How I recovered gradebook categories after a K-12 import overwrote them

I dealt with this recently in a K-12 school where teachers imported assignment scores from a learning platform into the gradebook. The visible problem was assignment categories changed from homework and quiz into unclassified after import. The easy explanation was teachers choosing the wrong import option, but it appeared when a new grading term opened and the platform exported category names wit…