If you ever drop your keys into a river of molten lava, forget em', cause, man, they're gone. –Jack Handey
Question #91073 posted on 03/21/2018 7:30 p.m.

Dear 100 Hour Board,

I am the Primary President in a ward with lots of growth. My presidency and I use Google Drive to create class lists, lesson schedules, etc. We have one Google Doc with all of the class lists which we print off to give to the teachers.

Because we have so many families moving in, we are updating these lists every week. I want my teachers to have updated lists but I don't love the idea of printing off a new list every time they gain a child. At the same time, though, I don't want to give all the teachers access to the Google Doc since it has all of the class lists. I know that I could create a separate doc for each class and share that doc, but then my presidency would have to update the class lists in two separate places.

Ideally, I would love to create a separate doc for each class that somehow is linked to the master class list doc so that when we edited a specific page on the maser doc, it would also edit the individual one. However, I don't think that this is a possibility.

What other ideas do you have to help us conserve paper but still allow the teachers to have accurate and up-to-date class lists? As a side note, we have a few children who either don't have records (they were never blessed so a record wasn't created), or their record is in a different ward (i.e. parents are divorced and records are with mom but the kids are with dad every other weekend). This means that the lds.org class lists are incomplete, so I don't want to use those either.



Dear person,

If you are willing to reconsider moving your class lists from a Google Doc to a Google Sheet, there is an easy way to do this using the Import Range function. This is a good post explaining how the function works

Create a master spreadsheet with a tab for each class. Then create a new sheet for each class and hook each of them up to a different tab in the master doc. Then share the individual sheets with the teachers. 

I can't quite understand from your question if you are using the class list to take attendance and want the teachers able to record attendance on their individual sheets so that it also shows up in the master document. If that is the case, I'd recommend a different solution. If you are interested to know more please ask another question and I can address that.



Dear Stitch,

You should still use the ones generated on lds.org because records can be created by the ward clerk for your ward only. So if a child's records are in another ward, work with the clerk to make a record for them for your ward. I know that may not sound appealing because it's not something you can do on your own but that is literally the job of the ward clerk. Then you will have up-to-date records when someone moves in too. Honestly it seems like less work to ask the ward clerk to make records for children whose records are not in the ward than it does trying to manage an excel sheet for every primary class.