+ Post New Thread
Page 1 of 2 12 LastLast
Results 1 to 15 of 26
MIS Systems Thread, Using = blank in an Assessment Template in Technical; Hi, Is it possible to use the following formula in SIMS.net if [Column/Constant] = blank , then use [Column/Constant]? ifthenelse.png...
  1. #1
    bastonc's Avatar
    Join Date
    Mar 2009
    Location
    Bedale, North Yorkshire
    Posts
    18
    Thank Post
    1
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Using = blank in an Assessment Template

    Hi,

    Is it possible to use the following formula in SIMS.net

    if [Column/Constant] = blank, then use [Column/Constant]?

    ifthenelse.png
    Last edited by bastonc; 28th June 2013 at 02:31 PM.

  2. #2

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,848
    Thank Post
    671
    Thanked 1,383 Times in 1,145 Posts
    Rep Power
    350
    No i don't think so, it might depend on the column type. I'm sure there are tricks to overcome this, like adding something to all columns like 0 if it's numeric, then testing for 0.

  3. #3
    bastonc's Avatar
    Join Date
    Mar 2009
    Location
    Bedale, North Yorkshire
    Posts
    18
    Thank Post
    1
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Hi vikpaw,

    Thanks for your response.

    I am now trying;

    if points column A is >0, then use whats in grade column B otherwise use whats in grade column C

    I'm still not getting anywhere.

    Any ideas?

  4. #4
    tombry's Avatar
    Join Date
    Jan 2012
    Location
    Bassingbourn
    Posts
    194
    Thank Post
    45
    Thanked 37 Times in 29 Posts
    Rep Power
    22
    I know when I made my Eng Bacc aspects it was an absolute pain, as it seems that SIMS counts a blank as both >0 and <0 (or 1).

    what are you trying to get your marksheet to do?

  5. #5
    bastonc's Avatar
    Join Date
    Mar 2009
    Location
    Bedale, North Yorkshire
    Posts
    18
    Thank Post
    1
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Hi tombry,

    I’m trying to have it so that if a pupil has a KS2 level then that is used to calculated their end of year/end of KS target, if they haven't got a KS2 level (many of our Service Pupils don’t) then use their subject baseline level.

    So,

    If [KS2] =”” then [Baseline] otherwise [KS2]

    I have also tried,

    If [KS2 pointscore] <= 0 then [Baseline] otherwise [KS2]

    Hope that makes sense

  6. #6
    tombry's Avatar
    Join Date
    Jan 2012
    Location
    Bassingbourn
    Posts
    194
    Thank Post
    45
    Thanked 37 Times in 29 Posts
    Rep Power
    22
    well, I think you could probably do it like I had to do my EBacc then.

    set a column to grade tally the KS2 aspect, tallying all grades, then set a column to count if that tally column = 1, make that Y/N

    then your if else statement is if your Y/N field = Y, use KS2, else Baseline

    make sense?

  7. #7
    bastonc's Avatar
    Join Date
    Mar 2009
    Location
    Bedale, North Yorkshire
    Posts
    18
    Thank Post
    1
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    thanks tombry,

    I'm getting there with it.

    I now have a column with 1.00's and blanks.

    I can't find 'count' from the formula type column, am I missing something?

    Also tried

    if [tally column] =1.00 use [KS2] else [Baseline] but nothing.

  8. #8
    tombry's Avatar
    Join Date
    Jan 2012
    Location
    Bassingbourn
    Posts
    194
    Thank Post
    45
    Thanked 37 Times in 29 Posts
    Rep Power
    22
    sorry, didn't mean "count" - it's a simple If Then statement, if tally column = 1, then Y, else N

    and I don't know why it works one way and not the other, neither did my LA support team

  9. #9
    bastonc's Avatar
    Join Date
    Mar 2009
    Location
    Bedale, North Yorkshire
    Posts
    18
    Thank Post
    1
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Ok, so I now have:

    a column that puts a 1.00 where there are [KS2 level]

    a column that puts a Y if there is a 1.00

    a column thats equals the Y column (because it wouldn't let me if a if column)

    and the actual calculation column

    if Y then [KS2], else [Baseline]

    Unfortunately I'm still not getting any baseline appearing for pupils with no KS2

    I have noticed aswell that there are no N's appeaing in the rows with no 1.00's

  10. #10

    Join Date
    Sep 2006
    Location
    Reading
    Posts
    177
    Thank Post
    14
    Thanked 41 Times in 39 Posts
    Rep Power
    22
    This probably not much help but...
    In similar situations I have given up trying to use a formula as there is just not the functionality in SIMS. I have all the relevant aspects in a template, make up mark sheets as required and then used the filters at the top of the columns to search for blanks. I then filter the other columns and just copy from column to column as required..

  11. #11
    tombry's Avatar
    Join Date
    Jan 2012
    Location
    Bassingbourn
    Posts
    194
    Thank Post
    45
    Thanked 37 Times in 29 Posts
    Rep Power
    22
    Yeah, the Ns don't matter so much.

    Now I'm stumped.

    sorry.

  12. Thanks to tombry from:

    bastonc (1st July 2013)

  13. #12
    bastonc's Avatar
    Join Date
    Mar 2009
    Location
    Bedale, North Yorkshire
    Posts
    18
    Thank Post
    1
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    No worries tombry.

    Thanks for your help.

  14. #13

    tmcd35's Avatar
    Join Date
    Jul 2005
    Location
    Norfolk
    Posts
    5,620
    Thank Post
    845
    Thanked 883 Times in 731 Posts
    Blog Entries
    9
    Rep Power
    326
    Quote Originally Posted by bastonc View Post
    Ok, so I now have:

    a column that puts a 1.00 where there are [KS2 level]

    a column that puts a Y if there is a 1.00

    a column thats equals the Y column (because it wouldn't let me if a if column)

    and the actual calculation column

    if Y then [KS2], else [Baseline]

    Unfortunately I'm still not getting any baseline appearing for pupils with no KS2

    I have noticed aswell that there are no N's appeaing in the rows with no 1.00's
    An idea...

    Column 1 = KS2 grade
    Column 2 = Baseline grade
    Column 3 = If "column 1 < "value for lowest possible score" then "column 2" else "column 1"

    A "1C" is worth 7 points so IF "Column 1" < 7 THEN "Column 2" else "Column 1"

    SIMS should see the underlying value of th grades in column1 so there's no need to go through extra steps converting grades to values to make the comparison

  15. #14
    bastonc's Avatar
    Join Date
    Mar 2009
    Location
    Bedale, North Yorkshire
    Posts
    18
    Thank Post
    1
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Hi tmcd35,

    Thanks for your post. I have tried it and still have the same problem.

  16. #15
    bastonc's Avatar
    Join Date
    Mar 2009
    Location
    Bedale, North Yorkshire
    Posts
    18
    Thank Post
    1
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    CRACKED IT!!

    Changed the if statement column from Data Review with Formula to Data Entry with formula

    Then went through the original process;

    if [KS2] = "" then [Baseline], else [KS2]


SHARE:
+ Post New Thread
Page 1 of 2 12 LastLast

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
  •