Generic filters

Lesson Schedule Excel Template

This template is design to create a yearly lesson schedule for Sunday school class with multiple teachers. It helps the teachers plan in teaching and prepare schedule of  lesson each week. A simple list to create very easily using Word or some other text editor, but this template is customize using Excel so that the dates can enter automatically. Using this version is probably the most convenient way to share the schedule among the teachers.

How to prepare schedule of lesson?

The main purpose of this template is to help a group of teachers coordinate with each other who are teaching what lesson and when. Instructions to understand this

  1. Enter the Start date
  2. Choose which day of the week the lessons will be taught, using the drop-down list the Start date.
  3. Edit the hyperlink formula at the top to link to the online manual.
  4. Edit the Teachers list at the top of worksheet. This list will populate the drop-down boxes in the table.
  5. Plan what lessons will be taught and enter the lesson or topic in the table. Consult a calendar to check for holidays or other events that may interrupt the normal teaching lesson schedule. You may want to highlight these dates to avoid planning a lesson for that day.
  6. Send the schedule to the teachers and let them indicate in the “Unavailable” column which days they are unavailable. You can use initials or abbreviated names as required.
  7. After entering who is teaching which lesson, if you find out later that a teacher is going, the teacher can contact other teacher to ask if you can swap days.

Non-Weekly Classes

The Day field at the top and the formulas in the Date column are design to handle weekly classes. For non-weekly classes or for a rotation not included in the drop-down list. You can enter dates manually into the lesson schedule.

Download Lesson Schedule Excel Template
Share on facebook
Share on linkedin
Share on email
Share on whatsapp

Download Guide

Compatible with : Microsoft Office Excel, Libra Office, WPS Office, Google WorkSheet
  • Download The Template XLSX File Format
  • Use the Template

Download Instruction :

All Excel templates and tools are sole property of User can only download and use the excel templates for their Personal use only. All templates provided by XLSX templates are free and no payment is asked. However, you are not allowed to distribute or share in any other website for sole purpose of generating revenue from it.

 You can also download and use our 1000 Best PowerPoint Presentation Templates and 500 Resume Samples from  Completely Free. All our templates are designed by Professionals

Recently Uploaded Excel Templates: