The 10 Day Film Challenge
  • WELCOME
  • 10 Day Challenge Home
    • Main Home
  • NJ 22-23 PROCESS
  • About Us
    • About the Directors
    • About the Challenge
  • Sign Up to Compete
  • Filmmaking Rules
    • All Rules
  • Genres
  • cinematic technique
  • Films / Awards
    • 2020 Multi-State Films
    • 2019 NJ Films
    • 2019 Multi-State Films
    • 2018 National Films
    • 2018 NY Films
    • 2018 PA Films
    • 2018 NJ Films
    • 2018 Multi-State Films
    • 2018 Overseas Films
    • 2017 National Films
    • 2017 NY Films
    • 2017 NJ Films
    • 2017 PA Films
    • 2017 Multi-State Films
    • 2016 National Films
    • 2016 NY Films
    • 2016 NJ Films
    • 2016 PA Films
    • 2016 Multi-State Films
    • 10 Day YouTube Channel
  • SUBMIT FINAL
  • Contact Us
  • Producers
  • FAQ

Exporting the data from Survey Monkey to an excel file

Go to www.surveymonkey.com, find your movie, click the PIE CHART to ANALYZE

sminchak@hammontonps.org
service

Click EXPORT ALL (the drop down) at the top right

Click: All Responses Data

Click: Opens in Microsoft Excel

You want to change the name of the file to the movie name here.  It will get confusing with all these charts.

Click  EXPORT

You will see it loading on the left side of screen

-       You may get a window that pops up that says download it

-       You may have to pick the’ XLS Data’ file on the left when it’s done

It will be a zip file.

Open it

Pick “excel” folder

Pick “sheet_1”

There are the results!

Take the average by doing the following

-       select all the scores

-       Go to that “Sum” button at the top (it looks like a funky capital E”)

-       Use the drop down of the “Sum” button and pick AVERAGE

-       It will make a row at the bottom of the average

-       Copy that AVERAGE row

-       Go to your new document and right click the row and click PASTE SPECIAL

-       You have to change it to VALUES

-       Then OK.