RootsSchImp

I think you'd have to export from the old school and import to the new one. If you make the column headings of the import csvs: <assessmenttype>$<term>$<yeargroup>$<subject> then when you go to Modules| Assessment| Manage Data and import them Bromcom will recognise them and you won't have to map them by hand.

Hi Gareth, You could do this by creating assessment types (integer) for A*-A, A*-C and A*-G. On your marksheet use a conditional column to give each student a 1 if they meet the threshold 0 if not. The average of these 1s and 0s is your percentage meeting threshold Good luck Ed

If you have write permission on the API (which I think they sometimes change as extra) you can do it. It's a bit of a faff if you aren't already set up with a tool for sending http requests. If you're not then I'd recommend power automate which can do it without you needing to write any code

ESS want to be careful sending long-winded legal threats to schools looking to buy other MIS systems, they could be misappropriating valuable Bromcom IP

HI Deepa, If you right click on the reg period in the cycle screen I think you'll see it's designated a non teaching period - in order to have classes there you need to turn that designation off. After you've done that you'll have to reexport the cycle to SIMS and after that the TT should go through. Good luck Ed

HI @duesouth, If you create a measure Avg reading age = AVERAGE('reading ages'[RA in Months]) Then create another measure using exactly the same code from your reading age calc column but with [Avg reading age] instead of the column reference then you'll have a slicer responsive age expressed in years and months

Nothing stopping you from building your own MIS and sharing the intellectual property

There's lots of ways you can do this but I think the simplest is: Combine your two results tables so you have results and targets in the same table. You do this is Power Query using 'Append Query'. Still in power query, join your mastery levels table using 'Merge Query' so you have the numerical value of each assessment on the main table (make sure the result type for this value is numerical). OK, so let's say you now have one table called 'Results' and in its Aspect column the value is either 'Current' or 'Target'. Your measure would be: Target Difference = CALCULATE( AVERAGE(Results[Points]),Results[Aspect]="Current") - CALCULATE( AVERAGE(Results[Points]),Results[Aspect]="Target")

NI schools are a job lot - they were all on SIMS and that contract win will move them all 1079 of them to Bromcom. Should be a walk in the park for their first rate infrastructure team.

I gave up using ad hoc reports years ago - they've always been garbage. Excel Addin / the odata feed are the best ways of getting data out of Bromcom IMO

Yeah that's right - you think of it as the aspect determining the 'what' e.g. Spanish Current Grade and the resultset determining the 'when' e.g. Year 9 Spring.

And once you've finally installed it it's terrible for timetabling. Garbage fires all the way down

Unless I'm missing something this way would require an execution of the report per subject which may not be practical. The way I would achieve it would be to merge the class report and the targets report in Power Query. Select your Class query, click Merge Query then in the dialogue select the target query as the one to merge, and click on student id in both as the first merge field. Then ctrl click the subject fields to match on subject as well. Then click OK. The merged query is shown as a single column - click on the out facing arrows at the top to expand it to the individual columns you want. Good luck Ed

The big drawback of custom BI datafeeds like Bromcom's OData is that you get what you're given. As a workaround you can: - create an ad hoc report in Bromcom with the data you want from last year - Use the live data feed option to get a weblink to bring the data into BI (in power query choose Web as the data source, paste in the link and authenticate type basic wiht your school's 5 digit id and your API key) - Still in Power Query make sure this last year data query has the same column names as the OData one (case sensitive). Then select the orginal query and use 'Append' to add the new one to it. That will mean your table in BI combines this years data (from OData) and last years (from the report). It means wrestling with Bromcom's garbage reporting module but you should be able to do that once then forget about it.

You can use Bromcom's API to write Assessment marks but not homework ones. Note that write access to the api usually carries an extra cost full list of the write api endpoints is here https://cloudmis.bromcom.com/Nucleus/WebServices/ThirdParty/TPWriteDataService.asmx