need help to do a bot to manipulate my raw data. The 5 columns of text feedback have to be converted corresponding grade (e.g., strongly agree = 5, disagree = 4, neutral = 3, disagree = 2.
strongly disagree = 1) . Aftwerwhich, i need to get the average score per line item . Then include in new worksheet the average scores and the comments (free-hand) . How do i go about it?
SAMPLE RAW DATA:
|Staff||Tidiness||Good working||Timeliness||Preparedness||Overall services provided by the TE is||Any comments or suggestions?|
|adc||Strongly Agree||Strongly Agree||Agree||Strongly Agree||Very good||good support, responsive and full support.|
|def||Agree||Strongly Agree||Agree||Strongly Agree||Very good||very responsible in discharging her duties and is very helpful to students. There is excellent equipment support for testing of zumo components.|
|ghi||Strongly Agree||Strongly Agree||Strongly Agree||Neutral||Very good||Very good services provided|
|khi||Strongly Disagree||Strongly Agree||Strongly Agree||Strongly Agree||Very good||Very good services provided & very helpful|
|pta||Strongly Agree||Strongly Agree||Strongly Agree||Strongly Agree||Very good||Very helpful, Great!|
|Staff||Supervisor||Student feedback||Lecturer feedback||combined (Student 2/3, Lect 1/3)||Comments|
|def||sggg||4.86||4.98||4.90||V good thank you!|
|wta||gtyth||4.6||4.76||4.65||Always there to assist us|
|khf||ntyjj||4.59||4.48||4.55||Ms Chee guide us on our project|
|jgd||rtyey||4.67||4.73||4.69||She has been very helpful and nice|
thanks in anticipation!