Managing Questionnaires
How questionnaires are created, updated and uploaded to eramba
Introduction
In this episode, we will guide you through the process of creating your questionnaires and uploading them to Eramba. You’ll learn how to structure your questions, define the format, and ensure they align with your assessment objectives, making the entire process smooth and efficient.
Structure
Questionnaires are created using spreadsheet templates (CSV files). You can download a CSV template, which includes detailed instructions on the required formatting, directly from Eramba. To do this, go to the “Questionnaire” tab, click “Add”, and select the option to download the template. This ensures your questionnaire is correctly formatted for upload.
The Online Assessment (OA) questionnaire is made up of several columns, some mandatory and others optional. The first row in the CSV template includes descriptions to help you understand the purpose of each column.
The first 6 columns are essential for organizing chapters and questions:
- Chapter ID: Groups your questions into chapters by assigning the same ID to related questions.
- Chapter Title: The title of the chapter to help categorize the questions.
- Chapter Description: A brief description of the chapter’s purpose or context.
- Question ID: A unique identifier for each question within the questionnaire.
- Question Title: The title or main text of the question.
- Question Description: Additional details or context to help respondents understand the question.
These columns ensure your questionnaire is well-structured and easy to navigate for both respondents and reviewers.
The next settings focus on configuring the answer options for each question:
- Type of Answer: You can choose between Open, Dropdown, or Both for the question type.
- Open: Allows respondents to provide free-text answers.
- Dropdown: Offers a list of predefined options.
- Both: Combines dropdown and open-text options.
- Dropdown-Specific Options (if Dropdown or Both is selected):
- Score: Assign a maximum score value to each dropdown option to evaluate responses quantitatively.
- Weight: Assign a weight to each option, which is multiplied by the maximum score to calculate the obtained score based on the selected option.
- Warning: Display a unique warning message for specific dropdown options when selected.
- Default Hidden: Keep the question hidden initially, and configure it to appear only when a related dropdown option in another question unhides it.
- Show Question: Use this setting to make specific dropdown selections reveal additional questions dynamically.
These settings allow you to design tailored, interactive questionnaires that streamline data collection and evaluation while adapting to the respondent’s input.
Importing
We recommend managing the content of your questionnaire using spreadsheets, as this is a quicker and more efficient way to handle them. The Eramba user interface has limited options for updating questionnaires directly, so spreadsheets provide greater flexibility and ease of management.
Once your questionnaire is finalized, you can import it into Eramba by navigating to the Questionnaire tab and selecting Actions > Import to upload your CSV file. This ensures a smooth and organized import process.
As shown in the diagram above, eramba will validate your inputs and if all is all right import the file to eramba.
Modifications
It is perfectly normal to need modifications to your questionnaires over time. We recommend making changes directly to your questionnaire’s CSV file and re-importing it into Eramba with a different version number. This ensures that your modifications are well-documented and maintainable.
While some changes can be made to questionnaires via the web interface, not all options are editable. Therefore, managing and updating questionnaires using CSV files is the most efficient approach.
It’s important to note that changes to a questionnaire are only possible if it is not already linked to any Online Assessments (OAs). Once a questionnaire is associated with OAs, it becomes locked and cannot be edited. If you need to make changes to such a questionnaire, you have two options:
- Delete the associated OAs to unlock the questionnaire.
- Upload a new version of the questionnaire as a separate entity.
This approach ensures consistency and flexibility in managing your questionnaires while avoiding disruptions to active assessments.
Templates
Our website includes a collection of templates you can use as inspiration, we also recommend using AI platforms (such as ChatGPT) to create tailor made questionaires.
Playlist
- Episode 1Introduction to Online Assessments6 mins left
- Episode 2Typical OA Questions2 mins left
- Episode 3OA Related Modules2 mins left
- Episode 4OA Strategy8 mins left
- Episode 5Managing Questionnaires3 mins left
- Episode 6Configuring the OA Module2 mins left
- Episode 7Creating User Accounts2 mins left
- Episode 8OA Attributes3 mins left
- Episode 9Creating Online Assessments4 mins left
- Episode 10Reviewing Feedback3 mins left
- Episode 11Findings1 min left