Can I Export Student Responses?

Overview

One way to review student answers after class is to export them to Google Sheets. Exporting student responses to a spreadsheet allows you to see the Text, Multiple Choice, and Number responses next to each student's name. Please note that at this time, only users signing in with a Google account are able to export responses.

In this article, you can learn about the following topics:

  • How to Export Responses to a Spreadsheet
  • How to Find your Spreadsheet Later

How to Export Responses

You can leave a Session running as long as you like. But to export responses, you'll need to end your Session first. You can do this at any time, you just...

1. Open the More Actions Menu and click End This Session, or
2. Click END.


Then you have the option to name the Session. This is optional, but makes the Session easier to locate later:

When you export responses from a Session to a spreadsheet, you will see the students' names along with their Text, Multiple Choice, and Number responses. You can only export responses once per Session, so be sure you are ready before you click Export.

Here are the two ways to export responses to a spreadsheet:

Export from the Sessions menu

  1. Go to app.peardeck.com/home.
  2. Open your Sessions.
  3. Click the More Actions (3-dot) button next to the Session you want to export, then click Export to Spreadsheet. Your Google Sheet will open in a new tab.

Export from Recent Activity

  1. Go to app.peardeck.com/home.
  2. Go to Recent Activity.
  3. Click on the Deck.
  4. Find the Session you want to export.
  5. Click the More Actions button next to it, then click Export to Spreadsheet. Your Google Sheet will open in a new tab.

How to Find your Spreadsheet Later

When you export responses, the spreadsheet is automatically saved to your Google Drive in your Pear Deck > Exports folder.

Please note: We cannot export images to Google Sheets. Therefore, Draggable answers export as coordinates, and Drawing answers do not export at all - but the spreadsheet will still tell you if the student responded to these types of questions. With Takeaways™ (a Premium feature), you can export Drawing and Draggable responses, too, as well as all of the Slides in the Session. It's another great tool for publishing student responses and extending the lesson after class!