State Of The Map/Planning/Scoring scholar applications
From OpenStreetMap Wiki
These are the key process steps. To speed things up, some can be done in parallel.
- The application form is closed to new applicants.
- Prepare the spreadsheet:
- Sort the data by country (nationality). This helps compare applicants from the same community.
- A "ref" (reference) column is added and is populated with the row number (i.e. starting with "2" as this is the first row with data on). This helps make it possible to link back to the original if the row order is ever changed.
- A copy of the responses is made (e.g. by duplicating the worksheet) and the original is protected to prevent changes (e.g. by using the "protect range" setting within the spreadsheet). The copy becomes the new working sheet.
- On the working sheet extra columns may be added to better present the data (e.g. to split out multiple checkbox selections into individual columns).
- Extra columns are added for each member of the selection committee (to add the scores).
- Score the written responses:
- A selection committee is formed. This may include people outside the State of the Map working group.
- Each member reads and score the written response (see below).
- If there are too many applicants then it is possible to reduce the workload. For example one selection committee subgroup can score the first half of the applicants, whilst the other subgroup scores the remainder. Once an applicant has been scored negatively by two persons then the others need not look at this applicant.
The written responses are scored as follows:
- -1 = Bad answer / off topic / no answer given.
- 0 = Not terrible but not that good either, a pretty bland / dull answer.
- 1 = A good answer, I'm starting to get excited now.
- 2 = Great answer, most inspiring, very clear what their aim/vision is.
- We are trialling this for the first time in 2017. Check how this went and whether it is something we propose as keeping.