Spreadsheet: 779665d1651962680-average-formula-problem-using-lists-test-cohort-tracking-2
Sheet: Group 4

Upn | Student | Year | Subject 1 | Subject 2 | Subject 3 | Subject 4 | Subject 5 | Subject 6 | Subject 7 | Subject 8
 | Student 1 | 2014-2015 | 9.76 | 9.4 | 9.65 | 107.09 | 9.6 | 107 | 7.92 | 86.14
 | Student 2 | 2014-2015 | 10.86 | 11.02 | 10.97 | 113.44 | 10.12 | 108.66 | 9.87 | 104.89
 | Student 3 | 2014-2015 | 11.32 | 11.45 | 10.51 | 122.64 | 9.52 | 107.91 | 9.94 | 112.32
 | Student 4 | 2014-2015 | 11.87 | 12.39 | 10.52 | 126.58 | 10.21 | 115.96 | 10.9 | 122.52
 | Student 5 | 2014-2015 | 11.29 | 11.27 | 10.69 | 122.09 | 9.97 | 113.84 | 9.65 | 108.42
 | Student 6 | 2015-2016 | 10.36 | 10.37 | 9.74 | 113.02 | 9.68 | 108.7 | 9.32 | 103.66
 | Student 7 | 2015-2016 | 11.36 | 9.76 | 11.48 | 118.28 | 11.97 | 135.08 | 12.65 | 138.91
 | Student 8 | 2015-2016 | 12.09 | 12.29 | 12.9 | 132.62 | 10.43 | 125.29 | 10.09 | 118.06
 | Student 9 | 2015-2016 | 11.78 | 12.01 | 11.63 | 122.03 | 10.23 | 110.2 | 11.09 | 119.89
 | Student 10 | 2015-2016 | 11.92 | 11.82 | 10.66 | 125.5 | 10.87 | 122.96 | 11.93 | 133.06
 | Student 11 | 2016-2017 | 12.33 | 12.59 | 10.96 | 126.12 | 10.26 | 109.45 | 10.48 | 111.29
 | Student 12 | 2016-2017 | 12.4 | 12.1 | 12.16 | 134.96 | 11.21 | 135.37 | 10.62 | 123.72
 | Student 13 | 2016-2017 | 8.79 | 9.45 | 9.07 | 99.04 | 10.01 | 114.24 | 9.42 | 105.53
 | Student 14 | 2016-2017 | 11.53 | 10.9 | 12.82 | 118.94 | 11.25 | 123.46 | 10.74 | 114.58
 | Student 15 | 2016-2017 | 9.99 | 9.51 | 7.21 | 110.78 | 9.01 | 100.96 | 5.54 | 59.44
 | Student 16 | 2017-2018 | 9.84 | 9.71 | 10.07 | 112.41 | 11.02 | 134.27 | 10.58 | 124.41
 | Student 17 | 2017-2018 | 12.27 | 12.59 | 12.21 | 128.6 | 10.57 | 118.52 | 10.44 | 114.79
 | Student 18 | 2017-2018 | 8.95 | 12.59 | 10.69 | 102.98 | 9.04 | 103.99 | 9.08 | 104.61
 | Student 19 | 2017-2018 | 10.74 | 11.02 | 10.31 | 119.62 | 9.65 | 113.05 | 9.68 | 112.23
 | Student 20 | 2017-2018 | 11.12 | 10.09 | 12.82 | 117.48 | 10.57 | 117.56 | 11.11 | 122.14
 | Student 21 | 2018-2019 | 11.14 | 11.3 | 11.25 | 115.54 | 10.86 | 118.48 | 11.21 | 120.47
 | Student 22 | 2018-2019 | 10.51 | 10.48 | 9.63 | 112.45 | 9.66 | 105.5 | 9.84 | 107.46
 | Student 23 | 2018-2019 | 11.72 | 11.45 | 10.59 | 123.23 | 10.5 | 117.03 | 11.12 | 122.56
 | Student 24 | 2018-2019 | 12.07 | 12.49 | 12.37 | 131.41 | 11.31 | 136.21 | 10.41 | 120.54
 | Student 25 | 2019-2020 | 12.84 | 12.59 | 11.84 | 137.29 | 11.03 | 130.32 | 10.63 | 121.58
 | Student 26 | 2019-2020 | 12.35 | 10.99 | 12.68 | 129.6 | 11.6 | 133.51 | 11.81 | 131.73
 | Student 27 | 2019-2020 | 11.26 | 10.99 | 11.53 | 120.28 | 10.31 | 115.98 | 9.92 | 109.65
 | Student 28 | 2019-2020 | 11.13 | 11.59 | 10.56 | 120.6 | 10.98 | 128.2 | 11.66 | 132.89
 | Student 29 | 2019-2020 | 12.1 | 12.1 | 12.26 | 126.42 | 10.84 | 121.06 | 10.85 | 118.81
 | Student 30 | 2019-2020 | 8.84 | 8.44 | 10.51 | 99.39 | 9.61 | 107.97 | 9.79 | 109.72
 | Student 31 | 2020-2021 | 11.22 | 10.99 | 11.18 | 117.08 | 12.7 | 145 | 12.07 | 132.07
 | Student 32 | 2020-2021 | 10.95 | 11.44 | 10.83 | 120.38 | 10.65 | 125.49 | 10.91 | 125.67
 | Student 33 | 2020-2021 | 11.2 | 10.8 | 12.12 | 119.7 | 9.61 | 105.96 | 10.17 | 112.71
 | Student 34 | 2020-2021 | 11.38 | 10.9 | 11.98 | 123.95 | 11.37 | 135.07 | 11 | 126.2
 | Student 35 | 2020-2021 | 9.37 | 9.21 | 9.43 | 104.68 | 10.33 | 118.98 | 10.35 | 117.2
 | Student 36 | 2021-2022 | 10.02 | 10.03 | 10.83 | 110.65 | 11.59 | 136.92 | 10.46 | 118.54
 | Student 37 | 2021-2022 | 11.22 | 11.59 | 11.98 | 122.72 | 10.22 | 119.31 | 10.73 | 123.23
 | Student 38 | 2021-2022 | 10.42 | 10.56 | 10.26 | 116.56 | 9.72 | 114.13 | 9.23 | 106.62
 | Student 39 | 2021-2022 | 10.25 | 10.18 | 8.69 | 115.06 | 10.18 | 120.42 | 9.84 | 114.08
 | Student 40 | 2021-2022 | 11.98 | 11.36 | 10.82 | 128.22 | 9.58 | 108.19 | 10.21 | 114.89