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

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...

THE podcast on Implicit Bias

I keep telling myself I need to get back to blogging but, well, it's been a long pandemic... But I guess this is as good an excuse as any to post something: I am Bonni Stachowiak's guest on the latest episode of the Teaching in Higher Ed podcast, talking about implicit bias and how it can impact our teaching.  Doing the interview with Bonni (which was actually recorded a couple months ago) was a lot of fun. Listening to it now, I also realize how far I have come from the instructor I was when I started this blog over a decade ago. I've been away from the blog so long that I should probably spell this out: my current title is Associate Vice President for Faculty and Staff Diversity and I have responsibility for all professional learning and development related to diversity, equity and inclusion, as well as inclusive faculty and staff recruitment, and unit-level diversity planning. But I often say that in a lot of ways, I have no business being in this position - I've ne...

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...