Search

How to export student results in a datafile

This article takes you through how to use the Scoresheet to export student results as a .csv file, so you can work with the scores within a spreadsheet program like Microsoft Excel, or even Google Sheets.

  What is a .csv (comma separated values) file?

A .csv file is a text file that contains a string of numerical data that can be used to create a spreadsheet. Sections of data are defined by a 'separator character' (normally a comma), and a program like MS Excel uses these commas to place the data into columns when the file is first opened.

Exporting results in this way is useful if you want to analyze student results in more detail (for instance with formulas and statistics), or perhaps if you need to fill out progress sheets for the benefit of your department.

Flash guide  

  1. Sign in to plickers.com on your laptop/computer
  2. Select Scoresheets... from the left-hand sidebar
  3. Select the Class and dates you're working with
  4. Click the Export Data to CSV icon CSV_icon_yellow_background.png in the top right-hand corner
  5. Save the file to your computer and open it with a program like MS Excel
For the full detailed guide on how to export student results, feel free to move through the steps below:
  1. Sign in to plickers.com on your laptop/computer

  2. Select 'Scoresheet...' from the left-hand sidebar

    You'll be taken to the following welcome page in a new tab:

    Scoresheet_welcome.png

  3. Select the Class you're working with

    You'll see your list of Classes on the left-hand side of the page.

  4. Select the date of your session using the calendar

    The calendar appears in the bottom left-hand corner of the page after you've selected your Class.

    You can change the date range used by the calendar by selecting an option from the following buttons, located at top of the screen:

    Date_Range_options.png

  5. Ensure your intended Sets and questions are included in the Scoresheet

    This will involve selecting the time range you require, as well as hiding any Sets or questions that you don't wish to include in the export file.

      Tip

    The time range selector is at the top of the Scoresheet page. You can also exclude questions/Sets by clicking on the percentage score for a content item in the Class Average row.

    More information about this can be found in our guide called How to customize your Scoresheet, within the following toggle boxes at the bottom of the article:
    • 'Include results from sessions across a range of dates'
    • 'Exclude questions or Sets from total scores'
  6. Click on the Export_to_csv.png icon in the top right-hand corner of the page

    This icon Export_to_csv.png is the Export Data to CSV button. When you click on it, you'll be able to save a .csv file to your computer.

    The easiest way to subsequently open the file on your computer is to locate it in Windows Explorer or Mac Finder, right-click on it, and select Open with.... You should then be able to select your usual spreadsheet program (like MS Excel for instance).

    You may be asked to define which separator character is used in the file, in which case you should select 'commas'.

 

Of course, exporting scores as a datafile isn't the only way to output student results from Plickers. You can also save or print Student Reports from the Scoresheet. Click here for more information about this.

Was this article helpful?

Comments

0 comments

Article is closed for comments.

Didn't find what you were looking for?

Didn't find what you were looking for?

Our support team members are ready to help with anything you might need.

Contact us