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

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

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

This is about getting through, not re-inventing your course

As someone who has worked hard to build a lot of interactivity into my courses, I have never been interested in teaching fully online courses, in part because I have felt that the level of engaged interaction could never match that of a face-to-face class (not that there aren't some exceptional online courses out there; I just have a strong preference for the in-person connection). But the current situation is not really about building online courses that are 'just as good' as our face-to-face courses; it is about getting through this particular moment without compromising our students' learning too much. So if you are used to a lot of interaction in your F2F class, here are some options for adapting that interaction for a virtual environment: [NOTE: SDSU is a Zoom/mostly Blackboard campus so that's how I've written this but I am pretty sure that other systems have similar functionality] If you use clickers in class to break up what is otherwise mostly lect...