MIS Systems Thread, Converting UMS Marks to Grades in SIM's in Technical; Cheers Vikpaw we were able to work it out from the info you provided, as always really appreciatted we can ...

17th January 2013, 06:39 PM #16 Cheers Vikpaw we were able to work it out from the info you provided, as always really appreciatted we can kinda see where we could develop this more.


30th April 2013, 10:17 AM #17 Hi
I have just created a Grade Set in SIMS to convert a Total UMS Score into a Grade. The UMS grade is A*  360, A  320, B  280, C  240, D  200, E  160, F  120, G  80, U  79, U  0. As you can see, 79 is a U and so is 0 but SIMS doesn't let you have duplicate grades in a Grade Set, so i have had to leave it as 79 is a U. When i calculated my Marksheet, it doesnt populate a grade for anyone who has a UMS score of less than 79. I thought that SIMS would recognise a score as being less than 79 and know it is a U.
Is there something I am missing here?
Any help would be appreciated!!
Lianne


30th April 2013, 10:30 AM #18 @LianneKemp just have U set to 0 in your gradeset and it will assign U to anything over and above 0, but less than 80

Thanks to MattMitchell from:
LianneKemp (30th April 2013)

30th April 2013, 10:43 AM #19 Originally Posted by
MattMitchell @
LianneKemp just have U set to 0 in your gradeset and it will assign U to anything over and above 0, but less than 80
Just to expand a little, SIMS always rounds down to the nearest grade, therefore you should think of your scores as boundaries, where each score is the minimum required for that grade (the same way the exam boards do it). This is why setting U to 0 will result in anything less than 80 being a U, as at 80 it will be high enough to gain a G in your example gradeset

Thanks to LosOjos from:
LianneKemp (30th April 2013)

30th April 2013, 10:53 AM #20 Thanks both for your quick responses  ive changed U to 0 in the Grade Set and this has worked! Thank you!!


30th April 2013, 02:42 PM #21 Just when you thought that was the last from me (for today)...I've managed to sort out my grade sets now so the marks entered for different units are calculated into a grade, but my traffic light formula no longer works because the value of the target grade and the topic grade is now different (the target grade has the KS Point Score grade set  A 52, B  46 etc and the topic grade I have calculated is using an ISA grade set).
Is there a way you can convert a grade back to points, and then back to a grade again  so id be converting the newly calculated grade to the KS point score and then using this in my formula?


1st May 2013, 02:46 PM #22 A grade is actually just the underlying points score, what you see is the display view. You can add / multiply the grade and it will affect the points. You could then try to convert it to the other gradeset but there needs to be a relationship between one gradeset and the other. e.g. *5 + 10. Though it doesn't look that simple.


1st May 2013, 03:07 PM #23 Another method you can use is to create lookup tables. I do that here to convert AQA unit scores in to UMS and from there in to GCSE grades. I wrote a bit about how to do it over in the Data Managers group, here: http://www.edugeek.net/groups/datam.../#gmessage1884
You'd create your lookup tables as described above, then in an AM7 template you'd need a LOOKUP formula referencing your previously made lookup table, then a "Marks to grade" formula column which would convert your points back in to a grade. You can then hide your calculation columns and just show the grade if you want, makes it a bit easy for teachers to read
Last edited by LosOjos; 1st May 2013 at 03:09 PM.


1st May 2013, 05:27 PM #24 Workin on something more accurate but try * 7 30


4th May 2013, 08:10 AM #25 Wasn't sure if you can multiply / divide by decimals, but you can, so roughly * 6.67 and subtract 26.67 . Or for a better result do 3 formulae. Multiply by 20, Subtract 80 (well Plus 80) and then divide by 3. Gives the exact answer for the two sets you gave. You can then convert back to a grade.
A lookup table is way easier, i just 'needed' to know how they were linked. Plus if different sets of scores have different gradesets, you don't want to keep putting formulae in, a named lookup table is a much better reference and easier for someone else to follow.

SHARE: Similar Threads

By CatherineMay in forum MIS Systems
Replies: 11
Last Post: 4th July 2011, 09:18 PM

By AnnDroyd in forum MIS Systems
Replies: 3
Last Post: 15th January 2008, 01:36 PM

By Disease in forum MIS Systems
Replies: 18
Last Post: 13th December 2007, 10:04 PM

By iceman in forum MIS Systems
Replies: 2
Last Post: 29th August 2007, 12:58 PM

By richard in forum General Chat
Replies: 12
Last Post: 22nd January 2007, 11:21 AM
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

Forum Rules