Education in partnership with American Heroes Channel and the National
Military Families Association present the My Hero Is Contest.
Discovery Education, American Heroes Channel, and the National Military
Families Association in honoring our military members and families by
recognizing their service and bravery through the My Hero Is Contest.
Get your students involved by using our free resources and classroom activities
around Veterans Day. Then, have them honor a current or veteran
military hero or military family member in their lives by creating and
submitting 30-second tribute videos.
The school with the largest number of videos submitted will receive a special school assembly honoring local veteran heroes.
To support Veterans Day and your students in creating tribute videos, we are providing a number of
classroom resources including a Veterans Day classroom activity, videos, and tip sheets on storytelling and interviewing.
Learn more and help your school win a special school assembly honoring the brave veterans in your community.
(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…
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!
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…