We have the school performance data for 2005-2011 of all schools in a certain exam. Unfortunately, instead of separating the number of passers from the number of takers like this:
Passers Takers Percentage
10 25 40%
the initial encoder wrote it as passers/takers in each school per each exam year, like this:
We need someone to re-encode the data to separate the number of passers from the number of takers. There are 1600+ schools, and 10 exam instances to re-encode for Tier 1 of the exam, and 1900+ schools and 10 exam instances for Tier 2 of the exam.