Lesson Schedule Spreadsheet

Discussions about the Lesson Schedules Tool at lds.org.
kennethjorgensen
Community Moderators
Posts: 419
Joined: Mon Sep 10, 2007 12:29 am
Location: Alnwick, UK

Lesson Schedule Spreadsheet

Postby kennethjorgensen » Sun Dec 11, 2016 5:04 pm

With the church discontinuing the lesson schedule tool I have created a spreadsheet to replace it.

As I leader I found the lesson tool very helpful to encourage and follow up on making sure auxiliaries were planning these lessons in advance as well as members always knowing what lessons were being taught for not just themselves but also for their children which could be used for a chat with them on Sunday afternoon.

In this spreadsheet, I have included the lesson material for most of the 2017 lessons and classes.

There are different "sheets" for each class. They contain the dates and the lesson topics and are ready for you to cut, copy and paste according to local circumstances
The sheet "Sunday Lessons" is the view of the lessons for the upcoming Sunday. Here you can change the name of your ward/branch but leave the rest alone.
The sheet "Ward" has the option for you to choose the classes you want to appear on the "Sunday Lessons" sheet according to local circumstances. The date displayed calculates the upcoming Sunday automatically. There are some hidden columns here used to display the data on the other sheet.

The first thing to do is find out when your ward and stake conferences are and mark those on the dates affected and then cut, copy and paste the lesson material around.
For the Youth Sunday School, Young Men and Young Women lessons I have copied the monthly topic into the lesson but all the lessons to choose from are displayed in the other columns for that month so this can easily be copied during planning of those lessons.

I included some 2016 dates and the data for those dates I have only included so you can see it working already now. It is possible to add and delete rows for each class "sheet" if needed.

I have saved it as an Excel 2003 format (xls) so it will be easier to import into an online spreadsheet if you wish to host it online.

LDS_Lesson_Scheduling.xls
(131.5 KiB) Downloaded 544 times

whitebandana
New Member
Posts: 6
Joined: Tue Aug 26, 2014 4:56 am

Re: Lesson Schedule Spreadsheet

Postby whitebandana » Mon Dec 12, 2016 2:28 am

Many thanks for taking the time to do this. I have adapted and shared this to suit our ward's needs and credited you for your work. :D

User avatar
johnshaw
Senior Member
Posts: 1958
Joined: Fri Jan 19, 2007 1:55 pm
Location: Syracuse, UT

Re: Lesson Schedule Spreadsheet

Postby johnshaw » Mon Dec 12, 2016 7:41 am

Ahhh... thanks, the 1990's are back!!!
“A long habit of not thinking a thing wrong, gives it a superficial appearance of being right, and raises at first a formidable outcry in defense of custom.”
― Thomas Paine, Common Sense

bballrob
Member
Posts: 125
Joined: Wed Sep 14, 2011 6:20 am
Location: The Great White North

Re: Lesson Schedule Spreadsheet

Postby bballrob » Mon Jan 02, 2017 2:42 pm

This is pretty awesome!!

Simmons48
New Member
Posts: 1
Joined: Sun Apr 16, 2017 11:34 am

Re: Lesson Schedule Spreadsheet

Postby Simmons48 » Sun Jun 11, 2017 11:25 am

I just want to say a big, THANK YOU!!!


Return to “Lesson Schedules”

Who is online

Users browsing this forum: No registered users and 2 guests