ASP.NET School Time Table Generation

After a very very long time I am back with anew post.

In this short post I will give you some important tips and hint to create a dynamic time table for schools.

I will definitely share the code and sql scripts in my next post.

I have created this timetable for my School Management System[SMS] and is a key highlight of the SMS application.

The key feature of this timetables are:

1. Very Very Very user friendly.
2. Through integrity and validations.
3. Has an option to create multiple templates(for those scenarios where school runs in multiple shifts and has variable periods/lecture).

Now lets talk business.

Steps to create a time table.

1. Create a thorough link between Standard-Division,Standard-Subject,Standard-Division-Subject-Teacher.
2. Create an aspx page it should accept the following input(A). 
• School start time,school end time,first break time,second break time,third break time all these break times should be optional,number of periods,period duration.
• Create a stored procedure that will accept these arguments and will create the list of periods and their timings.
3. Create a user control with 2 dropdownlist(AutoPostback=True for both) (B)
• The dropdownlist should populate the subjects for that particular class and division.
• The second dropdownlist will populate the teacher for the subject selected in the dropdownlist.
4. Create a aspx page with 3 dropdownlist(Standard,Division and Timetable)
• After selection of these parameters you should create a dynamic table.
• Load the cells of the dynamic tables with the user control.
5. Your time table generation format should look like this.

Good Luck,

Long Live .Net