[sims] Traffic lights/colour coding

[tholding]

Hi

 

Does anyone have any documentation or instructions on how to set up traffic lights on termly assessment data?

 

Thanks

[tombry]

We use nested if else formulas to generate our colors.

 

You can tie it to an aspect if you already have them, otherwise you can use the "formula for review" column type.

 

But basically the formula goes like:

 

If Art Est > Art Tar, then populate the column with Above, and color it green

If Art Est = Art Tar, then populate the column with On, and color it yellow

If Art Est < Art Tar, then populate the column with Below, and color it red

 

At the bottom of the nested if else formula screen there is an option titled "Also color this column", select that, and then choose your Art Est field to also color - this makes it so when you send the reports home, the aspect keeps its color.

[vikpaw]

There might be a few threads on here with info, or you can use the basic formulae as provided by tombry.

Quite a bit of resource here but maybe no specifics 12 Point 'On Track' Analysis Marksheets - SIMS Assessment Manager Blog

The other blog entries are very good too.

[tholding]

Thanks very much