Welcome to the AfterSchool21 Help Center

Find answers fast: Ask a question, search for keywords, or explore articles below.

Daily Activity Participation Summary

daily_activity_participation_summary_c242a583f733438ca (1).png

Overview & When to Use

The Daily Activity Participation Summary provides a day-by-day view of how many participants were marked Present for each activity and session across one or more sites. It is designed to help program staff and administrators monitor daily attendance patterns and quickly identify sessions where participation is unusually low or missing.

Typical audience: Site-level coordinators, program directors, and grant/district-level administrators who need to track daily operations across activities and sites.

This report is most useful when:

  • Monitoring whether daily attendance is being recorded consistently across all sites and sessions.
  • Identifying sessions with unexpectedly low or zero attendance that may signal scheduling issues, staffing gaps, or incomplete data entry.
  • Comparing participation patterns across multiple activities or sites over a selected date range.

How to Read the Report

  • Start with the site and activity groupings. Data is organized first by Site, then by Activity, then by Session within each activity — scan down the left columns to orient yourself to the scope of the data.
  • Read across the date columns. Each column represents a single date on which at least one “Present” count was recorded. Scan horizontally to see how attendance for a given session changes day to day.
  • Look for zeros or gaps. A zero in a date column for a session that normally shows activity is a signal worth investigating — it may mean attendance wasn’t entered, or that a session didn’t run as expected.
  • Compare sessions within the same activity. If one session consistently shows lower counts than others under the same activity, that pattern may warrant follow-up with site staff.
  • Use the date range filter to control scope. The report defaults to the past 30 days; narrow or expand the range to focus on a specific period of interest.
Daily Activity Participation Summary (1).jpg

Key Metrics

MetricWhat it MeasuresHow it is CalculatedNotes

Present

(daily count)

The number of participants marked as Present for a specific session on a specific dateCount of attendance records with a “Present” status for the Site + Activity + Session + Date combinationOne column per date appears for each date that has at least one Present record in the selected range

Enrolled

(participant count)

The number of participants enrolled in a sessionCount of active enrollment records for the sessionShown as a baseline reference; not the same as attendance
Excused AbsenceThe number of participants with an excused absence recorded for a session on a given dateCount of attendance records marked as Excused AbsenceDistinct from Present; helps distinguish true absences from missing data entry
SiteIdentifies the location where the activity took placeGrouping field; not a calculated metricMultiple sites appear when the report is run at the grant or district level
ActivityThe name of the program activityGrouping field; not a calculated metricActivities are grouped under their respective sites
SessionThe specific session within an activityGrouping field; not a calculated metricEach activity may have one or more sessions

Statuses, Colors, and Alerts

The Daily Activity Participation Summary is primarily a data grid without color-coded status indicators. However, the following values carry meaningful signals:

  • Present count > 0 — Attendance was recorded for this session on this date; data entry appears complete.
  • Present count = 0 — No participants were marked Present. This may indicate the session did not run, attendance was not entered, or enrollment is zero. Warrants follow-up.
  • Excused Absence count > 0 — Some participants were recorded as excused; these are not counted as Present.
  • No date column for a session — If a session has no date columns at all within the selected range, no Present attendance was recorded for any date in that period. This is a strong signal of either a scheduling gap or missing data entry.

Notes, Limitations, and Related Reports

  • Data accuracy depends on daily entry. This report reflects only what has been entered by site-level staff. If attendance has not been recorded, the report will show zeros or missing columns — not a true picture of what occurred.
  • Default date range is the past 30 days. Users should adjust the date range filter when reviewing historical periods or specific program windows.
  • Youth-only by default. The report defaults to showing only youth participant attendance. Adult participants are excluded unless the Adult status filter is changed.
  • No aggregate totals visible in the grid by default. The report is designed for day-level review; for rolled-up summaries, consider using complementary attendance summary reports.
  • Related reports: The Scheduled Sessions Without Attendance report is a useful companion — it highlights sessions that were scheduled but have no attendance recorded at all, helping distinguish planned gaps from data entry issues.

Report Filters (How to Slice the Data)

The following filters are available on this report:

Date Range

Controls which dates appear as columns in the report. Only dates within the selected range that have at least one Present record will generate a column. The default is the 30 days prior to today. Adjust this when reviewing a specific program period, grant reporting window, or historical trend.

Activity

Filters the report to show only the selected activity or activities. Use this when you want to focus on a single program area (e.g., Tutoring, STEAM, Snack) rather than viewing all activities across all sites.

Session

Narrows the view to one or more specific sessions within an activity. Useful when a single activity has multiple session groups (e.g., by grade level or day of week) and you want to isolate one.

Site

Controls which site or sites appear in the report. When run at the district or grant level, all sites are included by default. Filter to a single site for site-specific review.

Adult Status

Determines whether adult or youth participant attendance is shown. The default is youth-only (Adult = No). Change this filter to include adult participants when reviewing programs that serve both populations.

To apply filters (not available for all reports), use the filter icon available at the top right of the report header. The filter options shown in this report are the same for all users.

To filter by additional fields that are not available on-screen, export the table to Excel, turn on filters for the header row (Data > Filter), and use Excel’s filter dropdowns. For a quick tutorial, see Microsoft’s “Filter data in a range or table” video on https://support.microsoft.com/.

Updated

Was this article helpful?

0 out of 0 found this helpful

Have more questions? Submit a request