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

Upn | Student | Year | Subject 1 | Subject 2 | Subject 3 | Subject 4 | Subject 5 | Subject 6 | Subject 7 | Subject 8
 | Student 1 | 2015-2016 | 10.78 | 11.02 | 11.17 | 103.7 | 11.19 | 112.21 | 10.4 | 100.95
 | Student 2 | 2015-2016 | 13.31 | 12.59 | 13.29 | 123.8 | 12.17 | 121.24 | 10.72 | 101.24
 | Student 3 | 2015-2016 | 11.67 | 12.2 | 11.07 | 114.46 | 13.09 | 141.98 | 11.72 | 120.6
 | Student 4 | 2015-2016 | 11.99 | 11.36 | 12.49 | 112.99 | 9.67 | 89.13 | 11.04 | 106.65
 | Student 5 | 2015-2016 | 14 | 12.49 | 14 | 134.77 | 13.59 | 145 | 16 | 145
 | Student 6 | 2016-2017 | 12.72 | 12.2 | 12.33 | 124.02 | 11.87 | 125.6 | 11.67 | 120.04
 | Student 7 | 2016-2017 | 14.21 | 12.9 | 16 | 131.78 | 16 | 145 | 14.22 | 143.3
 | Student 8 | 2016-2017 | 12.76 | 12.29 | 12.79 | 121.66 | 12.92 | 135.55 | 10.99 | 108.28
 | Student 9 | 2016-2017 | 12.58 | 12.39 | 13.43 | 116.97 | 11.05 | 105.67 | 11.51 | 110.4
 | Student 10 | 2016-2017 | 13.75 | 12.59 | 14.57 | 129.09 | 14.16 | 145 | 14.67 | 145
 | Student 11 | 2017-2018 | 11.79 | 12.1 | 12.56 | 116.35 | 10.3 | 105.31 | 10.56 | 107.58
 | Student 12 | 2017-2018 | 11.74 | 11.92 | 11.55 | 109.71 | 10.78 | 102.69 | 10.51 | 98.82
 | Student 13 | 2017-2018 | 11.52 | 11.89 | 10.47 | 110.49 | 10.36 | 101.12 | 9.81 | 94.1
 | Student 14 | 2017-2018 | 12.6 | 12.1 | 12.59 | 119.91 | 10.69 | 105.07 | 11.78 | 117.35
 | Student 15 | 2017-2018 | 11.67 | 12.2 | 11.07 | 114.46 | 13.09 | 141.98 | 11.72 | 120.6
 | Student 16 | 2018-2019 | 11.09 | 11.44 | 11.03 | 104 | 11.54 | 113.27 | 10.1 | 94.22
 | Student 17 | 2018-2019 | 11.09 | 10.99 | 11.08 | 108.9 | 10.14 | 101.64 | 10.69 | 107.75
 | Student 18 | 2018-2019 | 12.59 | 12.29 | 12.28 | 121.47 | 12.33 | 129.67 | 13.25 | 137.3
 | Student 19 | 2018-2019 | 11.7 | 12.01 | 11.72 | 114.27 | 11.12 | 114.53 | 10.75 | 108.29
 | Student 20 | 2019-2020 | 11.21 | 11.3 | 10.6 | 109.17 | 10.11 | 99.96 | 10.31 | 102.06
 | Student 21 | 2019-2020 | 12.36 | 12.39 | 12.06 | 115.74 | 14.21 | 145 | 12.67 | 125.42
 | Student 22 | 2019-2020 | 13.41 | 12.69 | 13.58 | 132.83 | 12.31 | 135.26 | 10.75 | 112.32
 | Student 23 | 2019-2020 | 12.52 | 12.79 | 11.66 | 117.11 | 10.69 | 101.96 | 11.89 | 115.9
 | Student 24 | 2019-2020 | 11.47 | 11.18 | 10.81 | 109.9 | 12.22 | 126.02 | 11.37 | 112.7
 | Student 25 | 2019-2020 | 12.67 | 12.79 | 12.79 | 117.58 | 12.64 | 126.92 | 11.71 | 112.53
 | Student 26 | 2020-2021 | 13.81 | 12.79 | 13.79 | 135.95 | 11.94 | 129.5 | 11.13 | 116.35
 | Student 27 | 2020-2021 | 10.52 | 10.84 | 10.06 | 103.36 | 10.69 | 108.46 | 11.25 | 114.11
 | Student 28 | 2020-2021 | 13.52 | 12.39 | 13.06 | 125.36 | 12.1 | 119.81 | 11.85 | 114.39
 | Student 29 | 2020-2021 | 12.29 | 11.64 | 11.97 | 120.17 | 10.81 | 111.28 | 10.78 | 109.43
 | Student 30 | 2020-2021 | 10.75 | 10.75 | 11.44 | 109.14 | 11.62 | 126.57 | 12.12 | 129.31
 | Student 31 | 2021-2022 | 12.96 | 13 | 13.59 | 123.19 | 12.39 | 128.14 | 11.36 | 112.24
 | Student 32 | 2021-2022 | 11.71 | 11.27 | 11.19 | 116.82 | 9.88 | 101.5 | 11.33 | 118.45
 | Student 33 | 2021-2022 | 12.97 | 11.64 | 14.55 | 122.6 | 12.07 | 122.83 | 14.01 | 143.44
 | Student 34 | 2021-2022 | 10.54 | 10.06 | 11.71 | 98.73 | 11.81 | 116.2 | 11.14 | 106.01
 | Student 35 | 2021-2022 | 10.56 | 10.65 | 10.68 | 101.45 | 10.42 | 101.41 | 10.83 | 105.99