I will begin by saying that this is by no means the best way to do this. I am not a programmer, I am a physics teacher. My programming skills are completely self-taught and consist of some flash action scripting, enough html to be dangerous, and enough C++ to know that semi-colons are very important. I was talking to my nephew yesterday. He is a computer science major at the University of Iowa. I may have talked him into trying to develop the data analysis of this game for a class project he is doing for his degree. In fact, when Des Moines came to me and asked to see my programming mojo, I told them to hire someone smarter than me to build them an app.
That being said, here is a peak behind the curtain.
When teachers do a mission, they are to receive points depending upon which level the mission falls under. 4th level missions are worth 4 points, etc. I have to record that they did the mission, assign them the points, and then add up their total points. I do it all in google docs for the simple reason that I am comfortable with spreadsheets, and it's free. Here is how it is done. At the end of every mission, teachers submit a google survey to rate the mission's effectiveness. They have to put their mission number, and the survey records their user name.
I then create a pivot table that accesses this information with the teacher's username, mission number, and returns the points awarded. The final column on the pivot table adds the total number of points for that level. The different colors on the table allow us to keep track of chain missions. If someone does all in a chain, they earn a new title.