…and I'm all out of bubble gum.
Posts tagged spreadsheet
Google Docs Forms for Critique/Feedback
Nov 22nd
Posted by Seth Battis in "Expert Plan"
This post is part of a series that are components of my “Expert Plan” at my school, looking to create a shared resource for my colleagues as the school moves towards greater adoption of laptops and technology in our pedagogy.
The Model
I wanted to structure the feedback that my students presented to each other during our video critique. We often brainstorm the criteria that we will be using to review work as it is presented, and I post our criteria on the board or on the wiki as a reminder throughout the process. This time, I created a new Form in Google Docs and entered our criteria as questions. I then embedded the form in our class notes for the day, and each student filled out the form as we viewed video. I embedded the responses as a spreadsheet on a linked page, so that the the students could review the feedback they had received and post their responses to our class blog.
In Practice
Creating the form live went relatively smoothly — the only hang-up was my inability to type in public. Fortunately, the students were proofreading on the screen and caught me when I made errors. They were also able to help guide me when I got distracted and forgot what I was doing (“Mr. Battis, we’ve already got that question at the bottom of the screen…”).
It took very little instruction for the students to figure out how to use the form. The most complicated thing they had to do was refresh the page after they had submitted their feedback so that they could get a fresh, blank form for the next video.
We settled into a routine where I played each video through twice, once for them to watch, and once to remind them of details as they entered their feedback.
Reflection
After we finished reviewing videos and posting feedback, I put the question to the students: was this better, worse or the same as having a verbal critique of the same material (which we had done in the earlier digital photography unit). The response, by and large, appeared to be that this was actually really helpful: there were enough things to pay attention to while watching the video that being able to take notes into the form let them not forget things that were important.
Google Docs Syllabi
Nov 22nd
Posted by Seth Battis in "Expert Plan"
This post is part of a series that are components of my “Expert Plan” at my school, looking to create a shared resource for my colleagues as the school moves towards greater adoption of laptops and technology in our pedagogy.
The Model
This started out as simply a way of addressing my own personal predilections: I’m tired of trying to build a syllabus on a calendar (the calendar doesn’t present the syllabus in a useful view), or in a spreadsheet (changing dates becomes a chore), so I decided to separate the various issues out and automate as much as I could. The result is a Google Docs spreadsheet that I embed on my course web site, which allows me to think in terms of units and lessons, and which automatically sequences lessons on to class meetings and updates me with notes about those specific days (Moadim L’Simcha, vacation days, etc.).
This is an example of one of my syllabi as the students see it:
In Practice
This turned out to be some pro-level spreadsheet work. I like working in spreadsheets. Not everyone likes working in spreadsheets. This link takes you to a “scratch” version of one of my syllabi (you’re welcome to edit it to see changes — this isn’t live. The organization is thus:
- There is a worksheet for each unit of the syllabus, named sequentially Unit 1, Unit 2, Unit 3, etc. (The best way to create a new unit is to duplicate an old one and replace the information).
- On a unit worksheet, a few of the columns are automatically filled in. You just have to worry about editing the title of the lesson, the lesson description, and the assignment summary. Everything else is filled in automatically.
- The integrated view of all the units, sequenced together and lined up to days with notes is the Syllabus worksheet.
- The Meetings worksheet is just a list of days when the class meets (which I entered manually) and any notes about that day specifically that might be helpful for lesson planning.
- There are a bunch of “working” sheets that you can look at, but don’t edit — they’re collating and organizing all of the units automatically.
Reflection
This was way more work than it was worth for a single syllabus. But as a tool that I intend to reuse again and again, I’m pretty happy with it and feel good about the investment. It is mildly idiosyncratic, in the sense that it meets my specific needs. But it could be used as a model for other people’s style of syllabus design, separating the schedule from the concepts in a way that makes visualizing the lesson flow much, much easier.
