Wednesday, March 23, 2011
Tuesday, March 22, 2011
Monday, March 21, 2011
Thursday, March 17, 2011
Wednesday, March 16, 2011
Tuesday, March 15, 2011
Friday, March 11, 2011
Exporting to SPSS
You must be a GOLD or PLATINUM user, to have access to the SPSS export option to download a .sav file for SPSS.
1. Click the Analyze icon to access the Response Summary page.
2. Choose the All Responses Collected type of download.
3. Pick the SPSS format.
4. You can enter an email address to receive a notification and download link for when the export is ready, or just click the [View Download History] button later to access your current export requests.
5. This will deliver a compressed folder containing the .sav file.
NOTE: You will need to have SPSS software in order to open this file type. This export format supports SPSS 17.0.1 and onwards.
· The Variable view defines what each question is and its possible responses.
· The Data view is the spreadsheet-style view with all the responses.
This is defined by the type of question used in the survey:
· Scale is used for Rating Scale and Numerical Textbox questions
· Nominal is used for all other questions.
Google Docs users
You can export a spreadsheet in several different file formats, including .xls, .txt, .csv, .pdf, .html, and .ods. Note: it's not possible to export a spreadsheet as .xlsx. Once exprted as an excel file you should be able to import the data into SPSS software.
To export a spreadsheet, just choose File > Download as and select a file type.
· .txt - In this format, you can only export a single sheet.
· .csv - If you choose .csv, the file will export in UTF-8 and will not open directly in Excel or other applications. To edit a .csv file in Excel, open Excel, select File > Open, and then browse for your .csv file.
· .pdf - This is the best option for printing spreadsheets when formatting and styles are important. It's a good alternative to the Print menu option. There are many options available when exporting as a .pdf:
Analyzing data within SurveyMonkey
There are multiple ways to sort and filter data. These options are only available to paid users. Survey Monkey has a step by step tutorial on how to filter, graph, and create cross tabbed reports.
Blocking users from taking the survey twice or placing time limits
SurveyMonkey determines a "response" to be a response to the survey, no matter the number of questions answered. While the Web Link can limit the number of responses per computer, the Email Invitation truly allows only ONE response at all times. These settings are found under collector settings in the survey,
How to import an email list
· First export your contacts into an excel file
· From here you will have to move the columns around so that the Email Addresses are in column A, First Name in column B, Last Name in column C, and any Custom Data in column D.
· Please delete the rest of the columns so you only have the 4 columns.
· Save the file in the .CSV format.
· Open that file using Notepad, and then copy and paste all of that in to the import box in email list collector you have created in survey monkey
NOTE: A Professional (paid) account list may contain up to 10,000 emails. A Basic (free) account list may contain up to 100 emails. You can create multiple lists, but each one will be limited to this amount.
· If you do not see the .csv file in the Open prompt menu, then select the All Files type from the "Files of Type" selector.
· When the .csv file opens in the plain text program, it shows the emails in the correct format needed to copy and paste into the [Add Manually] textbox.
· Highlight the emails in the text file with your mouse/cursor and copy them. Paste them into the [Add Manually] textbox of the collector or inside the Address Book.
· When you are inside the Email Invitation collector, choose to Add Recipients Manually.
· Paste your emails from the Notepad (or plain text editor) file into the textbox.
NOTE: When you are inside the Address Book, click the [+ Add New List] button to begin the email upload. Once the list is saved, you can then pull those emails into any collector.
How does SurveyMonkey analyze text?
1. Click the Analyze icon associated with the survey to access the Response Summary page.
2. For any question that has comments, click the Show Responses button.
3. Click the Text Analysis tab to see the Cloud View and List View. This may give you some ideas for potential category names.
4. Under the My Categories tab: Click the [+ Create New Category] button, name it, and assign a color value to it.
5. Under the Responses tab, you can view all of the comments and assign them to the saved categories. Click the [Categorize As] button next to a response to place it into a category. Or select multiple responses at once by ticking off the box next to them and then click [Categorize As]. Click the Filter by Category button to apply a filter. Once it is applied, you will only see those comments.
A. Cloud View:
Our text analysis feature automatically searches for important words and phrases within your respondents' comments. The Cloud View then shows you these words by presenting them in different font sizes. The larger the font size, the more often that word was used by your respondents.
· Hover your mouse over each word and a prompt opens to show you the number of times (and the percentage) it was used.
· Click on the word in the Cloud View to see all of the responses associated with it.
· Consider creating category names for these responses based on the important words or phrases.
NOTE - Small number of comments: If you have a small number of responses (around 20 or less), then it won't show the cloud view. You need about 20 or more responses for the word cloud to pick up significant phrases.
B. List View:
Within this section, it orders the words shown in the Cloud View by highest to lowest number count. You will see the number of times (and percentage) that it appears within the comments.
C. Categorize Responses:
Create categories to tag responses together based on the content of their open-ended responses. When you need to view responses that pertain only to a specific category, create a filter and apply it to the comments under the Responses tab. Use the "Uncategorized Responses" filter option to quickly view any comments that have not yet been categorized.
D. View Category Counts:
After you have categorized your responses, click on the [Categories] tab. All your categories are listed with the count of comments that you tagged with that category, and their percentage of all responses. In this way, you can do quantitative analysis on your open-ended responses.
Thursday, March 10, 2011
Tuesday, March 8, 2011
Monday, March 7, 2011
I would enjoy hearing from others on their individual experiences with SurveyMonkey.