With almost universal availability of Internet and the availability of reliable on-line productivity tools, such as Google Docs, individuals as well as companies are switching over to Cloud Computing. In this blog I will post items of interest to my colleagues/patrons/clients.
Sunday, January 6, 2013
yogi_Compute Student Score For Each Quiz And Then SumUp The Scores For All The Quizes For Each Student
user Neal Boocock said:(http://productforums.google.com/forum/?zx=6xwd73m1l93e#!category-topic/docs/spreadsheets/xAxD8urYDqo) Need help with an array formula Hello,
Here is my scenario, I have a quiz that is administered through a google form and produces results to a quiz results page. Also in the quiz results page is the quiz key. I am attempting to grade the quiz with an array formula on my grade book where I need to count the number of times a students answer is the same as the key and then multiply the count by 10 because each correct answer is worth 10points.
Currently I can get the formula to work when "I" specify which rows to compare to the key, but I need the formula to do a dynamic match based on the students name and then calculate grade based on the row matched.
Currently I am using the formula below in my grade book but I have to change the row reference depending on the order in which the students complete their quiz, for example row 3 in the grade book may be student#2, but in the quiz results student#1 may be in row 6 depending on the order in which student#1 finished, and then on the next quiz the students may finish in a different order, so I have to change all the references again.