I started this spreadsheet (See below!) with an idea in mind to create a game for a PD I am doing. Decided the PD activity would not work but do not want to waste the spreadsheet! I asked Tweeps to share their Bitmoji’s to create avatar characters for the game, wouldn’t want to waste that either. Ended up making a worksheet template (see below)…. but we can design something better!
Help me with ideas for creating a better game!
3rd Tab – What Game Ideas Do You Have?
What I have so far is to create a character name on the first tab. Choose an avatar character on the 2nd tab. This becomes your game piece. The 3rd tab is where the game would go. What game could we make where your avatar you chose on the 2nd tab could do something?
Brainstorm ideas for how we could turn this into a game by adding to this spreadsheet.
It’s A Worksheet Game Template
You can enter up to 30 questions. You can use less than 30. The game defaults to 30 levels. Notice that the number of points is automatically created based on how many questions you type this makes sure that the avatar goes all the way around the game board.
The default game images are my Bitmoji’s. Change these.
If you have your own Bitmoji, click on the Bitmoji Chrome extension and choose to “Copy Image Address.” You can, of course, make your own image and not use a Bitmoji! Try Google Draw! Create an image in Google Drawing and use the File menu to choose “Publish to the web.” Use the publish link in the game spreadsheet.
Hide the Questions Tab
On the Character tab students get to choose which avatar they want. The Bitmoji’s were donated by kind Tweeps in my PLN. You can replace the images by inserting other image URL’s. Students can create their own avatar in Google Drawing and use the File->Publish to the web trick to insert it into the spreadsheet.
Game Board Tab
On the Game Board tab the questions are visible below the game board. As the student answers the questions, their avatar moves around the game board. In other words, it acts as a progress bar. The game board does NOT mark the questions right or wrong. It simply acknowledges that the student entered text into the response boxes.
There is a feedback column for leaving feedback for students on their responses.
Because this is Google Sheets you are able to view student work while they are working on it. Leaving feedback and inserting comments.
I coded a specific script for this worksheet game to allow you to extract all the student responses into one Google Sheets spreadsheet, give feedback and push it back to the student’s spreadsheet. Make a copy of the template below. Use the Add-on menu to choose “Worksheet Game.” From the sidebar menu, click on the button “Choose Folder.” Assuming all the student game spreadsheets are in a single folder in Google Drive the picker will allow you to select the folder and create a list of student responses in the spreadsheet. Next to each students answer, give feedback. After you have sent the feedback, use the button in the sidebar “Push Feedback” to send your feedback responses back to the students.
Template: Worksheet Game Grader
You can run the worksheet game grader multiple times using the same spreadsheet. Simply choose the buttons in the sidebar again to start over. This will allow you to check in on students while they are playing the game and give them feedback during the process and then look over student responses again at a later time.