Extensions

In this extension, you will change the skin of your navy-themed guessing game.

A “skin” refers to the appearance of a computer program, game, or character.

Skins can be changed to match the purpose, topic, or tastes of different users.

To begin, decide on a different theme for your game.

For example, you could set your game in space and change your ships to spacecraft.

Or, you could set your game in a field and change your ships to flowers that your partner has to try to collect.

Then, open the spreadsheet for your game.

Make a copy.

And rename it to match the new theme of your game.

Next, select all of the cells in the grid.

And remove any X’s from when you previously played your game.

Then, remove the shading from your key.

Then change the shading and text color in your grid to a color that represents your new theme.

If you want to set your game in a field, for instance, you could make your grid green.

Then, change your conditional formatting rules.

For example, if you want your groups of cells to represent flowers, then change your conditional formatting rule to use a shading color that looks like a flower.

Next, change the text associated with the rule.

And change the names of your hidden targets so that they match the new skin of your game.

Finally, change the label at the bottom of your sheet to match the new theme, as well.

Nice work! You changed the skin of your game so that you can enjoy the same game in a different way.

If you’d like to play the game with a partner, ask them to change their game’s skin in a creative way.

Then, share your new spreadsheets with one another.

And play your new game! Now, it’s your turn: Make a copy of your spreadsheet and rename it.

Clear any text from your grid and change the shading and formatting, Change your conditional formatting rule, And update your key.

In this extension, you will write directions for your game so that other people can play it, too.

To begin, open the spreadsheet for your game.

Then, clear any text and shading from when you previously played your game.

Remove your name from the tab at the bottom of the sheet.

Next, add a sheet.

And rename it “Directions.” Then, write directions for your game.

Start by describing the objective of the game.

Add another direction on a new line within the same cell by inserting a break.

To insert a break, press and hold “Ctrl” and “Enter” at the same time.

Next, add directions for setting up the game, including finding a partner and sharing the spreadsheet with them.

Finally, add directions for how to play the game.

Include details about how to hit and sink another person’s ships, how to record hits on your spreadsheet, how to track your hits on the other person’s board, and how to win the game.

When you’ve finished writing the directions, resize the column to fit the text.

Great job! Now that you’ve written the directions for playing your game, you can share it with others so that they can play it, too! Now, it’s your turn: Clear your spreadsheet of text and shading from your previous game, Add a new sheet and rename it “Directions,” Write directions for playing your game, Resize the column to fit the text, And share your game with others

In this extension, you will make your game more complex by claiming more territory in your digital ocean and adding more ships.

To begin, open the spreadsheet for your game.

Then, make a copy and rename it.

Then, select the last three columns in your grid.

And insert three columns to the right of them.

Next, select the last three rows in your grid.

And insert three rows below them.

Then, copy the format of a cell that is not part of one of your ships.

And paint the format onto the cells you just added to your territory.

Next, add the names and sizes of three new ships to the key.

The ships should contain no more than eight cells and no fewer than two.

Then, select all the cells in your grid and open the conditional formatting menu.

You can review the position of all your existing ships by hovering over the rule that you previously created.

Add a new ship to your ocean territory by adjusting your conditional formatting rule.

To do this, add another data range and select the cells you want to represent your new ship.

Compare your new range to the other ranges to double check that the ships don’t touch or overlap.

Repeat this process to add two more ships.

Finally, select your grid, remove the X’s from your previous game, and remove the shading from your ship key so you can play your game.

Now, it’s your turn: Make a copy of your game and rename it, Insert three columns and three rows into your grid, Copy cell formatting to the new cells, Add your new ships to your key.

Add conditional formatting to three new ranges of cells, And clear your spreadsheet of text and shading from your previous game.