Skip to main content

Tech tool bleg

Beggars Banquet
On Tuesday, I got to spend the day learning about various aspects of assessment, at SDSU's One Day in May symposium.  So much good stuff! Although I think of myself as relatively savvy about a lot of tools, and a definite data junky, I got lots of ideas about things I could be doing to track analytics in Blackboard and Google Docs. I haven't been a huge Google Docs user so I had no clue that there are so many cool things you can do with spreadsheet gadgets (like create word clouds or interactive timelines, a la Gapminder).

The day got me thinking about how I could use certain tools and I started looking for new ways to deal with one of my most time-consuming tasks. I have a couple different situations where I collect information from students that I want to pass on to other students (e.g., team peer evaluations in the data class or reviewer back evaluations in the writing class). Currently, the way I do that is either through emailing each student or putting the information in the 'comment' field for an assignment in Blackboard. Either way, there's a whole lot of cutting and pasting going on. Blackboard is supposed to have a way to batch upload comments for gradebook items (according to this link) but I can't get it to work. Even if I could, it's less than ideal for really long 'comments' (I think there's a 1000 character limit). I feel like I read something somewhere about a way to allow students to see just part of a spreadsheet in Google Docs but I can't find anything about that when I search. I could make a separate Google Doc for each student and just 'share' it with that one student but a) that doesn't seem like it would really save me any time and b) I prefer not to make students create new accounts if I can help it (although I know most already have Google accounts, if they don't, they'd have to create one to access a private Google Doc). Ideally, I'm thinking of something where I could have a spreadsheet with student identifiers in one column and their comments in another column and students could submit their identifier and see the comments in the associated row.

Rather than bugging just a few people, I thought I'd bug a lot of people and throw it out to you all. Does anyone know of a way to do this?

Comments

Popular posts from this blog

What are the costs?

I came across an interesting discussion about a 19-year-old intern who was fired from The Gazette in Colorado Springs for plagiarism. There appears to be some controversy over the fact that the editor publicly named the girl in a letter to readers (explaining and apologizing for the plagiarism), with some people saying that doing so was unduly harsh because this incident will now follow her for the rest of her career. I was intrigued by this discussion for two reasons - one, it seems pretty clear to me that this was not a case of ignorance (as I have often encountered with my own students who have no idea how to paraphrase or cite correctly) and two, putting aside the offense itself, I have often struggled with how to handle situations where there are long-term repercussions for a student, repercussions that lead the overall costs to be far higher than might seem warranted for the specific situation. As an example of the latter issue, I have occasionally taught seniors who need to p

What was your high school economics experience like?

As I mentioned in my last post , I am asking my Econ for Teachers students to reflect on their reading by responding to discussion prompts. It occurred to me that it wouldn't be a bad idea for me to share my thoughts on those issues here and see if anyone wants to chime in. For this week, the students were asked to read the California and national content standards , an article by Mark Schug and others about why social science teachers dread teaching economics and how to overcome the dread, an article by William Walstad on the importance of economics for understanding the world around us and making better personal decisions (with some evidence on the dismal state of economic literacy in this country), and another article by Walstad on the status of economic education in high schools (full citations below). The reflection prompt asks the students to then answer the following questions: What was your high school econ experience like? What do you remember most from that class? How do

When is an exam "too hard"?

By now, you may have heard about the biology professor at Louisiana State (Baton Rouge) who was removed from teaching an intro course where "more than 90 percent of the students... were failing or had dropped the class." The majority of the comments on the Inside Higher Ed story about it are supportive of the professor, particularly given that it seems like the administration did not even talk to her about the situation before acting. I tend to fall in the "there's got to be more to the story so I'll reserve judgment" camp but the story definitely struck a nerve with me, partly because I recently spent 30 minutes "debating" with a student about whether the last midterm was "too hard" and the whole conversation was super-frustrating. To give some background: I give three midterms and a cumulative final, plus have clicker points and Aplia assignments that make up about 20% of the final grade. I do not curve individual exams but will cu