[sims] Deviation and GRADE TALLY COLUMNS

[LianneKemp]

Hi all I am trying to create a template in SIMS to track pupil deviation across all subjects at a particular reporting point. I want to create a formula to work out how many times a pupil has a particular deviation, eg. -2, 0 etc. When I select GRADE TALLY COLUMNS, the deviation columns in my spreadsheet don't show as an option to select which I think is because they are Marks-Integer.

Is there a way of getting around this? I thought about copying each deviation column using the EQUALS formula to create it into a grade but I'm not sure how this would work.

Any suggestions would be greately appreciated!!

Thanks!

Lianne

[number34]

Hi,

you are correct, you need a grade. I have an aspect called Ma GD with a gradeset with grades ....+2, +1, 0, -1, -2 etc and use a marks to grade formula to assign the grade. I like to emphasize the positive and negative values but it has a lot of other advantages as well. You will need to add a lot of aspects but worth it in the end I hope.

[LianneKemp]

Hi,

you are correct, you need a grade. I have an aspect called Ma GD with a gradeset with grades ....+2, +1, 0, -1, -2 etc and use a marks to grade formula to assign the grade. I like to emphasize the positive and negative values but it has a lot of other advantages as well. You will need to add a lot of aspects but worth it in the end I hope.

 

Thank you, I'll give that a go!!

[LianneKemp]

Hi,

you are correct, you need a grade. I have an aspect called Ma GD with a gradeset with grades ....+2, +1, 0, -1, -2 etc and use a marks to grade formula to assign the grade. I like to emphasize the positive and negative values but it has a lot of other advantages as well. You will need to add a lot of aspects but worth it in the end I hope.

 

Sorry I might be being really dense, but what did you have as values in your gradeset?

[number34]

Depends, for GCSE I use multiples of 6. So if target grade is B and current grade is D the difference is -12 which has a grade of -2 with a value of -12. Hope that makes sense?

(SIMS is very flexible and you can use values in the marks to grades formula that don't fit the grade set ones)

Edited June 4, 2013 by number34
left a bit out!!

[Ecclesbury]

If you want to avoid creating new Aspects a Flinstones way of doing this would be to create a group of hidden Data Review Formula columns using IF THEN ELSE forumlas that said IF column = -2 THEN output 1 ELSE output 0. Your visible column would then just be a SUM of all these columns.

 

This would be slightly tedious and messy if you had lots of columns and wanted a separate count for lots of different residuals but it would avoid having to create new aspects and would mean that you could keep your old Mark-Integer columns.

[LianneKemp]

Thanks both for your help, I went with creating aspects with gradesets which works well for us