One pretty common need I’m starting to see around community-engaged learning is a way for students/faculty to submit events to a central calendar and then indicate their participation in various events. That comes with various program requirements. People want specific reflection patterns per event and have different ideas around what an event counts for in their program. That comes with additional metadata requirements, dashboard views etc. We did something like this with cultural events when we made the RVArts.org site.1 I’ve got at least three programs interested in this process and some are pursuing products like Give Pulse. So I took advantage of the request from the da Vinci Center to look at how quickly we could make a functional prototype that would – create a calendar of upcoming approved events for students allow students to submit reflections on those events with a particular structure allow students to submit additional events for approval generate data visualization and reporting for student reflection and for program analysis purposes I took the more difficult route and assumed we’d have no user accounts just to see what that felt like. With user accounts this become easier. Even with this restriction I was able to build out a functional custom theme in around three hours. Next time, it’d be considerably faster. We could easily bring […]
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.
I was looking around to see how many pictures I’ve been posting to Flickr since taking the new job at VCU. I had a feeling there was a dramatic increase but I was curious about actual numbers. After stumbling around the Internet for a bit attempting to do things the hard way, I stumbled on a URL from 2004 — https://www.flickr.com/photos/heather/archives/date-posted/2004/06/calendar/ It didn’t seem to be working but since the URL itself made sense, I just replaced heather with my flickr username and put in the current year/month to get https://www.flickr.com/photos/bionicteaching/archives/date-posted/2013/04/calendar/. Dingo!1 So not only do I get the numbers I want, but I also get a calendar view of all the days I took pictures. I’m still far away from the D’Arcy/Alan shot a day stuff but that’s not really my style. I can now look and see that in three months at VCU, I’ve taken more shots than I have in entire years in the past. That doesn’t necessarily mean anything but I’m having fun and I have the mental energy and desire to do things like this in ways I hadn’t previously. Quantity isn’t the goal but lots of practice and lots of reflection ought to create some improvement. 1 It feels right. Surely you aren’t going to argue that bingo really makes better sense somehow?