💡 Prerequisite: From the main menu of your Administrator dashboard, click the Statistics tab. Once you're on this page, you'll see the navigation bar with the following sub-tabs: Overview, Attendance Sheets, Trainings, Professors, Groups, Students, and BPF.
1. 🎯 Filter your overall data
To refine your analyses and focus on a specific scope, use the dynamic filters at the top of the screen. Any changes made here will update all tabs:
Date: past 30 days (time filter can be adjusted to select the period of your choice).
Group name (filter by class, cohort, or graduating class).
Student Name / Student Email / Student ID (Identify a specific student).
Professor Name / Professor Email (Analyze the activity of an instructor).
Training name / Training ID (summarize the data of a training module).
Classroom (track the occupancy of a physical classroom).
Attendance Sheet Name (search for a specific attendance sheet by name).
💼 Use case: Track the complete activity of a group of work-study students over a given billing month to send an accurate attendance report to their partner company or the funding OPCO.
2. 🏠 The "Overview" tab
The Overview tab displays your overall key performance indicators (KPIs) as well as a visual breakdown of your attendance data in the form of time-series charts.
Some Figures (Attendance Overview (Selected Period) Section)
This first section provides an overview of the organization's attendance over the period:
Global Attendance Rate: the average attendance rate for your entire institution.
Total Attendance Sheets: The total number of attendance sheets generated.
Total Attendances: the exact count of marked "present" entries.
Total Absences: the total number of absences recorded.
Unjustified absences: the number of absences for which no justification was provided.
Justified Absences: The number of absences justified by your teams.
Total Attendance Duration (Hours): the conversion of attendance records into a cumulative number of hours.
Total Absence Duration (Hours): the total number of hours lost due to absenteeism.
Trends Section
Located just below, this section measures behavioral and disciplinary issues:
Total Late Arrival Hours: the cumulative total, in hours, of all late arrivals.
Total Late Arrivals: the total number of recorded late arrivals.
Total Exclusions: the number of students who have been excluded from a course.
Total Early Departures: the number of early departures entered into the system.
Trend and Distribution Charts
Attendance vs. Absence: a pie chart showing the percentage breakdown between overall attendance and absence.
Justified vs. Unjustified Absences: a ring chart showing the proportion of justified absences compared to unjustified absences.
Signature Type Breakdown: a chart designed to map the most commonly used signature methods (QR code, email signature, app, etc.).
Monthly Attendance Summary: a cross-tabulation chart comparing the attendance rate (Attendance Rate %) and the number of attendance sheets on a monthly basis.
Weekly Attendance Rate Trend: a line graph showing the weekly trend in your attendance rate.
Weekly Absence Breakdown: a linear analysis that distinguishes, week by week, between the number of unjustified absences and justified absences.
Daily Presence vs. Absence Duration: A daily histogram comparing hours of absence (Absence (hrs)) and hours of presence (Presence (hrs)).
Weekly Presence vs. Absence: an area chart showing the volumes of presence (Present) and absence (Absent) week by week.
Weekly Absence Duration Trend: a weekly trend that measures the impact of late arrivals and absences (Unjustified Hours vs. Justified Hours).
Signature Method Trends: An upcoming trend chart designed to track the performance of your validation methods.
Daily Evolution: includes two charts that track data on a day-to-day basis: Daily Attendance Rate Evolution (the daily attendance rate) and Daily Absence Count Evolution (the daily number of absences).
💼 Use case: generating a monthly activity report for management or preparing for a Qualiopi recertification audit ( metrics related to monitoring and addressing absenteeism).
3. 📝 The "Attendance Sheets" tab
This tab focuses on the logistical organization of your classes and on the statistical performance specific to your attendance sheets.
Some Figures (Attendance Sheet Overview (Selected Period) Section)
Total Attendance Sheets: Total number of sheets created during the period.
Average Attendance Rate: the average attendance rate calculated per attendance sheet.
Average Students per Attendance Sheet: the average size of your groups per attendance sheet.
Attendance Sheets Without Attendance: An alert that counts the number of attendance sheets generated without any learners assigned to them.
Active Classrooms: Number of separate classrooms that have been set up and are in use.
Attendance Sheets with Full Attendance: the number of classes that achieved a perfect 100% attendance rate.
Attendance Sheets with Low Attendance: the number of critical attendance sheets showing high absenteeism.
Detailed Tables
Attendance Sheet, Attendance Table: the comprehensive chronological record of your classes.
Required columns: Date, Sheet, Professors, Classroom, Students, Present, Absent, Attendance %, Unjustified %.
💡 Navigation tip: If you have a large number of courses, use the horizontal scroll bar at the bottom of the table. The total number of attendance sheets found (e.g., 50 rows) is displayed in the lower-right corner.
Attendance Sheet Analysis Charts
Attendance Sheet Attendance Rate Distribution: a histogram that breaks down your class attendance sheets by completion rate (0% (No attendance), 1–49%, etc.).
Monthly Attendance Sheet Volume: a monthly chart that tracks activity volume based on the number of classes (attendance sheets) and the average number of students (Avg Students).
Classroom Analysis: includes the "Most Used Classrooms " (classrooms with the highest number of classes) and " Attendance Rate by Classroom " (average attendance rate measured within each physical classroom) rankings.
Professor Activity & Schedule: includes the "Most Active Professors (by Attendance Sheets) " chart (the instructors who have opened the most attendance sheets) and the " Attendance Sheet Start Time Distribution " chart (the most common class start times).
Student Attendance Summary: An overview chart will be provided shortly, summarizing attendance rates by student based on attendance sheets.
Day Analysis: a detailed time-based analysis that combines "Attendance by Day of Week" (the days of the week with the highest average attendance rate) and "Attendance Sheets per Day" (the schedule showing the workload on your attendance sheets).
Attendance Sheets Without Student Data: cross-tabulation charts (Weekly Attendance Rate and Weekly Attendance Sheets and Rate) used to measure the impact of blank attendance sheets on overall attendance.
Attendance Sheets With No Signatures - Details & Professors Linked to Attendance Sheets With No Signatures: alert sections listing, by name, the attendance sheets that have no signatures recorded, as well as the associated instructors.
💼 Use case: Instantly identify instances where a staff member has failed to generate forms or sign documents at the end of the day, in order to resolve the issue before administrative closing.
4. 📚 The "Trainings" tab
This section aggregates and summarizes your attendance records by training course.
Some Figures ( Training Overview (Active in Period) Box)
Active Trainings: Total number of different training sessions conducted during the period.
Average Training Attendance: the average attendance rate across all your training sessions.
Students in Active Training Programs: the number of unique learners enrolled in active training programs.
Average Justified Rate / Average Unjustified Rate: the average rates of justified and unjustified absences in your training programs.
Average Delays per Training Session: the average number of delays recorded per training session.
Average Exclusions per Training: the average rate of course exclusions applied per training session.
Detailed Tables
Training Details Table: Attendance Summary by Training Session.
Required columns: Training, Start, End, Students, Present, Absent, Unjustified, Attendance %.
Student-Training Attendance: an individual cross-tabulation table that measures each learner's attendance in their training program.
Exact columns: Training, Student, Email, Attendance %, Unjustified %, Attendance Sheets, Absences.
Training Analysis Charts
Training Ranking: This section combines the Top Training Attendance Ranking (training courses with the highest attendance rates) and the Lowest Attendance Trainings section (courses that require an exam or remedial instruction).
Lateness, Exclusions & , Early Departures: a set of 3 targeted charts: Training Late Arrivals Ranking (the training sessions with the most late arrivals), Exclusions by Training (the number of exclusions per course), and Early Departures by Training (learners who leave before the scheduled end of the course).
💼 Use case: Analyze the attendance rate for a new training course to assess learners' interest in and engagement with the proposed curriculum.
5. 👨🏫 The "Professors" tab
This tab is designed to track the number of class hours and your instructors' punctuality.
Some Figures ( Professor Overview (Active in Period) Box)
Professor Average Attendance Rate: the average attendance rate of learners in classes taught by your instructors.
Professor Total Attendance Sheets: the cumulative number of sheets managed by your instructors.
Professor Total Absences: the number of absences recorded under the instructors' supervision.
Professor Absence Hours: Conversion of student absences on these attendance sheets into hours.
Total Instructor Hours: the total number of class hours actually taught by your instructors.
Professor Attendance Count: total number of verified learners present during these sessions.
Detailed Tables
Professor by Training Table: Breakdown of your instructors' activities by training program.
Exact columns: Teacher, Training, Attendance Sheets, Rate %, Absences, Presence (hrs).
Professor by Attendance Sheet Table: a comprehensive list of attendance sheets assigned to instructors.
Exact columns: Teacher, Training, Sheet, Start, End, Rate %, Attendance, Absences.
Professor Attendance Sheet Attendance Detail: a summary table of attendance records by instructor.
Exact columns: Professor, Attendance Sheets, Attendance Rate %, Present, Absent, Hours Present, Hours Absent.
💡 Visual tip: In this last table, the " Attendance Rate % " column automatically applies a red color code to immediately identify instructors whose classes have critically high absenteeism rates.
Stakeholder Tracking Charts
Professor Attendance Trend: includes Weekly Professor Attendance Rate (a trend line showing the change in instructors' class attendance rates) and Weekly Professor Attendance (Area) (an area chart showing weekly attendance).
Professor Hours by Month: Total number of hours taught per month by each instructor.
Late Arrivals & Early Departures by Professor: a section coming soon that will include three punctuality metrics: Late Arrivals by Professor (student tardiness sorted by instructor), Early Departures by Professor (early departures), and the overall summary Professor Delay & Departure Summary.
Weekly Late Arrivals Trend: an upcoming weekly trend chart measuring delays.
Professor Trends (Duration & Attendance Sheets): a comparative analysis including the number of weekly sheets (Weekly Professor Attendance Sheets Count) and changes in the number of absences (Weekly Professor Absences).
Weekly Professor Absence Duration & Weekly Professor Presence Duration: graphs tracking changes in the number of hours of absence and presence over the course of several weeks.
Weekly Analysis: a general analysis that includes the number of weeklyattendance sheets and attendance rates by day of theweek.
💼 Use Case: Calculate and verify, in just a few clicks, the exact number of hours worked by a freelance instructor or temporary employee at the end of the month to approve their invoice or prepare their pay stub.
6. 👥 The "Groups" tab
This tab consolidates and compares overall attendance across your classes, sections, cohorts, or graduating classes.
Some Figures ( Group Overview (Active in Period) Box)
Average Group Attendance Rate: the average attendance rate calculated at the group level.
Active Groups: the exact number of classes that have attended at least one hour of instruction.
Average Unjustified Rate: the average percentage of unexcused absences within your groups.
Detailed Tables
Group Detail Table: Overview of promotion performance.
Exact columns: Group, Attendance Sheets, Students, Total Planned Hours, Hours Present, Attendance %, Absence %, Unjust. %, Absences, Delay (min).
Group Attendance Detail: a detailed analysis of the specific types of absences by cohort.
Exact columns: Group, Attendance Rate %, Unjustified Absence Hours, Unjustified Absence Count, Justified Absence Hours, Justified Absence Count.
Student Hours Detail - Groups: a comprehensive, name-based attendance record for all students assigned to their respective groups.
Exact columns: Group, Group IDs, Group ID Count, Student, Student ID, Email, First Date, Last Date, Days With Data, Attendance Sheets, Presence Hours, Absence Hours, Scheduled Hours, Attendance Hours %, Average Attendance %, Average Unjustified %, Presences, Absences, Justified Absences, Unjustified Absences, Justified Absence Hours, Unjustified Absence Hours, Exclusions, Delay Hours.
Group Analysis Charts
Group Attendance Ranking: a horizontal ranking that lists your groups from best to worst attendance rate.
Group Trends: includes Monthly Group Attendance Trend (long-term trend in average group attendance).
Absence Breakdown by Group: includes Monthly Absence Breakdown (type of absences by month, broken down into “Unjustified” and “Justified”) and Monthly Attendance Sheets and Active Groups (comparison of the number of attendance sheets to the number of active groups).
Delay Analysis: analytical spaces dedicated to the punctuality of cohorts: Group Delay Ranking (ranking of the groups with the most delays) and Weekly Group Delay Trend (trends in the number of hours of delay per week).
Attendance Rate Evolution: Includes the " Group Attendance Rate Evolution " line graph to track the behavioral trend of your cohorts.
💼 Use case: For the director of a vocational training center (CFA) or college, identifying a decline in overall attendance among a specific class in order to organize a planning meeting with the student representatives or the head of student affairs.
7. 🧑🎓 The "Students" tab & The "Action Advised" tool
The "Students" tab offers precise individual tracking for each learner and incorporates a unique decision-support algorithm to automate your follow-up and remediation processes.
Some Figures (Student Overview (Active in Period))
Average Student Attendance: the average individual attendance rate of a student.
Active Students: the total number of unique learners enrolled in your institution.
At-Risk Students (< 70%): an alert that identifies students whose attendance rate has fallen below the critical threshold of 70%.
Total Attendance Sheets: The total number of classes associated with your profile sheets.
Total Presence Hours: the cumulative total of actual presence hours recorded by learners.
Unjustified Absences / Unjustified Absence Hours: the number and total hours of unjustified absences.
The Predictive Module: " Action Advised" Insert
🔬 Understanding the "Risk Priority Score" formula: > The system automatically calculates an urgency score to classify and prioritize your administrative follow-up or educational support actions according to the following rule: Attendance rate below 70% × 2 + unexcused absences × 5 + class exclusions × 12 + minutes late / 30 + hours of unexcused absence × 2. The higher the score, the more the learner needs immediate assistance from your teams.
Students Needing Follow-up: A sorted list of your priority students who need an appointment or additional guidance.
Exact columns: Student, Email, Attendance Rate %, Attendance Sheets, Absences, Unexcused absences.
Students With a Negative Trend: Instantly identifies students at risk of dropping out (a sharp decline in attendance compared to their recent history).
Exact columns: Student, Email, Current Attendance Rate %, Previous Attendance Rate %, Trend Delta Points, Current Absences.
Groups Needing Follow-up: Identifies entire classes in which overall attendance trends are declining sharply.
Exact columns: Group, Students, Attendance Sheets, Attendance Rate %, Previous Attendance Rate %, Trend Delta Points, Unjustified Absences.
Absenteeism reports and lists of names
At-Risk Students Table: A Comprehensive Look at Students Who Are Chronically Absent.
Exact columns: Student, Email, Attendance Rate %, Total Absences, Unjustified, Exclusions, Attendance Sheets.
All Students Table: A comprehensive database of all your enrolled students.
Exact columns: Student, Email, Attendance Rate %, Absence Rate %, Justified Absence %, Unjustified Absence %.
Graphs and Tracking of Learner Behavior
Student Attendance Distribution: A bar chart showing the number of students by attendance rate (e.g., Below 50%).
Student Absence Breakdown: Ring plot analysis of the proportion of Unjustified absences at the individual level.
Absence Trends: Includes the " Weekly Student Absences " metrics (weekly number of absences), the " Attendance Progress Toward 80% " gauge (which tracks your internal "Goal 80" target), and the " Weekly Absence Trend (Stacked)" area chart.
Late Arrivals & Early Departures: A section analyzing punctuality that includes " Late Arrivals Per Week," " Early Departures Per Week," and the " Top Late Students" ranking by name.
Lateness & Delays (Selected Period): Delay dashboard including the metrics " Total Delay Hours" and " Students with Delays," the "Top Students by Delay " chart, and the " Weekly Delay Trend" graph.
Student Trends (Duration & Attendance Sheets): Cross-tabulation charts measuring the number of hours of attendance (Weekly Student Presence Duration), the number of signed attendance sheets (Weekly Student Attendance Sheets Count), the duration of absences (Weekly Student Absence Duration), and changes in disciplinary actions (Weekly Student Exclusions).
Student Exclusions Detail: An analysis section dedicated to exclusions, including the " Total Student Exclusions " global counter and the " Top Students by Exclusions" ranking.
💼 Use Case: Actively combat school dropout by identifying students whose attendance is declining using the "Students With Negative Trend " tool, in order to provide early support.
8. 💶 The "BPF" (Educational and Financial Report) tab
The BPF tab provides all the educational and course-hour data you need to easily complete your mandatory annual report.
📝 Regulatory Reminder: To accurately complete your BPF declaration (CERFA 10443), be sure to set the global date filter at the top of the page to Previous 12 months to cover your entire fiscal year. As a reminder, your declaration must be completed and submitted via the Mon Activité Formation portal no later than May 31.
Some Figures (BPF Indicators)
Active Professors: the number of instructors who taught classes during the fiscal year.
Active Students: the number of unique interns or trainees who have completed training.
Active Groups: the number of classes or cohorts managed.
Active Trainings: the number of distinct training sessions conducted.
Insert: Total Hours & Rate
These indicators eliminate the need for complex manual adjustments:
Total Training Hours: the organization's total number of training hours (the sum of the hours present and absent for all trainees).
Total Absence Hours: the exact total number of hours of absence recorded during the year.
Attendance Rate: the statutory attendance rate used for the fiscal year.
Hours Insert (Regulatory Details on Hours)
Student Attendance Hours: the total number of hours of actual attendance by your interns (information required to justify your funding).
Professor Presence Hours: the number of hours instructors spend with interns.
Total Planned Hours: The total number of hours originally scheduled in the calendar.
Students with Attendance: the exact number of interns who have logged at least one hour of actual attendance.
Regulatory Reconciliation and Export Reports
BPF Hours Reconciliation: The Essential Consistency Checklist for Administration.
Exact columns: Scope, Students, Attendance Sheets, Hours Present, Hours of Justified Absences, Hours of Unjustified Absences, Hours of Other Absences, Total Hours of Absences, Accounted Hours, Attendance Rate %, Percentage of Justified Absences %.
BPF Export Detail: the raw, named audit database needed to verify your calculations line by line.
Exact columns: Student, Email, Student ID, Groups, Justified Absence Hours, Unjustified Absence Hours, Other Absence Hours, Total Absence Hours, Accounted Hours, Attendance Rate %.
BPF Students With Planned Hours and Zero Attendance: instantly identifies regulatory files at risk (trainees listed on attendance sheets who have not logged any hours of attendance).
Exact columns: Student, Email, Student ID, Groups, Attendance Sheets, Absence Hours, Justified Absence Hours, Unjustified Absence Hours, Accounted Hours, Exclusions.
Student Hours Detail / Professor Hours Detail: a simplified summary of the number of hours per student and per teacher, respectively.
Monthly Hours Breakdown: a stacked histogram showing the monthly breakdown of your training hours into Presence Hours and Absence Hours.
Training Hours Summary (for Cadre F-3 / F-4): a breakdown by specialty or training program to directly fill in the fields related to your training typology.
Exact columns: Training, Enrolled Students, Presence Hours, Absence Hours, Total Hours, Rate %.
Group Hours Summary (for Cadre F-3 / F-4): a regulatory structure equivalent to the format of your official report, organized by cohorts.
Exact columns: Group, Enrolled Students, Presence Hours, Absence Hours, Total Hours, Rate %.
💼 Use case: Complete your annual BPF report in less than 15 minutes without any macros or complex Excel formulas. This module eliminates the risk of errors and discrepancies in working hours during audits by the DREETS.
💡 To learn more:
Analyzing your statistics doesn't stop there! For even more precise control, feel free to combine your global filters (e.g., isolate a trainer within a specific training course). This will allow you to track changes in your learners' behavior over the course of the quarters and plan ahead for the logistical needs of your future course sessions!
For further information, visit our help center.
💬 If you can't find what you're looking for, contact us via the chat. 💬