Microsoft Office Tutorials and References
In Depth Information
MAX and MIN—Recording Highs and Lows
Figure 3–25. Test scores, about to be boosted by three points each
So how do I go about padding these pause-giving scores by those three points? Gordon’s score is in
cell D11, and so I could write the following in E11, couldn’t I:
=D11+3
Sure I could. Then I’d return to cell E11, and utilize my newfound double-click-on the fill-handle trick.
I’ll bring about this revised grade distribution (Figure 3 - 26):
Figure 3–26. Nice guy: the three-point curve, now in effect
Are my calculations correct? Absolutely; but still I wouldn’t recommend this approach. That’s
because if I conclude that I need to award my charges say, 5 points instead, I’d need to edit the formula
in E11 to read:
=D11+5
and then copy that rewritten expression down the column again, so that all the students will enjoy my 5-
point largesse. Not an enormously big deal, but not an elegant way in which to proceed. As a rule, one
wants to avoid editing cells if one can; it can get messy, and a preferable alternative would be to enter the
5-point bonus figure in a cell—say in this case, A11, and rewrite Gordon’s formula thusly:
=D11+A11
and copy it down the column. And exactly why is this approach recommended? Because if I change
my mind again and issue a 7-point curve, all I need do is type 7 in cell A11, and all the scores should
change automatically—with no additional cell editing required.
 
Search JabSto ::




Custom Search