Curve Magic

	A	B	C	E	F	G	I	J	K
1	The goal of this spreadsheet is to make curving easier. Lower scores will be given more curve points; higher score = less curve. Curved + 4 gives a smaller point increase, Curved + 5 = Larger Curve. To use, put the class scores in "Original Point Score" and watch numbers change. See what the modified scores would be and decide if it works for you.						By Ian Hall for iddblog.org Faculty Instructional Technology Services (FITS) DePaul University
2	Original Score			Nice Curve			Really Nice Curve
3	Formulas -- ignore the !! prepend:		!! =B3/A3	!! =SUM((B4 * 4 ) / 5)+4	!! =E4/A4	!! =F4-C4	!! =SUM((B4 * 4 ) / 5)+5	!! =H4/A4	!! =I4-C4
4	Possible Score	Original Point Score	Original Percent Score	New Point Score	New Percent Score	% Increase	New Point Score	New Percent Score	% Increase
5	20	0.0	0%	4.0	20%	20%	5.0	25%	25%
6	20	1.0	5%	4.8	24%	19%	5.8	29%	24%
7	20	2.0	10%	5.6	28%	18%	6.6	33%	23%
8	20	3.0	15%	6.4	32%	17%	7.4	37%	22%
9	20	4.0	20%	7.2	36%	16%	8.2	41%	21%
10	20	5.0	25%	8.0	40%	15%	9.0	45%	20%
11	20	6.0	30%	8.8	44%	14%	9.8	49%	19%
12	20	7.0	35%	9.6	48%	13%	10.6	53%	18%
13	20	8.0	40%	10.4	52%	12%	11.4	57%	17%
14	20	9.0	45%	11.2	56%	11%	12.2	61%	16%
15	20	10.0	50%	12.0	60%	10%	13.0	65%	15%
16	20	11.0	55%	12.8	64%	9%	13.8	69%	14%
17	20	12.0	60%	13.6	68%	8%	14.6	73%	13%
18	20	13.0	65%	14.4	72%	7%	15.4	77%	12%
19	20	14.0	70%	15.2	76%	6%	16.2	81%	11%
20	20	15.0	75%	16.0	80%	5%	17.0	85%	10%
21	20	16.0	80%	16.8	84%	4%	17.8	89%	9%
22	20	17.0	85%	17.6	88%	3%	18.6	93%	8%
23	20	18.0	90%	18.4	92%	2%	19.4	97%	7%
24	20	19.0	95%	19.2	96%	1%	20.2	101%	6%
25	20	20.0	100%	20.0	100%	0%	21.0	105%	5%
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
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