"If you're creating a course website, you might want to display a calendar of events for that course. A natural consideration is Google Calendar for the actual calendar. This works fine, and has interesting benefits (easy to move events from one day to another) over the traditional "make a big table in MS Word and type dates in manually".
The bummer is, it'd be nice to display the calendar showing things to do for each day in a simple layout. If you add details to the calendar entry, the data is there, but doesn't display in the default views for embedding in your site.
Enter the calendrator. It pulls data from your calendar and formats it in a useful way. To create the calendrator, go to your Google Sites page where you want to embed your calendar. Go to Manage Site - > Apps Scripts and create a new script."
"Time to prep for the Fall semester classes. I typically create a spreadsheet of topics on Google Docs Drive, and for student-ease-of-use I would like to use that data in a Google Calendar. To get these two apps talking, I'm learning Google Apps Script. It is simple to complete https://developers.google.com/apps-script/your_first_script in a matter of minutes, the syntax is quite readable and easy to understand..."
"This app is an experiment in using crowd-sourcing methodology to surface hidden gems from the blogosphere. Topics covered include Collective Intelligence, Information Architecture, Cloud Computing, Big Data, Social Computing, Enterprise 2.0, Symbiotic Intelligence and more."
Here's a Google Spreadsheet template I've developed from some leftovers which pulls data together from comment feeds, Twitter and Delicious (with social counts for these plus Facebook, LinkedIn and Google+)...
"How can teachers harness all the awesomeness, ubiquitous access, and collaborative authoring power made possible by Google Docs without creating a document management nightmare? Solution
Written by an educator for educators, the free doctopus script gives teachers the ability to auto-generate, pre-share, and manage grading and feedback on templated Docs for group and individual projects."
Today Tony Hirst posted Data Shaping in Google Refine – Generating New Rows from Multiple Values in a Single Column. Coincidently I faced a similar problem today working with a Google Spreadsheet so thought I’d share my solution.
"I’ve been using iGoogle less and less over the past few years. A few weeks ago, the team announced that iGoogle would be shutting down in November 2013. It’s not a huge loss to me, though I do check iGoogle several times a day. Why? Stock prices! I’ve been using the Stock Market gadget for years.
As it turns out, the functionality I want is very easy to replicate using Google Spreadsheets and Google Apps Script. I’m thoroughly convinced that the fastest way to wire up different Google services for custom functionality is this product. Google Apps Script provides services to access Google Finance APIs."
Here's a chapter from Cultivating Change in the Academy: 50+ Stories from the Digital Frontlines at the University of Minnesota in 2012 written by Abram Anders. The chapter covers the development of a custom assessment and feedback tool written by Abram and available in the Script Gallery
"My last post got me to thinking- if I'm going to write a slight improvement to the google calendar's view interface, what other things would I like to add?
The first thing I'd add would be HTML markup in the description portion of the event. To see what I'm talking about, go make a calendar event, edit it and add to the description. This is a good place to add (say) an assignment for that particular day, but you'll quickly see that you're limited to plain text in this interface. That's highly unsatisfying."
Geocode and get administrative details and geoHash link from a UK postcode directly into an Excel or Google Spreadsheet Following on from the Yahoo GeoCode entry here's another geoCoder - this time using UK post code as input, and providing various UK specific administrative district information. As usual it is implemented as a rest-library member. This a data query API, populating columns in a row in a spreadsheet based on a variable column in the data. You just name the columns to match any data you want to retrieve and go. Here's an example geocoding various random postcodes
"I've been playing around with Google Apps Script lately, and I thought I'd share a small class I wrote to make building user interfaces with the UI Service a little more pleasant. With this library, you can specify an interface through a simple declarative JSON syntax, rather then a lot of chained function calls (or the GUI builder). It also includes some helpers to reduce the amount of code needed to build forms." by Dan Gottlieb via Eric Koleda
Matthew Knight explains why you don’t need to be a genius to make simple digital toys – just build upon the genius of others and make use of Google Apps Script...
In this tutorial Matthew explains how you can use Apps Script to get your Gmail unread count before passing the result to a php server to update your avatar (I reckon you could do the whole thing in apps script)
"Charts are a great way to visualize information. They let you arrange data in meaningful ways, allow you to tell a story, and can really catch the reader's eye. But when dealing with large datasets, visualizing all the data at once can be somewhere between a tough to impossible mission. You usually need to filter the data and concentrate on a specific part that is of interest, and then when you want to see a different part of the data you'll need to filter it again and refresh the view. That's why we're happy to announce the introduction of dashboards in Apps Script, which allow you to compose multiple charts and filters into a single experience!"
"I haven't posted anything on new entries to the rest-excel-gas library for a while. As I mentioned in this post the library itself is available as a rest query. There have been quite a number of new APIs added lately through forum requests, but here is a nice one - populate a worksheet with the Google Page Ranks of a list of given domains. (you just enter the domains you want, the library call fills in the rest)"