MIS Systems Thread, KS3 Results SATs in Technical; Hi all
Does anyone know where i can get a lookup table to convert KS3 SAT results to a National ...
17th October 2007, 01:27 PM #1
KS3 Results SATs
Does anyone know where i can get a lookup table to convert KS3 SAT results to a National Curriculumn level?
So i can use Excel to convert say a score of 45 for science to a NC level of 5b etc... I know they already give a level but i wish to break it down even further.
IDG Tech News
23rd October 2007, 01:33 PM #2
Re: KS3 Results SATs
Not sure if there is one out there that is already created / populated because the boundaries change every year.
We took all of our results with marks and guessed the borderlines by ordering them in a spreadsheet.
We then just worked out fine grades by doing a nested if then else on each subject using the boundaries. We use 5.1,5.2,5.3 etc. rather than the a,b,c style (even though the dcsf recommend against it! 8O )
If you can get the boundary information then you can make your own lookup table in either Excel and use it in there or do it in sims (never used the lookup function myself).
The best thing to do is wait for the Fischer Family Trust data, they have fine grades (decimalised) worked out for you and all you have to do is decide what range is equivalent to a 5b/5c etc.
Many people use 5.0, 5.3 and 5.7, but i spoke to the guy that prepares the CAT test results and predictions and he said to use 5.3, 5.5, and 5.8 as the equivalent of 5a,5b,5c.
Our LA prepares a lot of data for us, and we'll receive the most up to date in a week or so. If you don't get info from them then it might be worth contacting the Fischer Family Trust direct, they now have their own website that you can log into and access your schools data. Not sure if our LA pays them on our behalf or not.
I guess they are trying to copy RAISE Online to a degree.
sorry it's not a solution but hope it helps.
25th October 2007, 01:12 PM #3
Re: KS3 Results SATs
cheers for your help mate, much appreciated
By mark80 in forum MIS Systems
Last Post: 24th August 2007, 11:08 AM
By ctbjs in forum ICT KS3 SATS Tests
Last Post: 9th July 2007, 05:57 AM
By Chafftech in forum ICT KS3 SATS Tests
Last Post: 8th December 2006, 01:49 PM
By russdev in forum ICT KS3 SATS Tests
Last Post: 3rd November 2006, 12:40 PM
By russdev in forum General EduGeek News/Announcements
Last Post: 8th November 2005, 11:15 AM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)