Tuesday, March 29, 2022

Make a Word Game With Google Sheets - A Fun Way to Learn About Formulas

Google's Applied Digital Skills website is a good place to find lesson plans and activities that you can use to help students learn how to use many features of Google Workspace tools. To capitalize on the recent trend of word games like Wordle, Google recently published a new Applied Digital Skills lesson called Make a Word Game

Make a Word Game is a lesson in which students collaborate in Google Sheets to develop word game that utilizes functions and formulas to randomly generate letters that are used in a word game. Furthermore, students learn how to use functions and formulas to generate scoring for their games. Students don't need to have prior experience using spreadsheets in order to complete this lesson. However, a little prior experience will definitely help avoid some frustration. 

Applications for Education
Google provides some extension activities that students can complete to further develop their spreadsheet skills. Before doing those extension activities I would have students repeat the process of the lesson and modify their input to try to create a thematic version of the word game.

If you're unfamiliar with Google's Applied Digital Skills lessons, here's a short video in which I demonstrate how to access the lessons and distribute them via Google Classroom.