Hello, I have created a small survey to collect peer ratings from students.
As the image above shows:
Q1: Asks a student to select his/her name out of 5 students - as the Rater:
Student 1; Student 2; Student 3; Student 4; Student 5.
Q1.1: The selected student (e.g., Student 1) will rate Student 2, Student 3, Student 4 and Student 5, based on 4 likert-scaled questions:
-- Student contributed meaningfully to tasks: 0, 1, 2, 3, 4.
-- Student did their share of the work: 0, 1, 2, 3, 4.
-- Student paid much attention: 0, 1, 2, 3, 4.
-- Student was willing to listen: 0, 1, 2, 3, 4.
At the end of the survey, I need to calculate the average score each student received over all 4 questions by all 4 of his/peers. So for example, if Student 1 is rated 4 across all questions, by each of his/her 4 peers, we should have a total score, calculated as follows:
Student 1 Ratings: (Student 2: (4*4) = 16) + (Student 3: (4*4) = 16) + (Student 4: (4*4) = 16) = 48. Average = (48/3) = 16
I have been trying to export the data to Excel, but it takes so much time to clean it up.
Is it possible to calculate the total scores and average for each rated student in Qualtrics?
I am attaching a copy of the survey, in case it is helpful:
PeerRating.qsf
Uploaded Oct 13, 2020261.21 KB
Thanks in advance for your assistance, PS
Calculating Totals/Averages
Sign up
Already have an account? Login
Welcome! To join the Qualtrics Experience Community, log in with your existing Qualtrics credentials below.
Confirm your username, share a bit about yourself, Once your account has been approved by our admins then you're ready to explore and connect .
Free trial account? No problem. Log in with your trial credentials to join.
No free trial account? No problem! Register here
Already a member? Hi and welcome back! We're glad you're here 🙂
You will see the Qualtrics login page briefly before being taken to the Experience Community
Login with Qualtrics
Welcome! To join the Qualtrics Experience Community, log in with your existing Qualtrics credentials below.
Confirm your username, share a bit about yourself, Once your account has been approved by our admins then you're ready to explore and connect .
Free trial account? No problem. Log in with your trial credentials to join. No free trial account? No problem! Register here
Already a member? Hi and welcome back! We're glad you're here 🙂
You will see the Qualtrics login page briefly before being taken to the Experience Community
Login to the Community
Welcome! To join the Qualtrics Experience Community, log in with your existing Qualtrics credentials below.
Confirm your username, share a bit about yourself, Once your account has been approved by our admins then you're ready to explore and connect .
Free trial account? No problem. Log in with your trial credentials to join.
No free trial account? No problem! Register here
Already a member? Hi and welcome back! We're glad you're here 🙂
You will see the Qualtrics login page briefly before being taken to the Experience Community
Login with Qualtrics
Welcome! To join the Qualtrics Experience Community, log in with your existing Qualtrics credentials below.
Confirm your username, share a bit about yourself, Once your account has been approved by our admins then you're ready to explore and connect .
Free trial account? No problem. Log in with your trial credentials to join. No free trial account? No problem! Register here
Already a member? Hi and welcome back! We're glad you're here 🙂
You will see the Qualtrics login page briefly before being taken to the Experience Community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
