Practical Ed Tech Tip of the Week – Create MadLibs With a Google Sheets Template

Flippity is a great place to find Google Sheets templates for creating educational activities. In the past I’ve featured Flippity’s templates for creating Jeopardy-style games and for creating random name selectors. Recently, Flippity added a new template for creating MadLibs-style story starters.  Take a look at the demo then read on to learn how you can create your own MadLibs-style story starters through Google Sheets.

To create a MadLibs-style story generator first select the template on the Flippity homepage. Then you’ll be asked to make a copy of the template in your Google Sheets account. Once you’ve made the copy you can edit the template by writing your own stories into the spreadsheet cells. To define variables, those are the parts your students will complete, simply place brackets around the words “verb, noun, adjective, place, name, or number.” For example, if I want students to fill in a noun in the story I’d write [noun] in the spreadsheet cell in which I’m creating my story. When your completed work is published your students will see something like this on which they’ll complete the MadLibs story.


Here are this week’s most popular posts from FreeTech4Teachers.com:
1. Literature Map Helps You Find Authors You’ll Like
2. How JoeZoo Express Can Save You Tons of Time Grading in Google Documents
3. 5 Tools Students Can Use to Create Music Online
4. Student Stories – ClassDojo Portfolios on Chromebooks, Desktops, and Mobile Devices
5. Three Good Tools for Collaboratively Creating Multimedia Books
6. Projeqt – Create Dynamic Presentations
7. Create MadLibs Through Google Sheets

Upcoming professional development opportunities with me:

A new section of Getting Going With G Suite for Education is starting on November 21st. A graduate credit option is available.

School administrators: In addition to G Suite for Education, I offer online training on formative assessments, video creation in the classroom, digital portfolios, and teaching social studies with technology. Contact me to set-up a training for your school today. My email address is richardbyrne (at) freetech4teachers.com