+ Post New Thread
Results 1 to 8 of 8
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 ...
  1. #1
    ChrisH's Avatar
    Join Date
    Jun 2005
    Location
    East Lancs
    Posts
    4,988
    Thank Post
    120
    Thanked 283 Times in 261 Posts
    Rep Power
    107

    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?

  2. #2

    Join Date
    Dec 2009
    Posts
    59
    Thank Post
    2
    Thanked 8 Times in 6 Posts
    Rep Power
    14
    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.

  3. Thanks to resin1 from:

    ChrisH (27th September 2010)

  4. #3
    ChrisH's Avatar
    Join Date
    Jun 2005
    Location
    East Lancs
    Posts
    4,988
    Thank Post
    120
    Thanked 283 Times in 261 Posts
    Rep Power
    107
    Quote Originally Posted by resin1 View Post
    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 will do.

  5. #4

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,682
    Thank Post
    692
    Thanked 1,408 Times in 1,166 Posts
    Rep Power
    354
    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'.

  6. #5

    Join Date
    Dec 2009
    Posts
    59
    Thank Post
    2
    Thanked 8 Times in 6 Posts
    Rep Power
    14
    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.

  7. #6

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,682
    Thank Post
    692
    Thanked 1,408 Times in 1,166 Posts
    Rep Power
    354
    I thought it would handle middle values and round down to the nearest, if that's what you mean.

  8. #7

    LosOjos's Avatar
    Join Date
    Dec 2009
    Location
    West Midlands
    Posts
    5,528
    Thank Post
    1,462
    Thanked 1,214 Times in 823 Posts
    Rep Power
    724
    Quote Originally Posted by vikpaw View Post
    I thought it would handle middle values and round down to the nearest, if that's what you mean.
    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.

    e.g.
    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)

  9. Thanks to LosOjos from:

    ChrisH (28th September 2010)

  10. #8
    ChrisH's Avatar
    Join Date
    Jun 2005
    Location
    East Lancs
    Posts
    4,988
    Thank Post
    120
    Thanked 283 Times in 261 Posts
    Rep Power
    107
    Quote Originally Posted by LosOjos View Post
    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.

    e.g.
    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)
    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.

SHARE:
+ Post New Thread

Similar Threads

  1. Assessment Manager
    By Edu-IT in forum MIS Systems
    Replies: 11
    Last Post: 29th October 2010, 02:10 PM
  2. SIMS Assessment Manager 7
    By dhance in forum MIS Systems
    Replies: 19
    Last Post: 9th September 2010, 11:18 AM
  3. [SIMS] Aspects - assessment Manager
    By rh91uk in forum MIS Systems
    Replies: 13
    Last Post: 22nd July 2010, 06:02 AM
  4. How does your school use assessment manager?
    By thegrassisgreener in forum MIS Systems
    Replies: 9
    Last Post: 19th December 2007, 10:20 AM
  5. Assessment Manager
    By beeswax in forum Educational Software
    Replies: 3
    Last Post: 9th December 2005, 03:16 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •