This article is part of a series of steps to use Google Forms for a student peer assessment assignment. The steps outlined below assumes the form used is formatted to match the peer assessment created in How do I set up a Google Form to complete a student peer assessment?.
The processes described in this document are being explored as a way to implement peer assessments within Canvas. We don't yet know enough to say this is a "best practice". We will continue to update this document as we learn more. If you have found a different solution that works for you, we'd love to hear about it.
This article will provide the steps for synthesizing the data collected by the peer assessment Google Form into a spreadsheet and sorted so responses associated with a specific student are grouped together.
Step 1: Produce a Google Sheet that contains the raw form data
Open the editor page of the Google Form students filled out to complete the peer assessment.
- Click on the responses tab (the number in the dark circle indicates the number of form responses were completed in total).
- Click on the green spreadsheet icon found in the upper right of form data window.
A pop up window will appear. The default choice will be to create a new spreadsheet to hold the data.
- Rename the spreadsheet (if needed)
- Click create to open the spreadsheet with the data.
Select the Select existing spreadsheet option if you wish to save the data as a new tab on an already existing spreadsheet (for example if you create multiple peer assessment forms for each course section, linking all the data to one form may be useful for keeping results organized)
A new tab will open with the raw data in spreadsheet form.
Step 2: Sorting the data
Now that the data is in a spreadsheet, the sorting tools in Google sheets can be used to make the data easier to synthesize for each student.
- Select all of the data, including the headers and comments. There are many ways to do this but the easiest way is to use the select all keyboard shortcut (Ctrl+A for PC users and ⌘+A for Mac users).
- Select Data from the top navigation menu.
- Click Sort range.
- In the pop up menu, first click the check box to indicate Data has header row
The "Sort by" choices will now change to match the questions asked in the google form.
- Click on Timestamp to open the drop down menu.
- Select Group Member You are Evaluating.
- Click Add another sort column to produce another criteria to have the sort function use.
- Repeat steps 9 and 10 to sort by an additional criteria. The data will be easiest to interpret if it is sorted by Group Member you are Evaluating and then by the first evaluative criteria (for this example, it would be contribution and development)
- Click sort once all sorting criteria has been added.
The data will now be sorted so peer assessment data for the same student are grouped together.
Next Steps: Interpret and assess response data
There are many ways to interpret and score the results of a peer assessment. The purpose and goals of the peer assessment when it was assigned will contribute to how this data is interpreted and the final score that may be assigned to the student in the gradebook. Please see What should I consider when creating a student peer assessment? to learn more about how to use peer assessments to improve student growth in learning outcomes over time.
The NTN Gradebook is constantly being improved based on the feedback from users and we strive to keep our documentation up to date. If this document doesn't match what you are currently seeing, please let us know.