SIMS setup a report to get attendance for a subject

[martyn_wheeler]

Hi,

 

I'm a teacher trying to get some attendance data from SIMS.  I would like to set up a report to pull the attendance data for all students doing a particular subject at my school.  I am not that familiar with the reporting interface on SIMS and can't quite work out where to start.  Ideally, I would like the following columns to put into a spreadsheet:

 

Name, Class, Year, %attendance

 

Any help getting started would be much appreciated.

 

Thanks

[martyn_wheeler]

I have so far looked at lesson monitor.  I can get data for selected classes but it produces one table per class as an html document.  I'd like to be able to have one table with Name, Class, Year, %attendance.  I have looked at pulling the html document into power query but it doesn't give the class name easily.

[a_masters]

Have you looked at Reports > Lesson Monitor > Whole Group Student Reports > Lesson Attendance by Classes?

 

Looks to be what you're after, but not in the most friendly table.

 

I've achieved similar by pulling out ALL attendance marks for a time period and calculating it myself, but that might be overkill!

 

[martyn_wheeler]

Thanks, I had to pull out all students data then pull it into excel and use power query to filter it into just the data I need.  All works.  Only issue is that if a student has changed subject, they still show up.  I will need to create a comparison table.  Thanks again

[SIMS_Customer_Support]

On 13/10/2025 at 15:44, martyn_wheeler said:

Hi,

 

I'm a teacher trying to get some attendance data from SIMS.  I would like to set up a report to pull the attendance data for all students doing a particular subject at my school.  I am not that familiar with the reporting interface on SIMS and can't quite work out where to start.  Ideally, I would like the following columns to put into a spreadsheet:

 

Name, Class, Year, %attendance

 

Any help getting started would be much appreciated.

 

Thanks

Hi @martyn_wheeler Please can you confirm the name of the school and I will see what help I can arrange? I look forward to hearing from you. 

Best wishes

Sally 

[martyn_wheeler]

6 hours ago, SIMS_Customer_Support said:

Hi @martyn_wheeler Please can you confirm the name of the school and I will see what help I can arrange? I look forward to hearing from you. 

Best wishes

Sally 

Hi Sally, I have sent you a message.  Thanks

[SIMS_Customer_Support]

12 minutes ago, martyn_wheeler said:

Hi Sally, I have sent you a message.  Thanks

Hi @martyn_wheeler I am just checking with our service desk, I will be back in touch as soon as I receive a reply from the service desk. 

 

Many thanks

Sally 

[SIMS_Customer_Support]

18 hours ago, SIMS_Customer_Support said:

Hi @martyn_wheeler I am just checking with our service desk, I will be back in touch as soon as I receive a reply from the service desk. 

 

Many thanks

Sally 

 

18 hours ago, SIMS_Customer_Support said:

Hi @martyn_wheeler I am just checking with our service desk, I will be back in touch as soon as I receive a reply from the service desk. 

 

Many thanks

Sally 

Hi @martyn_wheeler you will need to contact your SIMS support provider Leicestershire County Council, who will be able to assist with your request.

 

Best wishes 

Sally