Matching Software
Monday, February 12, 2007
5
comments
Last year, just before christmas, I entertained myself programming a small application in Visual Basic for Ms Access 2002. I developed a matching software to pair mentors and students in our project... (see 2 - 3 posts below)
For our project we are asking mentors and students to complete an online questionnaire about their experience and values (which I designed in our online community tool). The data from the questionnaire (tab-delimited files) are imported into the matching software. The application then calculates a matching mark for all the mentor-mentee combinations. The more similar values and experience mentor and student have, the higher the marks. Marks are shown in the grid (click picture to see a larger version).
The next step in the process is manual. My colleague and I decide which mentor goes with which student by clicking on the marks. The software highlights the mentor and student so they cannot be chosen again. (Only one studefor each mentor and one mentor for each student.) Of course we will choose the highest marks possible. We are doing this bit manually to avoid having the last pairs getting the worst marks. So by choosing ourselves the pairs we will try to balance the scale and be fair. The list of pairs chosen is shown in the bottom of the screen.
The whole thing looks simple. The only thing though was the $£%@# grid. I had to draw it! 25x25 = 625 boxes :( one by one!! I had all the resulting matching marks in an array and needed something to display them. The only thing that occurred to me was that grid.... I asked some "experts" (Pastelito, Tiki, JLo¼...) in visual basic, .net, java, etc. how I could draw 625 boxes in one go but got no answer...
The software works so I don't mind the time I spent in each box :P but if you happen to know a shortcut or a better way for doing this feel free to contribute in this blog. If you have no clue, just tell me whatever you are thinking....
-----------
cuando le pregunte a la Chata lo de la grilla me dijo "desconozco joven" :D
For our project we are asking mentors and students to complete an online questionnaire about their experience and values (which I designed in our online community tool). The data from the questionnaire (tab-delimited files) are imported into the matching software. The application then calculates a matching mark for all the mentor-mentee combinations. The more similar values and experience mentor and student have, the higher the marks. Marks are shown in the grid (click picture to see a larger version).
The next step in the process is manual. My colleague and I decide which mentor goes with which student by clicking on the marks. The software highlights the mentor and student so they cannot be chosen again. (Only one studefor each mentor and one mentor for each student.) Of course we will choose the highest marks possible. We are doing this bit manually to avoid having the last pairs getting the worst marks. So by choosing ourselves the pairs we will try to balance the scale and be fair. The list of pairs chosen is shown in the bottom of the screen.The whole thing looks simple. The only thing though was the $£%@# grid. I had to draw it! 25x25 = 625 boxes :( one by one!! I had all the resulting matching marks in an array and needed something to display them. The only thing that occurred to me was that grid.... I asked some "experts" (Pastelito, Tiki, JLo¼...) in visual basic, .net, java, etc. how I could draw 625 boxes in one go but got no answer...
The software works so I don't mind the time I spent in each box :P but if you happen to know a shortcut or a better way for doing this feel free to contribute in this blog. If you have no clue, just tell me whatever you are thinking....
-----------
cuando le pregunte a la Chata lo de la grilla me dijo "desconozco joven" :D
Labels:
eMentoring,
software
Posts
