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.
4H Evaluation Orale
4H Evaluation Orale
docs.google.com
Shared publiclyView activity