Excel Templates | Excel Spreadsheets | Weekly Class Schedule



Weekly Class Schedule

Posted on October 28, 2009
Filed Under Calendar | 3 Comments

Pin It

One excel spreadsheet that can be built based on my weekly calendar template is a weekly class schedule. You can print this spreadsheet as a blank weekly schedule or you can customize it based on your weekly schedule. And like my weekly calendar, you can customize it by filling in one column list and the excel formula will automatically adjust your schedule in the weekly schedule worksheet.

Weekly Class Schedule

This weekly class schedule consists of two worksheets. The first one is a worksheet where you have to fill your lesson schedule based on lesson recurring period, either day or date, and fixed date reference. For example, within your academic year, you have math lesson that recurred every Monday, you have probably one lesson that only occur once a month, and you have lesson examination with fixed dates, where all dates have to be filled manually in a blank calendar or in your school book.

By using this spreadsheet, all you have to do just type your lesson in corresponding column and select your recurring days or just typing your recurring dates or fixed dates. The excel formula will automatically place your lesson information in corresponding date in weekly worksheet. And don’t forget to put your lesson period by typing the start and end time of your lesson. There is also a holiday column where you can add your school holiday.

Weekly Class Schedule Setup

After finishing the first worksheet, you can customize your weekly schedule worksheet. Just put the start time that will be used for slider bar reference, and your weekly class schedule is ready. You can slide right or left to see how your schedule is displayed. And you can use this feature to select your weekly schedule to be printed. The maximum lessons that can be displayed at the same date are only 20 lessons.

I think there are still some features need to be added, and I will be appreciated if you can give me some feedback to improve this spreadsheet.

You can download the file here.



Tags: , , , , ,

Comments

3 Responses to “Weekly Class Schedule”

  1. Seif Amr on January 13th, 2011 12:48 pm

    in Egypt we have Fridays and Saturdays as holidays instead of Saturdays and Sundays, could u do one for that?

  2. Dipak Somak on January 16th, 2011 2:39 pm

    This looks realyl useful….I am helping a charity org utilise it’s small rooms and halls and this might help do that. Do you have a 2011 or are you able to unprotect the “schedule” ?

    thanks
    D

  3. richard on April 21st, 2011 12:42 pm

    similar to the comment from dipak above – useful calendar but need to amend for 2011. ARe you able to unprotect the schedule tab or suggest a work round?

Leave a Reply