Atgal How to import the students’ courses (seminars) selection into the program

 

You can import students seminar picks, number of seminar lessons per week, and assign student to a certain seminar group from program MS Excel. Just select your Excel data and copy to the clipboard. Data for import must be exactly in this format.

TT_imp1

Note: Here numbers 2, 1, 4 in cells mean number of lessons of corresponding subject per week.

Notes:
You can click the column header to specify that the column holds student names or class names in case the software hasn’t autodetected them correctly.
Also click header of first seminar subject name and select “Seminar (Subject in header row.

Result:

TT_imp4

Red background color means that teachers are not yet assigned to these student picks.

Subjects and classes also will be added in case they are not yet inputted into the software.

Then we import teachers’ lessons information. Select data from Excel:

TT_imp5

Section number, e.g. for Teacher 1 means that there will be 3 sections (groups) of students who will attend Teacher 1 lessons. You decide number of sections beforehand, based on number of students who signed up for Teacher 1 chemistry lessons.

Then select “Import, Import from Clipboard” in Students window. Do not forget to choose that you are importing lessons:

TT_imp6

Program will ask to confirm teachers and sections to be added into the database.

TT_imp7

Result:

TT_imp8

Subjects’ background pink color means that students are not yet assigned to seminar groups.

Then press button “Assign students to seminars”:

TT_imp9

Subjects’ background color will change to blue. It means that teachers now are assigned.

For example, for class 3A such seminar lessons will be created.

TT_imp10

Note: In aSc Timetables Standard version it is necessary to assign students to seminar groups manually or by pressing button “Assign students to seminars”. Then this choice is fixed and students will not be changed between seminar groups during generation of the timetable.

In aSc Timetables Pro version program can move students between seminar groups thus making better timetable with less windows for students.


Recommendations:
Before generation of the timetable with seminar lessons (individual students picks), in Advanced card relationships set “Number of max gaps per day(#4)” to 2-4 and select “Apply to students in selected classes”.

TT_imp11

In class Advanced constraints window set Education block to “Discontinuous – ignore windows in the timetable of the class”.

TT_imp12