Template: click here

Canva Logo: click here (350px wide x 168 px tall)

Canva Ship Board: click here (8in x 8in)

Canva Title: click here (890px wide x 100px tall)

Canva Question Cards: click here 405px wide x 205px tall)

Ship Images: click here

How this works:  Students reveal questions using the dropdown menus.  They can answer questions (in any order) and will immediately know if their answers are right (green) or wrong (no change).  Correct answers will allow students to guess the location of a ship.  The sheet will say “hit” or “miss” and then display the appropriate image in the appropriate location.

Sheet 1:

• Add a title (text or image)

• Change the logo/theme

• Directions

• In the progress bars, you can change the hex codes to match the colors of your themes

Check to make sure that all of your answers are correct – change the font if you want, the size, etc. Make sure that the spreadsheet is working the way that it is supposed to – test it out!

Sheet 2:

• Add in your questions (text or image) PLUS a directions card that tells students to use the drop down

• Modify the “hit” or “miss” phrasing if you want

• Add in your correct answers – if there is only 1 correct answer, you can leave “aa” etc OR change it to gibberish – DO NOT LEAVE IT EMPTY

• The locations are all the potential spaces a ship would be located. IF there is a ship in a location, column G would need to say TRUE.  If there is no ship, FALSE.

• The “spacing” you can modify/adjust as you see fit.

• Hit images go in the “hit image” column and “not hit” would be the original.

To create your images:

• Start with a square document and add a 6×6 table (that way you know where things are) – you can use the canva template that has this step done for you

• Drop in your ships (or images) and place them appropriately. Duplicate this slide and add in markings to show that images were hit

• Remove the table that was added to the slides as a guide

• Export the files as images

• Split the images into pieces using Pinetools.com/split-image – you’ll need to split using the GRID and 6 ways vertically, 6 ways horizontally (Canva also now has a feature that does this)

• Insert the files in the appropriate locations – think – row 1 column 3 is the same as A3.

Finishing Details:

• On sheet 2, click the check box in D14.  This will turn everything white.  For extra protections, you can highlight the entire spreadsheet and make the columns super wide and the rows super skinny.  

• Go to Data → and choose Protected Sheets and Ranges.  You will click the + to add a sheet or a range.  You’ll need to click the tab that says Sheet and choose Sheet2 if it is not already chosen in the drop down.  Click Set permissions and then Show a warning when editing this range.  Click done and then hide the tab. 

• On Sheet1, we will follow very similar protections.  Go to Data → and choose Protected Sheets and Ranges.  You will click the + to add a sheet or a range.  You’ll need to click the tab that says Sheet and choose Sheet1 if it is not already chosen in the drop down and click the checkbox that says except certain cells.  Click the grid, then holding down command/control, you’ll need to choose all of the answer spaces, the guessing spaces and the two dropdown boxes.  Click Set permissions and then Show a warning when editing this range.  Click done.

⚠️A Quick Reminder About Sharing!
When you share your creations on social media, please do NOT include the Google Sheets URL or let it show in any screenshots or videos. Even a quick glimpse of the link means anyone can access (and steal) your resource for free – yikes!  Keep your hard work protected and just show the activity in action without revealing the URL.

BONUS: Ship Sinker More Battles, Less Prep

In this bonus, you’re getting 2 more Ship Sinker Templates. These two templates work just like the original Ship Sinker game, but with a smaller grid — only 25 guessing spaces instead of 36. This means less time spent creating… and more time for you to reheat your coffee for the third time, scroll TikTok for “recipe ideas,” or just stare at a wall in peace. You’ve earned it! When you build your ship board, you’ll need to build it so that it is 5×5, and when you split the board, you’ll need to split it the same way (5×5) so that you get 25 pieces.

Here are the two versions included in this set:

 Template 1: Exact Answers – click here

• Students must type their answers exactly as you wrote them (including spaces, punctuation, etc.)

 Template 2: Flexible Answers – click here

• This version is more forgiving… it will accept variations of correct answers (Example: both “aa” and “a a” would be accepted)

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.