What is the schedule like for a CRNA?

Auto-generating individual schedules from a master schedule?

• Last year, my school used a google spreadsheet as a master schedule, both in general and for days that differed from our normal weekly schedule. It was very effective for knowing where a certain class was or who was using a certain room, but it was not teacher-friendly. I'd like a way to take the master schedule and auto-generate a teacher's individual schedule. Is there a way to do so without a lot of extra work? Specifics inside. One day of our master schedule looked something like this: (please excuse formatting) MONDAY-------------------------------------------------------------------------------------------------------------------------------- | Homeroom 9X - Rm 1 | Homeroom 9Y - Rm 2 | Homeroom 9Z - Rm 3 |-------------------------------------------------------------------------------------------------------------------------------Period 1 | Course A (Teacher J) | Course B (Teacher K) | Course C (Teacher L) |Period 2 | Course D (Teacher K) | Course E (Teacher M) | Course F (Teacher J) |Period 3 | Course E (Teacher N) | Course F (Teacher K) | Course G (Teacher L) |Period 4 | Course A (Teacher L) | Course B (Teacher M) | Course C (Teacher N) |Each day had their own table like the above. Color coding helped somewhat, but only per subject area, not per teacher. An example of what I would like to generate: --Teacher K-- Monday Period 1: Course B - Homeroom 9Y - Rm 2 Period 2: Course D - Homeroom 9X - Rm 1 Period 3: Course F - Homeroom 9Y - Rm 2 Period 4: [PREP] Next year's constraints: - Master schedule should look similar. - We already use google calendar for events and would rather have a separate weekly schedule. - Free or low cost software if needed. We do use google apps for education. All staff have access to Macs on a regular basis. - Entries should be easy to input. (I do not want to recopy information from a schedule unless absolutely necessary.) - It is possible to generate many master and individual schedules, incl ones for half day, special events, etc. - Entries can be easily changed and individual schedules can be regenerated. - Prefer to generate either one, some, or all individual schedules as needed. - Courses do not meet the same time every day. - Rooms will now be assigned by course (Math, English, etc) instead of by Homeroom (10A, 10B, etc) These could be listed along with course and teacher in the individual cells. - Homerooms will often travel together, but will sometimes be split in two: Period 2 for Homeroom 9Z might have two entries: Spanish with Ms. J and Art with Mr. K. - During some periods, a teacher will not be listed. On their schedule, it should say "[PREP]." Any suggestions would be greatly appreciated. Thank you!

• Answer:

  We use Google Calendar for this at my work, but I see you’d prefer not to. If it makes a difference, each room in our office has its own calendar and can be “invited” to a meeting, which allows our staff to produce a printed schedule separate for each room in the morning, taped to the door as a reminder. By inviting a room and a teacher to an event, you’d have the ability to see separate calendar views for each. In a spreadsheet, I think the ability to filter might be helpful. With a unique identifier for each teacher, that would be possible. Names are not great for this because they can overlap, but a short unique thing like "T20" for "teacher #20" or the teacher’s email address would make it possible to use the filter feature to show only matching rows and columns. The difficulty in your example is that filtering wouldn’t collapse the columns; you would still be seeing all of rooms 1 and 2, but not 3.