ZombieBatman

Thanks for all the responses, Some good ideas here! The sheer number of classes that I am producing these for was the issue. I tried the pivot table idea as well before posting on here but with over 500 classes and 2 tracking grids required per class I had 1000 pages to produce (and on a regular basis). So even 1 minute a page would still be 1000 minutes worktime. I've found a solution though (thanks to help you've all given). I've calculated the level of progress data I require as an assessment/marksheet (it displays all the same data as the tracking grids i.e who is on target etc hence condensed two tracking grids into one). I used Ecclesbury's Lookup table suggestion as it meant I could create one uniform template for all my subjects. I had some results as sublevels and some as whole- converted them all to whole using Lookup tables and 'Marks to grade' on the result to turn it into a level. With that done I could simply clone my template and switch aspects in the formulas. So everything is now automatic AND I get more detail AND its less paper used. I just have to update the result sets every time and hit print. In regards to chance analysis- I used that until recently but have recently required more detail.

thanks for the advice so far. I am aware that ks3 is on the way out and not collected but this is an idea taken at a school level to try and aid staff monitoring their students. I have setup a marksheet that calculates ks2-ks3 levels but the darn sublevels tend to make it slightly inaccurate.

Also as I neglected to say: I do have discover. Any suggestion discover wise would be fine. A marksheet idea would be fine too. Long as it can show the level of progress. I have that for ks4 but not ks3- if anyone can point me towards how to make a ks2 to ks3 levels of progress calculator on the marksheets- that'd be excellent in itself. If using a marksheet- I guess I'd need a way to calculate the expected level of progress, the amount of progress the student is targetted to achieve, the current progress the student has achieved and whether the current progress is on target/above/below expectations. If anyone has any help with that- that'd also be appreciated/excellent I'm in the unfortunate position of having to get to these done as soon as possible so anything that anyone has would be a massive help! thanks again

Hello everyone, I've recently become a SIMs user and I've had a mammoth of a task. I've exported about 1000 tracking grids in the past week. It has been way too time consuming I need to make a quicker way to generate the same data What I am doing is placing ks2 sublevels as the rows and ks3/ks4 as the columns The 'target' would be the expected level of progress (e.g depending on year group 2 levels, 3 levels etc) However the catch is I've been doing that for every class in every subject and there are dozens of subjects and roughly 500 classes. I previously used chance analysis for this but the data needs to be printed with the students names. Would this be possible to generate using a report template? I just need something similar and a little more automatic than the grids as it will need to be used frequently I'll be extremely grateful for any help or suggestions anyone can offer Thanks