The Feedback report is built by merging a boilerplate Microsoft Word document with text and scores from the system. (Read an overview of Feedback Reporting That article has a sample template Word document attached (scroll to the bottom to download it)).
This article provides the detail of the merge strings available to build the feedback report and assumes you have already read and understood the article above.
Note: Merge Strings are case sensitive and there must be no spaces except between parameters within Square brackets e.g. {Bar[SectionNo=All Height=200]}
There are also several graphical options that can be included. These are documented in separate articles:
Horizontal Bar Chart (Progress Bar)
Response Based Merge Strings
Merge String |
Comments |
|
{Response.FirstName} |
Response First Name |
|
{Response.LastName} |
Response Last Name |
|
{Response.BusinessName} |
Response Business Name |
|
{Response.CompletionDate} |
Response Completion Date |
|
{Response.AdvisorName} |
Response Advisor Name |
|
{Response.OrganisationL1} |
Response Organisation Level 1 |
|
{Response.OrganisationL2} |
Response Organisation Level 2 |
|
{Response.OrganisationL3} |
Response Organisation Level 3 |
|
{Response.OrganisationL4} |
Response Organisation Level 4 |
|
{Response.OrganisationL5} |
Response Organisation Level 5 |
|
{Response.Address1} |
Response Address Line 1 |
|
{Response.Address2} |
Response Address Line 2 |
|
{Response.City} |
Response City |
|
{Response.Postcode} |
Response Postcode |
|
{Response.Country} |
Response Country |
Rating Based Text
Much of the body of most feedback reports are generally built using the Rating Subsection merge string. It displays the Rating Subsection text, followed by the report text for the selected answers. A bullet list for the answer report text can be achieved by formatting a bullet list for the merge string. The engine will iterate through the sections adding new bullet points for the answer text but the Subsection Rating Text will be left aligned.
e.g. {RatingSubsection.RatingText[SectionNo=2]} would produce the text from all the subsections and answer for Section Two (grouped by Subsection). Below is an example of the text for one of the subsections.
- This Text comes from the Subsection Rating. It is based on the rating the respondent scored for the subsection.
- The Text is Answer Report Text, based on the individual answers the respondent selected.
{RatingSubsection.RatingText} |
Report Text from the Subsection for the rating achieved for the subsection, followed by Report Text from the Answers table for the answers selected. NB. Formatting input into the Subsection rating Text or the Answer Report Text will be ignored. Merge word technology will not allow for formatting beyond that which is in the template document. |
{Rating.Rating} |
Rating for the assessment, calculated by comparing the calculated score with the maximum score on the rating. |
{Rating.RatingImage} |
Rating Image, from the ratings table. Note that the rating Image should be uploaded with the dimensions you want it on the Feedback report. |
The above merge strings are also available with these parameters:
SectionNo=n |
SubSectionNo=n |
{Rating.RatingText} |
Rating text From the ratings table for the assessment NB. Formatting input into the Rating Text will be ignored. Merge word technology will not allow for formatting beyond that which is in the template document. |
{Rating.Rating} |
Rating for the assessment, calculated by comparing the calculated score with the maximum score on the rating. |
{Rating.RatingImage} |
Rating Image, from the ratings table. |
The above merge strings are also available with these parameters:
[SegmentationNo=n]
e.g. {Rating.RatingText[SegmentationNo=1]} would produce the rating text from the ratings table, based on the score for Segmentation 1)
Report Text
Report Text is like Rating Text but doesn't include the Subsection Text. It only has the answer Text. The merge string is {RatingSubsection.ReportText}. The same Section and Subsection Parameters apply as above. Report Text can also print the Report Text 2 and Report Text 3 fields if they are implemented (by ticking the checkbox on the setup menu). The merge string is {RatingSubsection.ReportText2} or {RatingSubsection.ReportText3}.
Scores
Scores can be shown in the report ant any level.
e.g. {RatingScore.Score[SectionNo=1 SubsectionNo=2]} would produce the percentage score for Subsection 2 of section 1)
Also available is RatingType=n, which is only required when Advanced ratings are in use and you wish to use the score calculated using a Rating Type other than the Base. (Read more about Advanced Ratings)
{RatingScore.Score} |
Percentage Score calculated by dividing the total score of the answers selected divided by total potential score of the questions answered. |
{RatingScore.PotentialPoints} |
The total potential score of the questions answered. |
{RatingScore.ActualPoints} |
The average score of the answers selected. (as required for Likert-type reporting) |
The above merge strings have these parameters available:
SectionNo=n |
SubSectionNo=n |
QuestionNo=n |
SegmentationNo=n |
Decimals=n |
The Decimals parameter is optional. If it is not specified the score will be presented with no decimal points. If you have (for example) Decimals=1, the score will have one decimal point (like 20.3% for a percentage)
Individual Answers
The Question and Answer Id's are used as a short way of specifying a particular Question or Answer. The ID code can be found by clicking on the ID button on an Answer in The Assessment Builder.
e.g. 1{ResponseAnswer.AnswerText[S1 SS1 Q10 A1]} would produce the text entered into the response for the specified answer).
e.g. 2{ResponseAnswer.AnswerText[S1 SS1 Q10]} would produce the text entered into the response for the specified answer if the Answer Type is a Textbox or a multi-Line Text box. If the Answer Type is not text, The Answer Text (i.e. The wording of the answer selected) will be produced.
{ResponseAnswer.AnswerText[Sn SSn Qnn]} |
The answer text for the specified question (if answered) |
{ResponseAnswer.AnswerReportText[Sn SSn Qnn]} |
The answer report text for the specified question (if answered) NB. Formatting input into the Answer Report Text will be ignored. Merge word technology will not allow for formatting beyond that which is in the template document. |
{ResponseAnswer.Image[Sn SSn Qnn Ann]} |
The answer image for the specified answer. |
Response Answer Report Text can also print the Report Text 2 and Report Text 3 fields if they are implemented (by ticking the checkbox on the setup menu). The merge string is {ResponseAnswer.AnswerReportText2} or {ResponseAnswer.AnswerReportText3}.
Question Lists
Question Lists build up a word table of Questions, the answer selected and the report text for that answer. This is useful when you want to report back to the respondent the answers they specified.
For example {QuestionList[SectionNo=2]} would provide a list of all questions, answers and related report text (shown as Comments) in the format below.
You can list the questions at any level, Section, Sub-section or Question.
The Wordwidth parameter allows you to specify the percentage of the available width on the page that the table should occupy (i.e. Wordwidth=80 = 80%)
The Hide parameters suppress those fields. If both hide parameters are used, only the questions would be listed.
{QuestionList[]} |
Lists the Questions, Answer Text, and Report Text, under the headings Question, Response, and Comments. NB. Formatting input into the Answer Report Text will be ignored. Merge word technology will not allow for formatting beyond that which is in the template document. |
The available Parameters are:
SectionNo=n |
SubSectionNo=n |
QuestionNo=n |
Wordwidth=n |
HideReportText=Y |
HideAnswer=Y |
Website Text
Website Text is only used when you are using Brilliant Assessments to produce Website Reviews.
{AvailableAnswer.WebsiteSummary} |
Answered questions website summary text. Only applicable if you are using the system to generate Website Reviews. |
{AvailableAnswer.WebsiteText[SectionNo=1]} |
Answered questions website text by section. Only applicable if you are using the system to generate Website Reviews. |
The available Parameters are:
SectionNo=n |
SubSectionNo=n |
QuestionNo=n |
Comments
0 comments
Please sign in to leave a comment.