Wednesday, April 26, 2017

Random Group Generator and Student Selector

This year I decided that I didn’t want to assign lab groups for my students, but rather, I would random assign them into pairs or groups depending on the activity. As one to try to do most things digitally, I wanted something better than Popsicle sticks. I came across a few sites that did what I wanted.

 The first is Random Group Creator. It’s a very basic page, but it does the job. You can choose the maximum size or the group or the maxim number of groups that you want. Then you just paste in a list of names (one per line) and click submit. While the site looks like it gives you an option to save and load lists, that feature doesn’t seem to work. I would keep a word or excel file with the names in it that you can copy and paste from each time you want to use that list. 

 The next is another simple one called Random Team Generator. You paste in the list of names and choose how many groups you want. Press the refresh button and your groups will be made for you.
Group Maker Tool is another generator and its part of the Super Teacher Tools site. What I like about
this one is that you create a sort of makeshift account, but all of your student names are saved there and you don’t need to copy and paste them into a site each time. If you do have the student names in a list, you can copy and paste them into the bulk upload section to add them in all at one. If not, you can type in the names one by one. Once you do that all of your student names are in the systems and you can use this list to not only make groups, but it can also be used as a random picker and a seating chart generator. The group maker allows you to choose how many in a group or how many groups you want. 

Team Maker is another really simple generator. Once again you will need to paste in a list of names. You then choose some team names (you don’t have to use them, but there are there if you want). Then you choose the number of teams you want, press Generate Teams and you groups are made! If you like the groups that are made you can download the list as a CSV file (a type of file that opens in Excel). 

 The last option I have for you is Random Student Generator. This one requires you to type in the names (you can’t copy and paste from a list), but then you can save that list. Once your list is in you can use that list to randomly select a student as well arrange students into a number of different size groups. The one downside to this site is that it can only save one class list. If you have more than one list, you’ll have to pay for their upgraded version (and it’s expensive and not worth it).

Tuesday, April 18, 2017

Choose a Random Person from a Google Form

If you have people fill out a Google form and you want to select a random person from this form you can do that easily with the script that Alice Keeler wrote. Don’t worry, you don’t need to know anything about coding or script writing to use this. Alice Keeler made a template that you start with. You can access it by clicking here. Start off with this form and edit it to make it the way you want it to look. Distribute it and collect your responses. After you have collected the response click on the puzzle piece icon in the Google Form and run the add on “Choose Random Responder.” A random response will be selected and a pop up will tell you who it is. Each time you run this add-on a spreadsheet is created with the winner and all the (up to 19) runner ups. You will receive a link to that spreadsheet in your e-mail. If you already have a form that you want to use, the script is provided for you if you want to add it into your form. You can find more details on that and this whole process by visiting Alice Keeler’s blog directly.

Tuesday, April 11, 2017

Top 5 posts of March

I'm a little late with this, but below are the Top 5 Posts of March.  I hope that you enjoyed reading them and if you haven't now is a great time to give them a read. :-)
  1. Separating and Combining Columns in Excel
  2. StudyBlue Pro - give it a try!
  3. Using Mail Merge with Gmail
  4. Augmented Reality in the Science Classroom
  5. Multi-Owner Classes in Remind
Is there something that you are looking to learn how to do?  Leave me a comment below and I will work on a post and video to help you out! 

Monday, April 3, 2017

G Suite Training Chrome Extension

If you are new to using Google Apps, or you know people who are struggling using it, this extension is what you (or they) need! You simply visit this webpage in your Chrome browser (it does have to be Chrome) and install the extension. Now, that extension will be waiting for you read to give you advice and help when you need it. Once you are in any app that you need help in (Sheets, Drawings, Doc, etc.) you just click on the extension and you can access step by step written tutorials, video tutorials, product features and most anything else you would need to help you out. While it is fully functional in English, it does offer some limited support for Chinese, French, German, Japanese, Portuguese and Spanish. Lastly, if you are the domain administrator you can customize your domain’s’ training by installing the G Suite Training App in the Admin console.

If you want a quick visual of how to install it check out this post. 

What is one of your favorite places to look for edtech training (other than this blog of course ;-)?

If you would like to view a walk through, take a look a this quick walk through that I did.