turning student scores into a level???

T

teacherphil

I have a series of student test marks between 0 and 40. I have to tur
these into a national curriculum (UK) level. I have the grad
boundaries, but they are not linear.15=level3. 19=level4. 26=level 5
34=level6. I can easily use an if function to level these scores
however, I want to level them as 4.3, 6.1 etc. Short of using looku
and making a table 50marks long with the appropriate levels next to it
is there a way I can do this without cluttering up my sheet.

Any help would be appreciated

Phi
 
B

Bob Phillips

A lookup is the way to go, you only create it once, it is easily
maintainable, it can be off the visible screenj or even in a different
worksheet.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"teacherphil" <[email protected]>
wrote in message
news:[email protected]...
 
P

Pete

You can also get Excel to fill the numbers 0 to 40 for you, so you only
have to type in what grades each score represents. You might want to
set the grades column as Text before you enter the data, so that 3.0
(if such a grade exists) does not show as just 3.

Pete
 
J

Jim B

see the select function
and either use the help facility, or google for samples

JimB
Bob Phillips said:
A lookup is the way to go, you only create it once, it is easily
maintainable, it can be off the visible screenj or even in a different
worksheet.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"teacherphil" <[email protected]>
wrote in message
Click to expand...
 
Top