# Deviation and GRADE TALLY COLUMNS

• 4th June 2013, 11:06 AM
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
• 4th June 2013, 11:46 AM
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.
• 4th June 2013, 12:38 PM
LianneKemp
Quote:

Originally Posted by 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.

Thank you, I'll give that a go!!
• 4th June 2013, 03:21 PM
LianneKemp
Quote:

Originally Posted by 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.

Sorry I might be being really dense, but what did you have as values in your gradeset?
• 4th June 2013, 03:38 PM
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)
• 4th June 2013, 04:17 PM
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.
• 5th June 2013, 12:43 PM
LianneKemp
Thanks both for your help, I went with creating aspects with gradesets which works well for us :)