Wage a Sea Battle with Google Sheets

Create a navy-themed guessing game in Google Sheets.

Example outcome

Lesson details

Learning objectives

By the end of this lesson, students should be able to:
  • Format a spreadsheet to create a digital guessing game
  • Understand how conditional formatting affects spreadsheet behavior
  • Identify cell references in a spreadsheet by playing their game with a partner

Time to complete

45—90 minutes

Audience

  • High School
  • Late Elementary
  • Middle School

Digital tools

  • Icon representing the Sheets toolSheets

Skills

  • Spreadsheet design
  • Spreadsheet organization

Teaching materials

namespaces/google.engedu.apski/contents/Unit-36619881818130056628508628964088882427en