MIS Systems Thread, Nested IF statements in Technical; Does anyone have any experience of using nested IF statements with more than 4 comparisons in SIMS?...

16th November 2011, 11:24 PM #1
 Rep Power
 0
Nested IF statements
Does anyone have any experience of using nested IF statements with more than 4 comparisons in SIMS?


17th November 2011, 01:43 AM #2 Not that I have ever used SIMS but can you not do it with logical operators:
if (((studentStatus=='sick') AND (housecolour=='green')) OR (housecolour=='yellow')) then
?
If not does SIMS support CASE or SWITCH statments which are designed to evaluate lists of conditionals.


17th November 2011, 07:49 AM #3 @SYNACK SIMS  logical? LOL
@philserre  can it do more than 4? i've used the max which was 4 plus a default.
e.g. if less than 2 red else if less than 1 orange else if less than 1 white else if less than 2 blue else green.


17th November 2011, 09:30 AM #4
 Rep Power
 0
Thanks for the reply but the SIMS options are very limited. Whereas Excel is limited to 7 statements, SIMS is limited to 4 which means a more convoluted solution will be necessary, if possible at all.


17th November 2011, 09:44 AM #5
 Rep Power
 0
Thanks for your reply.
No, it can't do more than four  that's really the problem. I could just about live with seven. What I want to do is put 1 of 7 baseline National Curriculum grades in which then predict an outcome grade for three years later.


17th November 2011, 10:55 AM #6 Ah, i think i saw a similar post on support.
Anything complex is going to be a pain in SIMs. Most people move the data out to Excel, you could then reimport the predictions.
There are other methods used to make predictions, i think using trendlines and such, but we havent done that. Some people use other data like FFT, don't you have access to those, rather than doing your own formula?
What you would have to do, which is a pain, is to split the data at point 4 say and then store it in a new aspect. Then use the 4 + default formula on that if that makes sense. I have done similar for primary school maths tests, where they take two streams higher or lower. So split your baseline into two new temporary columns, run your conditions on both, such that one column gives the prediction on a scale and the other zeroes. Then add them together, and then convert that back to a predicted grade. I hope that makes sense.


17th November 2011, 06:05 PM #7
 Rep Power
 0
Yes, the 'similar post' was probably mine?!
I've had ago at what I think you suggested and it works in Excel OK. I've used the same logic in SIMS and I can't even get the first part to work. I enter the baseline grades and click ‘calculate’ and the baseline grades are all returned into the “4 pred grades” column. So I have two columns with the same grades in. If you have the time, and you feel inclined, please check the following for me.
I’m trying to produce a nested IF statement which looks at National Curriculum sublevels (e.g. 4c, stored in aspect “ICT Baseline”) and converts them into an end of Key Stage predicted levels.
So in the setup window for the formula column (called “4 pred grades”) I have the following:
IF “ICT Baseline” = “3a” THEN “5a” ELSE
IF “ICT Baseline” = “4c” THEN “6c” ELSE
IF “ICT Baseline” = “4b” THEN “6b” ELSE
IF “ICT Baseline” = “4a” THEN “6a” ELSE
“ICT Baseline”
I have ignored the colour options.
Because of the limit to 4 comparisons in SIMS, I was then hoping to repeat the NITE process for baseline levels 5c, 5b and 5a in a separate column (called “All pred grades”) to cover the full range.
IF “ICT Baseline” = “5c” THEN “7c” ELSE
IF “ICT Baseline” = “5b” THEN “7b” ELSE
IF “ICT Baseline” = “5a” THEN “7a” ELSE
“4 pred grades”
Thanks, Phil


18th November 2011, 11:44 AM #8
 Rep Power
 13
Within SIMS you could use the numeric value of the sublevel (as opposed to the grade) and use a formula to add the numeric value equivalent to two levels of progress to it. Did something similar recently for a secondary school myself.


18th November 2011, 11:56 AM #9
 Rep Power
 0
Thanks, I've been thinking about that as a solution but I would want staff to enter a sublevel, which is then translated into the grade set numeric value in a separate (hidden) column, before the final calc takes place. Any idea on how to do that translation without using another round of nested IF's?


18th November 2011, 01:16 PM #10
 Rep Power
 0
OK, I've worked it out now.
Instead of IF “ICT Baseline” = “3a” THEN “5a” ELSE, it's necessary to look back to the related SIMS grade set and put a numeric equivalent value into the formula.
3a = 23 points so the formula becomes IF “ICT Baseline” = “23” THEN “5a” ELSE and it works!
Thanks to all for the interest.


19th November 2011, 07:03 AM #11 What i said would be possible, but if you only need straigtforward mappings, then using the points value and gradesets would be easiest.
To make it even easier, create a gradeset with all your sublevels in, if you don't already. At my last school when ofsted was on the door, we went to the point of using extremely fine grades so we had decimals, 3.1, 3.2, ....3.9, 4 it took ages to setup, but so long as the points match the official ones for each actual level, and you split the ones inbetween, it's quite usable.
Not sure if that's what you're doing or not, but assume, 2 levels is 6 pts and your points scale is linear. Then get your formula to add 6pts to the baseline, then do a marks to grade formula which will convert the points back to a grade, using the fine gradeset. You could do the lot in 2 columns with no IFs.
Edit: actually, that's exactly what @iansimpson888 suggested.


19th November 2011, 09:48 AM #12 Just thinking, i also extended that gradeset to show negatives values as well, but had to managed the offset between zero and the first level to make it work  not sure what i did. Can't remember exactly how or why we needed to do that, something to do with calculating differences and lookups.


21st November 2011, 09:46 AM #13
 Rep Power
 0
I have used a KS3 gradeset but I was fooled by the way the SIMS formula operates since the process is so straightforward in Excel. I can't understand why NITE's are limited to 4 since most grade sets that school's will use involve more than four levels.
Thanks for your help with this.

SHARE: Similar Threads

By glennda in forum Web Development
Replies: 10
Last Post: 31st March 2011, 01:04 PM

By Flakes in forum Web Development
Replies: 17
Last Post: 29th March 2010, 01:42 PM

By park_bench in forum Office Software
Replies: 11
Last Post: 8th May 2009, 05:24 PM

By danIT in forum General Chat
Replies: 1
Last Post: 5th January 2007, 01:12 PM

By ajbritton in forum Jokes/Interweb Things
Replies: 6
Last Post: 26th April 2006, 12:09 PM
 [SIMS] Nested IF statements
Thread Information
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
 You may not post new threads
 You may not post replies
 You may not post attachments
 You may not edit your posts

Forum Rules