Spreadsheet: 477914d1472568688-tough-problem-how-can-i-average-different-columns-based-on-student-names-monthly-mastery-tracker_example
Sheet: Class_Log

Class | Month | Year | Student Name | OSIS # | Score
NHM | September | 2016 | Student x | 1 | 4
NHM | September | 2016 | Student y | 2 | 5
NHM | September | 2016 | Student z | 3 | 6
NHM | October | 2016 | Student x | 1 | 7
NHM | October | 2016 | Student y | 2 | 4
NHM | October | 2016 | Student z | 3 | 2
NHM | November | 2016 | Student x | 1 | 3
NHM | November | 2016 | Student y | 2 | 8
NHM | November | 2016 | Student z | 3 | 9
NHM | December | 2016 | Student x | 1 | 0
NHM | December | 2016 | Student y | 2 | 0
NHM | December | 2016 | Student z | 3 | 1
NHM | January | 2017 | Student x | 1 | 11
NHM | January | 2017 | Student y | 2 | 2
NHM | January | 2017 | Student z | 3 | 45
NHM | February | 2017 | Student x | 1 | 4
NHM | February | 2017 | Student y | 2 | 5
NHM | February | 2017 | Student z | 3 | 6
NHM | March | 2017 | Student x | 1 | 2
NHM | March | 2017 | Student y | 2 | 87
NHM | March | 2017 | Student z | 3 | 5
NHM | April | 2017 | Student x | 1 | 33
NHM | April | 2017 | Student y | 2 | 35
NHM | April | 2017 | Student z | 3 | 64
NHM | May | 2017 | Student x | 1 | 1
NHM | May | 2017 | Student y | 2 | 3
NHM | May | 2017 | Student z | 3 | 2
NHM | June | 2017 | Student x | 1 | 8
NHM | June | 2017 | Student y | 2 | 9
NHM | June | 2017 | Student z | 3 | 3
Spelling | September | 2016 | Student x | 1 | 7
Spelling | September | 2016 | Student y | 2 | 8
Spelling | September | 2016 | Student z | 3 | 9
Spelling | October | 2016 | Student x | 1 | 1
Spelling | October | 2016 | Student y | 2 | 1
Spelling | October | 2016 | Student z | 3 | 1
Spelling | November | 2016 | Student x | 1 | 2
Spelling | November | 2016 | Student y | 2 | 2
Spelling | November | 2016 | Student z | 3 | 2
Spelling | December | 2016 | Student x | 1 | 3
Spelling | December | 2016 | Student y | 2 | 3
Spelling | December | 2016 | Student z | 3 | 3
Spelling | January | 2017 | Student x | 1 | 4
Spelling | January | 2017 | Student y | 2 | 4
Spelling | January | 2017 | Student z | 3 | 4
Spelling | February | 2017 | Student x | 1 | 5
Spelling | February | 2017 | Student y | 2 | 5
Spelling | February | 2017 | Student z | 3 | 5
Spelling | March | 2017 | Student x | 1 | 6
Spelling | March | 2017 | Student y | 2 | 6
Spelling | March | 2017 | Student z | 3 | 6
Spelling | April | 2017 | Student x | 1 | 7
Spelling | April | 2017 | Student y | 2 | 7
Spelling | April | 2017 | Student z | 3 | 7
Spelling | May | 2017 | Student x | 1 | 8
Spelling | May | 2017 | Student y | 2 | 8
Spelling | May | 2017 | Student z | 3 | 8
Spelling | June | 2017 | Student x | 1 | 9
Spelling | June | 2017 | Student y | 2 | 9
Spelling | June | 2017 | Student z | 3 | 9
NS | September | 2016 | Student x | 1 | 10
NS | September | 2016 | Student y | 2 | 11
NS | September | 2016 | Student z | 3 | 12
NS | October | 2016 | Student x | 1 | 10
NS | October | 2016 | Student y | 2 | 12
NS | October | 2016 | Student z | 3 | 11
NS | November | 2016 | Student x | 1 | 14
NS | November | 2016 | Student y | 2 | 12
NS | November | 2016 | Student z | 3 | 12
NS | December | 2016 | Student x | 1 | 11
NS | December | 2016 | Student y | 2 | 1
NS | December | 2016 | Student z | 3 | 1
NS | January | 2017 | Student x | 1 | 54
NS | January | 2017 | Student y | 2 | 23
NS | January | 2017 | Student z | 3 | 12
NS | February | 2017 | Student x | 1 | 2
NS | February | 2017 | Student y | 2 | 5
NS | February | 2017 | Student z | 3 | 4
NS | March | 2017 | Student x | 1 | 12
NS | March | 2017 | Student y | 2 | 12
NS | March | 2017 | Student z | 3 | 12
NS | April | 2017 | Student x | 1 | 15
NS | April | 2017 | Student y | 2 | 12
NS | April | 2017 | Student z | 3 | 43
NS | May | 2017 | Student x | 1 | 22
NS | May | 2017 | Student y | 2 | 23
NS | May | 2017 | Student z | 3 | 24
NS | June | 2017 | Student x | 1 | 109
NS | June | 2017 | Student y | 2 | 19
NS | June | 2017 | Student z | 3 | 19