Results 1 to 7 of 7

Creating a grading rubric using Excel

This is a discussion on Creating a grading rubric using Excel within the Excel Questions forums, part of the Question Forums category; Hello All! First time poster here! I teach at a university and grade ALOT of projects, from speeches to art ...

  1. #1
    New Member
    Join Date
    Sep 2012
    Posts
    6

    Default Creating a grading rubric using Excel

    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:

    • 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

  2. #2
    Board Regular
    Join Date
    Jul 2012
    Location
    Livorno, Italy
    Posts
    1,950

    Default Re: Creating a grading rubric using Excel

    with a Google search you can find many examples about it

  3. #3
    New Member
    Join Date
    Sep 2012
    Posts
    6

    Default Re: Creating a grading rubric using Excel

    Thanks! I have searched but I mainly come up with rubrics for excel projects. Which search terms would you suggest!? Thanks again.

  4. #4
    New Member
    Join Date
    Sep 2012
    Posts
    6

    Default Re: Creating a grading rubric using Excel

    The more I look, "Rubric" is not the correct term. "Grading Feedback Form" is more correct...thanks again for any possible help!

  5. #5
    Board Regular
    Join Date
    Jul 2012
    Location
    Livorno, Italy
    Posts
    1,950

    Default Re: Creating a grading rubric using Excel

    I'm sorry, misunderstanding

  6. #6
    New Member
    Join Date
    Sep 2012
    Posts
    6

    Default Re: Creating a grading rubric using Excel

    Misunderstanding what?

  7. #7
    Board Regular
    Join Date
    Jul 2012
    Location
    Livorno, Italy
    Posts
    1,950

    Default Re: Creating a grading rubric using Excel

    I did not understand well your request, my english is not very good.

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


DMCA.com