Friday, November 2, 2012

yogi_Compute Numeric Part Of Individual Self-Assessment Scores And Compute Row By Row Average

                                           Google Spreadsheet   Post  #850
              Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI    Nov 02, 2012
user RichMc09 said : (!mydiscussions/docs/7NtORdGi3Zs)
Turn Multiple Choice Answers into a Number Value.
I'm trying to check an assessment tool for teachers and school to indicate how ready they are to implement systematic changes. 

I created a form using multiple choice answers, but when I examine the spreadsheet which collects the answers, I get the complete text of the multiple choice. 

Is there a simple way to get the answers to show up in the spread sheet as a number value, (i.e. 1, 2, 3 or 4) based on their selection rather than the text from the form. 

Thanks to anyone who can help. 

following is a solution to the problem: