Overview

When importing lessons from Excel, you can assign a lesson to a specific subgroup using a colon-separated syntax in the Classes column.

Template columns

Teacher name	Subject name	Classes	Lessons/week
James Wilson	ENG	10A:Advanced:S1	2
James Wilson	ENG	10C:Advanced:S2	3

Subgroup syntax

To assign a lesson to a subgroup, use:

CLASS:DIVISION:SUBGROUP_NAME

Examples:

• 10A:Advanced:S1 — class 10A, division Advanced, subgroup S1
• 10B:Beginner Languages:English — class 10B, division Beginner Languages, subgroup English

If no subgroup is specified (e.g. just 5A), the lesson is assigned to all students in that class.

Prerequisites

The division and its subgroups must already be defined in the app before importing. If the division or subgroup name does not match exactly, the import will report an error for that row.

Combining subgroups from multiple classes

To assign one lesson to subgroups from different classes, use / to separate them:

10A:Advanced:S1/10B:Advanced:S1

You can also mix subgroups and full classes in the same lesson:

10A:Advanced:S1/10B:Advanced:S1/10C

This assigns the lesson to the S1 subgroup of 10A and 10B, plus the entire class 10C.

Non-weekly lessons

Use 0.5 as the lessons/week value for lessons that occur every other week.

Note: Non-weekly lessons cannot be combined with subgroups.

Back