Table of Contents Example 2

Your school site will choose either Google Photos or Google Drive to share photos. Regardless of your choice, you will need to share the photo albums or image folders with your colleagues and student. Below are the steps to share those albums/folders with your staff.

Google Photos or Google Drive

Step 1 - Share Photos

  • Student editors upload the photos to either Google Photo or Google Drive.
    • Stick with one choice for the year.
  • If uploading from a memory card, student editors should remember
    • Delete the photos on the memory card after they have been uploaded.
    • Memory cards are easily lost. Keep track of them!
    • If using a USB cable, return it to the assigned location so that it doesn't get lost!

Step 2 - Google Sheets

    • CREATE a Google Sheets Table of Contents or something similar to organize the yearbook.
      • We will discuss the Table of Contents in a moment.
    • As Albums/Folders are created, copy the Shareable link and paste it into the Google Sheets.
Google Classroom logo 128

Step 3 - Google Classroom

When a student un-enrolls from the class, he/she no longer has access to the Google Sheets Table of Contents.

Because the shared settings of Google Photos are on/off (no specific groups option) remind students of good digital citizenship. They can not share the link with their friends or repost those photos anywhere expect the yearbook.

Google Sheets Table of Contents

When the photos have been uploaded to either Google Photos or Google Drive, the links to the albums or folders will need to be shared with students. This past spring, Compton JHS students used a Google Sheets to not only organize the album links but also to organize the order of the sections and keep track of the page numbers. The Sheets was posted in Classroom along with the yearbook created in Slides.

Our yearbook class called it close on the 2017-2018 yearbook price. Pre-sale orders were $10 and late orders were $15. The price was nice for students BUT we had added extra pages so it cost us exactly $10 to print each yearbook.  No profit made. As we have plans to expand the yearbook with more writing and photos in 2018-2019, our pre-sale price will need to increase. By using this Table of Contents at the beginning of the year, we can better project the cost of the yearbook and stay within that budget.

  • Column A = Page numbers with the function =A3+B2. The even pages are on the left-hand side of the yearbook.
  • Column B = Number of pages per group. Some groups may have 1 page while others may have a 2-page spread. This number is used in the Column A function.
  • Column C = Link to Google Slides Section. The yearbook is broken into sections for faster downloading and student ownership. The column is formatted to be clipped so that the entire link is not viewed.
  • Column D = Section number. This makes sorting the sections easier. Our student staff heavily debated where the individual students should be placed. We renumbered the pages multiple times until most of us were happy.
  • Column E = Name of the Group Photo Album or Folder (i.e., yearbook, choir, woodshop, etc).
  • Column F = Link to Album or folder.
  • Column G = Advisor's name
  • Column H = Advisor's contact information (school email or room extension).
  • Column I = Name of student yearbook staff assigned to this page.
  • Column J = Comments and questions.

Below are examples and a template that you can modify.

Additional Resources

YouTUBE Playlist

  • Google Sheets Tutorial by Stephen Kwiecinski
  • The NEW Google Classroom Updates! (2018) by MsLamm1
  • Adding students to Google Classroom (2018) b Alice Keeler


Caption Writing

A yearbook is not a yearbook without captions. How else will you remember names, dates, and events?