Editing files using Google spreadsheet

Page of 5

Assignment 3 - Google Sheets

Design The Battleship Game

Please download the instructions for your reference.

At the end of this assignment, you will know how to use the following: Fill Color Command, All Borders Command, Outside Border Command, how to change the Height of a cell, Font Colors, and how to change the sheet tab name.

Preparing your Ocean Grid:

1. Open a new Google Sheets. Name the document Battleship. Rename the sheet tab, at the bottom Battleship. Place a border, “all borders” around and “outside border” around the outside of the cells. A1:J10

2. Select A1:J10. Adjust your row height so that it is size 49.

3. Use fill color to make range A1:J10 some color of blue for the ocean.

4. With the range A1:J10 selected change the font size to 36. Select the range A1:J1 merge and center the cells. Then type your “last name Battleship.” Such as LASTNAME Battleship. Center and middle align your Battleship name, your last name Battleship.

5. Make the font color your favorite color, except for black, and change the background color to a unique color of your choice, except for black.

Selecting your Battleship Locations:

1. You have five battleships: Battleship (6 cells), Carrier (5 cells), Destroyer (4 cells), Submarine (3 cells), and Patrol Boat (2 cells). Make the ship any color of your choice. However, each ship should be a different color.

2. Rules for placing ships:

a. Place each ship in any horizontal or vertical position, but not diagonally.

b. Do not place a ship so that any part of it overlaps cells.

3. Shade each location of your battleship using the number of cells from #1with a color. (see example below)

4. When complete upload to your G Suite folder

5. Share the folder URL in Canvas for a grade

How to play the Game with your Family:

Prepare for Battle:

You and your opponent or family member can play; sit facing each other, with the computer screens facing so neither of you can see the other’s ocean grid.

How to Play:

Decide who will go first. You and your opponent will alternate turns, calling out one shot per turn to try and hit each other’s ships.

Call Your Shot:

On your turn, pick a target hole on your paper grid and call out its location by cell name. When you call a shot, your opponent must tell you whether your shot is a hit or a miss.

It’s a Hit:

If you call out a shot location that is occupied by a ship on your opponent’s ocean grid, your shot is a hit! Your opponent must tell you which ship you have hit (destroyer, submarine, etc.). Record your hit by placing an X on your paper grid. Your opponent will place a red X on the corresponding cell of the ship you have hit on his computer screen.

Example: You and Alex are the players. It’s your turn.

You call: “D4”

Alex answers: “Hit. Destroyer.”

You place an X in D4 on your paper grid. Alex places a red X on His computer screen on D4.

It’s a Miss :

If you call out a shot location not occupied by a ship on your opponent’s ocean grid, your shot is a miss! Your opponent must tell you that you have missed. Record your miss by placing an O on your paper grid to let you know what you have already called out. Your opponent doesn’t do anything to his/her computer screen.

Example: Now it’s Alex’s turn.

Alex calls: “F4”

Your answer: “Miss.”

Alex places an O on his paper grid. You do nothing.

After a hit or miss, you turn is over. Play continues in this manner, with you and your opponent calling one shot per turn.

Sinking a Ship:

Once all the gray areas of a ship are filled with a red X, it has been sunk. The owner of the ship must announce which ship was sunk. Highlight that ship and fill with the color red to indicate that the ship was sunk.

Winning the Game:

If you’re the first player to sink your opponent’s entire fleet of 5 ships, you win the game!