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…
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…
If you are looking at the summary view of the results for some Form data you have collected, you can copy a chart or diagram that you want to use elsewhere very easily and quickly.
Simply hover over the chart or diagram, and a copy icon will appear in the upper right corner of it. Click on that -
You will get a message that it has been copied to to the clipboard in the lower left corner -
You can then paste it into the location you want to use it. Here's an example in a G Doc -
I also pasted it into: Slides, an email, a Sites webpage, in my Blogger. A nice feature addition that saves time from taking screenshots!
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…
Another foray into creating a script to help make a process more efficient.
We had a program that spent a LOT of time with the invoicing process. They were hoping that they could use a Google form to gather information for invoices, then use the Add-on Autocrat to create the invoice which could then be shared with appropriate parties.
The problem was that each invoice needed to be assigned a unique number. Enter a script to add to the spreadsheet. After creating it, I realized that this simple script could be used in a variety of ways so thought I'd share (I've already used it for two other applications!).
1. Create your form to collect the data (not covering this here - I am assuming you know how to create a Google Form)
2. In the result page, select to create spreadsheet so you can view the data in a spreadsheet
3. Go to the Tools Menu and open the Script editor
4. Delete out the default text
Replace with this script (all in highlighted gray including the final curly bra…