I have been asked to make some changes to the program to allow it to be used as part of an re-enrollment package for the beginning of the year. Once students get there ncea results they will have the opportunity to jump online and make changes to there subjects based on the information they have. This then gets imported into the SMS and a timetable is created. All good in theory, but how will it work in practical. I am going over my code looking for how I developed the system and am surprised to see that I have already coded some of this in, and left it either commented out or being used in the junior sections.
I have fixed up the messages code and included in a table that will be able to be edited by others, something I wrote in comments ages ago and had yet to do. Now I am trying to figure out how to include a extra drop down box and how this will affect the I am planning on leaving school, there are now 32 options afterwards on where they are looking at going. This could be added to the main table and if there is a leaver they will have a number added to a field that will be pulled out in a report. select * from table where leaver = 2 order by asc.
This needs to Include blank timetables or no passing of information through to the export and that filled==2
If a student is leaving school? Does a student need to have their timetable reported back into the system? yes, if they are leaving school and are not coming back, they may come back later on.
One thing that makes this one different is that I have to include option lines, the thing about that is trying to figure out a way to do option lines being the beast that they are. I thought about doing different database row entries for each line, but this becomes unmanageable. One way around this could be to use the LIKE statement to look for the option line in the option field, this would mean changing the field from INT to VARCHAR(6) as there is the possibility of six option lines.
Has every students selected subject lines == no, some students don't have subjects, so these would have to have dummy/empty lines attached.
what does does it go live? NZQA release there results - 17 or 20 Jan
Those not returning could possibility get a different confirm screen, this would allow then to select from a combo box on where they ate planning to go and would be simpler to program. Students would still need to have the filled==2, and it would be unlikely that they would relogin and change there selections