Dear GAFE friends,

I am trying to create an assessment form for evaluating students on their ability to answer questions in French. This is what I have so far:
https://docs.google.com/forms/d/1c9ymHsWztL3Z0wk7ofglhkRx8t2_RsoTWvIl6HStsfI/viewform

I will be asking each student 10 random questions, individually. 

My question to you is, is there a mathematical way to take the answers from the associated sheet to create an overall average from all of the 10 questions? For example, if Student 1 had four level 1 answers, two level 2 answers, three level 3 answers, and one level 4 answer, is there a way to get a quick average of his answers for an overall mark?

Thank you ahead of time for helping me try to figure this out.
Shared publiclyView activity