Import from Excel
The quiz questionnaire system supports importing questions from Excel, allowing users to efficiently create comprehensive quizs by importing pre-formatted content. This feature streamlines the quiz creation process and supports multiple languages including Japanese, Korean, Traditional Chinese, Portuguese, Spanish, and French.
Feature Access
1. Navigate to the questionnaire creation page
2. Locate the quiz title input field
3. Click the "Import from Excel" button below the title field
Supported Question Types
The system supports the following question types:
- Multiple Choice (Single Answer)
- Checkboxes (Multiple Answers)
- Short Answer
- True/False
- Written Answer (Single)
- Multiple Textbox
File Import Process
1. File Format Selection:
- Excel format is selected by default
- Option to switch to Word format is available
2. Required Information:
- quiz title (mandatory)
- Question content
- Answer options (for multiple choice questions)
- Correct answers (where applicable)
Answer Format Guidelines
1. Multiple Choice Questions:
- Must include correct answer
- Supports both letter (A, B, C) and number (1, 2, 3) options
2. Short Answer and Single Written Questions:
- Correct answers are optional
- For single written questions, multiple correct answers should be separated by the "|" symbol
3. Multiple Textbox Questions:
- Correct answers should be enclosed in curly braces {}
Preview and Add to Survey
1. Click the "Preview" button to review the imported questions
2. A preview panel will open on the right side
3. Review the questions and their formatting
4. Click "Add to Survey" to proceed to the questionnaire editing page
Important Notes
- The quiz title is mandatory and must be entered before importing
- You can add new option columns and rows as needed
- Sample templates are available for download
- The system supports multiple languages for international use
- Preview your questions before finalizing the import
- Ensure correct answer formatting for each question type
FAQs
Q: How do I access the Excel import feature for quiz creation?
A: Navigate to the questionnaire creation page, locate the quiz title input field, and click the "Import from Excel" button below the title field. This feature allows you to efficiently create comprehensive quizzes by importing pre-formatted content.
Q: What question types are supported for Excel import?
A: The system supports Multiple Choice (Single Answer), Checkboxes (Multiple Answers), Short Answer, True/False, Written Answer (Single), and Multiple Textbox questions. Each type has specific formatting requirements for correct import.
Q: What file formats can I use for import?
A: Excel format is selected by default, but you also have the option to switch to Word format. The system supports both formats for importing your quiz questions.
Q: What information is required for Excel import?
A: Required information includes: quiz title (mandatory), question content, answer options (for multiple choice questions), and correct answers (where applicable). The quiz title must be entered before importing.
Q: How should I format multiple choice questions in Excel?
A: Multiple choice questions must include the correct answer and support both letter options (A, B, C) and number options (1, 2, 3). Ensure the correct answer is clearly marked in your Excel file.
Q: How do I format multiple correct answers for written questions?
A: For single written questions, multiple correct answers should be separated by the "|" symbol. This allows you to specify multiple acceptable answers for the same question.
Q: What format should I use for multiple textbox questions?
A: Correct answers for multiple textbox questions should be enclosed in curly braces {}. This format helps the system identify the specific answers that should be filled in the textboxes.
Q: Can I preview questions before finalizing the import?
A: Yes, click the "Preview" button to review the imported questions. A preview panel will open on the right side where you can review the questions and their formatting before adding them to your survey.
Q: What languages are supported for international use?
A: The system supports multiple languages including Japanese, Korean, Traditional Chinese, Portuguese, Spanish, and French, making it suitable for international quiz creation and administration.
Q: Are sample templates available for download?
A: Yes, sample templates are available for download to help you understand the correct format for each question type. These templates serve as examples for proper Excel formatting.
Q: Can I modify the Excel structure during import?
A: Yes, you can add new option columns and rows as needed during the import process. This flexibility allows you to customize your quiz structure according to your specific requirements.
Q: What happens after I click "Add to Survey"?
A: After clicking "Add to Survey," you'll be taken to the questionnaire editing page where you can further customize your imported questions, make adjustments, and finalize your quiz before publishing.
