NeilF

Hello, You could try this, you can add the subject code as a filter as well if needed.

Hi, I think the write back to the default teacher happens when the teacher who initiated the event is not 'synchronised with your school management system'. When you look at a list of teachers in ClassCharts you will see that not all have the left/right arrows next to their name. These teachers have been created manually and they are the ones who are responsible for the mis-labelled comments.

Hi, Which bit of this is causing you problems? Creating the marksheet, linking to classes or accessing the data?

Hi, Assuming that the child has taken SATs and that you have imported a CTF which contained the results, a quick way is to select the pupil, click Assessment in the Links on the right of your SIMS window, change the start date to something before the student could have taken SATs and click Refresh. Click on the Result Date header to sort on date and some of the first results should be EN KS2: Reading Test Scaled Score AWL and MA KS2: Maths Scaled Score AWL. That's your SATs. You probably already have a marksheet that shows these. If you don't see these then you will need to log into the DfE site and enter the UPN of the pupil into the Get Information About Pupils section. You could download a CTF and fill in the blanks for the pupil, but I think you should just get the CSV and read the numbers from there.

Hello, If you are starting this from the new year and want to run it at the end of each week then you can use the answer above was a way of running a whole years worth where you would design a report to show Late attendance marks with dates then use a pivot table to do the hard work.

Hi, You can create a report showing Year, Date and Mark with a filter on mark to restrict it to 'L'. Use a pivot table to do the work and you should be mostly there. This video shows how to beat the dates into submission for use in the table - https://www.youtube.com/watch?v=Ya10z2gfRB8. Then you just need to make sure any missing dates are sorted out and you should then have some numbers to play with.

Grade sets impose validation rules on the data entry into the aspect, allow comparisons and calculations and if you right click on the column header in a marksheet for a class and choose Show Grade Distribution you can see how the grades apply to the cohort the marksheet is set up for. Glad you have it working.

Have a look at this to see if it helps. The grade set and the aspect have the same name - this is just me, don't be confused. They are not the same thing, just imagine them with different names. Grade set KS2 aspect KS2 calculation

Just a quick check - you have clicked on the Calculate icon.

This is a screenshot of ours - you'll just have to keep trying to work out where you might have it set up differently.

First, create a gradeset for your KS2 levels so you can use grade distribution in marksheets. Create your aspect for "KS2 on entry" for these KS2 levels. Add a Column for data review using formula and calculate the mean of your 2 KS2 scaled scores. Add a column for data entry using formula and use a nested if-then-else to test the thresholds against your calculated column and assign the appropriate grade to your KS2 On Entry aspect. The DfE in their Secondary accountability measures - update give the thresholds as Low < 100 Mid >= 100 but <110 High >=110

According to a Capita doc from 2017 Schools that act as their own Admissions Authority will receive an Admissions Data Transfer (ADT) file from the LA for import into SIMS. This file contains details of all the applicants who have specified a preference to attend the school. so it may be intended for the school. Probably best to contact the LA.

Yes, formulas - so many Excel! You would just need to be aware of unintended consequences of allowing new changes in something that may have been calculated elsewhere that is then used to calculate something else incorrectly.

If all you need to do is change review to entry and there are no functions involved and the columns are not duplicated for entry with the same result set, then what could possibly go wrong?

You could have a look at exporting the template, amending the xml and re-importing the changed template. All the tags that determine whether it is entry/review are there. Try a test on a simple template with a couple of aspects, one Entry and one Review to see how it works.