Spreadsheet: 148533d1333458758-if-nested-statements-johnson-grade-book3
Sheet: Sheet1

Column1 | Column2 | Column3 | Column4 | Column5 | Column6 | Column7 | Column8 | Column9 | Column10 | Column11 | Column12 | Column13 | Column14 | Column15 | Column16 | Column17 | Column18 | Column19 | Column20 | Column21 | Column22 | Column23 | Column24 | Column25 | Column26 | Column27 | Column28 | Column29 | Column30 | Column31 | Column32 | Column33 | Column34 | Column35 | Column36 | Column37 | Column38 | [NAME] | Column40 | Column41 | Column42 | Column43 | Column44 | Column45 | Column46 | Column47 | Column48 | Column49 | Column50 | Column51 | Column52 | Column53 | Column54 | Column55 | Column56 | Column57 | Column58 | Column59 | Column60 | Column61 | Column62 | Column63 | Column64 | Column65 | Column66 | Column67 | Column68 | Column69 | Column70 | Column71 | Column72 | Column73 | Column74 | Column75 | Column76 | Column77 | Column78 | Column79 | Column80 | Column81 | Column82 | Column83 | Column84 | Column85 | Column86 | Column87 | Column88 | Column89 | Column90 | Column91 | Column92 | Column93 | Column94 | Column95 | Column96 | Column97 | Column98 | Column99 | Column100 | Column101 | Column102 | Column103 | Column104 | Column105 | Column106 | Column107 | Column108 | Column109 | Column110 | Column111 | Column112 | Column113 | Column114 | Column115 | Column116 | Column117 | Column118 | Column119 | Column120 | Column121 | Column122 | Column123 | Column124 | Column125 | Column126 | Column127 | Column128 | Column129 | Column130 | Column131 | Column132 | Column133 | Column134 | Column135 | Column136 | Column137 | Column138 | Column139 | Column140 | Column141 | Column142 | Column143 | Column144 | Column145 | Column146 | Column147 | Column148 | Column149 | Column150 | Column151 | Column152 | Column153 | Column154 | Column155 | Column156 | Column157 | Column158 | Column159 | Column160 | Column161 | Column162 | Column163 | Column164 | Column165 | Column166 | Column167 | Column168 | Column169 | Column170 | Column171 | Column172 | Column173 | [NAME] | Column175 | Column176 | Column177 | Column178 | Column179 | Column180 | Column181 | Column182 | Column183 | Column184 | Column185 | Column186 | Column187 | Column188 | Column189 | Column190 | Column191 | Column192 | Column193 | Column194 | Column195 | Column196 | Column197 | Column198 | Column199 | Column200 | Column201 | Column202 | Column203 | Column204 | Column205 | Column206 | Column207 | Column208 | Column209 | Column210 | Column211 | Column212 | Column213 | Column214 | Column215 | Column216 | Column217 | Column218 | Column219 | Column220 | Column221 | Column222 | Column223 | Column224 | Column225 | Column226 | Column227 | Column228 | Column229 | Column230 | Column231 | Column232 | Column233 | Column234 | Column235 | Column236 | Column237 | Column238 | Column239 | Column240 | Column241 | Column242 | Column243 | Column244 | Column245 | Column246 | Column247 | Column248 | Column249 | Column250 | Column251 | Column252 | Column253 | Column254 | Column255 | Column256
Student | SO1 | SO2 | SO3 | SO4 | SO5 | SO6 | SO7 | SO8 | SO9 | SO10 | SO11 | SO12 | JE1 | JE2 | JE3 | [NAME] | JE5 | JE6 | JE7 | JE8 | JE9 | JE10 | JE11 | [NAME] | GP | T1 | T2 | AE | Score | Grade
[NAME] | 49 | 75 | 68 | 100 | 54 | 75 | 80 | 41 | 75 | 85 | 68 | 81 | 6 | 5 | 9 | 6 | 9 | 9 | 9 | 6 | 5 | 9 | 6 | 9 | 71 | 99 | 85 | 92 | 82.625
[NAME] | 40 | 74 | 67 | 65 | 53 | 74 | 79 | 40 | 74 | 84 | 67 | 80 | 7 | 9 | 6 | 9 | 4 | 6 | 3 | 7 | 9 | 6 | 9 | 4 | 97 | 56 | 97 | 56 | 77.50000000000001
Carol | 39 | 73 | 66 | 87 | 52 | 73 | 78 | 39 | 73 | 83 | 66 | 79 | 9 | 7 | 7 | 7 | 6 | 5 | 7 | 9 | 7 | 7 | 7 | 6 | 73 | 43 | 73 | 43 | 64.39999999999999
[NAME] | 38 | 72 | 65 | 95 | 51 | 72 | 77 | 38 | 72 | 82 | 65 | 78 | 2 | 3 | 4 | 4 | 7 | 7 | 0 | 2 | 3 | 4 | 4 | 7 | 64 | 70 | 64 | 70 | 67.89999999999999
[NAME] | 37 | 71 | 64 | 60 | 50 | 71 | 76 | 37 | 71 | 81 | 64 | 77 | 5 | 4 | 3 | 8 | 5 | 9 | 3 | 5 | 4 | 3 | 8 | 5 | 98 | 67 | 98 | 67 | 79.825
[NAME] | 36 | 70 | 63 | 100 | 49 | 70 | 75 | 36 | 70 | 80 | 63 | 76 | 9 | 7 | 1 | 8 | 8 | 7 | 4 | 9 | 7 | 1 | 8 | 8 | 67 | 98 | 67 | 98 | 77.825
[NAME] | 35 | 69 | 62 | 98 | 48 | 69 | 74 | 35 | 69 | 79 | 62 | 75 | 7 | 5 | 5 | 7 | 2 | 6 | 3 | 7 | 5 | 5 | 7 | 2 | 77 | 64 | 77 | 64 | 70.89999999999999
[NAME] | 34 | 68 | 61 | 85 | 47 | 68 | 73 | 34 | 68 | 78 | 61 | 74 | 4 | 9 | 8 | 5 | 1 | 4 | 0 | 4 | 9 | 8 | 5 | 1 | 81 | 82 | 81 | 82 | 77.225
Ian | 33 | 67 | 60 | 74 | 46 | 67 | 72 | 33 | 67 | 77 | 60 | 73 | 3 | 5 | 7 | 6 | 8 | 3 | 4 | 3 | 5 | 7 | 6 | 8 | 96 | 73 | 96 | 73 | 80.14999999999999
[NAME] | 32 | 66 | 59 | 96 | 45 | 66 | 71 | 32 | 66 | 76 | 59 | 72 | 7 | 4 | 6 | 4 | 9 | 5 | 6 | 7 | 4 | 6 | 4 | 9 | 48 | 99 | 48 | 99 | 69.175
[NAME] | 31 | 65 | 58 | 85 | 44 | 65 | 70 | 31 | 65 | 75 | 58 | 71 | 4 | 5 | 9 | 2 | 6 | 3 | 7 | 4 | 5 | 9 | 2 | 6 | 67 | 73 | 67 | 73 | 68.2
[NAME] | 30 | 64 | 57 | 84 | 43 | 64 | 69 | 30 | 64 | 74 | 57 | 70 | 3 | 4 | 7 | 3 | 4 | 2 | 1 | 3 | 4 | 7 | 3 | 4 | 73 | 67 | 73 | 67 | 68.075
[NAME] | 29 | 63 | 56 | 86 | 42 | 63 | 68 | 29 | 63 | 73 | 56 | 69 | 4 | 3 | 4 | 8 | 7 | 1 | 3 | 4 | 3 | 4 | 8 | 7 | 99 | 48 | 99 | 48 | 72.825
Nick | 28 | 62 | 55 | 82 | 41 | 62 | 67 | 28 | 62 | 72 | 55 | 68 | 8 | 7 | 5 | 9 | 6 | 4 | 4 | 8 | 7 | 5 | 9 | 6 | 73 | 96 | 73 | 96 | 77
Olivia | 27 | 61 | 54 | 83 | 40 | 61 | 66 | 27 | 61 | 71 | 54 | 67 | 4 | 3 | 8 | 6 | 7 | 6 | 1 | 4 | 3 | 8 | 6 | 7 | 85 | 81 | 85 | 81 | 76.67500000000001
[NAME] | 26 | 60 | 53 | 84 | 39 | 60 | 65 | 26 | 60 | 70 | 53 | 66 | 7 | 4 | 3 | 4 | 5 | 8 | 5 | 7 | 4 | 3 | 4 | 5 | 48 | 77 | 48 | 77 | 60.325
[NAME] | 25 | 59 | 52 | 81 | 38 | 59 | 64 | 25 | 59 | 69 | 52 | 65 | 5 | 8 | 4 | 7 | 9 | 4 | 4 | 5 | 8 | 4 | 7 | 9 | 74 | 67 | 74 | 67 | 67.75
Ray | 24 | 58 | 51 | 83 | 37 | 58 | 63 | 24 | 58 | 68 | 51 | 64 | 4 | 3 | 6 | 2 | 3 | 3 | 1 | 4 | 3 | 6 | 2 | 3 | 89 | 98 | 89 | 98 | 81.97500000000001
[NAME] | 23 | 57 | 50 | 70 | 36 | 57 | 62 | 23 | 57 | 67 | 50 | 63 | 7 | 1 | 9 | 1 | 2 | 4 | 3 | 7 | 1 | 9 | 1 | 2 | 69 | 64 | 69 | 64 | 63.35
Travis | 22 | 56 | 49 | 92 | 35 | 56 | 61 | 22 | 56 | 66 | 49 | 62 | 6 | 8 | 7 | 4 | 8 | 9 | 1 | 6 | 8 | 7 | 4 | 8 | 67 | 73 | 67 | 73 | 66.25
Victor | 21 | 55 | 48 | 82 | 34 | 55 | 60 | 21 | 55 | 65 | 48 | 61 | 7 | 3 | 5 | 5 | 7 | 4 | 3 | 7 | 3 | 5 | 5 | 7 | 85 | 97 | 85 | 97 | 79.75
Will | 20 | 54 | 47 | 93 | 33 | 54 | 59 | 20 | 54 | 64 | 47 | 60 | 3 | 1 | 3 | 1 | 5 | 2 | 1 | 3 | 1 | 3 | 1 | 5 | 79 | 71 | 79 | 71 | 68.75