rsides

I need to set up a formula that identifies the top 5 highest performing students from a list of results. I also need to break this down further into the top 5 from each year group. Any ideas of the best formula to use.

Thank you both. The error message that I am getting now is "no schemes derived from the selected group". Any ideas?

Good Morning, I am after some advice regarding the promotion of students into the new academic year in SIMS. At the moment the students are showing on the pastoral lists as members however when I look at the academic structure and then curriculum assignments there are no students. I have gone through the SIMS help book a couple of times now but nothing seems to be working and when I spoke to CAPITA yesterday they just confirmed everything that I already knew and told me to change the date to the first day the students where in school in September and all the students should show up (which they haven't) Any ideas on what I have missed or am not doing? Thanks

Hi, Does anyone know how to make a pivot table count in Excel show names rather than numbers? I want it to create a matrix tracking students KS2-current data outside of SIMS. Thanks

Hi, I am using the following formula to calculate a students progress from KS2 to KS4 (eg 3B to B1) however the students with no KS2 data or a B for below average isn't calculating correctly. =IFERROR(VLOOKUP(((VLOOKUP(LEFT(U3,1),Lookup!$A:$B,2,FALSE)-VLOOKUP(VLOOKUP(1*LEFT($O3,1),Lookup!$H:$J,2,FALSE),Lookup!$A:$B,2,FALSE))/6)*1,Lookup!$L:$M,2,FALSE),"") I am asking the formula to look at the KS4 sub level first (U3) and then the KS2 (O3). The lookups are below A:B Lookup [TABLE=width: 48] [TR] [TD]a~*[/TD] [TD=align: right]58[/TD] [/TR] [TR] [TD]a[/TD] [TD=align: right]52[/TD] [/TR] [TR] [TD]b[/TD] [TD=align: right]46[/TD] [/TR] [TR] [TD]c[/TD] [TD=align: right]40[/TD] [/TR] [TR] [TD]d[/TD] [TD=align: right]34[/TD] [/TR] [TR] [TD]e[/TD] [TD=align: right]28[/TD] [/TR] [TR] [TD]f[/TD] [TD=align: right]22[/TD] [/TR] [TR] [TD]g[/TD] [TD=align: right]16[/TD] [/TR] [TR] [TD]u[/TD] [TD=align: right]0[/TD] [/TR] [TR] [TD]x[/TD] [TD=align: right]0[/TD] [/TR] [/TABLE] H:J Lookup [TABLE=width: 101] [TR] [TD]A[/TD] [TD]F[/TD] [TD]E[/TD] [/TR] [TR] [TD]B[/TD] [TD]F[/TD] [TD]E[/TD] [/TR] [TR] [TD=align: right]1[/TD] [TD]F[/TD] [TD]E[/TD] [/TR] [TR] [TD=align: right]2[/TD] [TD]E[/TD] [TD]D[/TD] [/TR] [TR] [TD=align: right]3[/TD] [TD]D[/TD] [TD]C[/TD] [/TR] [TR] [TD=align: right]4[/TD] [TD]C[/TD] [TD]B[/TD] [/TR] [TR] [TD=align: right]5[/TD] [TD]B[/TD] [TD]A[/TD] [/TR] [TR] [TD=align: right]6[/TD] [TD]A[/TD] [TD]A*[/TD] [/TR] [/TABLE] L:M Lookup [TABLE=width: 38] [TR] [TD=align: right]-3[/TD] [TD=align: right]0[/TD] [/TR] [TR] [TD=align: right]-2[/TD] [TD=align: right]1[/TD] [/TR] [TR] [TD=align: right]-1[/TD] [TD=align: right]2[/TD] [/TR] [TR] [TD=align: right]0[/TD] [TD=align: right]3[/TD] [/TR] [TR] [TD=align: right]1[/TD] [TD=align: right]4[/TD] [/TR] [TR] [TD=align: right]2[/TD] [TD=align: right]5[/TD] [/TR] [TR] [TD=align: right]3[/TD] [TD=align: right]6[/TD] [/TR] [/TABLE] An example of it not working is a student who has a B for KS2 data and is currently achieving a D1 therefore is making 2 levels of progress however the formula is leaving the cell blank. Have I missed something from the formula to make it calculate? Thanks and I hope this is making sense.

Thank you both. You've saved my sanity. Its been driving mad as I knew there was a way to do it just couldn't make the correct connection to the right formula

I want to transfer a cells information from one page to another without using a Vlookup and using the = formula ie ='SIMS Sheet A3' but don't want the blank cells to show as 0. Is there away?

Hi, I've been asked to add additional intervention types on the behaviour management tab. Is there a way of doing this?

Is there a way of removing the ability to add behaviour and achievement points whilst in register view. We're having an issue with staff not completing the information via this route so want to make them go into each student and complete the required information rather than using the shortcut. Thanks

Thanks that's saved me a lot of work

Just add them from scratch at the moment. - - - Updated - - - Yes some of them do. What setting do I need to change. This is the first time I have noticed it happening.

Hi All, I have recently noticed when I come to add aspects to some of the templates within SIMS I am unable to do so as they are missing. I have double checked that the aspects are still active which they are and as stupid as it sounds also checked several times that I have not already added it to the template, which I haven't. Has anyone else experienced missing aspects even though they exist on other templates and are active? If so, have you found a solution to why they aren't appearing?? Thanks

Hi, I'm having trouble with a look up table and wondered if anyone could advise. The idea is to forecast what a student is going to achieve in Year 11 from their KS3 data (Years 7-9) which is currently being inputted by staff members. I have created the attached lookup table however, I don't think I have done it correctly as nothing is being calculated when KS3 data is inputted. I know chance tables are available but SLT want teachers to see a forecast on their marksheet. Any advice or ideas gratefully received. ThanksDoc1.pdf

It doesn't seem to be working....is there something I could have missed? I've created a column via data review using formula and followed the above but the boxes aren't colouring.

Hi, I want a formula to use within SIMS for a column which measures a students effort for homework based on letters P, G, A, R. Once the staff member has rated them using the letters I want the column to change to the appropriate colour, blue, green, amber & red. How would I do this? Thanks,