We are so excited to announce a new, free live digital event for educators around the world!
“hacking” spirit has captured the hearts of educators around the world-
more and more, teachers are taking it upon themselves to transform the
way they teach, and the
way their students learn. Initiatives like Hour of Code and the
have been groundbreaking, which is why we are excited to announce this
three-hour event, focused on bringing the leaders
of these movements to you for a live, interactive session, and sharing
the stories of teachers and students who have embraced the “Hack the
Classroom” mentality to inspire thousands of other classrooms to do the
We are honored to announce that
Hadi Partovi, founder of Code.org, and Dale Dougherty, founder of MAKE Magazine and MakerFaire, will be joining us as our keynote speakers. MIE ExpertsLeah Obach from Canada and
Jeff Kash from USA will also be sharing their stories. We’re
bringing disrupters in education to you to spark a two-way dialogue;
hear their stories and ask them questions through live
Q&A while connecting with other educators around the world!
Hosted by Anthony Salcito, we invite each and every educator on the planet to join us on January 30, 2016, at 8:00a.m. PST to be amazed, empowered, and inspired by this
wonderfully disruptive movement in education.
(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…
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…
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.
Finally! We have access to the new template gallery in Google Docs, Sheets and Slides.
From any Google account you are able to access it - but it may not be as intuitive to get to as the "old" template gallery was. You need to go to the landing page for that TYPE of document, which I find many people still don't know about. So, go to: docs.google.com for your Documentssheets.google.com for your Sheetsslides.google.com for your Slidesforms.google.com for your Forms
The first time you go to these, you will get a message about the Template Gallery:
After that, you will both see a top bar with existing templates AND a link in the upper right that says Template Gallery.
Now if you belong to a Google Apps for Education organization, and templates are enabled, you have a couple additional options not available with a general Google account.
1. You will have a choice of General templates or your organization's templates
2. You will also see a choice of Submit Template to s…
Let's say you have put together a sheet with information you THINK is how you want it. And after using it for awhile, you realize you REALLY want the columns and rows switched. Can you easily remedy this without re-entering all the data? The answer is yes!
Before walking through how to easily do this, let me introduce you to a Google Sheets formula you may not know - it's called TRANSPOSE and it's purpose is to transpose the rows and columns in an array or range. So, here is some data I have in cells A1-E2:
If I want to flip the columns and rows, I add the formula:
in the cell I want to start the transposed information into. And...viola! My data is flipped:
It needs to be noted that you CANNOT change data in the transposed cells. As soon as you try to change the data in the transposed area you will get a REF! error because you have data in a cell it need to do the transposing. The data is dynamic - if you change your original data set it will c…