bastonc

Thank you all for your input into this matter. I will set up a meeting with my LEA and Senior Team to prevent the Schools in my area from becoming a story on the 10 o'clock news. edit* I have just spoke to one of the schools veteran members of staff who seem to recall that about 7 years back the school didn't send this information to the local papers and the school had many calls from parents wanting to know why the school hadn't. I am all for not publishing the pupil specific results and will be pushing for the school to cease.

Interesting from what I had read the Schools in my area haven't been doing anything wrong it just doesn't seem to be the done thing. It will make my job easier on exam day though.

That is rather worrying then. The majority of schools in my area have been doing this for years. My school has been doing for at least the five years I have been here.

Hi all, Each year our local newspapers ask us to send them our GCSE Results in certain formats. This year is our first time using SIMS and I wandered if there is an easy way to export the results in the following format (I have used reports in Facility in the past); J Smith 4 (3); K Thompson 10 (8); B Brooks 10 (7) The number following each name should represent the number of GCSE or equivalent passes and the number in brackets is the passes at grade C or above earned by the candidate.

Hi Guys, I was using the formula type 'PLUS' for the “ZERO COLUMN + MA KS2 GRADE” by mistake. I have changed this to 'SUM' and it looks like its working. Thank you for all your help. P.S. Its a lot of additonal columns for what should be a very simple if statement.

Hi HughR, Please see the table below. Hope it helps. [table=width: 500, class: grid] [tr] [td]Maths KS2[/td] [td]Ma Year 7 Baseline[/td] [td]If(Maths KS2=BLANK,Ma Year 7 Baseline,Maths KS2)[/td] [/tr] [tr] [td]5c[/td] [td]4a[/td] [td]5c[/td] [/tr] [tr] [td]BLANK[/td] [td]5b[/td] [td]5b[/td] [/tr] [tr] [td]3a[/td] [td] 4c[/td] [td]3a[/td] [/tr] [/table] I have gone through the process you have described and in the "Zero Column+Grade Tally Column" column I am getting a list of 1's but no 0's.

Thanks HughR, I thought I had cracked it but I couldn't replicate the if statement. I will have a look at the equals formula you mentioned.

Scratch that, couldn't replicate it with other Subjects. pickled!

Scratch that its worked for one subject but not the other I've just tried.

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]

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

No worries tombry. Thanks for your help.

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

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.

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