The Lesson Summaries Report compiles lesson-related data into a clean, list-based layout. It is highly customizable, allowing administrators to audit attendance, track hours, and review historical session data across any given timeframe.
How to Access the Report
From your main navigation bar:
Click on Reports.
Click on "Lesson Summaries".
Understanding the "Data Type" Setting
The Data Type field determines how the rows in your report are calculated:
Lessons by Student (Individual Records): Generates a unique line item for every single student entry. For example, if a group class contains 5 students, this option will output 5 separate rows, allowing you to see individual attendance statuses, shared notes, and individual billing costs.
Lessons (Lesson-Level Summaries): Generates a single line item per scheduled lesson, regardless of how many students are enrolled in it. This view is ideal for auditing total teacher payroll hours or reviewing the overall usage of your facility's rooms.
Report Settings
You can customize your Lesson Summaries report by configuring the following parameters to tailor the data exactly to your needs:
Data Type - "Lessons by Student" displays lesson details with information related to the students in a lesson such as the cost, notes, etc. This data type generates one record for each student in a lesson, which can result in repeated records for group lessons. To avoid this, you can select the "Lessons" data type, which displays top-level information about a lesson such as the total fees, wage, profit, etc., and ensures that only one record per lesson is shown. To change the Data Type, follow these steps:
Open the Lesson Summaries Report in Teachworks.
Locate the "Data Type" field in the report settings.
Click on the "Data Type" field to view the available options.
Select the "Lessons" option from the dropdown menu.
Dates - Select start and end dates.
Filters - Select one or more options to filter the lessons.
Format - Display results in list format or totals.
Grouping - Choose how to group results or do not group them and they will appear in chronological order.
Order - Choose ascending or descending order.
Columns - select which columns to display for each of the results.
Logo - If you are printing or saving a report to PDF to provide to a client you can check the box to include the logo at the top of the report.
Saving Reports
If you frequently generate a specific type of report, you can save the settings by switching the "Save Settings" toggle and entering a title.
Once saved, you can select the "Used Saved Settings" option and select the report from the drop-down menu. The saved settings will be pre-filled and you can adjust the date to use the new time period.
NOTE: If you are using the Safari browser, downloading the report via Excel is not supported. You will need to use another browser such as Internet Explorer, Google Chrome, or Mozilla Firefox.
NOTE: All of the columns you select are downloaded as text. In order to total up any amounts or counts you have selected, you will first need to apply "Text to columns" on these columns so that Excel views them as numbers instead of text. You can find the steps to do this here: Convert Text to Columns.