philserre

I've added the 'Class' field to an existing assessment template. When I check the related marksheets the column 'Class' doesn't always appear, and when it does, it doesn't always have any data in the column. This seems to be happening randomly. Any ideas? PS: Is this the correct forum for this post?

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.

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.

Thanks, I've been thinking about that as a solution but I would want staff to enter a sub-level, 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?

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 sub-levels (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

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.

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.

Does anyone have any experience of using nested IF statements with more than 4 comparisons in SIMS?

When running an Individual Candidate Report in Exams Organiser I get the following message when selecting Print. " accessviolation@address 0013204 in module examsw.exe. readofaddress 5bf44587" This seems to be an intermittent problem so I suspect the data is OK. Is this user rights or system setup maybe?

I have uninstalled SQL server 2005 using Add Remove Programs in the hope of reinstalling it. Now all of the options are greyed out and I'm told that everything is already installed. Are there any simple fixes to try before getting into registry settings etc?

Thanks for the advice. We are planning to do this tomorrow. We orginally set this up in the reverse order so maybe second time lucky! Phil

We're trying to set up a test sims server before moving sims to a new server. If we start with a Windows 2003 server, which has no apps on it, what is the order of installation for SIMS and SQL server? Does it matter which way around these are done? We have tried putting sims on and sql server but cannot log in to sims and cannot locate the original sims instance in SQL Server Management Console. We didn't detach the database on the original server before copying it over, but did stop the sql server. Thanks, Phil

Thanks for the help with this. I may have interrupted a backup some months ago so that's probably where the files came from. I'll save them for a while and delete them when I'm sure they're dead.

Problem solved thank you very much. I removed all the zip files from Backup and tried SIMS again. The system recognised that there were no files to tidy. I then reintroduced one zip file to the backup folder and ran tidy backups successfully. I then dropped them all back in and it failed. Two of the files are very big and are .BAK files. One of the zip files is much smaller than the others. When I removed these 3 files the system worked again. Could these 3 files be the result of a previously failed backup routine which has prevented some Tools features from working? Should the .BAK files be in the Backup folder at all? Thanks again, Phil

I don't get as far as seeing the backups in Tidy or Restore Backups windows. As soon as I select Tidy backups the system hangs. The same with Restore.

In SIMS.net, System ¦¦ Tools, Create Backup works but the Tidy & Restore Backup windows just hang. Capita say I should reinstall SQL Server 2005 which I'd like to avoid unless necessary. Is there another way of fixing this? I've tried running SIMSSQLApplication.exe with no effect.