first of all, I would suggest creating a Month field in your data model, you probably need this anyway and some functions don't take calculated dimensions.
Then I would suggest that you look into avg(), stdev() functions, and I believe something like sqr(stdev(Point)) should give you variance.
Please find attached a rough sample of how I would start with creating some pivot tables for the numbers you want to calculate and for how I would calculate the normalized points. I am not sure how you want to transform these into your levels AA, BA, BB etc.
Before trying to design the scorecard, I would suggest to first concentrate on calculating the numbers, the more design part should be done if we've mastered the base part.
Hope this helps,
survey2.qvw 1.0 MB