logo_sheets_128px
logo_docs_128px
logo_forms_128px

Google apps such as Sheets, Docs, and Forms help students organize and sell yearbooks. Below are examples of how the Compton Jr. High Yearbook class used each of these apps for our 2017-2018 yearbook.

Google Sheets can be your yearbook organizational tool. 

  • Column A = Page numbers with the function =A3+B3. Even pages are on the left side of the yearbook.
  • Column B = Number of pages per group. This number is used in the above equation.
  • Column C = Section title. The title is linked to the actual Google Slide using Insert -> Link. Multiple people will be assigned to this section.
  • Column D = Section number. This makes sorting the sections easier.
  • Column E = Name of the group.
  • Column F = Advisors name if necessary. It might be advisable to include the advisor's email address.
  • Column G = Student yearbook staff member who is assigned to the page.
  • Column H = Link to Google Photos Album OR Google Drive folder. Only the best photos are stored in the Album/folder.
  • Column I = Is the group done?

Below are examples and a template that you can modify.

When students sell yearbooks, the student salesperson completes a paper Google Doc and adds an entry in the receipt book. This paper Google Doc allows us to double check all sales. Furthermore, it gives us information such as Advisory teacher for delivery and student school email if they purchase their own page.  The Google Doc is not fancy, but it serves its purpose.

Forms
Sheets

Google Forms and Sheets are an excellent way to keep track of yearbook sales. Below is an example of the Google Form we used. Notice that the Google Sheets includes functions to keep track of the number of yearbooks sold and the money received.

Google Forms, Docs & Sheets

Schools will be audited. As such a receipt book is a must! The white copy goes to the customer, the yellow copy is kept for accounting purposes and the pink copy is saved for the yearbook staff.

This is an Example Sales Google Form with data stored in Google Sheets.

You may notice a question for Student Salesperson. Any yearbook staff member that sales 5 yearbooks receives one free yearbook.

  1. Insert -> Row below Row 1.
  2. Go to View -> Freeze -> No rows to temporarily turn off freeze.
  3. Turn the Freeze option back on for 2 rows.
  4. For Columns G-K, write the following function =sum(G3:G500). Change the letter to the appropriate column name. 

Continue...

What about student privacy? Read on.