How to Upload Test Questions from Microsoft Excel
How to Upload Test Questions from Microsoft Excel
Instructors may author questions offline, save them in a specially formatted text file, and then upload questions into an existing test, survey, or pool. Once uploaded, questions may be edited and used like the questions that have been authored in the system. This tutorial will show you how to format a question file, access a test, and upload the question file to the test.
Content
1 ->
1.933 -> Instructors may author questions offline, save them in a specially formatted text file,
7 -> and then upload questions into an existing test, survey, or pool.
10.866 -> Once uploaded, questions may be edited and used like the questions that have been authored in the system.
16.166 ->
17 -> This tutorial will show you how to format a question file, access a test, and upload the question file to the test.
23.3 ->
24.166 -> It's easy to author your test questions in Microsoft Excel and save them as a text file.
29 -> However, to successfully upload a question file, certain rules must be followed.
33.766 -> The first column of the Excel file must indicate the question type.
37.533 -> In this example, MC is for multiple-choice, TF is for true/false,
43.333 -> MA is for multiple-answer, and ESS is for essay.
48.433 -> The second column contains the question text.
51.266 -> The third column is the answer to the question.
54.133 ->
54.4 -> For questions with multiple answers, the following columns must indicate if the given answers are correct or incorrect.
61 -> For detailed formatting instructions please refer to help.blackboard.com.
66.266 -> When you are done creating questions, save the file as a tab delimited .txt file.
72.233 ->
73 -> Once your file has been created and saved, access the Tests, Surveys, and Pools tool
78 -> from the Course Tools section of the Control Panel.
80.5 ->
81.433 -> Access the contextual menu for the test to which you want to add the questions, and click Edit.
86.666 ->
87.5 -> Next, click Upload Questions and then click Browse to locate and select the question file on your computer.
93.633 ->
94.6 -> You can set the default point value for all questions in the file.
98.266 -> If no point value is specified, the questions will have a point value of zero, which can be changed later.
104.1 ->
105 -> When you are ready, click Submit.
107.3 -> The uploaded questions now appear in the test canvas page.
111.033 -> From here, you can edit the questions and set or change the point value, as well.
115.766 ->
116.466 -> Let's review. First, create a question file in Excel.
120.733 -> Then, access a test, survey, or pool to which the questions will be added.
125.366 -> Upload the question file, set the default point value, and submit.
Source: https://www.youtube.com/watch?v=Mi4H9eCNFgI