2 ms·
My wife was a teacher for a long time. She was technologically advanced, so she used spreadsheets to track all her grades. Apparently this wasn't a thing most
by jedberg 6y ago
My wife was a teacher for a long time. She was technologically advanced, so she used spreadsheets to track all her grades. Apparently this wasn't a thing most people did.
She was required by the district to do report cards in this very crappy Mac app, which then synced with a central server when you were done. The Mac app had no import utility nor any keyboard navigation, so I had to help her manually transfer the grades from the spreadsheets to the grading program, and each kid required about 90 mouse clicks (times 32 kids).
After the first time, I decided I was going to figure out a better way.
I ended up reverse-engineering the save file format, which was sort-of-but-not-really XML. I wrote a python program that could take CSV exports from her spreadsheet and recreate the save files for the app, so I would run that, load the app up, and then just spot check a few of the grades.
The first time I did the grades that way it took twice as long as just manually entering it, but after that, doing report cards was a breeze.