**To analyze resistance and gradient ideas:**

1. Login to your account on this website

2. Return to this question

3. Click on the link below to Analyze resistance ideas

4. Upload your spreadsheet for analysis

5. Use the ‘Student Text Response Column (Start)’ dropdown menu to select the column containing the student responses to part a of the question.

6. Use the ‘Student Text Response Column (End)’ dropdown menu to select the column containing the student responses to part b of the question.

7. Both columns containing student responses should now be highlighted in teal

8. Add a note (e.g. pre-instruction) to your file if desired

9. Repeat steps 3 - 8 using the link below to Analyze gradient ideas

**To analyze your class responses using a Physiology Learning Progression Framework:**

1. Download the csv files from the gradient and resistance reports.

2. To a new file, copy and paste the entire resistance score column and gradient column into the same worksheet so that the student response is in column A, resistance score in column B and gradient score in column C. You should not need the values from the Probability columns.

3. Enter the formula below in the cells of column D.

=IF(OR(AND(B2=2,C2=2),AND(B2=2,C2=1),AND(B2=1,C2=2)),3,IF(OR(AND(B2=2,C2=0),AND(B2=0,C2=2),AND(B2=1,C2=1)),2,1))