I fell in love with Kahoot several years ago. My students were instantly drawn to the excitement of the interaction, the competition, and the learning. I also saw a perfect opportunity for them to collaborate by creating future Kahoot quizzes. I made Google Forms for students to submit questions and answers for future Kahoot quizzes. Although I had a database of questions ready to go, it was still tedious to put the Kahoots together . . . until now!
Kahoot just came out with the best update ever. We now have the ability to upload questions and answers via spreadsheet. You read that right! Kahoot has provided a spreadsheet template, making the process seamless and super easy. I created a new Google Form (make a copy here) for students to enter questions and answers on. The data is collected in the proper format so that the Google Sheets spreadsheet created from that Google Form can now be copied and pasted directly into the spreadsheet template provided by Kahoot. Wow, it’s so streamlined and easy!
Don’t forget to snag a copy of my Google Form so that you can have your students submit questions, too!
Step 1 – create a new Kahoot quiz:
Step 2 – Click on “import from spreadsheet” then “download our template”
Step 3 – Populate your spreadsheet with data from Google Sheets (created from your Google Form) and upload into Kahoot. Here’s mine.
Step 4 – View your completed Kahoot quiz!
Step 5 – Preview your new game!
About the blogger: Jacqueline Prester is a business educator and instructional technology specialist at Mansfield High School. She was the 2015 Massachusetts Business Teacher of the Year and has been nationally recognized for her contributions to education in entrepreneurship, financial literacy, technology, and STEM. Jacqueline serves as the Treasurer of the Board of Directors for MassCUE, the Vice President of the Board of Directors for the MBEA, a Discovery Education Program Champion, an NGPF Financial Literacy Fellow, and co-founded Edcamp Southeastern Massachusetts. She is currently working towards her National Board Certification in Career and Technology Education, specializing in Business, Marketing, and Financial Services. Connect with her on Twitter @mrsprester or at mrsprester.com.
This blog post was relaunched on mbea-ma.org with permission from the blogger. You may find the original post HERE.