The Top pick reviewing mode in Good Grants does not produce a ranked list of winners but a group of winners in no particular order. To generate a ranked list, the Borda count method needs to be used outside of Good Grants with your exported results in Excel.
Borda count
Using the standard Borda count method, points are allocated to applications based on the number of first preferences, second preferences, third preferences, and so on.
Essentially, each preference is given a score value, for this example, we'll work with finding the top five applications based on user preferences. Based on the number of ranked winners we want, we start by assigning the lowest preference (i.e. fifth) and lowest point value (i.e. 1). At the other end of the scale, we give the first preference the highest point value (i.e. 5). So, points per preference would be:
- First preference = 5 points
- Second preference = 4 points
- Third preference = 3 points
- Fourth preference = 2 points
- Fifth preference = 1 point
So, if an application had the following distribution of preferences:
|
1st preference
|
2nd preference
|
3rd preference
|
4th preference
|
5th
preference
|
|
|---|---|---|---|---|---|
| Application A | 3 | 2 | 5 | 2 | 1 |
Then the points would be:
|
1st preference
|
2nd preference
|
3rd preference
|
4th preference
|
5th
preference
|
|
|---|---|---|---|---|---|
| Application A | 3 x 5 points | 2 x 4 points | 5 x 3 points | 2 x 2 points | 1 x 1 point |
| =15 | =8 | =15 | =4 | =1 |
Therefore, Application A would have scored a total of: 15 + 8 + 15 + 4 + 1 = 43 points.
Let's look at this with a larger dataset:
|
1st preference (5 points) |
2nd preference (4 points) |
3rd preference (3 points) |
4th preference (2 points) |
5th preference (1 point) |
Total points
|
|
|---|---|---|---|---|---|---|
| Application A | 3 | 2 | 5 | 2 | 1 | =43 |
| 3x5 = 15 | 2x4 = 8 | 5x3 = 15 | 2x2 = 4 | 1x1 = 1 | ||
| Application B | 5 | 3 | 0 | 0 | 2 | =39 |
| 5x5 = 25 | 3x4 = 12 | 0x3 = 0 | 0x2 = 0 | 2x1 = 2 | ||
| Application C | 1 | 7 | 2 | 3 | 3 | =48 |
| 1x5 = 5 | 7x4 = 28 | 2x3 = 6 | 3x2 = 6 | 3x1 = 3 | ||
| Application D | 3 | 2 | 3 | 0 | 0 | =32 |
| 3x5 = 15 | 2x4 = 8 | 3x3 = 6 | 0x2 = 2 | 0x1 = 0 | ||
| Application E | 10 | 2 | 0 | 3 | 2 | =66 |
| 10x5 = 50 | 0x4 = 0 | 0x3 = 0 | 3x2 = 6 | 2x1 = 2 |
Based on the total points for each application, this would be the ranked list of entries from 1st to 5th:
- 1st: Application E, 66 points
- 2nd: Application C, 48 points
- 3rd: Application A, 43 points
- 4th: Application B, 39 points
- 5th: Application D, 32 points
How to put Borda count into practice
- In the Manage workspace, go to Reviewing > Leaderboard and click Export
- Download the Results - Top pick export
- Once you have your exported results in Excel, add a column to the right of each Preference column
- Then all you need to do is multiply the preferences by the point allocation, and sum up your results in the total column
Here's what it looks like in Excel: