Messages

Hi Liviu,

Thanks. I tried the snapshot but I think I'll keep using then the first variant because what I need is the total of the tags. Perhaps doing it in the activity planning screen isn't necessary (though I don't mind scrolling down to see the third row)... I'd be quite happy if when exporting the statistics it would be possible to select what fields to export and to sum those? Not sure if a PivotTable interface is possible... but if all the raw data is extracted I could use a pivot table in Excel to do it too...

But my problem is solved by using the first variant. The second variant I think gives useful information but it's a trade-off between seeing the useful information and also doing the maths... Since I have a few teachers who teach several subjects and need to produce a report for the Government about how many teaching periods they teach - it makes more sense for me to use the one that gives the totals of the relevant periods. Ideally it would be nice to have a report - or when generating the html to have the x-axis as time, the y-axis as periods, with a column at the end summing by a pre-selected TAG... But for now using the first variant and looking along the x-axis of teachers to see their totals on the computer is good enough. I can just transcribe them into a table.

Thank you - I never expected to get such quick and friendly help.
Matthew Charlesworth.

Hi Volker,

Thanks - this is brilliant! I like the second variant where you could click 'show tags' and it would break the subject into it's tagged form e.g.

6 CSC
9 MAT

becomes

5 CSC CLASS
1 CSC Meeting
8 MAT CLASS
1 MAT Meeting

But I would like to also have the third Tag Row at the bottom which was in Variant 1 because that tells me the TOTAL of the Class, which is useful for teachers teaching many subjects... e.g.

13 CLASS
2 Meeting

Is it possible to combine Variant 2 with the third Tag row to show the totals overall?

Matthew.

Hello,
I use FET to timetable not only academic classes, but also extra-curricular ones as well, but I need to be able to see just how many academic classes they are assigned. I would like to be able to quickly get a count of how many teachers are assigned to classes (activities tagged with the tag CLASS, for example), but not include the number of activities of teachers tagged for supervision of extra-mural activities (activities tagged with the tag SPORTS, for example). So I guess I'm asking is it possible to do statistics of teachers by tag e.g. Teacher;Tag1;Tag2;Tag3;Total

NAME;CLASS;SPORT;STUDY;TOTAL
CHAM;28;5;4;37
CHUN;21;6;6;33
etc....

Thank you.
mcsj

Dear experienced FET users,

I'm writing to ask for some help with setting up three different sort of options.

a) My school offers a choice of BKK and TON which must be taught at the same time because the teachers can teach 1,2 or 3 of the classes e.g. Teacher T1 could teach TON to classes 8E, 8EE and 8G and T2 to class 8GG. Students from the four different classes but within the same year can take either BKK or TON. This situation is repeated for year 9.

b) A more complex option involves classes 10 A and 10 B being able to choose TON or LIT during one timeslot and COM or ACC in another. The complication is that the third class 10 Sc offers a choice of LIT or ACC or ADM and the LIT for 10 Sc is taught by the same teacher and at the same time as the LIT for 10 A or 10 B in their TON or LIT.

c) The third option involves a class called PU which must be done by everyone in the school and can be mixed between 8 E and 12 A or 11 A and 11 B, or any two combinations of any class either of the same year group or of different year groups. I don't know if there is a way for FET to automatically schedule any of the classes together - or whether I must determine which classes are grouped and then follow the similar procedure as in (a) above.

In order to try and solve these problems I have setup the following years (8,9,10,11,12) with the following groups and subgroups:

year:     8

group:    8 E
subgroup: 8 E BKK
subgroup: 8 E TON

group:    8 EE
subgroup: 8 EE BKK
subgroup: 8 EE TON

group:    8 G
subgroup: 8 G BKK
subgroup: 8 G TON

group:    8 GG
subgroup: 8 GG BKK
subgroup: 8 GG TON

group:    8 BKK
subgroup: 8 E BKK
subgroup: 8 EE BKK
subgroup: 8 G BKK
subgroup: 8 GG BKK

group:    8 TON
subgroup: 8 E TON
subgroup: 8 EE TON
subgroup: 8 G TON
subgroup: 8 GG TON

This was duplicated for Year 9. For years 10, 11 and 12 I used the following breakdown, using year 10 as an example:

year:     10

group:    10 A
subgroup: 10 A LIT COM
subgroup: 10 A LIT ACC
subgroup: 10 A TON COM
subgroup: 10 A TON ACC

group:    10 B
subgroup: 10 B LIT COM
subgroup: 10 B LIT ACC
subgroup: 10 B TON COM
subgroup: 10 B TON ACC

group:    10 Sc
subgroup: 10 Sc ACC
subgroup: 10 Sc ADM
subgroup: 10 Sc LIT

group:    10 LIT
subgroup: 10 A LIT COM
subgroup: 10 A LIT ACC
subgroup: 10 B LIT COM
subgroup: 10 B LIT ACC
subgroup: 10 Sc LIT

subgroup:
group:    10 TON
subgroup: 10 A TON COM
subgroup: 10 A TON ACC
subgroup: 10 B TON COM
subgroup: 10 B TON ACC

group:    10 COM
subgroup: 10 A LIT COM
subgroup: 10 A TON COM
subgroup: 10 B LIT COM
subgroup: 10 B TON COM

group:    10 ACC
subgroup: 10 A LIT ACC
subgroup: 10 A TON ACC
subgroup: 10 B LIT ACC
subgroup: 10 B TON ACC
subgroup: 10 Sc LIT ACC
subgroup: 10 Sc TON ACC

group:    10 ADM
subgroup: 10 Sc ADM

My question is, is there a way of making BKK TON (in the case of Years 8 and 9) options using individual subjects BKK and TON or must I create a subject called BKK/TON ? similarly, do I create TON/LIT, COM/ACC and LIT/ACC/ADM as subject? But if that is true - do I have to make the groups COM/ACC and TON/LIT/ACC/ADM - even though TON/LIT is concurrent for classes A and B and LIT/ACC/ADM only for the Sc class. Basically - how can I create the TON/LIT and LIT/ACC/ADM so that it's taught in the same timeslot across classes A, B and Sc. And if I use the latter option is there a way of showing only TON/LIT in classes A and B and LIT/ACC/ADM in the Sc class generated timetables? And do I add the subgroups (e.g. 10 A LIT, 10 B LIT, 10 Sc LIT) or groups (10 LIT) to the activity?

I tried using the Divide option but then it created a whole lot of Sc subgroups which included for e.g. COM - and so I thought I should manually edit the groups as above. Did I do the right thing?

Or is there a constraint to say that when one activity is being conducted, another should also be run simultaneously?

I've spent so much time trying to figure out my (a) and (b) I haven't had a chance to attempt (c) (with PU and using mixed classes in mixed years) - but if you have a suggestion on that, I'd be most grateful.

Thank you in advance, and if I have forgotten any other piece of information that you might need please let me know and I'll try and tell you.

matthew.