


A multi-choice where more than one answer can be selected. A multi-choice where only one answer can be selected. If your answers are short, just copy them to this column. Like the Question text we recommend a shortened version of your answer. If the Answer Type is a TextBox the Answer Text is often blank, but if it is entered it will appear on the response as a watermark.Īnswer Text 2 is only applicable to Matrix Questions.Īnswer Short Name – is used in internal reporting. ( Read more on Ranking Questions)Īnswer Text, as it appears on the assessment. Ranking – For Ranking questions, the questions are inline, but grouped Ranking questions are where the respondent is asked to rank their top n items from a list in order of preference.As Matrix Questions are difficult to use on a mobile phone, we recommend slider bars for questions like this. Answers may have an Answer Type of Single Choice Item or MultiChoice Item. Typically, these are scoring type questions (say 1 – 5) and there are multiple questions.

Answers must have an Answer Type of Single Choice Item. Slider bars can be used with numeric or text answers.

Slider Bar - a slider bar runs across the page underneath the question.They are also a good choice for mobile phones. Inline – Answers run down the page inline with the Questions.Repeat this text for every row for the Question. These indicate the format of the answers on the response entry screen. Some assessments have all the questions with the same potential score others weight certain questions by giving a higher potential score and higher proportionate answer scores. Repeat this score for every row for the Question.Īnswer Format. Do not include any Excel New Line characters (Alt-Enter). Repeat this text for every row for the Question. You can format the text by including HTML codes, or you can upload it as plain text and format it in the Assessment Builder later. By putting it on the first question for the assessment, section or subsection, it can introduce the assessment, section or subsection. This text will appear before the Question. These are documented in Point 3 of the Add/Edit Questions article. For example, if the question was “What is your annual revenue?” the Short Name might be “Revenue.” Also, Smart Question Short Names drive synchronization between the response settings and the answers for passing data like the respondents' names between the two.
#QUICK SPREADSHEET UPLOAD DOWNLOAD#
Use this field in internal reporting (when you download Assessment Answer data) and on the feedback or cohort report for graphics that are at the question level. Question Text as it appears on the response screen. It occurs on every row of the spreadsheet for the Question, one for each available answer. It occurs on every row of the spreadsheet for the Subsection. The subsections will be created in the order they appear, and all the rows for one section must be together. SubSection Name. Subsections are the third level for scoring, and important for building text on the feedback report. The sections will be created in the order they appear, and all the rows for one section must be together. It occurs on every row of the spreadsheet for the section. The Section name appears as a heading in the response. Section Name. A section appears as one page on the response. You should copy it down rather than rekeying it to avoid slight differences.
#QUICK SPREADSHEET UPLOAD FREE#
The free format name for the assessment - this will occur on every row of the spreadsheet. Fields that are not commonly used are defaulted but can be changed through the Assessment Builder later. From this sheet, we create the Assessment, Sections, Subsection. The Questions Example sheet shows a sample fully completed assessment for review. These are uploaded from the Questions Template sheet. To upload an existing assessment in a different language follow these steps. Once you have completed the spreadsheet, please send it to site information. It contains three empty sheets and three example sheets that have an example assessment for reference. The spreadsheet is attached and you can download it from the bottom of this article. It is not necessary to complete all three, the information can be input into the system directly later. One for the Questions and Answers, one for Ratings, and one for Rating Subsections. There are three sheets in the spreadsheet. Once the assessment is uploaded you can then alter it in any way via the Assessment Builder in the usual way. Brilliant Assessments offer a service for customers of uploading assessments from a spreadsheet.
