Creating a grading rubric using Excel

Thanks Thanks:  0
Likes Likes:  0
Results 1 to 7 of 7

Thread: Creating a grading rubric using Excel

  1. #1
    New Member
    Join Date
    Sep 2012
    Posts
    6
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    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
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    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
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    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
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    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
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Creating a grading rubric using Excel

    I'm sorry, misunderstanding

  6. #6
    New Member
    Join Date
    Sep 2012
    Posts
    6
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Creating a grading rubric using Excel

    Misunderstanding what?

  7. #7
    Board Regular
    Join Date
    Jul 2012
    Location
    Livorno, Italy
    Posts
    1,950
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Creating a grading rubric using Excel

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

User Tag List

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