How to automatically convert stand evaluation responses in numbers?

I recently took over for a colleague aggregating medical resident evaluations. Doctors fill out a form with a long list of five repeated text options about the residents performance. That data gets aggregated on a OneNote spreadsheet. Up until now, the previous person was manually reviewing each entry, assigning at a number, and then calculating an average. How do I automate this?