I collected data from Google Forms, and then imported that data as a quiz into Socrative. I ran a teacher-paced quiz to facilitate the game. Students got to choose what they thought was the lie through their phones or Chromebooks, and we would watch the live results as live polling was happening.
Socrative User Guide
In Socrative, you have the ability to import a "quiz" from an Excel spreadsheet.
Download the Excel Template:
If you are working in Chrome, this could open up in a new tab as an editable Excel spreadsheet using Office Editing for Docs, Sheets & Slides - If this happens, you'll need to hit save now and save to your computer:
With the template that Socrative provides, you need to be working in Excel (at least for the time being. I couldn't figure out how to select the question type in box two in the online version. I will update if I figure it out).
Here's what you should do for the Excel spreadsheet:
- Box 1: Rename the Quiz to whatever you want to find it as in Socrative
- Box 2: Question type: choose multiple choice so students get to choose from a list
- Box 3: this will be my first question from the form: their name
- Box 4: this will be the answer choices that they have to choose from, the 2 truths and 1 lie.
- Box 5: You can select the right answer, but I didn't want to have that selected for my activity
Now send a Form to your students with the information you want: this is the one I used.
After you have received the data from your students submitting their work, you can copy and paste it into your Excel spreadsheet template. Put your cursor in the B7 Box and paste the data.
It will automatically go into the correct boxes across the board. The template allows for 5 answer choices. You do not need to have all 5 answer choices for this to work. I only had the three (2 truths, 1 lie) and it worked perfectly.
Now return to Socrative, and import your Excel spreadsheet. If it worked perfectly, you will see a message appear that says quiz imported successfully.
You can now return to the Socrative Dashboard and launch the quiz. The quiz will be titled whatever you put into the template as the "quiz name" in Box 1.
I ran it as a teacher-paced quiz and had students watch the results on the screen. After each student, I asked them to clarify their answers and explain which one was the lie. If they managed to trick the whole class (by majority percentage from the "quiz"), they won a prize.
Thanks...this sounds like great fun. Appreciate the step by step info
ReplyDelete