Gradebook: Import grades from Scantron
If you give tests and quizzes with Scantron grading sheets, you can import those results directly into Sakai's Gradebook.
Prepare spreadsheet for import
- Ensure that students record their official Rutgers ID numbers to identify their Scantron sheets
- When you scan the answer sheets, save the resultant spreadsheet file
- Back in your office, open the spreadsheet into Excel and confirm that student IDs are in 1st column and each column is appropriately named and delete unnecessary columns
- Now, from the File menu choose "Save As" to save a copy of this spreadsheet as type "csv," giving it a simple but recognizable filename
In image below, note that columns are named properly (the name of any grade column will become the label for that grade in Sakai) and that in the "Save As" dialog box, the "type" has been changed to "CSV."
