1. Introduction to Wage a Sea Battle with Google Sheets
You can use a spreadsheet for a variety of purposes, such as to store data, completecalculations, and analyze information. Spreadsheet skills can be extremely helpful for both schooland work. But did you know that your spreadsheet skills can also be used for fun?
In fact, you can even use a spreadsheet to make your own game!
In this lesson, you will create a guessing game in a spreadsheet. You will then playyour game with a partner.
You will format your spreadsheet to contain a digital ocean and ships. Then you will wagea sea battle on your partner’s enemy fleet!
To complete this lesson, you will:Stake your ocean territory by formatting a grid and adding blue shading,Select cells to represent your ships and add conditional formatting to make them changecolor when “hit,” Disguise your ships and share your spreadsheetwith your partner, Take turns “aiming” at each other’sships and marking guesses on your spreadsheet, And continue playing until one person has“sunk” all of the other’s ships.
This lesson uses Google Sheets, but you could apply these skills and concepts in most otherspreadsheet applications or even on a piece of paper.
To work on this lesson, sign in to your Google account. Open a new tab in your browser, andnavigate to Google.com. If you are not signed in, do so now.
If you do not have a Google account, pause the video and create one now.
For part of the lesson, you will work with a partner. If you don’t have a partner,ask your teacher. Then sit next to or across from your partner. Each of you will work atyour own computer. To begin, open Google Drive and create a newspreadsheet.
Give your spreadsheet a title that describesyour game.
Then, move on to the next video to begin building your game.
Now, it’s your turn: Sign in to your Google account,Sit next to or across from your partner, Open Google Drive,Create a new spreadsheet, And title it.