Zipgrade is a teacher grading system that is very inexpensive (about $10 a year). Our lead scout, Chip, spent around 150 hours last year developing our Scantron in conjunction with Zipgrade. He now can make a new season’s Scantron in just a few hours. He is willing to share this with others. There are aspects of the Scantron sheet that remain the same every year and parts that can be customized for the current year’s competition.
The wonderful thing about the Scantron is that it is easy and the scouters much prefer it to paper and pencil. The database manager loves it because it is extremely easy to upload (you use a phone screenshot to capture the data - we have 99.94% accurate transfer of data). It is an advantage over a pure app because you can go back to the hard copy if there appears to be unreasonable data (55 cargo in a match). Also, sometimes electronic data gets corrupted or lost. If necessary, there is a hard copy to re-enter the data.
We use Tableau to analyze our data. Chip takes the Zipgrade data and transfers it to an Excel file. Tableau reads the Excel file. Tableau is wonderful. It’s extremely easy to do “on the fly” metrics. However, there is a learning curve with Tableau. We have trained other teams in our Scantron system. Some use Tableau to analyze the data, others stick with Excel.
As in any system, there is a learning curve. We learned that you must have proper lighting to photograph the Scantron. It’s not difficult to get that lighting, but it’s best to practice in different environments so that you know what will be sufficient for the task. It’s also critically important to do scouter training. We use the various Zero Weeks to train our scouters, check for errors, and give them a chance to ask their questions.
By “data pipeline” are you talking about how the data gets from the match scouter through the various processes until it gets to the Drive Coach? Chip has set up his database and a “Mission Control” system that addresses this. The data availability after a match is 2 minutes if there are no errors (determined by our quality control person) from the end of the match to appearing in Tableau. Otherwise, if it is sent back to a scouter, it’s about 5 minutes. Analysis and preparation for match strategy is variable.
We love the system. Let us know if you have any additional questions.