GradeHub – Answer Sheets 3.6 is out! In this release, you’ll find the regular fixes and a major new feature, offline reports in a GradeHub Excel Workbook. Also new is sorting or searching the Analyze Student report by student ID or name, improved recognition for darker PDFs, and faster exam processing.
Teachers love GradeHub’s online reports (see them with the link), but occasionally we hear that some still want paper. In this new release, not only are GradeHub reports in one Excel file, but we significantly increased the information available offline. Now each exam has a downloadable GradeHub Excel Workbook with nearly all of the statistical information offered online. The workbook can support extra analysis, such as curving. If you want paper, simply print it from Excel or a Google Sheet.
To download the GradeHub Excel Workbook, simply select the “Export to…” dropdown under the Analyze Exam button. The offline workbook provides nearly all of the information online separated in following tabs similar to our online reports:
As with our online reports, test reliability using Cronbach’s alpha, median, mean, standard deviation, and lowest and highest scores are presented.
Scores are presented in 10% increments with the distribution represented by an asterisk ( “*”) for each student.
We would say this is our biggest online report request from instructors. Without the color used in the GradeHub report under the Analyze Student button, the “old” CSV file didn’t allow instructors to see where students are struggling. With the GradeHub Exel Workbook, we made a few changes to the old “Response Data” export including:
The result, at a glance you’ll be able to see the questions students missed and the distractors they chose.
The above screenshot is our previous CSV download mentioned above. You can use this information if you’d like to analyze responses in Excel or other statistical packages, such as SPSS or R.
This tab of the GradeHub Excel Workbook summarizes the highest and lowest performing questions on your exam and their related point biserial correlation values.
The item statistics for each question are contained in this report. Since our online reports bold the correct response, we inserted a column for the corresponding correct response. Key statistics in the item analysis include p-values, point biserial correlation, Cronbach’s alpha with delete, and high and low cohort analysis.
To help you find students in the Analyze Students report, you can now sort by name or student ID.
You can search by name or student ID too.
Our algorithms are updated to better manipulate darker PDFs created by a few scanners and bleed-through from students using color inkjet printers.
Behind the scenes, the team did some other magical stuff to reduce answer sheet (aka scantrons) processing times for large classes!
We’re always grateful for all their hard work.
As we release this post we know there’s a tremendous amount of uncertainty with the Coronavirus. Our hope is that you’ll be healthy, safe, and secure. 🙏
As always, feel free to reach out; we’re here to help,
CEO + co-founder
CTO + co-founder