Manually analyze Analytics scenarios

[tomca32]

We want to manually test several analytics scenarios and see where are we making mistakes. Note that student and group scores can be seen in multiple places in the app. Student's scores can be seen on the student page as well as on the lesson page and analytics.

Setup

GROUP 1 GROUP 2
Students: A, B, C, D, E Students: F, G, H, I, J
Lessons: 1, 2, 3 Lessons: 1, 2, 3

"Graded" means a Student has recorded at least 1 score (means child is "present")

SCENARIO #1:

GROUP 1 has Lesson 1 with all five students present (A, B, C, D, E)
The "score" for the day should be:

• all of A's scores divided by the number of skills she was graded on
• plus all of B's scores divided by the number of skills she was graded on
• plus all of C's scores divided by the number of skills he was graded on
• plus all of D's scores divided by the number of skills he was graded on
• plus all of E's scores divided by the number of skills he was graded on

divided by the # of students graded that day (5)

SCENARIO #2:

GROUP 1 has Lesson 2 but Student B has moved from GROUP 1 to GROUP 2

• the "score" for GROUP 1, Lesson 1 should not change
• the "score" for GROUP 2, Lesson 1 should not change

The "score" for GROUP 1, Lesson 2 should be:

• all of A's scores divided by the number of skills she was graded on
• plus all of C's scores divided by the number of skills he was graded on
• plus all of D's scores divided by the number of skills he was graded on
• plus all of E's scores divided by the number of skills he was graded on

divided by the # of students graded that day (4)

The "score" for GROUP 2, Lesson 2 should be divided by the # of students present (6)

SCENARIO #3:

Student B's data graphs for each of the 7 skills should reflect her scores in GROUP 1, Lesson 1 and thereafter (starting with Lesson 2) be the scores from GROUP 2
(In other words, Student B keeps all her scores regardless of which group she was graded in when looking at graphs only for Student B)

SCENARIO #4:

GROUP 1 has Lesson 3 with these scores:
Student A: ungraded, 1, ungraded, ungraded, ungraded, ungraded, ungraded
Student C: 2, 2, 2, 2, 2, 2, 2
Student D: 3, 3, 3, 3, 3, 3, 3

The average score for each student should be:
Student A: 1
Student C: 2
Student D: 3

GROUP 1, Lesson 3 has a score of: 2 (1+ 2+ 3)/3

SCENARIO #5:

GROUP 2 has Lesson 3 with these scores:
Student B: ungraded, 1, ungraded, ungraded, ungraded, ungraded, ungraded
Student F: 1, 1, ungraded, 1, 2, 2, 1
Student G: 1, 1, ungraded, 2, 2, 2, 2
Student H: no grades
Student I: no grades
Student J: no grades

The average score for each student should be:
Student B: 1 (1)/1
Student F: 1.33 (1+1+1+2+2+1)/6
Student G: 1.67 (1+1+2+2+2+2)/6
Student H:
Student I:
Student J:

GROUP 2, Lesson 3 has a score of: 1.33 (1+1.33+1.67)/3