Attendance report

[Mr_Hulse]

I want to run an attendance report broken down week by week. And that shows that week by weeks attendance for each pupil. And by year group.

 

Like this

 

I'm a SIMS newbie, so please go easy!

 

Edited July 10 by Mr_Hulse

[simpsonj]

This isn't going to be the most helpful of posts, other than to say you can do this, but I remember it being fairly complicated. The main issue is that when you pull attendance data, by default it will just show the latest data %. My very limited memory is that you have to add the attendance data for each week, then you can change each instance of the attendance data (a little button to the right hand side?) to show the attendance for that particular week. But I no longer have SIMS, and my memory is extremely limited!

[simpsonj]

There is also a nagging thought in my head that you can't pull the attendance % for a set time period, so you have to pull the Total Sessions, and then the 'attended' attendance codes (/ and E?) for the time period, then do the calculation for the attendance % in the spreadsheet.

[Devaleth]

You may also consider FFT Aspire? If you already have that service as a school for targets/benchmarking, there is a school attendance report that has exactly this kind of data readily available. This can be downloaded as a CSV or excel, or viewed live on the website.

 

Other than that, simpsonj's approach definitely works. You'd want to have two columns per week - one counting all the attendance codes that are included in attendance figures (e.g. not Y codes!), and then a second counting the present and AEA codes (and then do the attendance % calculation itself in excel or similar). I'd caution that this kind of report could be quite performance intensive to run due to the amount of data you're pulling from the system. I certainly wouldn't setup a report that pulled every school week at once - probably no more than one half term at a time.

 

I've also checked the DfE's VYED site and I don't think it'll do what you need, at least on a student level. If you wanted to look at year groups etc it would work fine.

[psydii]

naively, might this be doable with the Wonde API and PowerBI?

[Mr_Hulse]

16 hours ago, psydii said:

naively, might this be doable with the Wonde API and PowerBI?

Wouldn't know where to start with that one.

[Mr_Hulse]

On 10/07/2026 at 16:10, Devaleth said:

You may also consider FFT Aspire? If you already have that service as a school for targets/benchmarking, there is a school attendance report that has exactly this kind of data readily available. This can be downloaded as a CSV or excel, or viewed live on the website.

 

Other than that, simpsonj's approach definitely works. You'd want to have two columns per week - one counting all the attendance codes that are included in attendance figures (e.g. not Y codes!), and then a second counting the present and AEA codes (and then do the attendance % calculation itself in excel or similar). I'd caution that this kind of report could be quite performance intensive to run due to the amount of data you're pulling from the system. I certainly wouldn't setup a report that pulled every school week at once - probably no more than one half term at a time.

 

I've also checked the DfE's VYED site and I don't think it'll do what you need, at least on a student level. If you wanted to look at year groups etc it would work fine.

We have FFT Aspire, so will have a look at that. Thanks.