How do you track revision comments in your e-learning or online courses? Most of the time, I use a spreadsheet based on the revision tracking template below.
My spreadsheet includes a formula to automatically add the page title once reviewers enter the module and page number. That makes it easier for reviewers. However, if I don’t have visible page numbers (either directly on the slide or in a table of contents), I remove the formula and ask reviewers to type the page title or description.
Depending on your reviewers, you may want to protect the sheet and lock down the page title column to keep them from overwriting the formula. If you use continuous numbering throughout the course, you can also probably use a simpler formula than this template.
The spreadsheet has three hidden columns. I keep these hidden when I initially send it to reviewers so they can focus on just their part. After I have gotten the feedback, I make the columns visible to add my comments and questions.
I use Google Docs when I can for reviews because multiple reviewers can all see each others comments. They can avoid duplicating feedback. Everything is all in one file and doesn’t need combining later. However, if Google Docs isn’t allowed in an organization or it’s important to get independent feedback from each reviewer, I use Excel instead.
Feel free to copy this spreadsheet and adapt it for your own use. You can also download it for Excel.
How do you track feedback on your courses? Do you use a spreadsheet like this, or do you use a custom-built tool like ReviewMyElearning or OQAR? If you have your own cool spreadsheet, I’d love to see it. I’m constantly tweaking this form to improve it, and I might learn something from your version.