Spreadsheet: 779683d1651962680-average-formula-solution-problem-using-lists-test-cohort-tracking-2
Sheet: Group 1

Upn | Student | Year | Subject 1 | Subject 2 | Subject 3 | Subject 4 | Subject 5 | Subject 6 | Subject 7 | Subject 8
 | Student 1 | 2011-2012 | 7.07 | 6.4 | 7.26 | 105.39 | 7.41 | 111.19 | 6.06 | 94.03
 | Student 2 | 2011-2012 | 8.39 | 7.66 | 9.19 | 125.53 | 8.03 | 132.42 | 9.23 | 142.95
 | Student 3 | 2011-2012 | 5.01 | 4.28 | 6.28 | 94.84 | 6.94 | 117.5 | 3.44 | 73.29
 | Student 4 | 2011-2012 | 6.94 | 6.26 | 6.87 | 110.85 | 7.3 | 120.08 | 5.26 | 93.24
 | Student 5 | 2011-2012 | 6.29 | 6.1 | 6.19 | 98.82 | 7.12 | 108 | 6.33 | 97.94
 | Student 6 | 2012-2013 | 7.59 | 6.66 | 7.72 | 112.58 | 7.16 | 111.56 | 7.32 | 112.46
 | Student 7 | 2012-2013 | 7.43 | 7.11 | 8.33 | 110.27 | 8.33 | 127.1 | 9.09 | 132.81
 | Student 8 | 2012-2013 | 6.49 | 6 | 7.03 | 107.73 | 7.42 | 123.57 | 8.68 | 136.12
 | Student 9 | 2012-2013 | 7.95 | 7.25 | 8.58 | 120.01 | 7.87 | 128.37 | 6.88 | 113.08
 | Student 10 | 2012-2013 | 8.41 | 8.95 | 8.07 | 121.48 | 8.4 | 131.48 | 6.15 | 100.34
 | Student 11 | 2013-2014 | 7.51 | 7.6 | 7.09 | 114.21 | 6.57 | 106.83 | 6.34 | 103.74
 | Student 12 | 2013-2014 | 9.04 | 9.72 | 9.66 | 129.19 | 7.71 | 124.44 | 7.88 | 123.61
 | Student 13 | 2013-2014 | 6.6 | 6.15 | 6.59 | 104.69 | 6.15 | 99.04 | 4.39 | 78.49
 | Student 14 | 2013-2014 | 8.05 | 7.51 | 8.7 | 119.7 | 7.21 | 116.75 | 6.86 | 110.8
 | Student 15 | 2013-2014 | 6.32 | 6.1 | 5.38 | 101.53 | 7.94 | 123.57 | 4.56 | 79.84
 | Student 16 | 2014-2015 | 6.82 | 6.4 | 6.28 | 111.7 | 8.61 | 140.93 | 8.12 | 129.74
 | Student 17 | 2014-2015 | 7.29 | 6.32 | 8.19 | 114.28 | 7.96 | 129.8 | 7.8 | 124.13
 | Student 18 | 2014-2015 | 8.81 | 8.62 | 7.75 | 130.95 | 8.45 | 140.96 | 4.54 | 88.32
 | Student 19 | 2014-2015 | 6.55 | 6.74 | 6.41 | 105.32 | 6.95 | 111.91 | 4.69 | 83.63
 | Student 20 | 2014-2015 | 8.94 | 7.87 | 9.56 | 131.48 | 8.35 | 138.49 | 8.35 | 133.64
 | Student 21 | 2015-2016 | 8.58 | 8.24 | 9.3 | 132.12 | 8.65 | 145 | 9.21 | 145
 | Student 22 | 2015-2016 | 5.73 | 5.62 | 6.11 | 99.68 | 7.91 | 128.6 | 7.65 | 122
 | Student 23 | 2015-2016 | 8.66 | 8.62 | 8.22 | 126.93 | 8.33 | 135.13 | 10.13 | 145
 | Student 24 | 2015-2016 | 7.34 | 7.08 | 7.48 | 117.87 | 6.85 | 118.79 | 6.76 | 115.74
 | Student 25 | 2015-2016 | 4.29 | 4.28 | 5.91 | 89.63 | 6.46 | 112.89 | 5.05 | 94.64
 | Student 26 | 2016-2017 | 7.86 | 7.11 | 7.47 | 119.3 | 7.49 | 122.77 | 8.04 | 126.81
 | Student 27 | 2016-2017 | 4.83 | 4.28 | 6.26 | 93.04 | 6.32 | 108.41 | 3.6 | 74.97
 | Student 28 | 2016-2017 | 7.89 | 7.51 | 8.2 | 121.93 | 8.9 | 145 | 8.85 | 139.68
 | Student 29 | 2016-2017 | 7.62 | 7.28 | 7.25 | 121.77 | 6.66 | 118.22 | 5.82 | 106.18
 | Student 30 | 2016-2017 | 5.39 | 5.22 | 6.11 | 99.82 | 7.46 | 127.09 | 6.3 | 109.9
 | Student 31 | 2017-2018 | 9.06 | 8.44 | 10.15 | 128.28 | 7.58 | 121.17 | 7.34 | 115.67
 | Student 32 | 2017-2018 | 7.36 | 6.8 | 7.91 | 108.45 | 8.38 | 125.93 | 6.69 | 102.24
 | Student 33 | 2017-2018 | 9.77 | 10.38 | 9.32 | 130.33 | 8.77 | 130.94 | 7.49 | 111.46
 | Student 34 | 2017-2018 | 9.02 | 8.44 | 9.51 | 127.19 | 7.04 | 112.1 | 7.86 | 121.07
 | Student 35 | 2017-2018 | 8.73 | 7.77 | 9.2 | 121.3 | 7.74 | 117.15 | 7.18 | 108.56
 | Student 36 | 2018-2019 | 8.66 | 8.07 | 8.45 | 124.57 | 8.25 | 130.5 | 9.31 | 139.47
 | Student 37 | 2018-2019 | 6.45 | 5.49 | 7.48 | 107.49 | 6.49 | 110.32 | 5.74 | 100.43
 | Student 38 | 2018-2019 | 8.01 | 8.22 | 6.84 | 120.33 | 7.5 | 122.58 | 6.3 | 105.26
 | Student 39 | 2018-2019 | 6.38 | 5.76 | 6.57 | 110.34 | 6.96 | 122.65 | 4.86 | 94.57
 | Student 40 | 2019-2020 | 8.59 | 7.77 | 9.33 | 120.04 | 7.85 | 120.8 | 8.45 | 125.6
 | Student 41 | 2019-2020 | 7.57 | 7.06 | 6.84 | 112.5 | 6.95 | 111.14 | 6.99 | 110.32
 | Student 42 | 2019-2020 | 7.79 | 8.17 | 6.57 | 118.88 | 7.02 | 118.78 | 7.17 | 118.34
 | Student 43 | 2019-2020 | 7.43 | 7.19 | 6.85 | 110.47 | 6.79 | 107.83 | 6.38 | 101.89
 | Student 44 | 2019-2020 | 6.72 | 5.81 | 7.27 | 102.88 | 7.3 | 113 | 6.9 | 106.62
 | Student 45 | 2019-2020 | 7.32 | 7.77 | 5.53 | 108.7 | 8.34 | 127.55 | 8.42 | 125.48
 | Student 46 | 2020-2021 | 4.66 | 5.22 | 7.24 | 89.22 | 7.4 | 120.13 | 7.2 | 115.29
 | Student 47 | 2020-2021 | 4.89 | 4.78 | 6.98 | 87.51 | 7.32 | 112.89 | 4.94 | 82.9
 | Student 48 | 2020-2021 | 8.51 | 8.07 | 9.53 | 120.62 | 7.48 | 115.18 | 5.72 | 92.37
 | Student 49 | 2020-2021 | 6.69 | 6.87 | 7.37 | 106.06 | 7.57 | 119.6 | 7.59 | 117.8
 | Student 50 | 2020-2021 | 8.62 | 8.07 | 8.96 | 121.42 | 7.92 | 120.91 | 6.58 | 102.41
 | Student 51 | 2021-2022 | 7.58 | 7.92 | 8.46 | 115.46 | 9.12 | 143.88 | 8.82 | 134.6
 | Student 52 | 2021-2022 | 6.72 | 6.45 | 6.99 | 105.11 | 6.53 | 103.3 | 6.83 | 107.17
 | Student 53 | 2021-2022 | 7.42 | 7.4 | 7.48 | 114.82 | 7.2 | 117.95 | 7.04 | 114.08
 | Student 54 | 2021-2022 | 6.43 | 6 | 6.58 | 107.28 | 6.97 | 117.83 | 3.65 | 75.71
 | Student 55 | 2021-2022 | 7.28 | 6.8 | 7.48 | 113.65 | 6.8 | 112.94 | 6.67 | 109.77