I’ve been on a quest for several years now to find an easy and free way to upload MP3 content to the web and then have it play nicely in WordPress using the Add Audio feature. In this post I will be attempting to add a link to an MP3 that I was able to upload to Google Docs now that it accepts other file formats.
The web page linked above uses a table to compare features of blogs, wikis, and Google Docs. Comparison topics include definitions, number of concurrent authors, and how each tool is used in collaborative activities. The author, who is unknown, outlines commonly known strengths and weaknesses of each tool. For example, one of the advantages of using a wiki is that a previous revision can be reverted to at any time. An example of a wiki disadvantage is that a user can accidentally override a fellow collaborator’s contribution if the wiki is used as a synchronous tool. Teachers can use this web page to help decide if one of these tools might be appropriate for a lesson that integrates technology. While all three tools can be used for reflection, blogs are probably most commonly associated with reflective activities. The table includes links to several blogs focused on reflective practice including David Warlick’s blog.
I’m co-teaching an educational technology course with Helen Barrett (@eportfolios). Instead of using Blackboard, we’re trying to use all open technologies for the course. We are using Google Sites for the content and Google Groups for class communication (no Google Wave invite yet).
So far, so good except for a few small snags such as what to do about a gradebook. I’ve agreed to find a solution for this. I would like a gradebook that allows students to check scores whenever they want. Students already have a number of applications they need to create logins for so I would like to avoid one more if possible.
I was hoping to be able to use Google Docs Spreadsheet alone for the gradebook for this course. My goal was to make it possible to have one spreadsheet where all scores were entered by the instructors, and students could only see their individual scores. However, it doesn’t look like there is a way to give students access to part of a sheet or even one sheet in a Google Docs Spreadsheet. I could create a spreadsheet for each student but this would require too many clicks when entering scores.
I did some research on the use of a mail merge command in Google Docs. It looks like I would need access to scripts that aren’t available to all users so this idea is out for now. Therefore, I am planning to use the following plan (which breaks our goal of trying to use only open software in this course) unless someone from my Personal Learning Network (you) can provide another way forward:
- Create a single Google Spreadsheet to enter student names, email addresses, and scores.
- Share this spreadsheet with my co-instructor, Helen Barrett.
- Enter scores as assignments are completed.
- Each week, export the spreadsheet as a Microsoft Excel document to a folder on my computer.
- Use Microsoft Word to create a MailMerge and send each student an update on their progress in the course.
- This is technology I am familiar with and know that it will work, possibly saving me time and stress.
- Students will get weekly feedback on their progress.
- Pushing grades to students (emailing) may encourage them to check in on the course as they probably check email more frequently than they access the course.
- This solution uses non-open technologies so university students who want to replicate this technique with their K-12 or adult ed students will need to have Microsoft Office. (All SPU students have Office 2007 or 2008 so maybe this isn’t a disadvantage.)
- Students won’t have real-time access to their grades. They will have to refer to my last email to check on their grades.
- I will have to remember to send out a grade update each week, which is unlikely so I will probably need a prompt from students or my co-instructor.
- Although I’m familiar with this process, it may seem complicated to teachers who want to replicate what I’m doing.
Do you have any suggestions for me? The idea solution would:
- Let students access grades whenever they want.
- Let them use existing login information so they don’t have to create an additional account
- Come at no cost to the students, a small annual fee for the instructor would be acceptable.
- Provide common gradebook features such as the ability to have easily enter data and sort, create reports, and make calculated columns.