[sims] Marksheet Colour Coding - SIMS Assessment

[katbanham]

Hi all,

 

I'm hoping someone can help me with this:

 

We want to start sending reports home with colour coding instead of grades which we will extract from an aspect in a marksheet. However, I'm not sure how to create a column that will remain blank but will colour depending on a grade that is entered into a different column. For example:

 

[TABLE=class: grid, width: 400]

[TR]

[TD]Name[/TD]

[TD]Strand A01[/TD]

[TD]Strand A01 Colour[/TD]

[/TR]

[TR]

[TD]Bloggs, Fred[/TD]

[TD]Emerging[/TD]

[TD](blank but coloured red)[/TD]

[/TR]

[TR]

[TD][/TD]

[TD][/TD]

[TD][/TD]

[/TR]

[/TABLE]

 

'Strand A01 Colour' is the aspect that I would pull through into the report.

 

I am familiar with formula columns and have tried a few to no avail. Can anyone help?

 

Thanks!

Edited June 17, 2016 by katbanham

[dapaulio]

Are these exported into excel?

if so Conditional formatting

[katbanham]

Unfortunately not, we create reports in SIMS that link directly to the marksheet aspects.

[dapaulio]

Staff here export them to excel and have asked me in the past something of similar nature.

[katbanham]

Ah okay! I have been to a school where they managed to do it but I cant remember how - they definitely used a formula column in the marksheet.

[Mistert89]

It's something like using the conditional if then else in Sims which allows you to assign colours. Ages since I did this... Used to do rising/flat/falling between half terms, and colour this. Just avoid red background as red text till you save your mark sheet looks blank!! Choose a pastel pink shade for red background.

[Sylv3r]

We couldn't get the cells to be blank with no text but coloured. So we wrote the colour in each cell i.e. Red, Green, Amber etc.

 

Not sure if it's possible or not.

[bobsmith]

If you're intending all of this so that you have a printed report at the end of it, which doesn't have the emerging, but has a empty but coloured cell instead then this isn't going to work as it is.

 

The word document output can pull through an aspect with the colour it has from SIMS, but you're not actually storing a value in the aspect Strand A01 Colour. The best solution if you don't want "emerging" on the report would be to store the name of the colour as @Sylv3r suggested.

[carotheoptimist]

Hi

You could create nested if then else formulae in each template for each aspect that you want to be colour coded in the marksheets and in the Individual Report. Remember to have the colour reflected in the original aspect cell the staff enter data in by 'also colour this column' If your result sets are by term and year group then you can clone the first completed template for a subject and change each result set either invidually or if there are a number of aspects in each term shift and select them e.g. 'Term1' and use replace.

Hope this helps

[Esteban_Child_of_the_Sun]

To get an "empty" cell but colored in the reports is not possible with Assessment Manager Individual reports, however you can get pretty close. Create a grade type aspect with a single grade just containing a full stop character, add it in to your AM template to add a result of a full stop character and the appropriate color. Then on your report use this aspect and set the font size as small as you can (thus rendering the full stop character not visible)

[GeorgeVince]

To get an "empty" cell but colored in the reports is not possible with Assessment Manager Individual reports, however you can get pretty close. Create a grade type aspect with a single grade just containing a full stop character, add it in to your AM template to add a result of a full stop character and the appropriate color. Then on your report use this aspect and set the font size as small as you can (thus rendering the full stop character not visible)

 

Or, find a replace all "." with an empty string to get rid all full stops.

[ajp233]

I used to do this sort of thing by having the column that needed to be coloured at a fixed width. In the cell on the template I inserted the assessment result tag but inserted enough spaces so before the result tag so that the result would never be displayed in the cell (due to it's fixed width). I then had a vba macro embedded in the template that shaded the cell depending on it's contents.

 

I can dig it out for you if you wish?