{"version":"1.0","provider_name":"Blackboard Help for Staff - University of Reading","provider_url":"https:\/\/sites.reading.ac.uk\/tel-support","author_name":"Peter Moll","author_url":"https:\/\/sites.reading.ac.uk\/tel-support\/author\/petermoll\/","title":"Blackboard: creating Test questions offline - Blackboard Help for Staff - University of Reading","type":"rich","width":600,"height":338,"html":"<blockquote class=\"wp-embedded-content\" data-secret=\"wE47Ipiy6F\"><a href=\"https:\/\/sites.reading.ac.uk\/tel-support\/2018\/07\/30\/blackboard-creating-test-questions-offline\/\">Blackboard: creating Test questions offline<\/a><\/blockquote><iframe sandbox=\"allow-scripts\" security=\"restricted\" src=\"https:\/\/sites.reading.ac.uk\/tel-support\/2018\/07\/30\/blackboard-creating-test-questions-offline\/embed\/#?secret=wE47Ipiy6F\" width=\"600\" height=\"338\" title=\"&#8220;Blackboard: creating Test questions offline&#8221; &#8212; Blackboard Help for Staff - University of Reading\" data-secret=\"wE47Ipiy6F\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\" class=\"wp-embedded-content\"><\/iframe><script type=\"text\/javascript\">\n\/*! This file is auto-generated *\/\n!function(c,d){\"use strict\";var e=!1,o=!1;if(d.querySelector)if(c.addEventListener)e=!0;if(c.wp=c.wp||{},c.wp.receiveEmbedMessage);else if(c.wp.receiveEmbedMessage=function(e){var t=e.data;if(!t);else if(!(t.secret||t.message||t.value));else if(\/[^a-zA-Z0-9]\/.test(t.secret));else{for(var r,s,a,i=d.querySelectorAll('iframe[data-secret=\"'+t.secret+'\"]'),n=d.querySelectorAll('blockquote[data-secret=\"'+t.secret+'\"]'),o=new RegExp(\"^https?:$\",\"i\"),l=0;l<n.length;l++)n[l].style.display=\"none\";for(l=0;l<i.length;l++)if(r=i[l],e.source!==r.contentWindow);else{if(r.removeAttribute(\"style\"),\"height\"===t.message){if(1e3<(s=parseInt(t.value,10)))s=1e3;else if(~~s<200)s=200;r.height=s}if(\"link\"===t.message)if(s=d.createElement(\"a\"),a=d.createElement(\"a\"),s.href=r.getAttribute(\"src\"),a.href=t.value,!o.test(a.protocol));else if(a.host===s.host)if(d.activeElement===r)c.top.location.href=t.value}}},e)c.addEventListener(\"message\",c.wp.receiveEmbedMessage,!1),d.addEventListener(\"DOMContentLoaded\",t,!1),c.addEventListener(\"load\",t,!1);function t(){if(o);else{o=!0;for(var e,t,r,s=-1!==navigator.appVersion.indexOf(\"MSIE 10\"),a=!!navigator.userAgent.match(\/Trident.*rv:11\\.\/),i=d.querySelectorAll(\"iframe.wp-embedded-content\"),n=0;n<i.length;n++){if(!(r=(t=i[n]).getAttribute(\"data-secret\")))r=Math.random().toString(36).substr(2,10),t.src+=\"#?secret=\"+r,t.setAttribute(\"data-secret\",r);if(s||a)(e=t.cloneNode(!0)).removeAttribute(\"security\"),t.parentNode.replaceChild(e,t);t.contentWindow.postMessage({message:\"ready\",secret:r},\"*\")}}}}(window,document);\n<\/script>\n","description":"How to create questions and answers in Excel, then upload them to your Blackboard course Introduction Creating multiple choice or other types of questions in the Blackboard Test Canvas is not particularly difficult, but can be a tedious process. You might find it easier to type your questions and answers into Excel, then upload them as a batch to Blackboard. Before reading this user guide, you should be familiar with the creation and deployment of Tests in Blackboard \u2013 see separate user guide on Blackboard Tests. How to create test questions in Excel Your test questions must be formatted in exactly the right way to be uploaded successfully. Type them into Excel with each question on a new row with each field in a new column, as shown below Do not use any text formatting (bold, italic etc.) because this will be lost when you save the file. Question Type Enter an abbreviation from this list: Question Type the question exactly as you want it to appear. Answer 1, 2, 3, 4 etc. Enter each answer exactly as you want it to appear. Multiple Choice \u2013 and most other question types \u2013 allow a maximum of 20 answers per question. Correct? After each Answer, in the next column, type either Correct or Incorrect. Need more help? Check the full details in this Blackboard Help Article on Uploading Questions \u2192 Saving the file When finished, you need to save the file as a Tab Delimited Text file (not as an ordinary Excel file). Optionally, delete the first row containing headings (this will avoid a non-critical error message later in the process, but is not essential). Go to File &gt; Save As and enter a filename. From the Save As type drop-down list, choose Text (Tab delimited) (*.txt) Ignore this warning message \u2013 click Yes. &nbsp; Uploading the test questions to Blackboard In your course, go to Control Panel &gt; Course Tools &gt; Tests, Surveys and Pools then Tests. Click on Build Test. Provide a Name, Description and Instructions for the Test, and Submit. You will now be in the Test Canvas. Click Upload Questions. Browse for the txt file you saved from Excel. If required, change the Points per question. Submit when done. The \u2018Question Upload Complete\u2019 screen shows any errors which occurred in the upload process. &nbsp; \u00a0 If there is an error in a question within the file, only that question will fail to upload: questions without errors will upload successfully. In the example shown here, the error was simply caused by leaving in the first row of the spreadsheet (showing headings \u2013 \u201cQuestion Type\u201d, \u201cAnswer1\u201d etc.) This error has not prevented the test questions from uploading successfully. Click OK to return to the Test Canvas. You will see all the questions uploaded. These questions can be modified in exactly the same way as if you had typed them directly into Blackboard. Once you are satisfied that all of the questions are set up correctly, you can deploy the test in a content area, to make it available to students. &nbsp;","thumbnail_url":"https:\/\/sites.reading.ac.uk\/wp-content\/uploads\/sites\/30\/2018\/07\/7-28.png"}