MIS Systems Thread, Lookup table in Assessment Manager? in Technical; How could I do some kind off lookup table in AM? I have some grade boundaries I want to convert ...
27th September 2010, 08:58 AM #1
Lookup table in Assessment Manager?
How could I do some kind off lookup table in AM? I have some grade boundaries I want to convert to something else. Each step of the grades could be up to 5 points difference eg 80-85 = A 75-79 = B.
I thought I could use a grade set and use the points value in some kind of formula to convert it back to a grade in another grade set (No idea if that would work), but I wondered if there was a more straight forward way than this?
IDG Tech News
27th September 2010, 10:42 AM #2
Have a look at topic 25942 on SupportNet forum. Works fine exploiting the lookup formula. I have some templates that have some formulas using values of the gradeset and some using values from a lookup, off the same grade aspect.
Thanks to resin1 from:
ChrisH (27th September 2010)
27th September 2010, 10:55 AM #3
Thanks will do.
Originally Posted by resin1
27th September 2010, 11:09 AM #4
There is the function of having a lookup table, but sounds like you're after Marks to Grade formula. Is that in the article? Having trouble getting on to SupportNet at the mo'.
27th September 2010, 11:49 AM #5
Ah - well spotted Vik. Never tried the reverse, but the only problem probably would be that the lookup function acts like a vlookup(x,x,x,FALSE) rather than a TRUE which is what would be better for a grade boundary lookup. I expect you would have to enter every single value to map to each grade which would be a bit of a pain. I dont know if there is a limit of number of rows in the lookup builder, but assuming thats not an issue, then its still a quick job, since you can create the table in Excel and simply copy/paste into the lookup builder in SIMS.
27th September 2010, 01:45 PM #6
I thought it would handle middle values and round down to the nearest, if that's what you mean.
27th September 2010, 02:41 PM #7
I use the "marks to grade" column to convert grades between gradesets: it always rounds down to the nearest grade, which is fine for us but may not be what you want.
Originally Posted by vikpaw
a=58 (anything above 58 would become a)
b=50 (anything between 50 and 57 becomes b)
c=42 (anything between 42 and 49 becomes c)
Thanks to LosOjos from:
ChrisH (28th September 2010)
28th September 2010, 02:29 PM #8
I did get it working with the lookup but it is good to know about the rounding down as this will simplify things a little when applicable.
Originally Posted by LosOjos
By Edu-IT in forum MIS Systems
Last Post: 29th October 2010, 03:10 PM
By dhance in forum MIS Systems
Last Post: 9th September 2010, 12:18 PM
By rh91uk in forum MIS Systems
Last Post: 22nd July 2010, 07:02 AM
By thegrassisgreener in forum MIS Systems
Last Post: 19th December 2007, 11:20 AM
By beeswax in forum Educational Software
Last Post: 9th December 2005, 04:16 PM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)