This post contains details of how the Canvas API can be queried with Google Apps Script and the data entered in a Google Spreadsheet. In this particular example I go on to explore the data using Social Network Analysis techniques, but the basic framework may be useful for other projects
gClassFolders Version 2 was released on 2/13/13 and contains the following new features:
* Ability to run in "Single Teacher Mode" or "School Mode" - school mode anticipates use over multiple semesters and at the scale of many classrooms.
* Ability to add students and classes over time without recreating all folders.
* Bulk operations like "Remove from class", "Add teacher," "Add school aide," "Move to another class," and "Archive course"
* Internationalized interface runs in over 70 languages via Google Translate API.
* Plugs into gClassHub, a gallery of tools that allows any teacher running gClassFolders to instantly launch spreadsheets containing useful scripts like Doctopus, autoCrat progress reports, etc. PRE-POPULATED with their student roster and student assignment folder IDs!
"Two important aspects about managing multiple projects with multiple teams are scheduling of the projects & milestones and allocation of resources to these projects. Over the past few years we have been using a simple Google Spreadsheet based utility which we had developed in-house to schedule projects and to allocate resources for projects. We had earlier released this as Free Software under a GPL license and made this available as free template and over 1000 users are currently using this tool.
The utility is available as a free Google Spreadsheet Template"
Jellybend.com provides Google Apps Scripts help and support to automate tasks across Google products and third party services.
Martin Hawksey's insight:
I've been struggling to keep up to date with the examples Marcello Scacchetti and the other folks at Jellybend have been up to. Check their blog for examples on creating custom forms, sales tracking, merging Google Documents, syncing contacts and more
You might not know but Google are dropping the Appointment Slots feature from Google Calendar. The academic community has been pretty miffed about this decision because it's one of the features they've really taken to their hearts and were actively using. Appointment Slots are a great way of making any number of tutorial slots available for tutorials and letting students pick which times suit them. Google responded to the academic outcry with a list of alternatives. This list included paid for services with no clear pricing model for enterprise, downloadable open source software and, rather desperately, a few web2.0 tools that weren't even relevant. Few of these tools integrated with Google Calendars or Contacts, none would have worked with our log ins, and of course, none would be embedded in your Google Calendar making it easy to create overlapping or clashing appointments. So, I wondered how useful a tool I could create using Apps Script. Of course I couldn't embed it Google Calendar but it could work with our York single sign-on, and add details to Google Calendar. The Apps Script environment is limited in many ways - making it difficult to create an elegant solution, but its integration abilities might make it "good enough" for booking tutorial slots."
In 2011 and 2012, while studying the region around Pluto with the Hubble Space Telescope, I discovered the dwarf planet’s fourth and fifth known moons. I soon found my inbox stuffed with hundreds of naming suggestions.
The best kept secret for saving time and improving results in AdWords may very well be AdWords Scripts, a lightweight automation tool that is easier to use than the API but more powerful than the standard interface and the AdWords Editor.
Bjorn Behrendt recently shared gClassFolders which automatically creates folders for your students in Google Docs. In the comments of this Google+ post you'll see Andrew Stillman has forked the code to include Romain Vialard's DriveApp library to handle ownership transfer.
[Great to see the Apps Community sharing and building like this]