Frequently Asked Questions (FAQs)

The Excel import feature supports the following question types: 1. Exam multiple choice questions (Multiple Choice) 2. Exam multiple selection questions (Checkboxes) 3. Single-answer fill-in-the-blank questions (Written) 4. Multiple-answer fill-in-the-blank questions 5. True/False questions (True/False). The system will automatically identify the question type based on the input content, and you can also manually select it from the drop-down menu.

The rules for setting the correct answer are as follows: 1. Single-choice questions: you can use uppercase letters (A, B, C, D) or numbers (1, 2, 3, 4) 2. Multiple-choice questions: use combinations of uppercase letters (such as A,B,C) or numbers (such as 1,2,3), separated by commas 3. True/false questions: you can use formats such as True/False, Yes/No, A/B, etc. 4. Fill-in-the-blank questions: directly enter the answer text in the correct answer column. The system will automatically convert lowercase letters to uppercase and supports recognition of correct answers in multiple formats.

The scoring rules are as follows: 1. You can set a separate score for each question 2. Scores support integers and up to one decimal place 3. The score range is limited to 0-100 points 4. If no score is set, the system will use 5 points by default 5. Scores exceeding 100 points will be capped and a prompt message will be displayed 6. Non-numeric input will be ignored and the default score will be used

The rules for handling answer explanations are as follows: 1. You can add an answer explanation for each question 2. Answer explanations support line breaks and special characters 3. If no answer explanation is provided, the system will not display undefined 4. Answer explanations will be shown in the preview and in the score report after completing the test 5. Answer explanations set for short-answer questions will also be displayed correctly

Excel import supports the following methods: 1. Upload an Excel file directly 2. Copy Excel content and paste it into the text box 3. Create using the template provided by the system and then import 4. Add questions directly on the import page. Users can choose the most suitable import method according to their needs.

The Excel import template must meet the following format requirements: 1. The header must include: question type, question content, option A, option B, etc., correct answer, score, answer explanation 2. Each row of data corresponds to one question 3. Question data starts from the first row after the header row 4. The option columns can be added or removed as needed 5. The system will provide templates in the corresponding language based on the current language environment 6. The template will include examples of various question types

Rules for handling special formats in imported data: 1. HTML tags will be correctly recognized and displayed 2. In multiple-fill-in-the-blank questions, curly braces {} will be recognized as blank areas 3. Line breaks will be correctly preserved and displayed 4. Special characters (such as emojis) will be correctly recognized, but note the character length limit 5. Content containing HTML code such as div tags will be appropriately styled and optimized 6. JSON data formats will be properly recognized and displayed

The data validation rules for Excel import include: 1. The question content cannot be empty, otherwise an error will be prompted 2. Multiple-choice questions must have at least one option, otherwise an error will be prompted 3. The correct answer for a multiple-choice question must be within the range of options, otherwise an out-of-range error will be prompted 4. Multiple-choice questions cannot have duplicate options, otherwise a duplicate option error will be prompted 5. The questionnaire title cannot be empty, and a prompt to enter a title will be shown during preview 6. The title length is limited to 200 characters, and special characters will take up more character space 7. The score must be a number within the range of 0-100

The user experience optimizations for Excel import include: 1. A clear text feature is supported, with a confirmation prompt on click 2. If content has already been entered before importing an example, a confirmation prompt will appear 3. The preview pop-up can be closed by clicking outside the blank area, making it easier to return to editing 4. When switching import methods, the currently entered content will be saved 5. When uploading an Excel file, the file name will be automatically used as the questionnaire title 6. The import interface supports automatically adding more option columns, with up to 20 options supported 7. Row height has been optimized to make content easier to view and edit

Multilingual support for Excel import includes: 1. The system provides templates and examples in the corresponding language based on the current language environment 2. All prompts and button text support multiple languages 3. Prompt width in the Japanese environment has been optimized to avoid overly wide display 4. In the English environment, wording uses standard English expressions, such as Please enter" 5. The downloaded sample file name remains consistent with the current system language 6. In the Japanese environment, the question type labels are kept consistent with those on the edit page"