+ Post New Thread
Results 1 to 3 of 3
MIS Systems Thread, Sims Assessment Traffic Lighting data in Technical; Hello! Does anyone know how to implement a traffic light system in marksheets in sims so you can tell if ...
  1. #1

    Join Date
    Jun 2011
    Location
    Gosforth, Newcastle upon Tyne
    Posts
    19
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Sims Assessment Traffic Lighting data

    Hello!

    Does anyone know how to implement a traffic light system in marksheets in sims so you can tell if a pupil is below at or above their KS3/GCSE target?

    Thank you,

  2. #2

    Join Date
    Mar 2011
    Location
    Bristol
    Posts
    119
    Thank Post
    24
    Thanked 24 Times in 20 Posts
    Rep Power
    18
    That's a fairly broad question, but if you have a current grade aspect and a target aspect with the same underlying grade set you can include a traffic light progress column as follows:

    Use a DIFFERENCE formula column to calculate the difference between the current and target
    Use a DIVISION formula to convert the difference to a number of grades/levels/sub levels (e.g. if you are using GCSE points scores you need to divide by 6)
    Use a NESTED IF THEN ELSE formula column to display a traffic lighted progress column (So IF 'Division Column' is Greater than 0 THEN show 'Division Column' and colour it green etc etc)

    There a few caveats and tweaks that you need to bare in mind in certain circumstances, but that should give you the basics (in fact, you can remove the division column if you only want to colour code above, at or below target.)

  3. #3

    LosOjos's Avatar
    Join Date
    Dec 2009
    Location
    West Midlands
    Posts
    5,452
    Thank Post
    1,439
    Thanked 1,170 Times in 798 Posts
    Rep Power
    707
    Quote Originally Posted by Ecclesbury View Post
    That's a fairly broad question, but if you have a current grade aspect and a target aspect with the same underlying grade set you can include a traffic light progress column as follows:

    Use a DIFFERENCE formula column to calculate the difference between the current and target
    Use a DIVISION formula to convert the difference to a number of grades/levels/sub levels (e.g. if you are using GCSE points scores you need to divide by 6)
    Use a NESTED IF THEN ELSE formula column to display a traffic lighted progress column (So IF 'Division Column' is Greater than 0 THEN show 'Division Column' and colour it green etc etc)

    There a few caveats and tweaks that you need to bare in mind in certain circumstances, but that should give you the basics (in fact, you can remove the division column if you only want to colour code above, at or below target.)
    You can actually cut out the DIFFERENCE and DIVISION calculations there - assuming they're both using the same gradeset, the NESTED IF can compare whether the grade is higher or lower than the target grade as it looks at the grade's underlying value as opposed to the grade itself

    For example if you had two columns, "Maths Target GCSE" and "Maths EGCuP GCSE", both based on the "GCSE Single" gradeset then your NESTED IF THEN ELSE statement would look like this:

    nested if then else.gif
    Last edited by LosOjos; 8th March 2013 at 02:23 PM.

  4. 2 Thanks to LosOjos:

    Ecclesbury (8th March 2013), vikpaw (9th March 2013)

SHARE:
+ Post New Thread

Similar Threads

  1. [SIMS] SIMS.net Training/Test Data
    By J_Worth in forum MIS Systems
    Replies: 11
    Last Post: 24th July 2012, 08:15 PM
  2. [SIMS] SIMs Security for sensitive data
    By sparker in forum MIS Systems
    Replies: 9
    Last Post: 19th November 2011, 06:23 AM
  3. Replies: 30
    Last Post: 14th September 2011, 10:05 PM
  4. [SIMS] SIMS 7.140 Training Data Sets
    By creese in forum MIS Systems
    Replies: 5
    Last Post: 4th August 2011, 01:19 PM
  5. [SIMS] Sims Assessment Manager Individual Reports
    By MACIT in forum MIS Systems
    Replies: 11
    Last Post: 30th June 2011, 02:14 PM

Thread Information

Users Browsing this Thread

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

Tags for this Thread

Posting Permissions

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