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 ...
8th March 2013, 01:46 PM #1
- Rep Power
Sims Assessment Traffic Lighting data
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?
8th March 2013, 02:57 PM #2
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.)
8th March 2013, 03:20 PM #3
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
Originally Posted by Ecclesbury
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 03:23 PM.
2 Thanks to LosOjos:
Ecclesbury (8th March 2013), vikpaw (9th March 2013)
By J_Worth in forum MIS Systems
Last Post: 24th July 2012, 09:15 PM
By sparker in forum MIS Systems
Last Post: 19th November 2011, 07:23 AM
By ctaylor in forum MIS Systems
Last Post: 14th September 2011, 11:05 PM
By creese in forum MIS Systems
Last Post: 4th August 2011, 02:19 PM
By MACIT in forum MIS Systems
Last Post: 30th June 2011, 03:14 PM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Tags for this Thread