Step 2: Enter your scores into your Excel spreadsheet

Once you have set up your Excel spreadsheet, you can begin to enter your students’ scores.

Click on a link below to see how to do this for:

Rubric Scores
Test Scores

A Note on Working with Survey Data

If you are working with survey data, enter the item responses as you would test scores. Be sure to enter numeric values instead of words.

  • For example, imagine you ask a student to rate how often she performs a specific task on a 4-point scale (1 = never, 4 = often). If she indicates that she “often” performs the task, enter the numeric value (“4”) instead of the word (“often”) so that you can perform calculations in later steps.

Rubric Scores

Imagine that you applied the Written Communication rubric introduced in Step 1 and got the following scores: 

Rubric Scores Raw Data 5

You would enter the data as shown below; note that each row represents one student’s scores (if you would like step-by-step instructions, including time-saving keyboard shortcuts, click here to view the Entering Rubric Scores Video)

Rubrics Scores Entered Into Spreadsheet 6

Remember to check your work for errors as you go. You want to be sure that your entries are accurate before you make decisions based on your findings.

Test Scores

Imagine that you graded the Critical Thinking Skills test introduced in Step 1 and got the following scores:

Test Scores Raw Data 7

You would enter the data as shown below; note that each row represents one student’s scores (if you would like step-by-step instructions, including time-saving keyboard shortcuts, click here to view the Entering Test Scores Video):

 Test Scores Entered Into Spreadsheet 8

Remember to check your work for errors as you go. You want to be sure that your entries are accurate before you make decisions based on your findings.

Return to Excel for Assessment Homepage              Next: Step 3: Use Excel to summarize your Scores