BONUS SHEETS

Google Sites & Google Sheet Bonus Activity Template

Canva link to title: click here

• • If you choose to make the title slide outside of canva, the sizing is 12.5 x 2 inches

Canva link to logo: click here

• • If you choose to make the title slide outside of canva, the sizing is 6 x 2 inches

Canva link to code (letters and numbers) cards: click here

• • If you choose to make the title slide outside of canva, the sizing is 2 x 2 inches

Canva link to question cards: click here

• • If you choose to make the title slide outside of canva, the sizing is 5.5 x 3.5 inches

To make a copy of the template, click here

How this template works:

On Sheet 1, you’ll need to add:

• • Title of the activity

  • Directions for the activity 

  • Questions for the activity

On Sheet 2, you’ll need to add:

• • In Column B:  all of your correct answers, starting in the cell that says “a”

  • Change the code in column I

    • Click into the first code cell, press = and then choose your first letter/number from column G – press enter when you selected it

    • Continue changing the letters/numbers to what you want the code to be

Before adding protections, be sure to go back to sheet 1 and make sure that everything is working correctly and that all of your correct answers work.

To add protections:

Sheet 2: Highlight all of sheet 2 and change the font color to white.  You’ll also want to make the columns as wide as you can and the rows as skinny as you can.  After you have done this, go to DATA → Protected Sheets and Ranges.  Add a protection to all of sheet 2 and make sure to choose “show a warning”.  Once you have done this, hide sheet 2.

Sheet 1:  You’ll want to add protections to all of sheet 1 with the exception of the answer spaces.  Go to DATA → Protected Sheets and Ranges.  You’ll choose Sheet 1 and click “except certain cells”.  From here, you’ll need to choose all of the answer spaces.   Make sure to choose the “show a warning” at the end.  

Game Show Activity Template

Canva link to title: click here

• • If you choose to make the title slide outside of canva, the sizing is 9.75 x 1 inch

Canva link to question cards: click here

• • If you choose to make the title slide outside of canva, the sizing is 5.7 x 2.8 inches

To make a copy of the template, click here

How this template works:

On Sheet 1, you’ll need to add:

• • Title of the activity

  • Directions for the activity 

  • Questions for the activity

  • Drop-down menus in answer spaces for any multiple choice questions 

On Sheet 2, you’ll need to add:

• • In Column C:  all of your correct answers, starting in cell C16

Before adding protections, be sure to go back to sheet 1 and make sure that everything is working correctly and that all of your correct answers work.

To add protections:

Sheet 2: Highlight all of sheet 2 and change the font color to white.  You’ll also want to make the columns as wide as you can and the rows as skinny as you can.  After you have done this, go to DATA → Protected Sheets and Ranges.  Add a protection to all of sheet 2 and make sure to choose “show a warning”.  Once you have done this, hide sheet 2.

Sheet 1:  You’ll want to add protections to all of sheet 1 with the exception of the answer spaces.  Go to DATA → Protected Sheets and Ranges.  You’ll choose Sheet 1 and click “except certain cells”.  From here, you’ll need to choose all of the answer spaces Make sure to choose the “show a warning” at the end.  

This or That Activity Template

Canva link to title: click here

• • If you choose to make the title slide outside of canva, the sizing is 7 x 1 inch

Canva link to question cards: click here

• • If you choose to make the title slide outside of canva, the sizing is 5.4 x 2.8 inches

Canva link to logo card: click here

• • If you choose to make the title slide outside of canva, the sizing is 3.5 x 1.5 inches

To make a copy of the template, click here

→ the way this template works, for each question students will choose their most preferred option.  This means that in a 12 question template, you will need 24 questions, as each question will have 2 potential options 

How this template works:

On Sheet 1, you’ll need to add:

• • Title of the activity

  • Directions for the activity 

On Sheet 2, you’ll need to add:

• • In Column E:  all of your “this or that” options need to be added in

  • In Column F:  all of your question cards need to be added as well as the “title card” that appears before students choose a “this or that”

  • In Column G:  all of your correct answers, starting in cell D21

Before adding protections, be sure to go back to sheet 1 and make sure that everything is working correctly and that all of your correct answers work.

To add protections:

Sheet 2: Highlight all of sheet 2 and change the font color to white.  You’ll also want to make the columns as wide as you can and the rows as skinny as you can.  After you have done this, go to DATA → Protected Sheets and Ranges.  Add a protection to all of sheet 2 and make sure to choose “show a warning”.  Once you have done this, hide sheet 2.

Sheet 1:  You’ll want to add protections to all of sheet 1 with the exception of the answer spaces.  Go to DATA → Protected Sheets and Ranges.  You’ll choose Sheet 1 and click “except certain cells”.  From here, you’ll need to choose all of the answer spaces AND all of the drop down spaces.  Again, make sure to choose the “show a warning” at the end.  

Need help with this lesson? Email Lisa at lisa@helloalgebra.com and include the workshop and lesson name so we can help you as quickly as possible.