Course Session Attendance Summary Report in PICS

The Course Session Attendance Summary Report produces a list of Attendance Values for Course Sessions taking place within a specified date range. Unlike the Course Session Attendance report, this template is set up for use as an Interactive report offering a top-level view of session attendance.

Report Options

The following customisation options are available:

  • Attendance – Here you can choose whether to include only Recorded Attendance values or both Expected and Recorded Attendance values.

  • Attendee Type – Here you can restrict the report to only attendance by Learners or Applicants.

  • Sessions From and To – Here you can specify the date range that will determine which sessions will have their attendance included in the report. You can either choose a Fixed Date and choose the relevant dates from the calendar date selector, or choose one of the relative values such as TodayStart of WeekStart of Month or others. If you choose a relative value, it is possible to add a positive or negative Offset value, which will adjust the date by the specified number of weeks. For example, choosing End of Week with a +1 Weeks Offset value will run the report from the end of the next week.

  • Attendance Type – Here you can restrict the report to specific attendance types. You can add multiple types to the field and remove any added ones by selecting the X icon.

  • Tutor – Here you can restrict the report to attendance for sessions run by a specific tutor Officer.

  • Course Leader – Here you can restrict the report to attendance for sessions for courses led by a specific Officer.

  • Course Organiser – Here you can restrict the report to attendance for sessions for courses organised by a specific Officer.

  • Course Type – Here you can restrict the report to attendance for sessions of a specific Course Type.

  • Course Tags – Here you can restrict the report to attendance for Courses with specific Tags. Choosing a tag from the drop-down menu will add it to the field. You can add multiple tags to the field and remove any added ones by selecting the X icon. The following tag options are available:

    • Any – This will restrict the report to courses that have at least one of the specified tags.

    • All – This will restrict the report to courses that have every specified tag.

    • None – This will restrict the report to courses that do not have any of the specified tags.

  • Enrolment Type – Here you can restrict the report to attendance for sessions with either Fixed Start Date or Roll-on Roll-off enrolments.

  • Sites – Here you can restrict the report to attendance for sessions for courses linked to specific Sites. You can add multiple sites to the field and remove any added ones by selecting the X icon.

  • Course Status – Here you can restrict the report to attendance for sessions from Live or Dormant courses.

Report Output

Interactive Output

The Interactive output option will be selected by default when running the course session attendance summary report.

With no Analysis Columns set, the report will show a top-level summary of your attendance values for the specified date range.

Analysis columns and report filters can then be set up to analyse the data by different criteria, including any Custom Attendance Values that you have set up.

More information on using interactive reports is available in the Interactive Reports page.

Spreadsheet Output

The course session attendance summary report spreadsheet consists of a single sheet listing all matching attendance values by attendee.. Along with the relevant attendee and session details, any Optional Fields chosen when building the report will be included as additional columns.