Class Schedule

[Shud]

I am trying to create a class schedule with excel for my school. Right now I am stuck. I want to be able to put all the students on the master schedule then be able to create individual schedules with the teachers they are taking from it. I have tried several 'If' statements and nothing is working. I don't know if it is even possible to do. Let me know if anyone has done this before and might have some answers. Thanks!

 

[NARAYANK991]

Hi ,


If you can upload some data , and supply the rules , help will certainly be forthcoming.


Any class schedule will have the basic data :


1. Classes and their timings

2. Teachers and their classes

3. Students and their classes


The rules may be specific to your school , teachers , students , classes. If you can specify all the rules , we can take this forward.


Narayan

 

[Shud]

Hi,


Thanks for the response! How do I upload on this site? Can I upload my excel file?

 

[maku]

Here are instructions for posting a file...they are in the sticky's at the top


http://chandoo.org/forums/topic/posting-a-sample-workbook

 

[Shud]

https://docs.google.com/spreadsheet/ccc?key=0Aj1TqskjVuJPdEZhTmUwZkJhQmpnbm9NYzFwa2JNY3c


I would like to enter student names on the 'master schedule' then they would transfer to the 'schedule student' sheet or to the 'indiv schedule' and automatically create individual schedules for students with their teachers.


Let me know if this is possible or if there is a better way to make this happen.


Thanks!

 

[Luke M]

Perhaps this will help out:

http://www.rondebruin.nl/copy5.htm


It's fairly basic in what it does, but it does it well.