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

Upn | Student | Year | Subject 1 | Subject 2 | Subject 3 | Subject 4 | Subject 5 | Subject 6 | Subject 7 | Subject 8
 | Student 1 | 2012-2013 | 6.09 | 5.19 | 6.57 | 95.77 | 8.04 | 119.58 | 6.08 | 93.44
 | Student 2 | 2012-2013 | 11.35 | 11.3 | 10.99 | 143.11 | 9.19 | 134.42 | 9.98 | 139.55
 | Student 3 | 2012-2013 | 8.82 | 8.53 | 8.56 | 116.05 | 7.65 | 106.57 | 7.46 | 104.14
 | Student 4 | 2012-2013 | 10.1 | 10.09 | 11.39 | 127.94 | 11.1 | 145 | 10.43 | 139.85
 | Student 5 | 2012-2013 | 9.23 | 10.09 | 9.51 | 123.2 | 8.92 | 129.82 | 7.54 | 109.55
 | Student 6 | 2013-2014 | 9.57 | 9.95 | 8.85 | 124.36 | 8.85 | 125.78 | 8.88 | 122.99
 | Student 7 | 2013-2014 | 8.95 | 9.95 | 9.32 | 119.29 | 8.16 | 117.07 | 9.12 | 126.62
 | Student 8 | 2013-2014 | 7.13 | 6.67 | 7.47 | 105.43 | 6.87 | 102.42 | 7.13 | 106.58
 | Student 9 | 2013-2014 | 8.05 | 8.73 | 9.21 | 110.88 | 8.31 | 118.93 | 8.68 | 121.2
 | Student 10 | 2013-2014 | 7.74 | 6.97 | 6.96 | 112.54 | 7.73 | 117.67 | 7.7 | 115.24
 | Student 11 | 2014-2015 | 8.15 | 7.19 | 6.57 | 114.72 | 7.79 | 115.97 | 8.21 | 119.29
 | Student 12 | 2014-2015 | 8.47 | 8.36 | 8.83 | 115.71 | 7.54 | 108.84 | 6.47 | 94.89
 | Student 13 | 2014-2015 | 8.62 | 8.99 | 4 | 119.2 | 8.31 | 123.71 | 6.07 | 93.64
 | Student 14 | 2014-2015 | 9.96 | 9.61 | 9.53 | 125.26 | 8.51 | 116.94 | 8.31 | 112.77
 | Student 15 | 2014-2015 | 7.79 | 7.96 | 8.07 | 109.55 | 9.45 | 136.54 | 8.49 | 120.32
 | Student 16 | 2015-2016 | 11.41 | 10.48 | 11.05 | 142.37 | 8.66 | 124.41 | 8.94 | 124.86
 | Student 17 | 2015-2016 | 11.03 | 11.16 | 10.31 | 135.42 | 9.43 | 130.45 | 9.88 | 132.03
 | Student 18 | 2015-2016 | 5.84 | 4.85 | 6.3 | 90.1 | 7.24 | 102.84 | 8.19 | 114.51
 | Student 19 | 2015-2016 | 9.43 | 9.21 | 9.81 | 124.62 | 9.15 | 132.52 | 8.23 | 117.4
 | Student 20 | 2015-2016 | 11.21 | 11.44 | 10.46 | 139.05 | 9.45 | 133.84 | 10.56 | 143.07
 | Student 21 | 2016-2017 | 9.85 | 11.44 | 10.52 | 130.22 | 8.59 | 127.23 | 9.74 | 137.75
 | Student 22 | 2016-2017 | 9.81 | 9.51 | 10.34 | 126.81 | 9.17 | 130.71 | 10.13 | 138.42
 | Student 23 | 2016-2017 | 7.63 | 8.54 | 4 | 103.96 | 7.41 | 101.37 | 5.76 | 81.66
 | Student 24 | 2016-2017 | 8.82 | 8.83 | 9.09 | 118.63 | 7.39 | 106.91 | 7.81 | 111.48
 | Student 25 | 2016-2017 | 8.62 | 8.83 | 10.48 | 116.47 | 9.27 | 132.82 | 9.03 | 125.85
 | Student 26 | 2017-2018 | 10.78 | 10 | 11.33 | 139.61 | 10.27 | 145 | 10.92 | 145
 | Student 27 | 2017-2018 | 10.17 | 10 | 10.61 | 134.34 | 8.48 | 127.6 | 8.79 | 127.84
 | Student 28 | 2017-2018 | 8.81 | 8.95 | 8.87 | 121.47 | 8.91 | 133.02 | 8.22 | 120.26
 | Student 29 | 2017-2018 | 11.77 | 8.95 | 10.69 | 145 | 9.05 | 133.91 | 8.33 | 121.06
 | Student 30 | 2017-2018 | 10.03 | 10.09 | 9.69 | 131.66 | 7.43 | 110.44 | 8.83 | 126.62
 | Student 31 | 2018-2019 | 11.26 | 11.02 | 10.87 | 140.56 | 8.59 | 123.31 | 6.86 | 99.63
 | Student 32 | 2018-2019 | 8.12 | 7.76 | 8.45 | 108.94 | 8.54 | 117.67 | 8.63 | 117.37
 | Student 33 | 2018-2019 | 11.09 | 11.44 | 10.24 | 135.11 | 8.73 | 119.32 | 9.14 | 122.21
 | Student 34 | 2018-2019 | 11.45 | 11.44 | 10.62 | 139.74 | 9.47 | 131.3 | 10.33 | 138.02
 | Student 35 | 2019-2020 | 7.82 | 7.11 | 7.97 | 105.43 | 8.73 | 119.43 | 7.46 | 101.93
 | Student 36 | 2019-2020 | 6.33 | 4.95 | 6.56 | 98.41 | 7.56 | 113.36 | 8.09 | 118.3
 | Student 37 | 2019-2020 | 9.67 | 4.95 | 10.4 | 130.44 | 7.75 | 118.22 | 10.47 | 145
 | Student 38 | 2019-2020 | 10.2 | 4.95 | 9.2 | 129.85 | 9.64 | 136.54 | 9.8 | 133.94
 | Student 39 | 2019-2020 | 8.52 | 7.66 | 9.22 | 116.79 | 7.56 | 110.75 | 8.52 | 121.26
 | Student 40 | 2019-2020 | 10.31 | 10.28 | 10.42 | 132.86 | 10.32 | 145 | 10.78 | 145
 | Student 41 | 2020-2021 | 9.73 | 9.62 | 10.14 | 131.26 | 8.92 | 135.22 | 6.77 | 104.81
 | Student 42 | 2020-2021 | 11.93 | 11.89 | 11.4 | 143.8 | 10.6 | 145 | 10.07 | 134.79
 | Student 43 | 2020-2021 | 8.53 | 11.89 | 7.86 | 119.88 | 7.22 | 110.59 | 8.21 | 121.57
 | Student 44 | 2020-2021 | 5.76 | 11.89 | 8.72 | 87.24 | 6.88 | 94.24 | 4.31 | 64.67
 | Student 45 | 2020-2021 | 10.47 | 10.48 | 9.82 | 134.26 | 8.89 | 129.01 | 9.55 | 133.27
 | Student 46 | 2021-2022 | 10.1 | 10.28 | 10.07 | 128.64 | 8.39 | 118.48 | 8.4 | 116.45
 | Student 47 | 2021-2022 | 6.72 | 6.45 | 6.99 | 105.11 | 6.53 | 103.3 | 6.83 | 107.17
 | Student 48 | 2021-2022 | 7.42 | 7.4 | 7.48 | 114.82 | 7.2 | 117.95 | 7.04 | 114.08
 | Student 49 | 2021-2022 | 6.43 | 6 | 6.58 | 107.28 | 6.97 | 117.83 | 3.65 | 75.71
 | Student 50 | 2021-2022 | 7.28 | 6.8 | 7.48 | 113.65 | 6.8 | 112.94 | 6.67 | 109.77