Wednesday, February 8, 2017

How to Create Random Name Selector, Seating Charts and Group Selectors from a Single Google Sheets with!

Ever wanted to take your list of students and quickly pick a random name for activities, prizes or other reasons? Want to use that same spreadsheet o create seating charts, pair students in groups? Want to use a simple google spreadsheet of terms to create online flashcards and review games from the same spreadsheet?


  1. Go to, 
  2. Click on their template and then
  3. click the Make a Copy button on the next screen.
  4. In the first two columns fill in the names or terms and definitions but do not change the header row
  5. When done, click on the second spreadsheet at the bottom.
  6. Follow the instructions
  7. Go to File and Publish to the web
  8. Copy the link into the highlighted box on the second tabbed sheet
  9. A new link appears below
  10. Click that and watch the magic begin!

No comments:

Post a Comment