Never grade a spreadsheet-based homework or test by hand again.
What is SpreadsheetGrader?
How Does It Work?
You or your TA can upload any semi-blank Excel-based spreadsheet you wish to the system for students to complete based on your given instructions. The student’s submission will be automatically and instantly graded by the system based on the answer key you provide, requiring no manual spreadsheet grading labor or time on your part.
What Else Makes It Unique?
You have the option to use “Training Mode,” which provides instant feedback to students on their work (turning correct cells green in real time), or to withhold this feedback, such as in a traditional testing context.
What Is It Like?
Students receive an email from the SpreadsheetGrader system when an assignment, quiz or test is made available by faculty or a TA. All students have to do is click on the link in the email and they can begin their work. No username or password is needed!
If the student has used Excel, the user interface is immediately familiar to them, and they can dive right in, using the entire library of Excel functions, and popular keyboard shortcuts.
If Training Mode is turned on, the student will see cells turn from red to green when they arrive at the correct answer, encouraging them to press on and complete the assignment.
For Faculty and TAs
Faculty and TAs are set up as Group Leaders in the SpreadsheetGrader system.
Upon logging in to administrator view, Group Leaders are met with a simple, clean user interface.
Group Leaders can:
- Create a new test question and assign it to a new test or to an existing test
- Clone an existing question or test
- Edit an existing question or test
- Configure test settings related to:
- Passing score threshold
- E-mail notifications to you and the test-taker
- Test-taker post-test results messaging
- Amount of time given for a question
- Deploy tests to students
- View reports of individual and group performance.