sn = section number m1 = grade on first midterm with 2 points added m2 = grade on first midterm with 1 point added f = grade on final with 2 points added iq = number of correct out of 22 quizes. h = % grade on homework. g1 = (55)[(m1+m2+f)/55] + (15) {iq/18} + (30) (h%/100) where {iq/18}=(iq/18) if iq/18 is less than or equal to one and {iq/18}=1 if iq/18 is greater than one. g2 = grade out of 4.0 g2 PID sn iq h m1 m2 f g1 2.5 20706759 1 12 104 8 7 11 68 4.0 21994239 1 19 110 11 13 20 93 0.0 22480741 1 0 0 0 0 0 0 0.0 22678053 1 4 0 6 0 0 10 2.5 23270977 1 11 112 11 7 13 74 2.0 23526569 1 15 111 7 6 6 65 3.0 24295728 1 15 116 8 9 15 80 3.5 24461041 1 9 109 14 12 15 82 0.0 24702862 1 4 50 6 4 7 36 0.0 24749815 1 0 0 0 0 0 0 3.5 25216586 1 15 112 9 13 16 85 0.0 25375455 1 0 0 0 0 0 0 1.5 25692200 1 3 61 12 9 18 60 2.5 25817575 1 15 104 7 10 10 71 2.5 26007571 1 13 113 5 10 11 71 4.0 26064558 1 19 117 12 13 17 93 3.0 26114208 1 10 94 9 13 17 76 4.0 26115055 1 14 104 16 15 25 100 3.5 26156779 1 19 107 7 13 17 85 3.5 26177963 1 5 99 12 14 22 82 4.0 26184305 1 16 114 11 12 20 91 2.0 26204164 1 5 70 10 9 16 61 3.5 26222551 1 9 115 12 9 19 83 2.0 26283517 1 13 84 7 12 8 64 0.0 26506131 1 8 28 9 6 0 31 2.5 26526469 1 16 111 7 8 10 72 0.0 26637616 1 5 58 6 6 10 44 2.0 26743573 1 15 64 11 13 11 67 3.0 26825085 1 18 116 11 5 12 78 2.5 26987206 1 17 114 8 7 10 74 3.0 27038724 1 18 111 8 7 11 75 3.5 27134873 1 11 113 13 11 17 85 2.0 27174449 1 14 104 7 3 8 62 3.5 27238069 1 16 113 10 9 18 85 4.0 27405365 1 17 115 15 15 24 103 3.0 27421360 1 12 105 12 11 13 78 4.0 27425325 1 19 116 12 12 19 93 0.0 27453424 1 3 31 10 10 0 32 0.0 27458237 1 4 75 5 2 0 33 2.5 27485083 1 12 94 9 12 11 71 2.0 27592900 1 17 104 11 4 6 67 4.0 27677439 1 22 116 15 15 22 103 4.0 27683056 1 20 116 10 12 20 92 2.0 27688817 1 11 100 7 10 8 65 2.5 27689484 1 6 114 9 9 14 72 2.5 27704554 1 1 100 12 8 19 70 3.0 27745243 1 18 117 8 9 10 78 2.0 27779135 1 14 97 9 5 11 66 0.0 27836267 1 5 4 10 0 0 16 2.0 27942210 1 9 95 8 6 10 61 3.0 27985130 1 11 116 9 10 12 76 3.5 28034874 1 18 114 10 8 14 82 1.0 28063304 1 5 54 9 9 14 53 2.5 28067926 1 16 108 8 8 9 71 3.0 28126373 1 16 111 8 8 14 77 4.0 28141603 1 18 111 10 14 24 97 0.0 28244306 1 4 18 7 0 0 16 3.5 28255468 1 16 116 9 12 14 84 2.5 28283406 1 21 112 9 5 10 73 1.5 28308837 1 3 75 9 8 14 57 3.5 28330177 1 16 115 10 11 15 84 3.0 28343567 1 16 116 9 6 11 75 2.5 28375423 1 14 98 7 9 14 72 3.0 28378266 1 19 100 12 8 15 81 3.5 28384245 1 20 108 8 10 16 82 3.5 28389145 1 14 110 12 7 18 82 3.5 28391405 1 18 114 10 12 13 85 4.0 28392917 1 20 116 9 12 21 92 2.5 28421363 1 16 112 10 7 7 71 3.5 28456045 1 19 116 10 16 12 89 3.5 28479353 1 18 113 10 11 16 86 0.0 28498535 1 7 48 9 6 10 46 2.5 28511420 1 11 113 9 8 12 73 3.5 28541728 1 18 117 6 7 20 84 3.5 28545938 1 19 116 6 11 15 83 3.0 28553378 1 11 96 12 12 19 81 3.5 28579421 1 19 115 11 9 16 86 2.0 28586888 1 5 100 8 9 12 64 3.5 28595356 1 17 117 13 7 12 82 3.0 28602072 1 13 114 9 8 18 81 3.5 28612850 1 17 111 13 10 14 85 4.0 28627691 1 19 111 13 10 21 93 0.0 28637878 1 0 1 8 5 0 14 2.5 28639003 1 15 116 8 10 8 74 3.5 28642199 1 17 105 11 12 18 87 3.5 28643210 1 18 109 11 9 17 85 4.0 28652794 1 20 116 12 14 13 90 3.0 28656676 1 18 107 8 11 14 81 2.5 28694943 1 14 107 7 9 9 69 2.5 28697015 1 10 93 11 5 16 69 0.0 28702106 1 6 29 5 0 0 19 2.0 28703392 1 6 99 14 5 11 65 0.0 28707290 1 6 39 10 0 0 27 3.5 28708248 1 14 113 12 10 17 85 2.0 28711317 1 14 80 10 6 13 65 3.5 28737945 1 20 116 12 13 13 89 0.0 28745987 1 3 14 5 4 9 25 3.0 28801845 1 17 116 8 6 14 78 1.0 28896108 1 7 92 5 6 4 49 4.0 28922206 1 19 117 13 11 18 93 3.0 28943673 1 16 110 6 9 16 78 2.0 28944877 1 11 58 10 9 16 62 3.5 28957609 1 17 116 9 10 15 84 3.0 28959909 1 17 116 10 7 9 75 2.0 28972877 1 12 102 9 7 8 65 4.0 28987026 1 22 114 11 10 20 91 1.0 28988836 1 8 66 9 6 9 51 3.0 29029306 1 11 113 14 10 9 77 2.5 29125949 1 18 112 8 6 8 71 2.5 29132695 1 16 114 7 9 10 74 3.0 29195780 1 17 102 10 9 11 75 3.0 29223620 1 13 104 11 12 15 81 3.0 29238072 1 15 104 9 11 14 78 3.0 29244838 1 18 114 9 8 11 78 1.0 29288310 1 6 83 7 7 6 50 0.0 29316442 1 4 9 7 4 0 18 3.0 29353504 1 12 104 11 11 17 81 2.0 29357181 1 7 100 6 9 12 63 2.0 29367200 1 7 107 11 5 11 65 3.0 29399703 1 19 113 8 6 12 75 2.0 29406707 1 13 94 7 7 10 64 2.0 29424002 1 10 115 6 4 10 63 1.5 29431975 1 5 79 10 5 12 55 4.0 29455658 1 18 116 11 13 18 92 2.0 29596013 1 15 73 10 8 14 67 3.0 29640300 1 13 112 9 9 12 75 3.5 29649653 1 15 83 13 11 20 82 1.5 29662920 1 7 79 9 8 10 57 2.5 29745012 1 8 98 10 8 19 74 3.0 29765446 1 17 117 9 8 12 79 3.5 29774416 1 13 114 10 13 15 84 0.0 29813479 1 2 44 7 4 6 32 2.5 29817382 1 16 108 11 7 8 72 2.5 29839376 1 12 116 10 6 11 72 2.0 29868922 1 14 88 9 7 8 63 2.5 29869121 1 15 111 8 7 10 71 3.0 29933306 1 9 111 10 14 12 77 4.0 29972269 1 20 114 15 15 23 103 3.5 29976567 1 13 115 9 13 15 83 2.5 29999128 1 3 111 11 11 11 69 3.5 30021207 1 19 115 13 9 11 83 3.0 30037734 1 16 102 11 11 15 81 3.0 30038594 1 14 108 9 7 15 76 3.0 30042392 1 18 97 9 11 16 81 2.5 30061441 1 14 110 9 9 10 73 1.0 30066702 1 2 91 10 4 9 52 2.5 30069808 1 12 111 10 9 11 74 2.5 30075814 1 14 116 9 6 12 74 1.0 30129318 1 10 67 9 5 9 52 1.5 30199857 1 12 95 6 6 7 58 4.0 30200142 1 17 115 10 13 20 92 1.0 30201755 1 9 64 10 3 7 47 3.5 30205813 1 17 107 9 11 16 83 3.5 30230889 1 13 117 10 13 17 87 3.5 30251810 1 16 115 13 10 13 84 1.5 30258356 1 11 104 9 5 0 55 2.5 30289970 1 15 116 7 7 10 72 2.5 30302532 1 13 104 8 9 10 70 2.5 30336160 1 8 96 12 5 15 68 2.5 30373106 1 17 79 12 9 15 74 0.0 30386391 1 7 38 7 0 0 25 3.0 30391708 1 17 107 11 10 13 81 3.0 30408521 1 16 112 11 6 16 80 4.0 30427646 1 19 117 10 13 16 90 1.0 30539321 1 9 69 9 5 7 50 1.5 30580818 1 11 99 9 4 6 58 1.5 30585269 1 7 85 7 3 15 57 0.0 30638515 1 1 32 8 0 0 19 3.5 30672447 1 15 113 12 12 18 89 4.0 30676183 1 17 113 17 16 21 103 3.5 30677776 1 20 117 9 8 16 84 2.5 30680053 1 12 104 10 8 14 74 1.5 30741449 1 15 93 8 4 7 60 2.5 30769844 1 13 100 10 7 14 72 2.5 30899797 1 13 80 7 16 10 68 4.0 30900325 1 18 115 10 10 20 90 1.5 31037243 1 16 99 11 4 0 59 4.0 31127622 1 22 101 14 15 20 95 2.5 31140237 1 14 114 6 6 13 71 2.0 31234635 1 5 104 8 10 9 63 4.0 31342611 1 20 115 13 10 17 90 3.5 31359032 1 20 109 13 11 15 87 4.0 31463462 1 11 116 15 14 24 97 2.0 31878400 1 16 110 5 7 7 66 3.0 31880579 1 17 112 9 9 11 77 4.0 32035106 1 20 116 11 11 18 91 3.5 32107600 1 16 116 10 8 16 83 2.5 32154878 1 19 113 9 7 8 73 2.5 32292018 1 17 102 7 8 13 73 3.5 32354754 1 18 92 13 12 15 83 1.0 32399470 1 11 49 6 10 11 51 4.0 32587450 1 18 110 11 13 17 90 2.5 32621623 1 14 97 5 10 12 68 3.5 33030971 1 21 115 12 12 15 89