Lectures Attended Raw Homework Scores
Section Number
Sections Attended
Name Sec
Last Email Lec SecAtt. HW1 HW2 HW3 HW4 HW5 HW6 HW7 HW8 HW9 HW10 HW11
5 1 4 30 45 44 44 31 45 45 33 41 26
14 1 8 28 23 24 42 20 26 42 29 40 27 15
12 2 9 31 33 45 46 28 29 38 44 44 43 34
3 2 6 30 48 45 47 20 37 50 15 49 48 56
9 2 9 30 47 49 46 39 39 49 51 47 50 50
3 2 5 30 41 44 35
4 1 10 33 49 43 49 46 50 45 51
11 1 7 28 39 40 32 21 27 35 31 9 14
3 1 5 30 41 45 40 26 27 39 23 37
7 1 9 32 47 50 48 49 42 50 41 48 50 60
6 2 7 29 28 47 42 47 33 29 29 43 48
10 1 10 29 32 49 39 40 17 46 46 48 47 40
13 2 10 30 36 41 41 20 15 47 43 48 44 48
13 1 10 34 47 50 49 47 43 50 50 47 49 56
2 1 6 31 42 43 46 34 46 27
13 1 9 30 46 49 48 41 37 50 49 47 47 48
0 2 5 22 44 48 33 2 28
13 2 9 30 37 42 31 22 14 38 35 12 16
0 1 33 27 10
0 2 7 30 32 43 34
12 2 9 30 28 48 44 16 33 44 41 44 25 50
14 2 9 31 42 38 38 44 27 45 43 44 45 40
1 2 2 28 21 24
7 1 9 32 49 50 49 46 40 48 50 47 50 55
8 2 7 29 40 49 47 41 31 46 45 48 48 51
2 2 7
8 1 9 32 48 47 48 46 37 50 51 49 50 55
4 1 3 35 33 35 16 25 43
13 1 10 31 35 42 32 33 36 48 47 43 23
6 1 7 31 26 9 25 31 37 31 35
11 1 9 30 37 40 30 38 17 45 50 46 25 50
11 2 10 29 20 44 43 14 32 48 45 47 49 53
14 1 10 32 38 42 42 40 45 50 50 43 41 43
8 2 10 31 40 45 35 27 20 36 18
14 2 10 30 35 46 46 16 33 44 40 48 47 42
10 1 9 28 32 38 40 22 46 45 44 49 50
14 1 10 32 45 38 38 38 40 50 47 44 42 43
8 2 10 29 19 43 35 3 22 7 29 13
14 2 9 32 50 48 49 48 41 50 51 51 49 49
14 2 9 31 47 50 50 47 43 50 50 49 56
13 1 10 32 49 50 50 50 42 50 53 49 48 55
5 2 7 31 37 38 46 25 35 47 43 35
9 2 8 30 36 45 43 13 16 48 41 45 42
11 2 10 32 41 42 39 26 50 41 31 37 50
0 1 32 16 35 32 23 41 30 27 24
14 2 10 30 49 46 42 47 41 50 51 44 46 46
4 1 5 15 41 45 38
Average 26.9 35.3 40.8 37.6 30.3 28.9 43.2 41.2 39.7 41.1 74.8
Total 30 40 50 50 50 45 50 50 50 50 50
% 90% 88% 82% 75% 61% 64% 86% 82% 79% 82% 150%
Total Score Raw Prelim 1 Problem Scores Prelim 2 Problem Scores
Deviation from mean Total Total
Deviation from the mean Deviation from the mean
Name HW HW P1 P2
Last HW12 HW13 HW14 Cum Dev P1-1 P1-2 P1-3 P1-T Dev P2-1 P2-2 P2-3 P2-T Dev
41 41 50 516 (0.11) 34 25 17 76 (0.11) 24 27 14 65 (0.10)
45 20 381 (0.34) 34 25 23 82 (0.04) 22 27 30 79 0.10
415 (0.28) 32 30 23 85 (0.00) 22 22 15 59 (0.18)
42 50 50 587 0.01 38 24 19 81 (0.05) 24 30 20 74 0.03
46 50 50 643 0.11 35 27 24 86 0.01 27 30 30 87 0.21
150 (0.74) 34 24 28 86 0.01 20 30 23 73 0.02
366 (0.37) 38 30 30 98 0.15 26 30 30 86 0.20
276 (0.52) 33 30 19 82 (0.04) 18 25 30 73 0.02
308 (0.47) 40 29 9 78 (0.09) 20 18 25 63 (0.12)
48 55 50 670 0.16 40 30 30 100 0.17 18 29 30 77 0.07
39 41 47 502 (0.13) 39 30 30 99 0.16 35 20 13 68 (0.05)
41 40 41 555 (0.04) 40 30 25 95 0.11 28 30 20 78 0.09
36 50 47 546 (0.06) 33 30 24 87 0.02 21 15 23 59 (0.18)
44 55 50 671 0.16 40 30 30 100 0.17 34 25 30 89 0.24
269 (0.54) 33 24 2 59 (0.31) 25 30 12 67 (0.07)
58 49 42 641 0.11 38 30 15 83 (0.03) 32 27 30 89 0.24
177 (0.69) 33 30 23 86 0.01 21 28 16 65 (0.10)
27 304 (0.48) 36 30 24 90 0.06 19 30 15 64 (0.11)
70 (0.88) 37 24 25 86 0.01 18 25 29 72 0.00
139 (0.76) 37 24 25 86 0.01 20 30 17 67 (0.07)
41 55 50 549 (0.05) 40 30 6 76 (0.11) 20 30 20 70 (0.03)
55 35 40 567 (0.02) 40 27 29 96 0.13 30 23 30 83 0.15
73 (0.87) 27 30 12 69 (0.19) 17 22 4 43 (0.40)
43 45 50 654 0.13 35 27 25 87 0.02 27 30 30 87 0.21
38 50 50 613 0.06 39 30 29 98 0.15 19 22 12 53 (0.26)
491 (0.15) 30 25 30 85 (0.00) 24 25 6 55 (0.23)
45 45 44 647 0.12 40 30 27 97 0.14 27 30 30 87 0.21
39 226 (0.61) 31 24 18 73 (0.14) 17 30 15 62 (0.14)
27 25 422 (0.27) 40 30 17 87 0.02 27 28 30 85 0.18
29 34 288 (0.50) 34 30 10 74 (0.13) 21 25 20 66 (0.08)
25 25 25 483 (0.17) 33 25 20 78 (0.09) 65 (0.10)
45 55 50 574 (0.01) 35 24 15 74 (0.13) 27 30 20 77 0.07
60 55 41 622 0.07 40 24 28 92 0.08 35 26 30 91 0.27
252 (0.56) 33 27 29 89 0.04 25 30 30 85 0.18
44 50 50 571 (0.01) 20 22 12 54 (0.37) 22 30 12 64 (0.11)
43 45 50 532 (0.08) 33 27 12 72 (0.16) 23 28 20 71 (0.01)
50 44 40 591 0.02 36 25 17 78 (0.09) 17 28 17 62 (0.14)
200 (0.65) 31 25 20 76 (0.11) 22 25 17 64 (0.11)
60 55 48 681 0.18 40 30 30 100 0.17 36 30 30 96 0.34
44 55 49 621 0.07 40 30 29 99 0.16 28 30 18 76 0.06
60 52 50 690 0.19 40 30 20 90 0.06 27 30 28 85 0.18
27 37 401 (0.31) 40 30 23 93 0.09 26 21 23 70 (0.03)
42 50 451 (0.22) 33 30 27 90 0.06 21 20 16 57 (0.21)
49 50 47 535 (0.08) 39 30 26 95 0.11 9 30 15 54 (0.25)
21 281 (0.51) 33 22 17 72 (0.16) 17 27 20 64 (0.11)
56 45 50 643 0.11 40 30 30 100 0.17 23 30 22 75 0.04
139 (0.76) 40 25 24 89 0.04 20 27 30 77 0.07
Average 44.1 47.7 47.4 579 0.00 36 27.6 22 85.3 0.00 24 26.8 22 71.9 0.00
Total 50 50 50 665 40 30 30 100 40 30 30 100
% 88% 95% 95% 87% 90% 92% 73% 85% 59% 89% 72% 72%
Prelim 3 problem scores Total for prelims and homework divided by 400.
Total Deviation from the mean
Deviation from the mean Deviation from the mean
Name P3 Comm Current
Last P3-1 P3-2 P3-3 P3-T Dev Total Dev Major Semester Math
25 5 9 39 (0.40) 2.58 (0.17) CEE 5
29 15 6 50 (0.23) 2.68 (0.13) MAE 5
Bad Performance -- Bad Performance
24 25 15 64 (0.01) 2.70 (0.13) CEE 7
15 15 7 37 (0.43) 2.80 (0.09) CEE 5
20 5 16 41 (0.37) 3.11 0.01 CEE 5
25 25 6 56 (0.14) 2.38 (0.23) Environ 5
25 40 15 80 0.23 3.19 0.03 MAE 3
29 38 11 78 0.20 2.75 (0.11) MAE 5
27 25 9 61 (0.06) 2.48 (0.20) CEE 5
35 39 18 92 0.42 3.70 0.20 MAE 3
35 38 19 92 0.42 3.34 0.08 MAE 3 270
35 20 7 62 (0.04) 3.18 0.03 CEE 5
18 20 8 46 (0.29) 2.74 (0.11) CEE 5
25 38 14 77 0.19 3.67 0.19 MAE 3 TAM310
20 15 17 52 (0.20) 2.18 (0.29) Copying
BlatantMAE 5 294
37 39 7 83 0.28 3.51 0.14 MAE 3
23 30 20 73 0.13 2.51 (0.19) to talk
Needs CEE to me 5
10 25 12 47 (0.28) 2.47 (0.20) CEE 5
28 30 18 76 0.17 2.45 (0.21) MAE
Bad Performance 3
35 0 20 55 (0.15) 2.29 (0.26) CEE 5
15 10 16 41 (0.37) 2.70 (0.13) CEE 5
37 38 17 92 0.42 3.56 0.15 MAE 3 294
16 5 12 33 (0.49) 1.56 (0.50) CEE 7
Bad Performance -- Bad Performance
25 42 19 86 0.33 3.58 0.16 MAE 3
28 36 7 71 0.09 3.14 0.02 CEE 5 420
26 26 13 65 0.00 2.79 (0.10) OR&IE 7
37 37 13 87 0.34 3.68 0.19 MAE 3 310
27 33 20 80 0.23 2.49 (0.19) MAE 4
22 10 14 46 (0.29) 2.81 (0.09) MAE 3
35 10 12 57 (0.12) 2.40 (0.22) MAE
Bad Performance 5 270
28 29 8 65 0.00 2.81 (0.09) MAE 5
18 25 15 58 (0.11) 2.95 (0.04) to talk
Needs CEE to me 5
35 25 20 80 0.23 3.57 0.15 MAE 3
32 33 15 80 0.23 2.92 (0.06) CEE 5
16 10 13 39 (0.40) 2.43 (0.21) CEE 6
12 25 14 51 (0.21) 2.74 (0.11) CEE 5
24 25 17 66 0.02 2.95 (0.05) MAE 3
21 15 8 44 (0.32) 2.14 (0.31) to talk
Needs MAE to me 3 294
33 40 17 90 0.39 3.88 0.26 CEE 5
40 38 17 95 0.46 3.63 0.18 MAE 3 270
37 30 5 72 0.11 3.51 0.13 MAE 5
34 20 17 71 0.09 2.94 (0.05) ABEN 5
8 38 9 55 (0.15) 2.70 (0.13) CEE 5
36 20 7 63 (0.03) 2.92 (0.05) CEE 6
22 25 7 54 (0.17) 2.32 (0.25) to talk
Needs MAE to me 6
20 40 19 79 0.22 3.51 0.13 MAE 5
15 40 13 68 0.05 2.55 (0.18) MAE 5
Bad Performance -- Blatant Copying -- Blatant Copying
Average 26.5 26.3 13.4 65 0.00 3.09 0.00
Total 40 40 20 100 4.00 0.29
% 66% 66% 67% 65% 77%
Name Previous
Last Math
294 1
294 1
294 1
294 1
294 1
294 1
294 1
294 1
294 1
294 1
294 1
294 1
294 1
294 1
1
293,294 1
294 1
294 1
294 1
294 1
294 1
293 1
294 1
294 1
336 1
294 1
294 1
294 1
294 1
294 1
294 1
294 1
293,294 1
294 1
294 1
294 1
293,294 1
293 1
294 1
294 1
294 1
294 1
294 1
294 1
294 1
294 1
294 1
Average
Total
%
Histogram of Scores
Total Class Score Homework and Prelims, Scaled with Drop Raw Final Exam
100.0%
90.0%
80.0%
70.0%
Percent Cumulative
60.0%
50.0%
40.0%
30.0%
20.0%
10.0%
0.0%
0 10 20 30 40 50 60 70 80 90 100
Points
Breakdown of the Homework and Prelim Scores
Total Scaled Homework Prelim1 Scaled Prelim2 Scaled Prelim3 Scaled
100.0%
90.0%
80.0%
70.0%
Cumulative Percent
60.0%
50.0%
40.0%
30.0%
20.0%
10.0%
0.0%
0 10 20 30 40 50 60 70 80 90 100
Points
Note: All the data on this page was Raw Homework Scores BL = Bilinear Normalization
*copied* from Sheet one. It will NOT Total Homework Scores
Automatically update.
Name Total
Last First Points TA 1 2 3 4 5 6 7 8 9 10 11 12 13 14 HW BL
70.51517 0 30 45 44 44 31 45 45 33 41 41 41 50 490 75
57.69232 0 28 23 24 42 20 26 42 29 40 27 45 20 366 56.02
67.99908 0 31 33 45 46 28 29 38 44 44 43 34 415 63.52
64.27174 0 30 48 45 47 37 50 49 48 56 42 50 50 552 89.09
84.55758 0 30 47 49 46 49 51 47 50 50 46 50 50 565 92.05
50.90256 0 30 41 44 35 150 22.96
93.67976 0 33 49 43 49 46 50 45 51 366 56.02
64.25749 0 28 39 40 32 21 27 35 31 9 14 276 42.24
59.40953 0 30 41 45 40 26 27 39 23 37 308 47.14
87.61591 0 32 47 50 48 49 50 48 50 60 48 55 50 587 97.05
86.93588 0 29 47 42 47 33 29 29 43 48 39 41 47 474 72.55
83.1513 0 29 49 39 40 46 46 48 47 40 41 40 41 506 78.64
60.9304 0 30 36 41 41 47 43 48 44 48 36 50 47 511 79.77
87.67727 0 34 47 50 49 47 50 50 47 49 56 55 50 584 96.36
52.52136 0 31 42 43 46 34 46 27 269 41.17
85.29015 0 30 46 49 48 50 49 47 47 48 58 49 42 563 91.59
75.57977 0 22 44 48 33 2 28 177 27.09
63.74654 0 30 37 42 31 22 14 38 35 12 16 27 304 46.53
64.21944 0 33 27 10 70 10.71
66.0477 0 30 32 43 34 139 21.28
64.57727 0 30 28 48 44 33 44 41 44 50 41 55 50 508 79.09
84.52619 0 31 42 38 38 44 45 43 44 45 40 55 40 505 78.41
42.22065 0 28 21 24 73 11.17
82.22652 0 32 49 50 49 46 48 50 47 50 55 45 50 571 93.41
78.07522 0 29 40 49 47 41 46 45 48 48 51 50 50 544 87.27
77.84253 0 29 31 41 46 36 33 50 50 50 50 50 25 491 75.23
91.45815 0 32 48 47 48 46 50 51 49 50 55 45 45 566 92.27
59.65929 0 35 33 35 16 25 43 39 226 34.59
75.52126 0 31 35 42 32 33 36 48 47 43 23 27 25 422 64.59
61.78707 0 31 26 9 25 31 37 31 35 29 34 288 44.08
57.40587 0 30 37 40 30 38 45 50 46 50 25 25 25 441 67.5
76.29779 0 29 44 43 32 48 45 47 49 53 45 55 50 540 86.36
90.48712 0 32 42 42 45 50 50 43 41 43 60 55 41 544 87.27
81.63452 0 31 40 45 35 27 20 36 18 252 38.57
61.95356 0 30 35 46 46 44 40 48 47 42 44 50 50 522 82.27
66.12269 0 28 32 38 40 46 45 44 49 50 43 45 50 510 79.55
66.04807 0 32 45 38 40 50 47 44 42 43 50 44 40 515 80.68
55.27566 0 29 19 43 35 3 22 7 29 13 200 30.61
94.94697 0 32 50 48 49 50 51 51 49 49 60 55 48 592 98.18
89.24405 0 31 47 50 50 47 50 50 49 56 44 55 49 578 95
85.09048 0 32 49 50 50 50 50 53 49 55 60 52 50 600 100
62.16561 0 31 37 38 46 25 35 47 43 35 27 37 401 61.38
54.4475 0 30 36 45 43 13 16 48 41 45 42 42 50 451 69.03
64.36365 0 32 41 42 39 50 41 31 37 50 49 50 47 509 79.32
62.86734 0 32 16 35 32 23 41 30 27 24 21 281 43.01
89.18763 0 30 49 46 47 50 51 44 46 46 56 45 50 560 90.91
74.48452 0 15 41 45 38 139 21.28
Average 71.84932 28 33 42 37 24 15 45 41 41 40 75 40 0 0 414.9
Total 100 30 40 50 50 50 45 50 50 50 50 50 50 50 50 565
Median 67.99908 30 40 44 43 34 31 48 45 45 44 50 44 50 49 490
Avg. Shift 0.153
Factor High 1.485
Factor Low 1
data on this page was
Note: All theBL = Bilinear Normalization Prelim 3 Total Score Total raw Lab score
*copied* from Sheet one. It will NOT
Total Homework Scores Total Raw Final exam score
Automatically update. Prelim 1 Total Score
Name Prelim 2 Total Score
Last First P1 BL P2 BL P3 BL Total Lab Final Bins
76 66.28 65 68.66 39 45 69.98 48.3 67.00 1
82 71.51 79 83 50 57.69 70.73 47.3 30.00 2
85 74.13 59 62.32 64 73.85 70.50 49.8 58.00 3
81 70.64 74 78 37 42.69 79.24 49.6 35.00 4
86 75 87 91 41 47.31 86.02 57 78.00 5
86 75 73 77 56 64.62 72.21 1.8 41.00 6
98 96.43 86 90 80 87.5 91.31 54.9 98.00 7
82 71.51 73 77 78 85.83 78.11 49 37.00 8
78 68.02 63 66.55 61 70.38 68.32 52 35.00 9
100 100 77 81 92 97.5 98.18 57.5 69.00 10
99 98.21 68 71.83 92 97.5 89.42 49.9 85.00 11
83.1513
95 91.07 78 82 62 71.54 83.90 50 82.00 12
60.9304
87 76.79 59 62.32 46 53.08 72.96 48.8 35.00 13
87.67727
100 100 89 93 77 85 96.45 55.6 73.00 14
59 51.45
52.52136 67 70.77 52 60 60.74 36.8 37.00 15
83 72.38
85.29015 89 93 83 90 91.53 48.9 78.00 16
86
75.57977 75 65 68.66 73 81.67 75.11 48.5 74.00 17
90 82.14
63.74654 64 67.61 47 54.23 67.99 51.8 48.00 18
86
64.21944 75 72 76 76 84.17 78.39 31.5 49.00 19
66.0477
86 75 67 70.77 55 63.46 69.75 46.3 56.00 20
76 66.28
64.57727 70 73.94 41 47.31 73.10 40.7 51.00 21
96 92.86
84.52619 83 87 92 97.5 92.45 51 73.00 22
69 60.17
42.22065 43 45.42 33 38.08 47.89 50.7 16.00 23
87 76.79
82.22652 87 91 86 92.5 92.30 54.7 64.00 24
98 96.43
78.07522 53 55.99 71 80 87.90 46.9 64.00 25
85 74.13
77.84253 55 58.1 65 75 74.79 54 77.00 26
97 94.64
91.45815 87 91 87 93.33 93.42 57.2 87.00 27
73 63.66
59.65929 62 65.49 80 87.5 72.22 29.8 46.00 28
87 76.79
75.52126 85 89 46 53.08 76.79 53.3 68.00 29
74 64.53
61.78707 66 69.72 57 65.77 66.67 53.6 43.00 30
78 68.02
57.40587 65 68.66 65 75 70.56 38.1 36.00 31
74 64.53
76.29779 77 81 58 66.92 78.10 48.2 72.00 32
92 85.71
90.48712 91 95 80 87.5 89.92 49.1 95.00 33
89 80.36
81.63452 85 89 80 87.5 85.62 46.1 78.00 34
54 47.09
61.95356 64 67.61 39 45 65.66 53.5 45.00 35
72 62.79
66.12269 71 75 51 58.85 72.45 49.6 50.00 36
78 68.02
66.04807 62 65.49 66 75.83 74.85 47.3 48.00 37
76 66.28
55.27566 64 67.61 44 50.77 61.55 51.8 33.00 38
94.94697
100 100 96 100 90 95.83 99.39 57.8 88.00 39
99 98.21
89.24405 76 80 95 100 97.74 57.9 74.00 40
90 82.14
85.09048 85 89 72 80.83 90.38 56 74.00 41
93 87.5
62.16561 70 73.94 71 80 80.48 47.1 29.00 42
54.4475
90 82.14 57 60.21 55 63.46 71.55 28.5 33.00 43
95 91.07 54 57.04 63 72.69 81.03 49.2 33.00 44
72 62.79 64 67.61 54 62.31 64.23 46 55.00 45
100 100 75 79 79 86.67 92.53 55.5 83.00 46
89 80.36 77 81 68 77.5 79.62 49.1 64.00 47
48
Average 85 72 65 48.04 58.38298 49
Total 100 100 100 100 100 50
Median 86 71 65 49.6 58 51
52
Avg. Shift 0.9 1.1 1.2 1.512 1.293103 53
Factor High 2 0.9 0.7 1.992 0.483333 54
Factor Low 1 1 1 1 1 55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
Note: All the data on this page was is where I put histogram data. This will NOT regenerate automatically, even from data
Here
Total from Sheet one. NOT
*copied* Raw Final exam scoreIt will in this sheet. It needs to be created with the Histogram data analysis package
Automatically update. which might not be installed automatically (is wasn't for me).
Name
Last First Total Scaled Homework Prelim2 Prelim3 Homework and Prelims, Scaled with Drop
Total Class Score Prelim1 Scaled Scaled Scaled Raw Final Exam
0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0%
0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0%
0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0%
0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0%
0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0%
0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0%
0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0%
0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0%
0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0%
0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0%
0.0% 2.1% 0.0% 0.0% 0.0% 0.0% 0.0%
0.0%
83.1513 4.3% 0.0% 0.0% 0.0% 0.0% 0.0%
0.0%
60.9304 4.3% 0.0% 0.0% 0.0% 0.0% 0.0%
0.0%
87.67727 4.3% 0.0% 0.0% 0.0% 0.0% 0.0%
0.0%
52.52136 4.3% 0.0% 0.0% 0.0% 0.0% 0.0%
0.0%
85.29015 4.3% 0.0% 0.0% 0.0% 0.0% 2.1%
0.0%
75.57977 4.3% 0.0% 0.0% 0.0% 0.0% 2.1%
0.0%
63.74654 4.3% 0.0% 0.0% 0.0% 0.0% 2.1%
0.0%
64.21944 4.3% 0.0% 0.0% 0.0% 0.0% 2.1%
0.0%
66.0477 4.3% 0.0% 0.0% 0.0% 0.0% 2.1%
0.0%
64.57727 4.3% 0.0% 0.0% 0.0% 0.0% 2.1%
0.0%
84.52619 8.5% 0.0% 0.0% 0.0% 0.0% 2.1%
0.0%
42.22065 10.6% 0.0% 0.0% 0.0% 0.0% 2.1%
0.0%
82.22652 10.6% 0.0% 0.0% 0.0% 0.0% 2.1%
0.0%
78.07522 10.6% 0.0% 0.0% 0.0% 0.0% 2.1%
0.0%
77.84253 10.6% 0.0% 0.0% 0.0% 0.0% 2.1%
0.0%
91.45815 10.6% 0.0% 0.0% 0.0% 0.0% 2.1%
0.0%
59.65929 12.8% 0.0% 0.0% 0.0% 0.0% 2.1%
0.0%
75.52126 12.8% 0.0% 0.0% 0.0% 0.0% 4.3%
0.0%
61.78707 12.8% 0.0% 0.0% 0.0% 0.0% 6.4%
0.0%
57.40587 14.9% 0.0% 0.0% 0.0% 0.0% 6.4%
0.0%
76.29779 14.9% 0.0% 0.0% 0.0% 0.0% 6.4%
0.0%
90.48712 14.9% 0.0% 0.0% 0.0% 0.0% 12.8%
0.0%
81.63452 14.9% 0.0% 0.0% 0.0% 0.0% 12.8%
0.0%
61.95356 17.0% 0.0% 0.0% 0.0% 0.0% 19.1%
0.0%
66.12269 17.0% 0.0% 0.0% 0.0% 0.0% 21.3%
0.0%
66.04807 17.0% 0.0% 0.0% 0.0% 0.0% 25.5%
0.0%
55.27566 17.0% 0.0% 0.0% 0.0% 0.0% 25.5%
0.0%
94.94697 19.1% 0.0% 0.0% 2.1% 0.0% 25.5%
0.0%
89.24405 19.1% 0.0% 0.0% 2.1% 0.0% 25.5%
0.0%
85.09048 19.1% 0.0% 0.0% 2.1% 0.0% 27.7%
0.0%
62.16561 21.3% 0.0% 0.0% 2.1% 0.0% 27.7%
2.1%
54.4475 23.4% 0.0% 0.0% 4.3% 0.0% 29.8%
2.1% 25.5% 0.0% 0.0% 4.3% 0.0% 29.8%
2.1% 27.7% 0.0% 0.0% 8.5% 0.0% 31.9%
2.1% 27.7% 0.0% 2.1% 8.5% 0.0% 34.0%
2.1% 29.8% 0.0% 2.1% 8.5% 0.0% 34.0%
2.1% 31.9% 2.1% 2.1% 12.8% 2.1% 38.3%
Average 2.1% 31.9% 2.1% 2.1% 12.8% 2.1% 40.4%
Total 2.1% 31.9% 2.1% 2.1% 12.8% 2.1% 42.6%
Median 4.3% 31.9% 2.1% 2.1% 14.9% 2.1% 44.7%
4.3% 31.9% 4.3% 2.1% 14.9% 2.1% 44.7%
Avg. Shift 6.4% 31.9% 4.3% 2.1% 14.9% 2.1% 44.7%
Factor High 6.4% 31.9% 4.3% 2.1% 19.1% 2.1% 44.7%
Factor Low 8.5% 31.9% 4.3% 2.1% 21.3% 2.1% 46.8%
10.6% 31.9% 4.3% 4.3% 21.3% 2.1% 48.9%
10.6% 36.2% 4.3% 4.3% 21.3% 2.1% 48.9%
14.9% 36.2% 4.3% 6.4% 23.4% 2.1% 51.1%
14.9% 36.2% 4.3% 8.5% 25.5% 2.1% 51.1%
19.1% 36.2% 4.3% 8.5% 27.7% 2.1% 51.1%
21.3% 36.2% 6.4% 10.6% 27.7% 4.3% 51.1%
25.5% 38.3% 6.4% 10.6% 27.7% 6.4% 51.1%
29.8% 38.3% 10.6% 14.9% 29.8% 6.4% 51.1%
31.9% 40.4% 12.8% 14.9% 34.0% 6.4% 57.4%
42.6% 42.6% 17.0% 14.9% 36.2% 8.5% 57.4%
42.6% 42.6% 17.0% 19.1% 38.3% 10.6% 57.4%
48.9% 42.6% 23.4% 21.3% 40.4% 12.8% 59.6%
51.1% 44.7% 23.4% 29.8% 40.4% 14.9% 61.7%
51.1% 44.7% 29.8% 36.2% 40.4% 17.0% 63.8%
51.1% 46.8% 29.8% 38.3% 40.4% 21.3% 63.8%
53.2% 46.8% 31.9% 42.6% 42.6% 27.7% 63.8%
53.2% 46.8% 36.2% 44.7% 44.7% 29.8% 66.0%
53.2% 48.9% 38.3% 44.7% 46.8% 38.3% 70.2%
53.2% 48.9% 38.3% 48.9% 48.9% 40.4% 76.6%
55.3% 51.1% 53.2% 51.1% 53.2% 44.7% 76.6%
59.6% 53.2% 53.2% 53.2% 55.3% 46.8% 76.6%
61.7% 53.2% 59.6% 57.4% 55.3% 48.9% 78.7%
63.8% 53.2% 59.6% 59.6% 57.4% 48.9% 85.1%
66.0% 57.4% 59.6% 61.7% 57.4% 55.3% 85.1%
66.0% 66.0% 59.6% 63.8% 61.7% 59.6% 85.1%
66.0% 68.1% 63.8% 70.2% 63.8% 61.7% 85.1%
68.1% 68.1% 63.8% 72.3% 66.0% 63.8% 87.2%
70.2% 70.2% 70.2% 74.5% 66.0% 63.8% 89.4%
72.3% 70.2% 70.2% 74.5% 66.0% 66.0% 89.4%
76.6% 70.2% 70.2% 74.5% 70.2% 66.0% 91.5%
80.9% 70.2% 72.3% 74.5% 72.3% 68.1% 91.5%
83.0% 72.3% 72.3% 76.6% 74.5% 70.2% 93.6%
87.2% 76.6% 74.5% 76.6% 83.0% 72.3% 95.7%
87.2% 76.6% 74.5% 83.0% 83.0% 72.3% 95.7%
91.5% 78.7% 74.5% 85.1% 85.1% 76.6% 95.7%
93.6% 80.9% 74.5% 91.5% 85.1% 78.7% 95.7%
95.7% 83.0% 78.7% 91.5% 85.1% 83.0% 95.7%
95.7% 87.2% 80.9% 95.7% 87.2% 89.4% 95.7%
97.9% 89.4% 80.9% 95.7% 89.4% 91.5% 95.7%
100.0% 91.5% 83.0% 97.9% 89.4% 91.5% 97.9%
100.0% 91.5% 83.0% 97.9% 91.5% 91.5% 97.9%
100.0% 93.6% 87.2% 97.9% 91.5% 93.6% 97.9%
100.0% 95.7% 87.2% 97.9% 97.9% 95.7% 100.0%
100.0% 97.9% 91.5% 97.9% 97.9% 97.9% 100.0%
100.0% 100.0% 100.0% 100.0% 100.0% 100.0% 100.0%
1
Letter grad cutoff numbers are on Total Class Score Scaled Prelim1 Total Raw Total Lab Score.
the bottom. Total Raw Final Exam Scaled Prelim2 Total
Scaled Homework Total Scaled Prelim3 Total
Letter Name
Grade Last First Final F-Exam Homework Prelim1 Prelim2 Prelim3 Lab
A+ 94.9 88 98 100 100 96 58
A+ 93.7 98 56 96 90 88 55
A 91.5 87 92 95 91 93 57
A 90.5 95 87 86 95 88 49
A 89.2 74 95 98 80 100 58
A 89.2 83 91 100 79 87 56
A 87.7 73 96 100 93 85 56
A 87.6 69 97 100 81 98 58
A 86.9 85 73 98 72 98 50
A- 85.3 78 92 72 93 90 49
A- 85.1 74 100 82 89 81 56
A- 84.6 78 92 75 91 47 57
A- 84.5 73 78 93 87 98 51
A- 83.2 82 79 91 82 72 50
B+ 82.2 64 93 77 91 93 55
B+ 81.6 78 39 80 89 88 46
B+ 78.1 64 87 96 56 80 47
B 77.8 77 75 74 58 75 54
B 76.3 72 86 65 81 67 48
B 75.6 74 27 75 69 82 49
B 75.5 68 65 77 89 53 53
B 74.5 64 21 80 81 78 49
B 70.5 67 75 66 69 45 48
B 68.0 58 64 74 62 74 50
B- 66.1 50 80 63 75 59 50
B- 66.0 48 81 68 65 76 47
B- 66.0 56 21 75 71 63 46
C+ 64.6 51 79 66 74 47 41
C+ 64.4 33 79 91 57 73 49
C+ 64.3 35 89 71 78 43 50
C+ 64.3 37 42 72 77 86 49
C+ 64.2 49 11 75 76 84 32
C 63.7 48 47 82 68 54 52
C 62.9 55 43 63 68 62 46
C 62.2 29 61 88 74 80 47
C 62.0 45 82 47 68 45 54
C 61.8 43 44 65 70 66 54
C 60.9 35 80 77 62 53 49
C- 59.7 46 35 64 65 88 30
C- 59.4 35 47 68 67 70 52
C- 57.7 30 56 72 83 58 47
C- 57.4 36 68 68 69 75 38
D 55.3 33 31 66 68 51 52
D 54.4 33 69 82 60 63 29
D 52.5 37 41 51 71 60 37
D 50.9 41 23 75 77 65 2
D- 42.2 16 11 60 45 38 51
A+=93 A-=83 B=68 C+=64 C-=57 D=50
A=87 B+=78 B-=66 C=60 D+=56 D-=42
Raw Total Lab Score.
This is where I put the raw data from the labs and the final exam - as Sheet one was getting too full.
Name Final Exam
Last First Lab1 Lab2 Lab3 Lab4 Total F1 F2 F3 F4 F5 Total
12.9 10.3 12.1 13 48.3 14 13 13 19 8 67
13 10.8 10 13.5 47.3 12 8 2 8 0 30
13.4 10.7 12.7 13 49.8 14 11 13 12 8 58
11.8 11.3 13 13.5 49.6 8 6 13 8 0 35
14.7 13.3 14 15 57 18 6 20 15 19 78
0 1.8 0 0 1.8 19 10 12 0 0 41
14.4 12.5 14 14 54.9 18 20 20 20 20 98
11.5 11.3 12.7 13.5 49 14 13 4 6 0 37
13.2 11.9 12.9 14 52 17 6 5 7 0 35
16 13.3 13.7 14.5 57.5 17 14 18 10 10 69
14.4 10 12 13.5 49.9 16 15 20 15 19 85
13.3 11 12.7 13 50 16 13 19 19 15 82
13.3 10.3 12.2 13 48.8 5 9 10 8 3 35
15 13.5 13.6 13.5 55.6 20 13 19 18 3 73
14.3 0 10.5 12 36.8 14 8 0 10 5 37
13.7 10.3 11.4 13.5 48.9 18 10 15 20 15 78
14 8.5 13.5 12.5 48.5 20 14 17 15 8 74
13.6 11.8 12.4 14 51.8 14 8 15 7 4 48
0 10.5 8.5 12.5 31.5 15 14 5 10 5 49
11.3 9.5 13.5 12 46.3 14 12 9 16 5 56
11 1.8 13.9 14 40.7 15 9 16 8 3 51
14.5 12.5 10.5 13.5 51 20 11 19 13 10 73
14.5 11.4 10.5 14.3 50.7 8 6 2 0 0 16
14.5 13.9 12.8 13.5 54.7 20 15 16 8 5 64
12.7 10.8 10.9 12.5 46.9 14 11 10 14 15 64
14.5 11.8 14.2 13.5 54 15 12 18 12 20 77
14.5 13.9 14.5 14.3 57.2 17 14 17 20 19 87
0.8 2 14 13 29.8 13 7 13 5 8 46
16 10.2 13.6 13.5 53.3 19 10 12 20 7 68
15.8 10.3 14 13.5 53.6 10 4 14 15 0 43
13.5 11.9 1.7 11 38.1 7 8 10 3 8 36
13 10.8 12.4 12 48.2 12 14 11 15 20 72
14 10.1 11.5 13.5 49.1 20 16 20 20 19 95
11.3 11.3 13.5 10 46.1 15 16 17 20 10 78
14.5 13.5 10.5 15 53.5 15 9 3 13 5 45
11.8 11.3 13 13.5 49.6 14 4 6 18 8 50
13.8 8.5 11.5 13.5 47.3 13 10 11 10 4 48
13.4 11.8 12.6 14 51.8 8 6 11 3 5 33
16 13.3 14 14.5 57.8 20 11 20 18 19 88
15.9 13.5 14 14.5 57.9 19 12 18 20 5 74
15 13.5 14 13.5 56 15 20 20 14 5 74
12.9 10.8 10.9 12.5 47.1 14 8 7 0 0 29
11 1.5 2 14 28.5 13 6 6 5 3 33
13.1 10.8 11.8 13.5 49.2 11 9 5 8 0 33
12.5 11.5 10.5 11.5 46 15 15 9 8 8 55
14.9 13.5 13.6 13.5 55.5 17 11 16 20 19 83
11 11.3 13.8 13 49.1 6 19 16 20 3 64
14.6
Avg 11 12.6 12.2 7.98 58.4