making a class calendar

If you’re teaching a Bahá’í children’s class, one thing you’ll probably find indispensable is the class calendar. At its simplest, this is a list of lesson topics or themes that will be covered during your school year. More complex calendars can also include lists of activities to be included in each lesson, prayers and quotes to be studied, and so on. Over the years, we’ve put together a calendar template that seems to work well for us. We’ve written about it before, but this time around, we’ve prepared some sample templates for you to download and use. Go ahead and download our pre-filled neighbourhood calendar template for Microsoft Excel (.xlsx) and open it in another window, and we’ll run you through the basics of it here. There’s also a blank template if you just want to dive in without having to look through a bunch of fake data.

Our calendar is actually a combination of two things: a class calendar and a class attendance sheet, all on the same worksheet. This means that you can enter the dates for each of your lessons and fill in all the related activities in one section of the sheet, and scroll to the next section to record attendance for the class after it happens.

neighbourhood calendar

Because we had a children’s class and a junior youth group going at the same time in our neighbourhood, we built space for both into our calendar. The “Type” field can be anything, but I usually use the following abbreviations for different activities: “CC” for children’s class; “JY” for junior youth group; “HV” for home visit; “RM” for reflection meeting; “DM” for devotional meeting; “SC” for study circle; and so on. There are enough columns for all the basic elements of a children’s class—quotes, prayers, songs, stories, drama and games, arts and crafts—and extra space for notes.


The attendance sections (one for a children’s class and one for a junior youth group, but you can always copy and paste in Excel to make more) provide space for quite a few participants, and can always be expanded by inserting new columns. As you can see in the figure above, there’s space for a first name, age, family identifier (usually the first name of a guardian), and comments to give some context and help you remember who’s who (such as where you first met them). You can put “yes” or “no” for attendance in a new row each week, and at the very end of the spreadsheet, there are a few “total” columns that will tally up the number of yeses to give you the final attendance numbers.

There are a lot of benefits to using a calendar like this. First of all, because it includes a section for attendance, keeping accurate statistics is easy. If you import the calendar to a service like Google Drive, it can make collaboration within a teaching team easier, too, since different team members can access it and update information in real time. If you’re not a computer person in the first place, you can always print it out and complete it by hand, too! And, of course, it’s a great tool for organizing and planning classes and other activities in your neighbourhood.

This entry was posted in misc and tagged , , by dan. Bookmark the permalink.

Leave a Reply

Your email address will not be published. Required fields are marked *