+ Post New Thread
Results 1 to 7 of 7
MIS Systems Thread, Deviation and GRADE TALLY COLUMNS in Technical; Hi all I am trying to create a template in SIMS to track pupil deviation across all subjects at a ...
  1. #1
    LianneKemp's Avatar
    Join Date
    Apr 2012
    Location
    Solihull
    Posts
    20
    Thank Post
    12
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Deviation and GRADE TALLY COLUMNS

    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

  2. #2

    Join Date
    Sep 2006
    Location
    Reading
    Posts
    177
    Thank Post
    14
    Thanked 41 Times in 39 Posts
    Rep Power
    23
    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.

  3. Thanks to number34 from:

    LianneKemp (4th June 2013)

  4. #3
    LianneKemp's Avatar
    Join Date
    Apr 2012
    Location
    Solihull
    Posts
    20
    Thank Post
    12
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Quote Originally Posted by number34 View Post
    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!!

  5. #4
    LianneKemp's Avatar
    Join Date
    Apr 2012
    Location
    Solihull
    Posts
    20
    Thank Post
    12
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Quote Originally Posted by number34 View Post
    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?

  6. #5

    Join Date
    Sep 2006
    Location
    Reading
    Posts
    177
    Thank Post
    14
    Thanked 41 Times in 39 Posts
    Rep Power
    23
    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)
    Last edited by number34; 4th June 2013 at 03:39 PM. Reason: left a bit out!!

  7. Thanks to number34 from:

    LianneKemp (4th June 2013)

  8. #6

    Join Date
    Mar 2011
    Location
    Bristol
    Posts
    121
    Thank Post
    26
    Thanked 24 Times in 20 Posts
    Rep Power
    18
    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.

  9. Thanks to Ecclesbury from:

    LianneKemp (4th June 2013)

  10. #7
    LianneKemp's Avatar
    Join Date
    Apr 2012
    Location
    Solihull
    Posts
    20
    Thank Post
    12
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Thanks both for your help, I went with creating aspects with gradesets which works well for us



SHARE:
+ Post New Thread

Similar Threads

  1. Replies: 1
    Last Post: 20th September 2009, 10:51 AM
  2. Pay and Grading - Bolton
    By tdkmillsy in forum General Chat
    Replies: 15
    Last Post: 24th November 2008, 09:38 PM
  3. Replies: 0
    Last Post: 2nd April 2008, 03:04 PM
  4. mini macs and midi
    By russdev in forum Mac
    Replies: 7
    Last Post: 29th November 2005, 03:08 PM
  5. Vids, Graphix and all that Sound
    By KeithFermor in forum Comments and Suggestions
    Replies: 3
    Last Post: 19th June 2005, 11:43 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •