[sims] Percentage Attendance detailed report

[forkies]

Looking for some help. I am trying to get a report out of Sims similar to the "Percentage Attendance Report" which is under Reports, Lesson Monitor, Selected Student Reports, Percentage Attendance Report. However, I need more data than just a name and form, such as admission number. When I try to create a report using % Attendance Summary (Current Year) and the data "% Present + AEA" it is giving the me the data to date.

 

I have tried changing the effective date but it is not changing. I need to be able to set a date for the attendance % to end, e.g. start of academic year to Friday of last week.

 

Does anyone have any ideas of how to get this information out of Sims using reports?

 

Thanks,

Tom

[ajp233]

You'll have to create an Advanced Report and use multiple instances of the Attendance Marks sub-report and filter the sub-reports by date. If you output the report to Excel you can then embed code in the AutoOpen macro to calculate percentages etc

[forkies]

You'll have to create an Advanced Report and use multiple instances of the Attendance Marks sub-report and filter the sub-reports by date. If you output the report to Excel you can then embed code in the AutoOpen macro to calculate percentages etc

 

So I have done this using statistical meaning as a filter and the percentages don’t work out the same as the percentage attendance report. They are out by 1% or so and some out by 3-4%. I can’t seem to set anything that actually matches.

 

Have you got a report def that works with actually matching the percentage attendance report?

[CAM]

The SIMS built-in report in Lesson Monitor will include anyone ever on roll in the specified timeframe. The School Report does not and is only students on-roll at the time of running the report.

[forkies]

The SIMS built-in report in Lesson Monitor will include anyone ever on roll in the specified timeframe. The School Report does not and is only students on-roll at the time of running the report.

 

The percentage per student is what I am looking for, that is what is out. So John Doe has 93.49% attendance in the percentage attendance report but the closest I get is 94.5% on the advanced report using the same timeframe using present + AEA marks/total marks.

[ajp233]

Is your denominator (total marks) made up of presents (statistical meaning present or AEA) + absences (authorised and unauthorised) + missing marks (statistical meaning is no mark)??

[forkies]

Is your denominator (total marks) made up of presents (statistical meaning present or AEA) + absences (authorised and unauthorised) + missing marks (statistical meaning is no mark)??

 

Yes, tried it every way possible and still doesn't come to the same value as the Percentage Attendance report. Even filtered it down to Mon-Fri in case weekend was affecting it.

 

I am going to try doing it based on mark values instead and see where I get with that.

[bobsmith]

pull out the attendance sessions on both methods and don't convert to percentages - it'll show you straight away where the differences are.

[BradShort]

Check you have marks for every session and no missing marks, as this can introduce discrepancies in the way that the attendance is calculated. 1 - (unauth+auth / Possible) can produce different values than (present+AEA / Possible) if you have missing marks. I believe the attendance module calculates absence, and the reporting engine calculates present marks.