+ Post New Thread
Results 1 to 2 of 2
MIS Systems Thread, SIMS MATHEMATICAL OPERATORS FOR MARKSHEETS in Technical; Does anyone know if there is an INTEGER function which can be applied to a marksheet in SIMS? I have ...
  1. #1

    Join Date
    Jan 2013
    Posts
    10
    Thank Post
    13
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    SIMS MATHEMATICAL OPERATORS FOR MARKSHEETS

    Does anyone know if there is an INTEGER function which can be applied to a marksheet in SIMS? I have some percentages which I want to change into whole numbers out of 10 - so 72% becomes 7 and88% becomes 9. I can do this easily in EXCEL but want my SIMS marksheet to do it with a calculated column. Does anyone know if this is possible.

    Thanks

  2. #2
    CAM
    CAM is offline

    CAM's Avatar
    Join Date
    Mar 2008
    Location
    Burgh Heath, Surrey
    Posts
    4,120
    Thank Post
    826
    Thanked 358 Times in 282 Posts
    Blog Entries
    60
    Rep Power
    281
    There is but being SIMS you have to do it the roundabout way.

    1) Set up a new Aspect. In this example I will call it EN-LEVEL. Make sure it is a grade aspect with a grade set consisting of 1-10 (you might need to create the grade set if you haven't already got one). Do not use Marks or Marks-Decimal as a shortcut, it must be a grade.
    2) Create a new column and choose Data Entry Using Formula.
    3) Set up a Marks to Grade column and tell it to use the aspect EN-LEVEL.
    4) Enter the criteria for the rounding. Example:

    Mark - Integer
    95 - 10
    85 - 9
    75 - 8
    65 - 7
    55 - 6
    45 - 5
    35 - 4
    25 - 3
    15 - 2
    5 - 1
    0 - 0

    In this example, 75 would round up to a grade of 8 whilst 84 would round down to a grade of 8.

    Also remember to tick Read Only to stop staff from altering the contents of the field and tick "Calculate formula automatically" in the template screen. Otherwise staff will either complain that the formula "doesn't work" or amend the formula to what they think is correct then complain the sheet overwrites their amendment.

  3. 2 Thanks to CAM:

    neil27 (5th January 2013), vikpaw (7th January 2013)

SHARE:
+ Post New Thread

Similar Threads

  1. [SIMS] SIMS Connection failed for Login USERNAME reason: 0
    By tech_guy in forum MIS Systems
    Replies: 42
    Last Post: 17th July 2014, 01:25 PM
  2. [SIMS] SIMS Learning Gateway for Divorced Parents
    By fiza in forum MIS Systems
    Replies: 10
    Last Post: 23rd February 2012, 02:22 PM
  3. [SIMS] Running an addional sims.net database for testing.
    By sj2780 in forum MIS Systems
    Replies: 18
    Last Post: 12th January 2012, 07:29 AM
  4. [SIMS] [SIMS] Extract CTF for RAISEOnline
    By CAM in forum MIS Systems
    Replies: 8
    Last Post: 28th June 2011, 01:48 PM
  5. [SIMS] SIMS Server Hardware for a large School
    By Johan in forum MIS Systems
    Replies: 32
    Last Post: 26th June 2011, 11:04 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
  •