skinsley

A quick fix I used in a similar situation was to create an Aspect (Comment) Called Head of Year. I then created a marksheet containing this aspect and bulk populated it. It means I can call it up in a report using Assessment result. A quick and dirty method but it works for me.

I agree with Nadeem, Mapilabs Mailmerge Toolkit Pro is excellent. It is best to attach pdf files in preference. Prepare them first and store them in a single folder and you can have personalised emails with a different pdf for each recipient.

I find ASAP utilities (free version) very useful for things like this.

Hi, I have had to do something similar at my school so I have a word mailmerge document and an excel spreadsheet which I use. I have attached anonomyzed versions them in a zip file, please feel free to play around with them if it helps. You will have to recreate the link in the Word document as it is set up for my machine and the pathname for the excel source file will be different, but that is fairly minor. Just put the data into the spreadsheet, I have a SIMS marksheet which allows me to populate it easily. If you change the headings you can change the fields in the Word document. Hope this helps. Steve Login Mail Merge Anonymised.zip

Me too!

Try this. I have put the report definition for it if you need it in the attached zip fileStudent Timetable check.zipStudent Timetable check.zip

This page may be of help if you want to use excel, but it will require some forethought and formula planning. https://www.get-digital-help.com/search-for-a-text-string-and-return-multiple-adjacent-values/

Hi, The 'Reporting' in the start up kit is not the reports which tend to be sent home, this I think is linked to Assessment Manager through Individual Report although it probably uses the reporting engine. Reporting in the Start up kit is basically everything in the Reports menu including the analysis tools and design/edit reports. Seems a silly way of doing it as the data seems totally linked - but that's SIMs.

Hi In Sims go to Reports-Design Report and select Open an Existing Report, from the Open Report select Focus-Behaviour Incidents and open the Behaviour Incident Report. You should be able to save that as a Report for you under a different name and modfy it to extract the information that you want. The default output is Word List I believe, but you can change the output to Excel. Hope this helps

Hi, the FSM end date is only populated when the student comes off FSM eligibility. If this date is within 6 years of the current date they are still flagged as PP. If there is no end date then they are considered to be still FSM and therefore PP and included in ever 6. To add to the confusion, if the student has got an end date but has become eligible for FSM again (after 6 Years from the end date) they are again ever 6 and until they have a new end date they are considered on FSM. I have attached a couple of Report Definition files (one Secondary, one Primary) which give Ever 6 sent from our LA support. If you import them, re-save and change the default output to excel they do help in identifying which students are in this sort of category. Oh, if they became FSM since the Census used for deciding on PP the won't be flagged as PP - just to make it even easier NOT! FSM Ever6 Primary 2020 (Approximate).zipFSM Ever6 Secondary 2020 (Approximate).zip

Try this Microsoft Access help, tutorials, examples, it is only up to Access 2010 but not too bad and quite well structured. I would advise that you get hold of either Access (Insert Version using Here) for Dummies or the Access (Insert Version using Here) Bible as they come with cd/dvd resources. A very good investment.

I think you will find it is because there is already a category called Subject under the CES Examination Services and you cannot have two Categories with the same name even if they are on different branches of the Category Tree.

In SIMS you can create User Defined Groups (Focus - Groups - User Defined Groups - New) but you normally have to add students one at a time, equally if you have Discover you can create Groups quite easily which can be accessed in SIMS. Whether these can be exported to Show My Homework I couldn't tell you as I do not have anything to do with that.

The data will still be there unless you deleted results. Was it the Name or Column Heading you altered on the aspect or did you just alter the Column Heading on the Template?

This sounds similar to something I do. The way I do it is to create a single template which contains the aspects which holds the current round of marks/Grades for all the subjects for a particular year. I then have a marksheet for the whole year, open it and export it unformatted. I do this for each year and copy all the sheets into a single prepared workbook with each year as a separate tab. I use the Reports-Student list-General Student list to create an excel spreadsheet which shows all student subject Groups and use this as a lookup. It takes a bit of time to prepare in the first instance but allows me to update, process and analyse very quickly, effectively less than an hour from completion of data entry for the whole school.Strand Analysis Master Modified 2019-20 Autumn Anonymised.zipStrand Analysis Master Modified 2019-20 Autumn Anonymised.zip I have attached an anonymised copy of the spreadsheet I use, feel free to play with it and adapt if useful. Good luck Steve