{"id":800,"date":"2018-03-27T10:09:47","date_gmt":"2018-03-27T10:09:47","guid":{"rendered":"http:\/\/360elearning.com\/blog\/?p=800"},"modified":"2018-03-27T10:09:47","modified_gmt":"2018-03-27T10:09:47","slug":"create-import-export-question-csv-file-lectora","status":"publish","type":"post","link":"https:\/\/360elearning.com\/blog\/create-import-export-question-csv-file-lectora\/","title":{"rendered":"Create, Import and Export Question CSV File in Lectora"},"content":{"rendered":"<p>The number of features in Lectora that can save your time, import CSV feature is the prominent one. This feature allows users to add bulk questions in Lectora. In this way, you can add different types of questions with less amount of time. In this article, we will go through the process of importing and exporting CSV file in Lectora. In the first part, we will discuss the CSV file format and in second part describe you, how can you import and export file in Lectora. You can import and export the following questions types within CSV files:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-801\" src=\"http:\/\/360elearning.com\/blog\/wp-content\/uploads\/2018\/03\/Types-of-questions.jpg\" alt=\"\" width=\"150\" height=\"301\" \/><\/p>\n<h1>A.\u00a0 How to create or edit a CSV file?<\/h1>\n<p>A CSV file has three main parts. Question information, Feedback information, and Choice information.<\/p>\n<h2>1.\u00a0\u00a0\u00a0\u00a0\u00a0 Question information<\/h2>\n<p>In first, you have to add information about the question such as:<\/p>\n<ul>\n<li>Question name: Give a name to your question like question 1, Activity 1, progress check etc.<\/li>\n<li>Question type: There are 12 different types of questions that you can add in Lectora. You have to put question type key in the second column.<\/li>\n<li>Question text: Simply just enter the question text. Make sure the question text should be according to its type.<\/li>\n<li>Question options: In options column, you have to add some limitations for the user such as the number of attempts, Grade each value, Randomize sequence order etc.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-802\" src=\"http:\/\/360elearning.com\/blog\/wp-content\/uploads\/2018\/03\/2.jpg\" alt=\"\" width=\"974\" height=\"429\" srcset=\"https:\/\/360elearning.com\/blog\/wp-content\/uploads\/2018\/03\/2.jpg 974w, https:\/\/360elearning.com\/blog\/wp-content\/uploads\/2018\/03\/2-300x132.jpg 300w, https:\/\/360elearning.com\/blog\/wp-content\/uploads\/2018\/03\/2-768x338.jpg 768w\" sizes=\"auto, (max-width: 974px) 100vw, 974px\" \/><\/p>\n<h2>2.\u00a0\u00a0\u00a0\u00a0\u00a0 Feedback information<\/h2>\n<p>In next, you enter the feedback information whether you want feedback immediately or when question process. Lectora gives you following feedback options:<\/p>\n<ul>\n<li>None<\/li>\n<li>Immediately\/On process<\/li>\n<li>By choice<\/li>\n<li>Custom correct\/incorrect<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-803\" src=\"http:\/\/360elearning.com\/blog\/wp-content\/uploads\/2018\/03\/3.jpg\" alt=\"\" width=\"643\" height=\"326\" srcset=\"https:\/\/360elearning.com\/blog\/wp-content\/uploads\/2018\/03\/3.jpg 643w, https:\/\/360elearning.com\/blog\/wp-content\/uploads\/2018\/03\/3-300x152.jpg 300w\" sizes=\"auto, (max-width: 643px) 100vw, 643px\" \/><\/p>\n<p>Blank = No feedback<\/p>\n<p>Y = Yes (Enable feedback. Correct\/incorrect feedback is the default.)<\/p>\n<p>B = Individual feedback by choice (Multiple Choice questions)<\/p>\n<p>P = Feedback displayed on process of the question (Immediate feedback is the default.)<\/p>\n<p>BP = Individual feedback by choice displayed on process (Multiple Choice questions)<\/p>\n<h2>3.\u00a0\u00a0\u00a0\u00a0\u00a0 Choice information<\/h2>\n<p>Finally for each question you have to put choices text and correct option. Is it a True or False?<\/p>\n<ul>\n<li>Choice options<\/li>\n<li>Choice text<\/li>\n<li>Additional choice information<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-804\" src=\"http:\/\/360elearning.com\/blog\/wp-content\/uploads\/2018\/03\/4.jpg\" alt=\"\" width=\"820\" height=\"327\" srcset=\"https:\/\/360elearning.com\/blog\/wp-content\/uploads\/2018\/03\/4.jpg 820w, https:\/\/360elearning.com\/blog\/wp-content\/uploads\/2018\/03\/4-300x120.jpg 300w, https:\/\/360elearning.com\/blog\/wp-content\/uploads\/2018\/03\/4-768x306.jpg 768w\" sizes=\"auto, (max-width: 820px) 100vw, 820px\" \/><\/p>\n<p>CC: indicates the correct choice(s). A number without CC: also indicates the correct choice(s).<\/p>\n<p>ALL = All answers\/All of the following rules (Fill in the Blank, Number Entry questions. The default is &#8220;any&#8221; choice\/rule.)<\/p>\n<p>ML = Create a multi-line entry field. (Fill in the Blank questions)<\/p>\n<p>TL: = Text character limit (Fill in the Blank, Number Entry, Short Answer, Essay questions)<\/p>\n<p>DL = Show choices in drop-list (Multiple Choice questions)<\/p>\n<p>LB = Show choices in the list box (Multiple Response questions)<\/p>\n<p>CS = Case sensitive (Fill in the Blank questions)<\/p>\n<p>RC = Randomize choices (Multiple Choice, Multiple Response, Rank\/Sequence questions)<\/p>\n<h1>B.\u00a0 Import CSV file on Lectora<\/h1>\n<p>Finally, import CSV file in Lectora just enter in Test &amp; Survey tab and click on Import CSV option.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-805\" src=\"http:\/\/360elearning.com\/blog\/wp-content\/uploads\/2018\/03\/5.jpg\" alt=\"\" width=\"872\" height=\"144\" srcset=\"https:\/\/360elearning.com\/blog\/wp-content\/uploads\/2018\/03\/5.jpg 872w, https:\/\/360elearning.com\/blog\/wp-content\/uploads\/2018\/03\/5-300x50.jpg 300w, https:\/\/360elearning.com\/blog\/wp-content\/uploads\/2018\/03\/5-768x127.jpg 768w\" sizes=\"auto, (max-width: 872px) 100vw, 872px\" \/><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-806\" src=\"http:\/\/360elearning.com\/blog\/wp-content\/uploads\/2018\/03\/6.jpg\" alt=\"\" width=\"381\" height=\"361\" srcset=\"https:\/\/360elearning.com\/blog\/wp-content\/uploads\/2018\/03\/6.jpg 381w, https:\/\/360elearning.com\/blog\/wp-content\/uploads\/2018\/03\/6-300x284.jpg 300w\" sizes=\"auto, (max-width: 381px) 100vw, 381px\" \/><\/p>\n<p>You can select some more option while importing. Select location on each page where the question will appear. Select font, size, and colour of text. Hit OK.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-807\" src=\"http:\/\/360elearning.com\/blog\/wp-content\/uploads\/2018\/03\/7.jpg\" alt=\"\" width=\"1340\" height=\"706\" srcset=\"https:\/\/360elearning.com\/blog\/wp-content\/uploads\/2018\/03\/7.jpg 1340w, https:\/\/360elearning.com\/blog\/wp-content\/uploads\/2018\/03\/7-300x158.jpg 300w, https:\/\/360elearning.com\/blog\/wp-content\/uploads\/2018\/03\/7-768x405.jpg 768w, https:\/\/360elearning.com\/blog\/wp-content\/uploads\/2018\/03\/7-1024x540.jpg 1024w\" sizes=\"auto, (max-width: 1340px) 100vw, 1340px\" \/><\/p>\n<p>Your questions are imported successfully. You can see each question criteria from its properties to match with CSV file information.<\/p>\n<h1>C.\u00a0 Export CSV file from Lectora<\/h1>\n<p>You can export test from Lectora simply click on export CSV in the properties tab.<\/p>\n<ul>\n<li>Export entire test<\/li>\n<li>Export single question<\/li>\n<li>Export multiple question<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-808\" src=\"http:\/\/360elearning.com\/blog\/wp-content\/uploads\/2018\/03\/8.jpg\" alt=\"\" width=\"824\" height=\"148\" srcset=\"https:\/\/360elearning.com\/blog\/wp-content\/uploads\/2018\/03\/8.jpg 824w, https:\/\/360elearning.com\/blog\/wp-content\/uploads\/2018\/03\/8-300x54.jpg 300w, https:\/\/360elearning.com\/blog\/wp-content\/uploads\/2018\/03\/8-768x138.jpg 768w\" sizes=\"auto, (max-width: 824px) 100vw, 824px\" \/><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-809\" src=\"http:\/\/360elearning.com\/blog\/wp-content\/uploads\/2018\/03\/9.jpg\" alt=\"\" width=\"1338\" height=\"704\" srcset=\"https:\/\/360elearning.com\/blog\/wp-content\/uploads\/2018\/03\/9.jpg 1338w, https:\/\/360elearning.com\/blog\/wp-content\/uploads\/2018\/03\/9-300x158.jpg 300w, https:\/\/360elearning.com\/blog\/wp-content\/uploads\/2018\/03\/9-768x404.jpg 768w, https:\/\/360elearning.com\/blog\/wp-content\/uploads\/2018\/03\/9-1024x539.jpg 1024w\" sizes=\"auto, (max-width: 1338px) 100vw, 1338px\" \/><\/p>\n<h1>Last words<\/h1>\n<p>Lastly, CSV file is handy in a way to store your test information in a text format for review by auditors and stakeholders. CSV Import option also save your time by adding multiple question pages with simple few steps.<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>The number of features in Lectora that can save your time, import CSV feature is the prominent one. This feature allows users to add bulk questions in Lectora. In this&#8230;<\/p>\n<p><a class='more-link' href='https:\/\/360elearning.com\/blog\/create-import-export-question-csv-file-lectora\/'>Read More <span class='screen-reader-text'>Create, Import and Export Question CSV File in Lectora<\/span><\/a><\/p>","protected":false},"author":4,"featured_media":814,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[33,20],"tags":[15,36,22,27],"class_list":["post-800","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-elearning-tools","category-lectora","tag-360elearning","tag-best-elearning-tools","tag-elearning-tool-lectora","tag-mobile-learning","excerpt"],"post_mailing_queue_ids":[],"_links":{"self":[{"href":"https:\/\/360elearning.com\/blog\/wp-json\/wp\/v2\/posts\/800","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/360elearning.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/360elearning.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/360elearning.com\/blog\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/360elearning.com\/blog\/wp-json\/wp\/v2\/comments?post=800"}],"version-history":[{"count":5,"href":"https:\/\/360elearning.com\/blog\/wp-json\/wp\/v2\/posts\/800\/revisions"}],"predecessor-version":[{"id":816,"href":"https:\/\/360elearning.com\/blog\/wp-json\/wp\/v2\/posts\/800\/revisions\/816"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/360elearning.com\/blog\/wp-json\/wp\/v2\/media\/814"}],"wp:attachment":[{"href":"https:\/\/360elearning.com\/blog\/wp-json\/wp\/v2\/media?parent=800"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/360elearning.com\/blog\/wp-json\/wp\/v2\/categories?post=800"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/360elearning.com\/blog\/wp-json\/wp\/v2\/tags?post=800"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}