Worksheets

Running the Summary report to context (WS:151)

This worksheet shows you how to run the Summary report to context and produce a report output for each context.

Change category colors in charts (WS: 125)

Change chart colors to match your organisation’s branding, or to better reflect the category name.

Summarise rating scale responses with Group Variables (WS: 124)

Quickly evaluate overall responses to questions in a grid, and make comparisons between separate question grids in your survey.

Create a chart of positive responses to rating scale questions (WS: 123)

Learn how to create an ‘Overall’ category for responses to all questions in a grid, and add the ‘Overall’ category to a Horizontal bar chart.

Analysing several variables in a single table (WS: 119)

See how to create a single table combining data from four multi-choice style questions.

 Analyzing data with crosstabs (WS: 113)

You can find trends and patterns in your data by creating ordered crosstabs. This worksheet shows you how to produce them, order them and display them as charts.

Using a cell reference to put the filtered base in a Summary Report (WS: 107)

How to Insert data as text, into a Summary report instruction, which is referencing a cell in a saved table. The example in this worksheet is inserting a filtered base figure.

Adapting the automatic Summary Report (WS: 106)

Customising the Summary Report in Snap desktop to make it more appropriate for your organisation.

Using Net Promoter Scores (NPS) in Snap (WS: 103)

This workpack describes how to create questions suitable for generating Net Promoter Scores in a Snap survey, and how to generate a Net Promoter Score from them. If you ask a rating scale question such as “How likely are you to recommend our company/product/service to your friends and colleagues?” you can analyse the responses to show how your customers see your company.

Creating a simple report (WS: 100)

This worksheet describes how to create a simple report consisting of a title, introduction, analysis and a conclusion. It assumes that you have already created any analyses that you wish to use in your report. You can run your report as often as you like, using the latest data to produce an up-to-date report. Once you have set up the report the way you like it, it will be produced like that every time you run it, with no chance of errors creeping in through copying or cut and paste.

Smart Reports: tailoring your data to a context (WS: 99)

This worksheet describes how to use contexts and filters to create a report that is tailored for a specific user. By setting a context, you can tailor the text and values in a report. By setting a filter, you can limit the data. In this worksheet, you add a list of comments to the report created in the worksheet Smart reports: creating multiple pdf reports using contexts. The comments will be filtered so that they only include comments for a specific restaurant. This is done by applying a filter based on context to the list analysis.

Smart Reports: creating multiple pdf reports using contexts (WS: 98)

This worksheet describes how to set up a Smart Report so it creates multiple pdf reports with Snap dynamically selecting the data depending on the context. It explains how to set up the survey in Snap so that it will produce all the reports that are needed, and then tells you how to set up the report instructions so that each report will be sent to a different pdf file.

Smart Reports: understanding contexts (WS: 97)

This worksheet describes how to set up a Smart Report so it dynamically selects the data depending on the context. The context is a variable containing a list of possible values.

Creating a Smart Report which includes automatic text (WS: 96)

This worksheet is the first of a series on how to use Smart Reports. Smart Reports can be re-run using the latest data to produce an up-to-date report. This worksheet describes how to use data from analyses in the report text. It also shows you how to use ordered tables so you can headline important points. For example, you can automatically include the aspects your customers are least satisfied with.

Using word clouds to display your results (WS: 95)

This worksheet describes how to create wordclouds from free text responses. Wordclouds allow you to display words or responses as a text graphic with the most common value written in the largest text. You can select how many items are displayed. Snap can automatically categorise open responses and uses a stop list to stop common words such as “and” or “the” being included in the word cloud. You can add words to the stop list and tailor the categories.You can create clouds from open responses or from the labels of coded responses.

Banding quantity variables for analysis (WS: 70)

When you have a quantity question in your survey, you sometimes want to split the results into bands for analysis (for example, when you wish to split ages or salaries into ranges). There is a quick way of doing this using numeric variables. Numeric variables are a type of derived variable, i.e, they contain information that is derived from people’s responses. This worksheet will use the data in the snCrocodile survey supplied with Snap to show you how to band the amount spent.

Putting counts and percentages on a bar chart (WS: 66)

Bar charts normally display one value per bar. You can choose whether this is the count, (number of respondents who chose that response), or the percentage (number of respondents as a percentage of the total). This worksheet explains how to create a bar chart that shows both the counts and the percentage values on a single chart.

Using filters to find a subset of respondents (WS: 63)

Use filters to break down the data you are displaying or analysing, so you only see the data that is appropriate.

Calculating the difference between times on different dates (WS: 50)

How to calculate the difference in hours from a start date and time and an end date and time, and use the results for analysis.

Using scores to analyse satisfaction questions (WS: 48)

Make more sense of rating questions, find out how to convert rating questions into mean values by assigning scores. If you have satisfaction or other questions where users rate something from one to five, you can convert this into more useful mean values by analysing the responses using a score.

Creating a combination chart to display respondent means as points and bars (WS: 45)

How to use a combination chart to display the means of groups of respondents in a satisfaction survey to the mean responses of all respondents. Create a derived variable called “All” which includes all respondents, and then shows you how to produce a chart of the satisfaction ratings, with total responses displayed as bars, and the individual breakdowns by male and female displayed as points.

Giving a consistent look and feel to all your charts (WS: 42)

You can save and apply chart styles in Snap in the same way that you can save and apply questionnaire styles. If you wish to have a consistent look and feel for the analysis charts you produce, you can create a style that only contains the colors and background definitions. You can then apply that style to any chart to make it appear in your organisation’s colors. This worksheet shows you how.

Using patterns to categorise postcodes into postal area (WS: 25)

This worksheet looks at applying a pattern at analysis stage. This particular example uses a derived variable in conjunction with a pattern, to extract the postal area part from a full UK postcode.

Gap Analysis: Compare results from satisfaction and importance questions (WS: 16)

Gap analysis in Snap shows the difference between how important attributes/services are to your respondents and how satisfied they are with those attributes/services. It is a really useful way of comparing the results from your satisfaction and importance questions and can be used as a tool for interpretation.

Calculating the Time in Minutes between Two Time Variables (WS: 11)

Snap has the capability to analyse times of the day using the 24 hour clock. If a questionnaire contains a start time and end time question, Snap can calculate the time difference between the two answers.

Calculating the Number of Days between Two Dates (WS: 8)

Calculating the number of days between two dates is easy as this worksheet shows.

Analyzing Dates (WS: 6)

Snap includes a number of operations and functions specifically designed to help in Analyzing dates.

Analyzing Post codes and Zip codes (WS: 5)