(Updated on 3/21/2017 - triggers have been moved!)
I guess it was only a matter of time before I ended up dabbling with Google Scripts. Today I was asked by a teacher how he could populate a drop-down list on his Google Form from data on a spreadsheet - and have it update as he changed the data. Not finding an add-on for this (why recreate the wheel? :-) I explored creating a script. And...discovered that this task is not too hard!
To do this yourself -
1. Create your form.
Really important step. Make sure to create your drop-down item and give it a title, but you do not need to add any options to it (because later you will populate it from the spreadsheet).
2. Create the spreadsheet where your list will reside.
You have two options for this.
A: You can create the spreadsheet for your form responses and add a second sheet to it. That is what I did here - adding a sheet called Student Names:
B: You can create a new spreadsheet to use. If you do this you will need to add the sp…
You may notice a new look and feel to your Google login! As this update "goes live" this is what you should expect -
The first time, you will get a message box telling you that you should expect the new look:
While you may not have feelings one way or another about how it looks, if you are on a device that has many people logging in with their Google, you should appreciate the fact that you can now REMOVE accounts from the list.
Look at the bottom for a "Remove an account" option:
Clicking on that will put an x next to each account:
Clicking on the x will pop-up a confirmation window that you want to remove that account from the list:
Note- this does NOT delete the account, it just removes it from the list for quickly logging in the sign-in window. It can always be added back to the list when you sign in with it again in the future.
2. Login with the account you used previously to register for the conference. You must use the same account!
3. Note a new window at the top will tell you that you are already registered for the conference, but you may add workshops (pre-conference sessions) by going through the process again. (You would use these same steps to make any modifications to your registration.)
4. Click Next on the first screen with your contact information
5. Click Next on the next screen about Membership
6. On the next screen, pre-conference workshops are now an option
7. When you click on the blue bar, it will display the pre-conference sessions. Each one has the following: Registration box for that workshopName of the workshop sessionSponsoring SIGCost (1/2 day sessions are $70, full day sessions a…
This is a really cool video on how to make your Google Form interactive - or, if you will, "Choose Your Own Adventure!" I can think of so many applications for this...both as a teacher, and as a learning activity for students.
Many of you may have missed a new feature in Google Classroom - the ability to have an item (or some items) available to students all the time OUTSIDE the Stream. This can be very handy for a course syllabus or other item you want students to easily reference throughout the course.
To add items to this area, you need to go to the About section of your Class -
Once you are there, look for a section at the bottom of the page that says Add class materials -
When you click on that area, it changes so you can add the following:
1 - a Title for the section
2 - icons showing you want you can add here
3 - the box to Post it to your current class
While there are 4 icons of types of items that can be added, it is technically 3.
1. You can link to items that are in your Google Drive. (If you select the Attach icon, it actually loads the item to your Google Drive and attaches it the same way as the Drive icon.)
2. Add a general URL link - note that at this time you cannot add a title to this…