Did someone share this with you? If you'd like the newsletter delivered directly to your inbox, please register here:http://eepurl.com/q4LYz
Create a Group Calendar
Google not only gives the ability to create multiple calendars, but through the sharing you can actually create a calendar that is contributed to by a group of people. This gives some great flexibility in the use of the calendar as it can both be VIEWED and EDITED, as established by the owner of the calendar. Some uses of a Group Calendar:
some teachers have a class calendar that either the teacher OR students log upcoming events and due dates on
a professional group (such as a PLC, building staff, curriculum team) may maintain a shared calendar where all the organizers have the ability to edit events, and other participants can view the calendar
a student group may maintain a calendar of events pertinent to the group
The Letters App for the iPad by d-Studio is a letter board reminiscent of the magnetic letter boards. Kids can drag letters (and numbers & symbols) onto the board. The letters actually interact with each other, pushing each other out of the way if you attempt to put one on top of another. Letter color can be changed if the user visually needs to view a single color. Rotation of the letters can be turned on or off. And when you want a clean board, you simply push them off the side...
Sometimes you want to move a single item from one course to another. Moodle has made this very easy to do know with the inclusion of the backup choice for every item you create. When you are viewing the item you want to move, look for the backup under the Activity Settings (found in the Settings Block). This will assume you want to only back up that activity as you go through creating the backup.
The World Digital Library is a site to obtain primary source documents from a specific location of the world AND time span. The slider under the map will let the user specify the timespan wanted. Clicking on the item on the map will then bring up a screen to select and view a synopsis of the item.
Curate.Us is a site to "create visually compelling clips and quotes that are easily embedded--just like video."
(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…