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

Hi Andy, I've had something similar caused by lessons scheduled with no teacher or room. The fix for that is in SIMS focus, curriculum structure edit lessons and delete any lessons that have no staff or room. Then in T6 make sure every session has them (placeholder values if necessary). Good luck Ed

Hi Mark, You can do this with Row Level Security in Power BI but the people you're sharing with need Power BI Pro licences so there's a cost (around £20 per year/per user I believe). Not sure if Google Data Studio can do this - I'd be very interested to hear if anyone's done wiht that or any other free tool Good luck, Ed

Hiya, I think periods exist across the cycle, so the only way to do this would be to create one for each start time. So you have a period from 8.45 to 9, then from 9 to 9:35 then 9:35 to 10 etc. So on a normal day period 1 is a double of the second and third period, on the weird day it's a double of the first and second. It would be tricky to label both of these as 'period 1' though, so you might need to come up with a new naming system. Good luck Ed

I'd like to echo @Ditto 's comments about Arbor's culture having worked with them to create power bi resources and promote the MIS's BI connectivity. It's not only a really friendly company, there's also a deep commitment to understanding and improving schools.

The tragedy of this thread is that pot of gold at the end of the rainbow is having to do your timetable on etimetable Thoughts and prayers @kennysarmy

I've worked for both companies (tho I don't stand to gain anything from you choosing either one), used Bromcom a lot and Arbor a little - here's my opinion: Arbor's UI is a lot nicer both in terms of how it looks and ease of finding stuff and the native analysis/ report writing tools are way better than Bromcom's (which are a bit rubbish). However, Arbor have less experience in secondary and I hear that assessment set up and exams are a bit clunky. Assessment in Bromcom is a real strength - you can set up a whole school tracking system from flat in about an hour - with all the formulas/conditional formatting etc that are available in Assessment Manager. Automating workflow (eg. behaviour events to detentions) is also good in Bromcom although I'm not sure how this works in Arbor so can't say that it's better. Bromcom would argue that their power bi capability makes up for their weak analysis module/reporting - you can get data from Arbor to BI just as easily as from Bromcom so that wouldn't necessarily be a clincher for me. However, Bromcom have a power BI viewer that lets you share dashboards published to a free account so that can save you money on BI licences (if you decide to go down that route). Both companies should give you access to a demo system (if they won't that's a red flag) - I'd say there's no substitute for havinga play yourself

Is this an issue with SIMS or Go4Schools? It makes sense that if a kid is in care then their ever in care flag would be true

Hi @danielstucke - I'm afraid in order to share both the sharer and the receiver need a power BI pro licence. If you want to get round this and continue without spending anything more the options are: -Publish the same file separately to many free accounts - could maybe use powershell to automate this process - annoying for you if not tho. -Publish to a generic free account and get users to all log into it: this will get annoying because sooner rather than later MS will force one of them to change the pw -Create a report with no individual level data and use the publish to web feature (possible for governors/trust users who have responsibility for school but limited use for interventions) -Put the desktop file on sharepoint for people to access: seems like it would be incredibly annoying for me but I've heard of schools doing this None of these are great I'm afraid - might be better to take a cold look at who is going to provide value for money with access and get pro licences for them Good luck - let us know if you come up with a better workaround Ed

Hi, it's been a while since I've used SIMS but I think it should be possible to sort this without creating timetable clashes. Get the data manager to create a Reporting Group (I think that's the term - a custom group of kids, rather than a class) of the KW kids. Then in Edit Marks you should be able to choose group type and select Reporting group and filter to just members of that group. Hope that works - system as it is sounds rubbish so there is definitely a better way. Ed

I don't know a way to do this in bulk, but I do have a small hack that will make doing them one by one slightly less tedious. When you open the list to choose a new resultset is the existing one selected or does it put you at the top? If the latter, edit the name of the resultset to make it '!Y7 Engage 1' - ie putting it first alphabetically. Then when you open the list to choose a new resultset it will already be selected and you can just hit return to close the list. If the existing one is selected then edit the name to make it 'xY7 Engage 1' then you can hit x to find it rather than using the mouse. After you're finished you change the name back to what it's supposed to be. Alt+U is also faster than using the mouse to close and update the edit aspect pop up. Good luck wading through the SIMS drudge Ed