Log in
search
EN
CN TW EN
Menu

Product Support

HiTeach Web Excel Import: Build Questions with Correct Answers

HiTeach Web | Operation and Application Guide

Import Questions with Preset Correct Answers

When you have many text-based questions and want to preset the question type, choices, correct answer, and score, organize them in the HiTeach Web Excel format and import the file.

Requirements and Before You Begin

  • HiTeach Web is a browser-based service. The teacher and all students need a stable internet connection. We recommend the latest version of Google Chrome or Microsoft Edge for the teacher device.
  • HiTeach Web is available under Free, Professional, and School licenses. See the product and licensing page for details.
  • Available features, usage limits, participant capacity, and cloud storage vary by license. Refer to the latest information shown after sign-in and on the product page.
  • An Excel question file must follow the fields and format required by HiTeach Web. This method is designed mainly for text-based questions. For images, formulas, or complex layouts, use a PDF or image instead.

Who Should Use Excel Import?

Use it for recurring assessments, large question sets, and activities that need preset correct answers. For one question asked during class, writing on the whiteboard or inserting an image is faster.

1

Prepare questions with the template

Enter the prompt, answer choices, correct answer, and score in the required column order. Do not merge cells or rename required fields. (Download the Excel sample template)

HiTeach Web Excel question format
Organize text-based questions and answers in the required format.
2

Import the Excel file

Open the question-import function and select the completed XLSX file.

Import an Excel question file
Choose an Excel file that follows the required format.
3

Preview and check the questions

Review the prompt, choices, correct answer, and score for every question. If anything is displayed incorrectly, revise the Excel file and import it again.

Preview imported Excel questions
Check every question before class.
4

Run each question

After import, the question shown on the current page starts automatically. Once students respond, display the preset correct answer and response statistics.

Student answers a question imported from Excel
Questions are used in the order in which they were imported.
Response chart for a question imported from Excel
After responses close, review the answer distribution and the correct result.
5

Move to the next question

After the explanation, go to the next page and repeat the question, results, and discussion workflow.

Move to the next Excel question
Proceed question by question at the pace of the lesson.

Common Import Problems

  • Incorrect field names or order: Download the current template and compare the columns.
  • Answer code does not match an option: Check that the answer field uses the required code.
  • Line breaks or special characters display incorrectly: Simplify the text formatting and try again.
  • The question includes an image: Use PDF, image, or screen capture instead.

Related Resources

HiTeach Web operation and application series

Product and additional resources

Contact Us

If you still have questions, click Message us Message us in the lower-left corner of the page, contact us through our official Facebook page, or email habook@habook.com.

Service hours: Monday–Friday, 09:00–12:00 and 13:00–18:00 (UTC+8), excluding public holidays.

Go Back
TOP