How to download the report
Go to the school settings. Click on the Live Classes tab, then go to Reports and select Completed Lessons v2.0.
Click the Download Report button, choose the desired period for the report, and click Download.
How to read the report
The report is designed to track attendance for both individual and group classes (not for Online Courses). It is sorted by the date and time of each lesson.
For group classes, all students belonging to the group are listed in a column. The fields, such as Lesson ID and Class/Group name, are repeated for each student in the group.
Table columns
1) Lesson type
Group - Group lesson
Individual - Individual lesson
2) Lesson status
The lesson conducted successfully
Absence from lesson - The student was marked absent by the teacher or administrator
The lesson is written off when canceling - The lesson was canceled by the student with a penalty
The lesson is cancelled by the student - The lesson was canceled by the student without a penalty
No lessons on balance - The lesson took place, but the student had no remaining lessons
3) NR of students in class/group
Number of students in the class or group. For individual lessons, it will always be 1 student.
4) Absent
Indicator of student absence during the lesson: 1 - Student was absent 0 - Student was present
5)Attended
Indicator of student attendance during the lesson: 1 - Student attended 0 - Student was absent/
The fields Absent and Attended are determined based on the lesson status.
Lesson status | Absent | Attended |
The lesson conducted successfully | 0 | 1 |
Absence from lesson | 1 | 0 |
The lesson is written off when canceling | 1 | 0 |
The lesson is cancelled by the student | 1 | 0 |
No lessons on balance | 1 | 0 |
6) Plan name
The name of the pricing plans in the school's billing system.
How to create pivot tables
To create your own report with pivot tables based on the data from the Lesson learned v2.0 report, copy the Google Spreadsheet template and paste the data into the first tab along with the headers.
The header names cannot be changed, otherwise the pivot table will lose its connection to the report.
Copy the template via the link:
https://docs.google.com/spreadsheets/d/1JKEJOcrRq4NpY9XsrUqb1D7Vdss_QqAFY3hRrcFC7Rg/edit?usp=sharing