||[Back to Help Center]|
Corrupted Grades Sheets - What can I do?
Why am I seeing this error?
Flubaroo is confused because the Grades sheet doesn't look like it expects it to. This is most likely because:
- Grading got stopped/stuck when you last graded, so the Grades was left in an incomplete state.
- You deleted rows in the Grades sheet after last grading.
- You deleted columns in the Grades sheet after last grading.
- You deleted some other data in the Grades sheet after last grading, such as one or more timestamps in Column A, or the summary information at the top-left of the sheet.
So what can I do?
You'll need to get back a Grade sheet that's formatted correctly. If you just deleted this data a moment ago, then you may be able to quickly "undo" your change (Edit > Undo), and you'll be good to go. But if you can't undo your change, then there are 3 ways to fix your problem.
If none of these methods work for you, then email the Flubaroo Discussion Forum for help (firstname.lastname@example.org).
Method 1 (Easiest):
- Instructions: Turn off Autograde (if on). Delete the Grades sheet and grade your assignment again.
- Pro: Very easy.
- Con: You will lose information on which students have already been emailed, any individual student feedback, and any Grade by Hand scores & teacher comments.
Method 2 (Moderate):
- Instructions: Turn off Autograde (if on). Rename the Grades sheet to something else (i.e. "Grades - bad"), and then grade your assignment again. Use the "bad" Grades sheet as a reference. Copy over information to your new Grades sheet about which students have already been emailed, any individual student feedback, and any Grade by Hand scores. Note that Grade by Hand teacher comments cannot be copied over (easily).
- Pro: You won't lose so much information.
- Con: It can be a bit time intensive, depending on how many submissions you graded.
Method 3 (Moderate):
- Instructions: Turn off Autograde (if on). Use the spreadsheet's revision history (File > See Revision History) to restore the Grades sheet to how it looked just after grading last completed.
- Pro: You won't lose any information, and this can be done quickly if you're familiar with revision history and know when grading last completed.
- Con: Revision history in a spreadsheet could be a bit confusing to first-time users (though it's worth learning!).