Google Maps Street View
Another pretty amazing option in Google Maps. You now have the “street view” option in addition to map, satellite and hybrid views.
This view appears to be a real street level view of the city’s streets that you can advance incrementally (using the arrows you see). Talk about a great way to give your students a view of a particular novel or historical location. It appears to be just major cities right now but it’s pretty impressive.
flickr photo shared by CraigMoulding under a Creative Commons ( BY-SA ) license Just two little functions in Google Sheets that came up as we tried to quickly pull comments from a blog for some other work. It was an odd scenario but the techniques should have other useful applications. IMPORTFEED The function below pulls my 10 most recent comments into a spreadsheet. You can set it to pull more but will also need to change the number of items in your RSS feed. You can find that setting under Settings>Reading. It’ll work on any RSS feed and there are a variety of other IMPORT functions that are worth checking out. This could be a useful option if you wanted to analyze the comments in one place or if you wanted to look a bit more deeply at comments on sites you don’t control. I had to switch this to code because copy/paste led to issues with quotes messing up the formula.
Sometimes the options given in Google Forms just won’t quite work for what you want to do. Maybe you want a particular look, or an interaction, or whatever that Google Forms just won’t do. Luckily, it’s not too hard to make a custom form that can do whatever you want and still has the ability to write the submitted data to a Google Spreadsheet and the form HTML is still served by Google. The following steps should get you up and running and comments in the scripts should provide additional details. Make a new spreadsheet in Google Sheets. Go to Tools>Script Editor Select all that stuff and replace it with the content below. Replace the string of ****** with the ID of your spreadsheet. Then save it. If you get any permissions prompts approve them. Make a new HTML page (File>New>HTML File) and name it index.html Select all and replace it with this.This is as parsed down as I could get it so it’s easier to understand (I hope). Save it. To make sure things work, let’s publish it (Publish>Deploy as Web App). Now go to that URL and submit something and see if it goes to the spreadsheet. If so, great. Now you can start customizing the form to reflect your needs. This form should now write to a […]
This script allows you to setup a Google Form that adds events to a calendar. It’s useful. You’d make your form first and calendar. Then you’d adjust it to reflect your particular column order and calendar ID. Finally, you’d add the script to your Google sheet (where the form submissions end up). [Edit] You’ll also want to set your script trigger to run on the submission of the form. While in script editor, you’ll see a little clock icon. Click it and add the trigger so that the function runs on form submission. That’s about it.