#  >> K-12 >> K-12 For Educators

How to Create a Rubric With Excel

Teachers often use rubrics to evaluate student work and to ensure students understand how they will be evaluated. Rubrics provide detailed descriptions of what a student must do to prove a certain level of mastery of several learning objectives. Many rubrics are visually arranged as a table. Students can read these easily to determine what they must do to prove proficiency at each targeted learning objective. Teachers can use these rubrics to easily score and evaluate student work. Excel is a good program for creating rubrics because of the way users can enter data into cells and visually manipulate the cells.

Instructions

    • 1

      Type a description of each learning objective on the left-hand side of the worksheet. Start typing in the leftmost cell of the worksheet, one row from the top. Write one learning objective per cell, adding each successive learning objective in next lower cell.

    • 2

      Type the possible scores for the learning objectives along the top of the worksheet. Skip the first cell. Type one possible score per cell. Start with the highest possible score on the left, and add each lower possible score in the next cell to the right.

    • 3

      Type a short description of the evidence a student must show to reach a particular score in the corresponding cell. For instance, if 4 is the highest score for "Using Proper Punctuation" then type a description of how students would demonstrate proper punctuation where the cells intersect.

    • 4

      Repeat the previous step until there is a description of how students can achieve every possible score on the rubric and for every learning objective.

    • 5

      Insert borders around every cell containing rubric information. Select all of the cells in the rubric, then click the arrow next to the borders on the Home tab. Select the borders around every cell.

Learnify Hub © www.0685.com All Rights Reserved