Best way to structure students?

Started by ChicagoPianoTuner, January 28, 2015, 11:50:13 AM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

Volker Dirr

#15
I don't know the names of your courses. Let's say you call it like this:

Example:
You have Year 7.
Classes 7a, 7b, 7c
English Easy, English Medium, English Difficult
...

Then you need to have a students structure like:
"Year","Number of Students per Year","Group","Number of Students per Group","Subgroup","Number of Students per Subgroup"
"7",0,"7a",0,"Peter Wood (01.01.2007)",1
"7",0,"7a",0,"Lisa House (01.02.2007)",1
"7",0,"7 English Medium",0,"Peter Wood (01.01.2007)",1
"7",0,"7 English Difficult",0,"Lisa House (01.02.2007)",1
...

But like i said: it is very much work to enter. You should import such data from your school administration software. I fear it can't export that directly, but can check if i can code an import filter from the csv file format of your school administartion software. if it isn't a to rare software, i can try to code it. Of course you can also contact your school administration software and ask them to code an export like that.

Liviu Lalescu

Quote from: ChicagoPianoTuner on January 28, 2015, 08:19:58 PM
I can't seem to find any information in the documentation on how to construct groups from subgroups.

Volker just answered for import from CSV. Another way is to make an XML .fet file. You need to examine an example, for instance German sample 1.

ChicagoPianoTuner

Okay, I think I understand now.  I'll be meeting with my school's administration and then I can figure out what sort of access I have to that data.  I am sure that I can have them export whatever data I need, probably in MS Excel, then I can arrange it properly (simple cut/paste) and then export as CSV, then import to FET.  I have made a simple test file and it all seems to work fine.

I know about XML, but I am not at all proficient enough to use it.

Thank you both very much for your help.

Liviu Lalescu

You are welcome!

If two students have the same timetable, it is best to use only one of them (for speed).