idno h1 h2 h3 h4 e1 hwtotal hwscore mtscore mtgrade
0235 34 44 48 55 85 181 83 84 B
0699 35 56 46 95 137 63 76 C+
0881 19 95 19 9 45 F
1331 29 50 44 55 99 178 81 89 A
1448 35 54 47 55 92 191 87 89 A
1755 38 57 50 70 100 215 98 99 A
1833 39 54 35 48 100 176 80 89 A
2247 38 57 50 69 96 214 98 97 A
2874 36 53 43 46 95 178 81 87 B+
2965 34 47 44 85 125 57 69 C
2998 38 57 48 72 100 215 98 99 A
3222 29 46 45 50 85 170 78 81 B
3251 39 56 50 70 99 215 98 99 A
3418 38 57 50 70 100 215 98 99 A
3521 34 51 45 49 100 179 82 90 A
3924 35 52 48 61 96 196 89 92 A
4837 35 53 45 54 95 187 85 89 A
4848 39 55 48 62 100 204 93 96 A
4909 29 53 48 63 43 193 88 69 C
5173 28 51 43 52 98 174 79 87 B+
5237 36 50 45 48 100 179 82 90 A
5316 36 56 45 53 95 190 87 90 A
5331 37 56 50 70 100 213 97 98 A
5463 36 52 44 61 100 193 88 93 A
6243 37 52 40 92 129 59 73 C
6500 37 51 43 100 131 60 77 C+
7114 31 41 99 72 33 61 D
7537 35 48 48 94 131 60 74 C
7875 38 56 50 144 66 38 F
8083 25 79 25 11 40 F
8249 35 55 48 64 88 202 92 90 A
8667 31 53 46 90 130 59 72 C
9283 35 49 48 53 88 185 84 86 B+
9482 34 54 47 63 99 198 90 94 A
9490 39 55 49 66 95 209 95 95 A
9672 36 56 45 63 95 200 91 93 A
possible 40 57 50 72 100 219 100 100

Here's the key: idno is the last four digits of your social security number, hwtotal is the sum of your homework scores, hwscore is the percentage on your homework, and mtscore is your midterm score computed by the formula mtscore = (hwscore*.175+e1*.13)/.305.  Notice that the grades for those who turned in all the homework are usually a letter grade higher than for those who missed a homework.