Feedback database
Grading major projects, essays, presentations, and other major assignments can be difficult, especially for more larger classes. Students expect and deserve fairly detailed feedback and justification for the grades they receive. Feedback should describe the various strengths and weaknesses of a student’s performance – exactly what s/he did well, and where s/he lacks or needs improvement. Feedback is also an opportunity to provide students specific advice on how to improve.
A common practice for grading such work is a feedback database or grading bank. Since many students make similar errors, or show similar strengths or shortcomings, writing out the same feedback for each student is time-consuming. The more efficient method is to create a “database” the first time you grade an assignment. This is a text file, a word processor file, or a spreadsheet, containing the various kinds of comments that you need to provide to students. These comments can be copied and pasted (and perhaps modified and personalized a bit) from the database into an email or printout for each student.
Contents
1 Examples
1.1 Simple example
Let’s say that you are grading an essay assignment, and are watching videos of the students’ presentations. You can create a database file as you grade it for the first time. While grading, you can use this as a source for specific feedback to students. As you grade the same kind of assignment later, you can add to it, and draw from it to give feedback whenever you grade the same kind of assignment. Let’s say that in the process of grading the essays, you’ve had to write the same kinds of comments to several or many students, like these.
|
Then these can be copied and pasted as needed into comments for another student, e.g.:
|
2 Guidelines
When giving feedback, specifics are helpful, and such a database can make this work easier. It’s helpful to provide some positive feedback – even if it’s not a good paper, at least try to find something positive to comment on; otherwise, a fully negative set of comments may seem mean-hearted. Even good students need positive feedback, because they need to know what their strengths are, so they can build on them or feel good about them. When giving negative feedback, it’s best to also give specific advice about what they can do to improve – e.g., something they can refer to, something they can read for more background knowledge on the topic, some references that you know of, or specific suggestions for better research, study, or preparation skills. Again, negative comments with no advice that they can act on can make you look unkind or uncaring, or might make them too discouraged to try to improve.
3 Grading bank + rubrics
Grading banks can also be used in conjunction with grading rubrics. A rubrics can be done in a spreadsheet, along with a column for comments for each student. The spreadsheet can be used for emailing students feedback on rubric categories and comments via email merge. Similarly, a Google Form can be constructed based on rubric categories, and checkboxes for common issues or comments. Each rubric category corresponds to an item in the online form, with checkboxes; each checkbox contains a commonly used comment. The instructor can fill out a form for each student, tick the appropriate checkboxes, and submit the form, which goes into a spreadsheet, which the instructor can then use for grade records. From the spreadsheet, the instructor can create an email merge to send each student feedback for rubric criteria and comments.
3.1 Within a document
A rubric can be printed out, with key items underlined or highlighted to draw students' attention to particular issues or strengths in the assignment. Similarly, a Google Doc rubric can simply be pasted into a students' file or online submission, to provide rubric feedback and comments, like the example below.
# | Criteria (My comments are in blue) | Score (1-10) |
---|---|---|
01 | Rationale, goals, objectives – Clear rationale & explanation of why the project is needed, goals, and its benefits
Which group / people / areas are you targeting, specifically? What kinds of areas are you priority? Since the Lifestraw and Waka are already existing technologies, what exactly are you proposing that is novel or inventive?
|
5 |
02 | Contents – Sufficient contents & explanations
What aspects of your concept are novel, creative, innovative…?
|
7 |
03 | Project details – Sufficient details & explanations
Where do you want to carry out the project, and how are these devices to work together in your concept?
|
7 |
04 | Other details – Timeline, budget, participants, etc., as necessary
Few details here.
|
8 |
05 | Explanations – Clear explanations, easy to understand follow;
It’s not clear what new ideas are presented here.
|
8 |
06 | Clarity & expression - Clear expressions & style; clear sentences; writing that shows sufficient work, revision, & proofreading | 8 |
07 | Organization - Well organized; clear intro & conclusion
Weak conclusion
|
8 |
08 | Format - Readable; appropriate formatting. Also, if used, suitable and well-done graphics, tables, charts, graphs, etc. (not required)
Long paragraphs; hard to follow.
|
7 |
09 | Value – Overall social, practical and scientific value & benefit; creativity and originality |
7 |
10 | Persuasiveness - Overall, the proposal would be persuasive and interesting to a professional audience | 5 |
Grade | 70 |
3.2 From a spreadsheet
Rubric evaluation can be done in a spreadsheet, with a column for extra comments from a feedback database. The following example shows a rubric for group presentations. Group identifiers are included, so the instructor can easily sort the spreadsheet by groups. After entering comments, the feedback can be emailed to students via email merge. See the page on spreadsheet tips for grading for more.
3.3 From a Google Form
An instructor can create a Google Form with rubric categories and checkboxes for common items from a feedback database for each category. The instructor can fill out one form for each student, entering a score for each category and checking the relevant checkboxes. After submitting each form, another form can be filled out for another student. The form submissions go into a spreadsheet in Google Drive, which the instructor can access, download, and use for emailing students feedback via email merge. Two out of ten categories from a rubric for essays are shown below, with checkboxes, another blank for extra comments, and a blank for a score for each category.
1a. Focus
[ ] Clear focus throughout the paper
|
2a. Organization & structure
[ ] Good organization
|
4 See also