Friday, 18 July 2008

online subject system

Version 2008.3a

the ability to hide a subject from being shown in the student list is now available. When you change the subject details through the teacher part you can change a hide code from 0 shown, to 1 hidden. Later on I could make this a combo box where it shows the words instead of a 1 or 0.

But this makes it a little less confusing when students already have english selected for them, they cannot select another english subject again.

These changes have now been made tothe live server.

Require a list of subjects that cannot select, especially when it comes to esl english. Though how do we put in richard centre and deaf centre students, this question is still to be answered.

I have been thinking about the maths, english, science question that was posed to me early on and it was decided that it wasn't going to be developed under this version, however, if I was to develop it I think it would be a valuable part of the system. Being able to say that if your were english you could assign students to a subject, since all the information is in one column of data the UPDATE statement would be quite easy to do, though if the students had not selected their subjects you would need to use the INSERT...ON DUPLICATE KEY statement that I used when changing their subjects to allow multiple times.
All the csv files look for is whether it is filled in or not, SELECT details from table where filled = 1;
They would have something in the export to KAMAR file as their would be information in the transaction table. It would be just their compulsory subjects.
How would I want it to look, would you bring in all students at a time, or develop a login for teachers in a subject to change where they think the students should go. You would also have to include the previous years english class in the information, and at the moment this is spread over 6 fields.
Another question: I have to ask is how do they want the 11FIN/11HEA/11GYM details to be entered.

No comments: