HOW TO: Sorting Questionnaire responses

STEP 1

Open the Questionnaire Responses Spreadsheet. Try viewing the responses on a computer rather than a mobile device.

STEP 2

Find and click the dropdown menu named "Data" at the top.

ADVICE: change the view from 100% to 90% or 75% to see more categories at once. (see picture, button next to "Comment Only" )

STEP 3

Go to "Filter Views".

  • Here, you will be able to use one of our pre-set filters for a specific sleep time, party frequency, or cleanliness. (ex. If you want a specific major/interest, you can use CTRL+F or COMMAND+F and type your major/interest.)

  • OR, you can make your own by clicking "Create new temporary filter".

STEP 4

  • YELLOW BOX - Type Range as "A3:T"

  • BLUE LINES - Upside-down triangle

To customize a filter, click the upside-down triangle at the top of each column. (see white arrows)

  • For most columns: Scroll down and uncheck the choices you don't want to show up. (i.e. for Sleep Time: if you want Morning Person, uncheck the Night Owl box, see picture)

  • To specify a major: Scroll down and hit "Clear". Now you can type in the search bar a specific major and you can select the ones you want from the list accordingly.

If you would like a specific interest (music, tv shows, sports) use CTRL+F or COMMAND+F to do so.