how insert student names from libreoffice calc?

[dimzev]

In my school some lessons is personal for students and i need to add them from a LibreOffice calc (or excell) page.
How can add them to groups?

thank you!!!

[Volker Dirr]

hmmm... Why do you need to add them? What do you want to do with them? Using them as subgroup? Maybe you only need to save the Excel / LibreOffice file as csv and import the csv file int FET.
But i fear it might be more complicated. Please explain more detailed what you want to do with the names in FET.

[dimzev]

is a music school where in addition to secondary education courses and musical instruments courses ...
So in the same class there are students doing gymnastics, a student doing a piano teacher1 a student playing the violin a student doing a guitar teacher1 a student doing a piano teacher 2, a student doing a guitar teacher2 etc
while at some other time the student who has been playing guitar is playing piano etc.
there are students who have their own guitar teacher but different piano teacher
is a very complex program and individual for each student

[Liviu Lalescu]

In the official FET each activity must have the exact student and teacher. The program cannot choose teachers for students. If this is respected, you can use the official FET. You can define a FET subgroup = a real student. Add a bit of data, export it as CSV and see how the file looks, then generate similarly from your LibreOffice CSV file. Volker can tell you more.

If you need FET to choose the teachers for students (for the activities), we may devise you a custom version. But I think it is not the case.

[Vangelis Karafillidis]

is a music school where in addition to secondary education courses and musical instruments courses ...
So in the same class there are students doing gymnastics, a student doing a piano teacher1 a student playing the violin a student doing a guitar teacher1 a student doing a piano teacher 2, a student doing a guitar teacher2 etc
while at some other time the student who has been playing guitar is playing piano etc.
there are students who have their own guitar teacher but different piano teacher
is a very complex program and individual for each student

Solving the timetable of a Greek Music School is difficult. Also, it's really tricky and risky to describe the musical instruments courses in terms of FET (i.e. "normal" activities). The reason is that these courses should be "private-like" lessons (which means one teacher with one student). But, due to the lack of sufficient number of teachers, most of the time these courses are not private-like. So, one needs to form groups of a few (or more) students. And the greatest problem is that these groups are not "fixed". In conclusion, it's really difficult to describe your timetabling problem in terms of FET. It's easier to use a spreadsheet application (such as LibreOffice Calc, MS Office Excel, e.t.c.). Generally speaking, it's easier to solve the timetable "per student", that to solve it "per teacher".

Best regards,
Vangelis Karafillidis.

[dimzev]

Solving the timetable of a Greek Music School is difficult. Also, it's really tricky and risky to describe the musical instruments courses in terms of FET (i.e. "normal" activities). The reason is that these courses should be "private-like" lessons (which means one teacher with one student). But, due to the lack of sufficient number of teachers, most of the time these courses are not private-like. So, one needs to form groups of a few (or more) students. And the greatest problem is that these groups are not "fixed". In conclusion, it's really difficult to describe your timetabling problem in terms of FET. It's easier to use a spreadsheet application (such as LibreOffice Calc, MS Office Excel, e.t.c.). Generally speaking, it's easier to solve the timetable "per student", that to solve it "per teacher".

Best regards,
Vangelis Karafillidis

thank very much for your advice , i want your opinion for best solution...
(Σε ευχαριστώ πολύ Βαγγέλη( αν μου επιτρέπεις) ήθελα και την γνώμη ανθρώπων με μεγαλύτερη εμπειρία στην δημιουργία σχολικών προγραμμάτων. Συγχαρητήρια για την συμμετοχή σε αυτή την προσπάθεια!!! Σας ευχαριστώ όλους για την βοήθεια...!!!
και πάλι συγχαρητήρια!!!

[Vangelis Karafillidis]

You are welcome!
Solving the timetable of a typical Greek Music School is a really complicated task. One should take care of ALL the following:
1) The students of each year (for example 1st class of the Gymnasium) should be distributed evenly into each one of the groups, according to their ELECTIVE musical instrument course (for example A1, A2 and A3 groups of the 1st class should each have nearly the same number of students for each one of the elective musical instrument courses). If you divide some groups into subgroups (for example, if the same hour half of a group has the Sports activity and the other half musical instrument courses, each one of these "halves" should have nearly the same number of students for each one of the elective musical instrument courses).
2) It's really useful to create a virtual teacher for the musical instruments courses (for your timetable). This makes easier to "monitor" the whole procedure. The distribution of the musical instrument courses in your timetable (actually which hour each one of your groups or subgroups is available for musical instrument courses) strongly affects the procedure of solving your whole timetable (including the private-like musical instrument courses). So, try to start from the timetable of this virtual teacher, in order to satisfy the most difficult part of your timetable, which is the musical instrument courses timetable.
3) Avoid making changes for this virtual teacher. They are going to affect nearly ALL of the musicians who teach musical instrument courses.
4) It's better to take care of the (1), (2) and (3) from the beginning of the school year. If you don't the situation becomes really complicated!
5) Most of the time, Music Schools need at least two people to solve their timetables. The one person solves the timetable for the "General" Courses, and the other the timetable for the Musical Instrument Courses.
6) Generally speaking, solving timetables has to do with people. Unfortunately, very few teachers know how difficult this procedure is. But, most of them tend to demand you to make changes, because they have "other things to do". Bear in mind that if you satisfy a couple of demands, virtually all the teachers of your school are going to ask for changes for their own reasons, and most likely, you're going to spend not just hours, but days or weeks, in order to solve your timetable. So, think carefully...