Hello All! First time poster here!
I teach at a university and grade ALOT of projects, from speeches to art projects. I would like to be able to create grading rubrics in Excel. This is what I am thinking. On the first sheet, this is where I would enter in the students name, course section date. On this same sheet I would have multiple "canned" responses that I could select. Perhaps these responses could be grouped by the "type" of response. Sort of like:
So, for instance, while the student is giving their speech I can click on the various canned responses as well as having the option to type in personalized messages. When the speech was over, I could click over to the second sheet and everything would be formatted that I could print or save and email directly to the student.
I know this is probably over simplifying things but if anybody had any ideas, I'd be all ears!
Thanks much!
Pat Immel
I teach at a university and grade ALOT of projects, from speeches to art projects. I would like to be able to create grading rubrics in Excel. This is what I am thinking. On the first sheet, this is where I would enter in the students name, course section date. On this same sheet I would have multiple "canned" responses that I could select. Perhaps these responses could be grouped by the "type" of response. Sort of like:
- Type 1
- response 1
- response 2
- response 3
- etc.
- Type 2
- response 1
- response 2
- response 3
- etc.
- Type 3
- response 1
- response 2
- response 3
- etc.
So, for instance, while the student is giving their speech I can click on the various canned responses as well as having the option to type in personalized messages. When the speech was over, I could click over to the second sheet and everything would be formatted that I could print or save and email directly to the student.
I know this is probably over simplifying things but if anybody had any ideas, I'd be all ears!
Thanks much!
Pat Immel