{"id":576,"date":"2018-06-28T14:51:55","date_gmt":"2018-06-28T14:51:55","guid":{"rendered":"http:\/\/sites.reading.ac.uk\/tel-support\/?p=576"},"modified":"2023-02-01T22:45:06","modified_gmt":"2023-02-01T22:45:06","slug":"turnitin-create-and-import-a-qualitative-rubric-using-excel","status":"publish","type":"post","link":"https:\/\/sites.reading.ac.uk\/tel-support\/2018\/06\/28\/turnitin-create-and-import-a-qualitative-rubric-using-excel\/","title":{"rendered":"Turnitin: Create and Import a qualitative rubric using Excel"},"content":{"rendered":"<div style=\"margin: 15px;padding: 12px;background-color: #fff2cc;font-size: 1em\">\n<p><img data-attachment-id=\"12447\" data-permalink=\"https:\/\/sites.reading.ac.uk\/tel-support\/tii_logo_black_50sq\/\" data-orig-file=\"https:\/\/i0.wp.com\/sites.reading.ac.uk\/tel-support\/wp-content\/uploads\/sites\/30\/2022\/02\/tii_logo_black_50sq.jpg?fit=50%2C50&amp;ssl=1\" data-orig-size=\"50,50\" data-comments-opened=\"0\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"tii_logo_black_50sq\" data-image-description=\"\" data-image-caption=\"\" data-medium-file=\"https:\/\/i0.wp.com\/sites.reading.ac.uk\/tel-support\/wp-content\/uploads\/sites\/30\/2022\/02\/tii_logo_black_50sq.jpg?fit=50%2C50&amp;ssl=1\" data-large-file=\"https:\/\/i0.wp.com\/sites.reading.ac.uk\/tel-support\/wp-content\/uploads\/sites\/30\/2022\/02\/tii_logo_black_50sq.jpg?fit=50%2C50&amp;ssl=1\" decoding=\"async\" loading=\"lazy\" class=\"alignnone wp-image-12447 size-full\" src=\"https:\/\/i0.wp.com\/sites.reading.ac.uk\/tel-support-for-students\/wp-content\/uploads\/sites\/34\/2022\/03\/tii_logo_black_50sq.jpg?resize=50%2C50&#038;ssl=1\" alt=\"\" width=\"50\" height=\"50\" data-recalc-dims=\"1\" \/><strong>We have switched to a new version of Turnitin.<\/strong><\/p>\n<p>The new version of Turnitin is being used<\/p>\n<ul>\n<li>for all assignments due 1st\u00a0August or later \u2013 including coursework resubmissions and resit exams<\/li>\n<li>on all Blackboard courses for 2022\/23.<\/li>\n<\/ul>\n<p>This article relates only to the old version of Turnitin.<\/p>\n<p>For Turnitin LTI assignments, <a href=\"https:\/\/sites.reading.ac.uk\/tel-support\/2018\/06\/28\/blackboard-send-submission-reminders-for-assignments\/\">send a reminder via the Blackboard Grade Centre<\/a>.<\/p>\n<p>For help with the new version of Turnitin please see\u00a0<a style=\"font-size: large\" href=\"https:\/\/sites.reading.ac.uk\/tel-support\/turnitin-lti-assignments\/\"><strong>Turnitin LTI Assignments<\/strong><\/a><\/p>\n<\/div>\n<h2>Downloading the Excel Template<\/h2>\n<p>Access the Turnitin Assignment Inbox by going to <strong>Course Tools<\/strong> &gt; <strong>Turnitin Assignments<\/strong> &gt; choose an assignment from the list.<\/p>\n<p><img data-attachment-id=\"3254\" data-permalink=\"https:\/\/sites.reading.ac.uk\/tel-support\/2018\/06\/28\/turnitin-access-and-view-assignments\/tii-graphic-2\/\" data-orig-file=\"https:\/\/i0.wp.com\/sites.reading.ac.uk\/tel-support\/wp-content\/uploads\/sites\/30\/2018\/06\/Tii-Graphic-1.png?fit=1032%2C1118&amp;ssl=1\" data-orig-size=\"1032,1118\" data-comments-opened=\"1\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"Tii Graphic\" data-image-description=\"\" data-image-caption=\"\" data-medium-file=\"https:\/\/i0.wp.com\/sites.reading.ac.uk\/tel-support\/wp-content\/uploads\/sites\/30\/2018\/06\/Tii-Graphic-1.png?fit=1032%2C1118&amp;ssl=1\" data-large-file=\"https:\/\/i0.wp.com\/sites.reading.ac.uk\/tel-support\/wp-content\/uploads\/sites\/30\/2018\/06\/Tii-Graphic-1.png?fit=980%2C1062&amp;ssl=1\" decoding=\"async\" loading=\"lazy\" class=\"alignnone wp-image-3254 size-full\" src=\"\/wp-content\/uploads\/sites\/30\/2018\/06\/Tii-Graphic-1.png\" alt=\"A composite graphic magnifying the Blackboard Course Tool Menu. Where to access Turnitin\" width=\"1032\" height=\"1118\" srcset=\"https:\/\/i0.wp.com\/sites.reading.ac.uk\/tel-support\/wp-content\/uploads\/sites\/30\/2018\/06\/Tii-Graphic-1.png?w=1032&amp;ssl=1 1032w, https:\/\/i0.wp.com\/sites.reading.ac.uk\/tel-support\/wp-content\/uploads\/sites\/30\/2018\/06\/Tii-Graphic-1.png?resize=768%2C832&amp;ssl=1 768w, https:\/\/i0.wp.com\/sites.reading.ac.uk\/tel-support\/wp-content\/uploads\/sites\/30\/2018\/06\/Tii-Graphic-1.png?resize=138%2C150&amp;ssl=1 138w, https:\/\/i0.wp.com\/sites.reading.ac.uk\/tel-support\/wp-content\/uploads\/sites\/30\/2018\/06\/Tii-Graphic-1.png?resize=366%2C397&amp;ssl=1 366w, https:\/\/i0.wp.com\/sites.reading.ac.uk\/tel-support\/wp-content\/uploads\/sites\/30\/2018\/06\/Tii-Graphic-1.png?resize=770%2C834&amp;ssl=1 770w\" sizes=\"(max-width: 980px) 100vw, 980px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>1.\u00a0\u00a0\u00a0\u00a0 Click on the <strong>Libraries<\/strong> tab.<\/p>\n<p>2.\u00a0\u00a0\u00a0\u00a0 Click on <strong>Rubric\/Form Manager<\/strong>.<\/p>\n<p><a href=\"\/wp-content\/uploads\/sites\/30\/2018\/06\/2-13.png\"><img data-attachment-id=\"578\" data-permalink=\"https:\/\/sites.reading.ac.uk\/tel-support\/2018\/06\/28\/turnitin-create-and-import-a-qualitative-rubric-using-excel\/2-15\/\" data-orig-file=\"https:\/\/i0.wp.com\/sites.reading.ac.uk\/tel-support\/wp-content\/uploads\/sites\/30\/2018\/06\/2-13.png?fit=1153%2C428&amp;ssl=1\" data-orig-size=\"1153,428\" data-comments-opened=\"1\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"2\" data-image-description=\"\" data-image-caption=\"\" data-medium-file=\"https:\/\/i0.wp.com\/sites.reading.ac.uk\/tel-support\/wp-content\/uploads\/sites\/30\/2018\/06\/2-13.png?fit=1153%2C428&amp;ssl=1\" data-large-file=\"https:\/\/i0.wp.com\/sites.reading.ac.uk\/tel-support\/wp-content\/uploads\/sites\/30\/2018\/06\/2-13.png?fit=980%2C364&amp;ssl=1\" decoding=\"async\" loading=\"lazy\" class=\"alignnone size-full wp-image-578\" src=\"\/wp-content\/uploads\/sites\/30\/2018\/06\/2-13.png\" alt=\"Image showing the Libraries tab and the Rubric\/Form manager below it\" width=\"1153\" height=\"428\" srcset=\"https:\/\/i0.wp.com\/sites.reading.ac.uk\/tel-support\/wp-content\/uploads\/sites\/30\/2018\/06\/2-13.png?w=1153&amp;ssl=1 1153w, https:\/\/i0.wp.com\/sites.reading.ac.uk\/tel-support\/wp-content\/uploads\/sites\/30\/2018\/06\/2-13.png?resize=768%2C285&amp;ssl=1 768w, https:\/\/i0.wp.com\/sites.reading.ac.uk\/tel-support\/wp-content\/uploads\/sites\/30\/2018\/06\/2-13.png?resize=150%2C56&amp;ssl=1 150w, https:\/\/i0.wp.com\/sites.reading.ac.uk\/tel-support\/wp-content\/uploads\/sites\/30\/2018\/06\/2-13.png?resize=366%2C136&amp;ssl=1 366w, https:\/\/i0.wp.com\/sites.reading.ac.uk\/tel-support\/wp-content\/uploads\/sites\/30\/2018\/06\/2-13.png?resize=770%2C286&amp;ssl=1 770w\" sizes=\"(max-width: 980px) 100vw, 980px\" \/><br \/>\n<\/a><\/p>\n<p>3.\u00a0\u00a0\u00a0\u00a0 Click the <strong>Import\/Export<\/strong> button in the right-hand corner of blue menu bar.<\/p>\n<p>4.\u00a0\u00a0\u00a0\u00a0 Click on <strong>Import<\/strong> from the menu.<\/p>\n<p><a href=\"\/wp-content\/uploads\/sites\/30\/2018\/06\/3-14.png\"><img data-attachment-id=\"579\" data-permalink=\"https:\/\/sites.reading.ac.uk\/tel-support\/2018\/06\/28\/turnitin-create-and-import-a-qualitative-rubric-using-excel\/3-15\/\" data-orig-file=\"https:\/\/i0.wp.com\/sites.reading.ac.uk\/tel-support\/wp-content\/uploads\/sites\/30\/2018\/06\/3-14.png?fit=1119%2C328&amp;ssl=1\" data-orig-size=\"1119,328\" data-comments-opened=\"1\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"3\" data-image-description=\"\" data-image-caption=\"\" data-medium-file=\"https:\/\/i0.wp.com\/sites.reading.ac.uk\/tel-support\/wp-content\/uploads\/sites\/30\/2018\/06\/3-14.png?fit=1119%2C328&amp;ssl=1\" data-large-file=\"https:\/\/i0.wp.com\/sites.reading.ac.uk\/tel-support\/wp-content\/uploads\/sites\/30\/2018\/06\/3-14.png?fit=980%2C287&amp;ssl=1\" decoding=\"async\" loading=\"lazy\" class=\"alignnone size-full wp-image-579\" src=\"\/wp-content\/uploads\/sites\/30\/2018\/06\/3-14.png\" alt=\"image showing the Import\/export button button and the import option being selected\" width=\"1119\" height=\"328\" srcset=\"https:\/\/i0.wp.com\/sites.reading.ac.uk\/tel-support\/wp-content\/uploads\/sites\/30\/2018\/06\/3-14.png?w=1119&amp;ssl=1 1119w, https:\/\/i0.wp.com\/sites.reading.ac.uk\/tel-support\/wp-content\/uploads\/sites\/30\/2018\/06\/3-14.png?resize=768%2C225&amp;ssl=1 768w, https:\/\/i0.wp.com\/sites.reading.ac.uk\/tel-support\/wp-content\/uploads\/sites\/30\/2018\/06\/3-14.png?resize=150%2C44&amp;ssl=1 150w, https:\/\/i0.wp.com\/sites.reading.ac.uk\/tel-support\/wp-content\/uploads\/sites\/30\/2018\/06\/3-14.png?resize=366%2C107&amp;ssl=1 366w, https:\/\/i0.wp.com\/sites.reading.ac.uk\/tel-support\/wp-content\/uploads\/sites\/30\/2018\/06\/3-14.png?resize=770%2C226&amp;ssl=1 770w\" sizes=\"(max-width: 980px) 100vw, 980px\" \/><br \/>\n<\/a><\/p>\n<p>5.\u00a0\u00a0\u00a0\u00a0 In the <strong>Import Rubric<\/strong> window, scroll down and click on <strong>Download Example Template<\/strong> button.<\/p>\n<p><a href=\"\/wp-content\/uploads\/sites\/30\/2018\/06\/4-11.png\" rel=\"prettyphoto[576]\"><img data-attachment-id=\"580\" data-permalink=\"https:\/\/sites.reading.ac.uk\/tel-support\/2018\/06\/28\/turnitin-create-and-import-a-qualitative-rubric-using-excel\/4-13\/\" data-orig-file=\"https:\/\/i0.wp.com\/sites.reading.ac.uk\/tel-support\/wp-content\/uploads\/sites\/30\/2018\/06\/4-11.png?fit=1117%2C748&amp;ssl=1\" data-orig-size=\"1117,748\" data-comments-opened=\"1\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"4\" data-image-description=\"\" data-image-caption=\"\" data-medium-file=\"https:\/\/i0.wp.com\/sites.reading.ac.uk\/tel-support\/wp-content\/uploads\/sites\/30\/2018\/06\/4-11.png?fit=1117%2C748&amp;ssl=1\" data-large-file=\"https:\/\/i0.wp.com\/sites.reading.ac.uk\/tel-support\/wp-content\/uploads\/sites\/30\/2018\/06\/4-11.png?fit=980%2C656&amp;ssl=1\" decoding=\"async\" loading=\"lazy\" class=\"alignnone size-full wp-image-580\" src=\"\/wp-content\/uploads\/sites\/30\/2018\/06\/4-11.png\" alt=\"Image showing the Download Example Template button on the page\" width=\"1117\" height=\"748\" srcset=\"https:\/\/i0.wp.com\/sites.reading.ac.uk\/tel-support\/wp-content\/uploads\/sites\/30\/2018\/06\/4-11.png?w=1117&amp;ssl=1 1117w, https:\/\/i0.wp.com\/sites.reading.ac.uk\/tel-support\/wp-content\/uploads\/sites\/30\/2018\/06\/4-11.png?resize=768%2C514&amp;ssl=1 768w, https:\/\/i0.wp.com\/sites.reading.ac.uk\/tel-support\/wp-content\/uploads\/sites\/30\/2018\/06\/4-11.png?resize=150%2C100&amp;ssl=1 150w, https:\/\/i0.wp.com\/sites.reading.ac.uk\/tel-support\/wp-content\/uploads\/sites\/30\/2018\/06\/4-11.png?resize=366%2C245&amp;ssl=1 366w, https:\/\/i0.wp.com\/sites.reading.ac.uk\/tel-support\/wp-content\/uploads\/sites\/30\/2018\/06\/4-11.png?resize=770%2C516&amp;ssl=1 770w\" sizes=\"(max-width: 980px) 100vw, 980px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>This will download an Excel file you can edit to produce your own custom rubric for an assignment.<\/p>\n<p>&nbsp;<\/p>\n<h2>Creating a rubric<\/h2>\n<p>In Excel, enter:<\/p>\n<p>1.\u00a0\u00a0\u00a0\u00a0 <strong>Headings<\/strong> for the <strong>assessment criteria<\/strong> in column A<\/p>\n<p>2.\u00a0\u00a0\u00a0\u00a0 <strong>Titles<\/strong> for the <strong>scales<\/strong> in row 1<\/p>\n<p>3.\u00a0\u00a0\u00a0\u00a0 Descriptive text in each cell<\/p>\n<p><a href=\"\/wp-content\/uploads\/sites\/30\/2018\/06\/5-11.png\" rel=\"prettyphoto[576]\"><img data-attachment-id=\"581\" data-permalink=\"https:\/\/sites.reading.ac.uk\/tel-support\/2018\/06\/28\/turnitin-create-and-import-a-qualitative-rubric-using-excel\/5-13\/\" data-orig-file=\"https:\/\/i0.wp.com\/sites.reading.ac.uk\/tel-support\/wp-content\/uploads\/sites\/30\/2018\/06\/5-11.png?fit=613%2C327&amp;ssl=1\" data-orig-size=\"613,327\" data-comments-opened=\"1\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"5\" data-image-description=\"\" data-image-caption=\"\" data-medium-file=\"https:\/\/i0.wp.com\/sites.reading.ac.uk\/tel-support\/wp-content\/uploads\/sites\/30\/2018\/06\/5-11.png?fit=613%2C327&amp;ssl=1\" data-large-file=\"https:\/\/i0.wp.com\/sites.reading.ac.uk\/tel-support\/wp-content\/uploads\/sites\/30\/2018\/06\/5-11.png?fit=613%2C327&amp;ssl=1\" decoding=\"async\" loading=\"lazy\" class=\"alignnone size-full wp-image-581\" src=\"\/wp-content\/uploads\/sites\/30\/2018\/06\/5-11.png\" alt=\"Image showing the excel grid\" width=\"613\" height=\"327\" srcset=\"https:\/\/i0.wp.com\/sites.reading.ac.uk\/tel-support\/wp-content\/uploads\/sites\/30\/2018\/06\/5-11.png?w=613&amp;ssl=1 613w, https:\/\/i0.wp.com\/sites.reading.ac.uk\/tel-support\/wp-content\/uploads\/sites\/30\/2018\/06\/5-11.png?resize=150%2C80&amp;ssl=1 150w, https:\/\/i0.wp.com\/sites.reading.ac.uk\/tel-support\/wp-content\/uploads\/sites\/30\/2018\/06\/5-11.png?resize=366%2C195&amp;ssl=1 366w\" sizes=\"(max-width: 613px) 100vw, 613px\" \/><\/a><\/p>\n<pre>\u00a0<img data-attachment-id=\"903\" data-permalink=\"https:\/\/sites.reading.ac.uk\/tel-support\/2018\/06\/28\/turnitin-create-and-import-a-qualitative-rubric-using-excel\/t-100-2\/\" data-orig-file=\"https:\/\/i0.wp.com\/sites.reading.ac.uk\/tel-support\/wp-content\/uploads\/sites\/30\/2018\/06\/t-100-2.png?fit=100%2C100&amp;ssl=1\" data-orig-size=\"100,100\" data-comments-opened=\"1\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"t-100-2\" data-image-description=\"\" data-image-caption=\"\" data-medium-file=\"https:\/\/i0.wp.com\/sites.reading.ac.uk\/tel-support\/wp-content\/uploads\/sites\/30\/2018\/06\/t-100-2.png?fit=100%2C100&amp;ssl=1\" data-large-file=\"https:\/\/i0.wp.com\/sites.reading.ac.uk\/tel-support\/wp-content\/uploads\/sites\/30\/2018\/06\/t-100-2.png?fit=100%2C100&amp;ssl=1\" decoding=\"async\" loading=\"lazy\" class=\"size-full wp-image-903 aligncenter\" style=\"border: none\" src=\"\/wp-content\/uploads\/sites\/30\/2018\/06\/t-100-2.png\" alt=\"\" width=\"100\" height=\"100\" srcset=\"https:\/\/i0.wp.com\/sites.reading.ac.uk\/tel-support\/wp-content\/uploads\/sites\/30\/2018\/06\/t-100-2.png?w=100&amp;ssl=1 100w, https:\/\/i0.wp.com\/sites.reading.ac.uk\/tel-support\/wp-content\/uploads\/sites\/30\/2018\/06\/t-100-2.png?resize=75%2C75&amp;ssl=1 75w\" sizes=\"(max-width: 100px) 100vw, 100px\" \/>Don\u2019t worry about formatting\u2013 it will display in Turnitin as plain text.<\/pre>\n<pre> <img data-attachment-id=\"904\" data-permalink=\"https:\/\/sites.reading.ac.uk\/tel-support\/2018\/06\/28\/turnitin-create-and-import-a-qualitative-rubric-using-excel\/i-100-2\/\" data-orig-file=\"https:\/\/i0.wp.com\/sites.reading.ac.uk\/tel-support\/wp-content\/uploads\/sites\/30\/2018\/06\/i-100-2.png?fit=100%2C100&amp;ssl=1\" data-orig-size=\"100,100\" data-comments-opened=\"1\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"i-100-2\" data-image-description=\"\" data-image-caption=\"\" data-medium-file=\"https:\/\/i0.wp.com\/sites.reading.ac.uk\/tel-support\/wp-content\/uploads\/sites\/30\/2018\/06\/i-100-2.png?fit=100%2C100&amp;ssl=1\" data-large-file=\"https:\/\/i0.wp.com\/sites.reading.ac.uk\/tel-support\/wp-content\/uploads\/sites\/30\/2018\/06\/i-100-2.png?fit=100%2C100&amp;ssl=1\" decoding=\"async\" loading=\"lazy\" class=\"size-full wp-image-904 aligncenter\" style=\"border: none\" src=\"\/wp-content\/uploads\/sites\/30\/2018\/06\/i-100-2.png\" alt=\"\" width=\"100\" height=\"100\" srcset=\"https:\/\/i0.wp.com\/sites.reading.ac.uk\/tel-support\/wp-content\/uploads\/sites\/30\/2018\/06\/i-100-2.png?w=100&amp;ssl=1 100w, https:\/\/i0.wp.com\/sites.reading.ac.uk\/tel-support\/wp-content\/uploads\/sites\/30\/2018\/06\/i-100-2.png?resize=75%2C75&amp;ssl=1 75w\" sizes=\"(max-width: 100px) 100vw, 100px\" \/>The Description field is optional and can be left blank.\r\n\r\n<img data-attachment-id=\"905\" data-permalink=\"https:\/\/sites.reading.ac.uk\/tel-support\/2018\/06\/28\/turnitin-create-and-import-a-qualitative-rubric-using-excel\/w-100-2\/\" data-orig-file=\"https:\/\/i0.wp.com\/sites.reading.ac.uk\/tel-support\/wp-content\/uploads\/sites\/30\/2018\/06\/w-100-2.png?fit=100%2C100&amp;ssl=1\" data-orig-size=\"100,100\" data-comments-opened=\"1\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"w-100-2\" data-image-description=\"\" data-image-caption=\"\" data-medium-file=\"https:\/\/i0.wp.com\/sites.reading.ac.uk\/tel-support\/wp-content\/uploads\/sites\/30\/2018\/06\/w-100-2.png?fit=100%2C100&amp;ssl=1\" data-large-file=\"https:\/\/i0.wp.com\/sites.reading.ac.uk\/tel-support\/wp-content\/uploads\/sites\/30\/2018\/06\/w-100-2.png?fit=100%2C100&amp;ssl=1\" decoding=\"async\" loading=\"lazy\" class=\"size-full wp-image-905 aligncenter\" style=\"border: none\" src=\"\/wp-content\/uploads\/sites\/30\/2018\/06\/w-100-2.png\" alt=\"\" width=\"100\" height=\"100\" srcset=\"https:\/\/i0.wp.com\/sites.reading.ac.uk\/tel-support\/wp-content\/uploads\/sites\/30\/2018\/06\/w-100-2.png?w=100&amp;ssl=1 100w, https:\/\/i0.wp.com\/sites.reading.ac.uk\/tel-support\/wp-content\/uploads\/sites\/30\/2018\/06\/w-100-2.png?resize=75%2C75&amp;ssl=1 75w\" sizes=\"(max-width: 100px) 100vw, 100px\" \/>There is a 13-character limit for the criteria names, so you will have to use short headings (e.g. \u2018Analysis\u2019 rather than \u2018Analytical skills\u2019). However, you can enter a fuller description of these headings on a new line, as shown below.\r\n\u00a0\r\n<img data-attachment-id=\"582\" data-permalink=\"https:\/\/sites.reading.ac.uk\/tel-support\/2018\/06\/28\/turnitin-create-and-import-a-qualitative-rubric-using-excel\/6-9\/\" data-orig-file=\"https:\/\/i0.wp.com\/sites.reading.ac.uk\/tel-support\/wp-content\/uploads\/sites\/30\/2018\/06\/6-8-e1530196347547.png?fit=400%2C400&amp;ssl=1\" data-orig-size=\"400,400\" data-comments-opened=\"1\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"6\" data-image-description=\"\" data-image-caption=\"\" data-medium-file=\"https:\/\/i0.wp.com\/sites.reading.ac.uk\/tel-support\/wp-content\/uploads\/sites\/30\/2018\/06\/6-8-e1530196347547.png?fit=400%2C400&amp;ssl=1\" data-large-file=\"https:\/\/i0.wp.com\/sites.reading.ac.uk\/tel-support\/wp-content\/uploads\/sites\/30\/2018\/06\/6-8-e1530196347547.png?fit=400%2C400&amp;ssl=1\" decoding=\"async\" loading=\"lazy\" class=\"size-full wp-image-582 alignnone\" src=\"\/wp-content\/uploads\/sites\/30\/2018\/06\/6-8-e1530196347547.png\" alt=\"Image showing excel grid\" width=\"400\" height=\"400\" srcset=\"https:\/\/i0.wp.com\/sites.reading.ac.uk\/tel-support\/wp-content\/uploads\/sites\/30\/2018\/06\/6-8-e1530196347547.png?w=400&amp;ssl=1 400w, https:\/\/i0.wp.com\/sites.reading.ac.uk\/tel-support\/wp-content\/uploads\/sites\/30\/2018\/06\/6-8-e1530196347547.png?resize=150%2C150&amp;ssl=1 150w, https:\/\/i0.wp.com\/sites.reading.ac.uk\/tel-support\/wp-content\/uploads\/sites\/30\/2018\/06\/6-8-e1530196347547.png?resize=366%2C366&amp;ssl=1 366w, https:\/\/i0.wp.com\/sites.reading.ac.uk\/tel-support\/wp-content\/uploads\/sites\/30\/2018\/06\/6-8-e1530196347547.png?resize=75%2C75&amp;ssl=1 75w\" sizes=\"(max-width: 400px) 100vw, 400px\" \/>\r\nTo insert a line break inside an Excel cell:\r\n\r\n<span id=\"box-table-text\">- double-click the cell<\/span>\r\n\r\n<span id=\"box-table-text\">- click in the text where you want to insert the line break<\/span>\r\n\r\n<span id=\"box-table-text\">- press ALT+ENTER.<\/span>\r\n\r\n\r\n\r\n\r\nWhen you save the Excel file, ensure the filename is no more than 30 characters long. Once you have saved the Excel file, you can import it into your Turnitin Rubric Library, ready to be attached to an assignment.<\/pre>\n<p>&nbsp;<\/p>\n<h2>Import a rubric<\/h2>\n<p>1.\u00a0\u00a0\u00a0\u00a0 Click on the Libraries tab.<\/p>\n<p>2.\u00a0\u00a0\u00a0\u00a0 Click on Rubric\/Form Manager.<\/p>\n<p>3.\u00a0\u00a0\u00a0\u00a0 Click the Import\/Export button in the right-hand corner of blue menu bar.<\/p>\n<p>4.\u00a0\u00a0\u00a0\u00a0 Click on Import from the menu.<\/p>\n<p><a href=\"\/wp-content\/uploads\/sites\/30\/2018\/06\/7-8.png\"><img data-attachment-id=\"583\" data-permalink=\"https:\/\/sites.reading.ac.uk\/tel-support\/2018\/06\/28\/turnitin-create-and-import-a-qualitative-rubric-using-excel\/7-9\/\" data-orig-file=\"https:\/\/i0.wp.com\/sites.reading.ac.uk\/tel-support\/wp-content\/uploads\/sites\/30\/2018\/06\/7-8.png?fit=1119%2C328&amp;ssl=1\" data-orig-size=\"1119,328\" data-comments-opened=\"1\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"7\" data-image-description=\"\" data-image-caption=\"\" data-medium-file=\"https:\/\/i0.wp.com\/sites.reading.ac.uk\/tel-support\/wp-content\/uploads\/sites\/30\/2018\/06\/7-8.png?fit=1119%2C328&amp;ssl=1\" data-large-file=\"https:\/\/i0.wp.com\/sites.reading.ac.uk\/tel-support\/wp-content\/uploads\/sites\/30\/2018\/06\/7-8.png?fit=980%2C287&amp;ssl=1\" decoding=\"async\" loading=\"lazy\" class=\"alignnone size-full wp-image-583\" src=\"\/wp-content\/uploads\/sites\/30\/2018\/06\/7-8.png\" alt=\"iamge showing the Import\/Export button clicked and the import option selected\" width=\"1119\" height=\"328\" srcset=\"https:\/\/i0.wp.com\/sites.reading.ac.uk\/tel-support\/wp-content\/uploads\/sites\/30\/2018\/06\/7-8.png?w=1119&amp;ssl=1 1119w, https:\/\/i0.wp.com\/sites.reading.ac.uk\/tel-support\/wp-content\/uploads\/sites\/30\/2018\/06\/7-8.png?resize=768%2C225&amp;ssl=1 768w, https:\/\/i0.wp.com\/sites.reading.ac.uk\/tel-support\/wp-content\/uploads\/sites\/30\/2018\/06\/7-8.png?resize=150%2C44&amp;ssl=1 150w, https:\/\/i0.wp.com\/sites.reading.ac.uk\/tel-support\/wp-content\/uploads\/sites\/30\/2018\/06\/7-8.png?resize=366%2C107&amp;ssl=1 366w, https:\/\/i0.wp.com\/sites.reading.ac.uk\/tel-support\/wp-content\/uploads\/sites\/30\/2018\/06\/7-8.png?resize=770%2C226&amp;ssl=1 770w\" sizes=\"(max-width: 980px) 100vw, 980px\" \/><br \/>\n<\/a><\/p>\n<p>5.\u00a0\u00a0\u00a0\u00a0 Click on Select Files and upload the file from your PC or Drag and Drop the file into the dotted Import box.<\/p>\n<p><a href=\"\/wp-content\/uploads\/sites\/30\/2018\/06\/8-6.png\"><img data-attachment-id=\"584\" data-permalink=\"https:\/\/sites.reading.ac.uk\/tel-support\/2018\/06\/28\/turnitin-create-and-import-a-qualitative-rubric-using-excel\/8-7\/\" data-orig-file=\"https:\/\/i0.wp.com\/sites.reading.ac.uk\/tel-support\/wp-content\/uploads\/sites\/30\/2018\/06\/8-6.png?fit=1116%2C502&amp;ssl=1\" data-orig-size=\"1116,502\" data-comments-opened=\"1\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"8\" data-image-description=\"\" data-image-caption=\"\" data-medium-file=\"https:\/\/i0.wp.com\/sites.reading.ac.uk\/tel-support\/wp-content\/uploads\/sites\/30\/2018\/06\/8-6.png?fit=1116%2C502&amp;ssl=1\" data-large-file=\"https:\/\/i0.wp.com\/sites.reading.ac.uk\/tel-support\/wp-content\/uploads\/sites\/30\/2018\/06\/8-6.png?fit=980%2C441&amp;ssl=1\" decoding=\"async\" loading=\"lazy\" class=\"alignnone size-full wp-image-584\" src=\"\/wp-content\/uploads\/sites\/30\/2018\/06\/8-6.png\" alt=\"image showing the &quot;select files&quot; option highlighted\" width=\"1116\" height=\"502\" srcset=\"https:\/\/i0.wp.com\/sites.reading.ac.uk\/tel-support\/wp-content\/uploads\/sites\/30\/2018\/06\/8-6.png?w=1116&amp;ssl=1 1116w, https:\/\/i0.wp.com\/sites.reading.ac.uk\/tel-support\/wp-content\/uploads\/sites\/30\/2018\/06\/8-6.png?resize=768%2C345&amp;ssl=1 768w, https:\/\/i0.wp.com\/sites.reading.ac.uk\/tel-support\/wp-content\/uploads\/sites\/30\/2018\/06\/8-6.png?resize=150%2C67&amp;ssl=1 150w, https:\/\/i0.wp.com\/sites.reading.ac.uk\/tel-support\/wp-content\/uploads\/sites\/30\/2018\/06\/8-6.png?resize=366%2C165&amp;ssl=1 366w, https:\/\/i0.wp.com\/sites.reading.ac.uk\/tel-support\/wp-content\/uploads\/sites\/30\/2018\/06\/8-6.png?resize=770%2C346&amp;ssl=1 770w\" sizes=\"(max-width: 980px) 100vw, 980px\" \/><br \/>\n<\/a><\/p>\n<p>6.\u00a0\u00a0\u00a0\u00a0 Wait for the file to upload. You will see a message to tell you that the import was successful.<\/p>\n<p><a href=\"\/wp-content\/uploads\/sites\/30\/2018\/06\/9-4.png\"><img data-attachment-id=\"585\" data-permalink=\"https:\/\/sites.reading.ac.uk\/tel-support\/2018\/06\/28\/turnitin-create-and-import-a-qualitative-rubric-using-excel\/9-5\/\" data-orig-file=\"https:\/\/i0.wp.com\/sites.reading.ac.uk\/tel-support\/wp-content\/uploads\/sites\/30\/2018\/06\/9-4.png?fit=1120%2C465&amp;ssl=1\" data-orig-size=\"1120,465\" data-comments-opened=\"1\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"9\" data-image-description=\"\" data-image-caption=\"\" data-medium-file=\"https:\/\/i0.wp.com\/sites.reading.ac.uk\/tel-support\/wp-content\/uploads\/sites\/30\/2018\/06\/9-4.png?fit=1120%2C465&amp;ssl=1\" data-large-file=\"https:\/\/i0.wp.com\/sites.reading.ac.uk\/tel-support\/wp-content\/uploads\/sites\/30\/2018\/06\/9-4.png?fit=980%2C407&amp;ssl=1\" decoding=\"async\" loading=\"lazy\" class=\"alignnone size-full wp-image-585\" src=\"\/wp-content\/uploads\/sites\/30\/2018\/06\/9-4.png\" alt=\"Image showing an &quot;Import Complete&quot; success message\" width=\"1120\" height=\"465\" srcset=\"https:\/\/i0.wp.com\/sites.reading.ac.uk\/tel-support\/wp-content\/uploads\/sites\/30\/2018\/06\/9-4.png?w=1120&amp;ssl=1 1120w, https:\/\/i0.wp.com\/sites.reading.ac.uk\/tel-support\/wp-content\/uploads\/sites\/30\/2018\/06\/9-4.png?resize=768%2C319&amp;ssl=1 768w, https:\/\/i0.wp.com\/sites.reading.ac.uk\/tel-support\/wp-content\/uploads\/sites\/30\/2018\/06\/9-4.png?resize=150%2C62&amp;ssl=1 150w, https:\/\/i0.wp.com\/sites.reading.ac.uk\/tel-support\/wp-content\/uploads\/sites\/30\/2018\/06\/9-4.png?resize=366%2C152&amp;ssl=1 366w, https:\/\/i0.wp.com\/sites.reading.ac.uk\/tel-support\/wp-content\/uploads\/sites\/30\/2018\/06\/9-4.png?resize=770%2C320&amp;ssl=1 770w\" sizes=\"(max-width: 980px) 100vw, 980px\" \/><br \/>\n<\/a><\/p>\n<p>7.\u00a0\u00a0\u00a0\u00a0 The Rubric is now available in your Turnitin Rubric Library, and can be attached to any assignment for which you are responsible.<\/p>\n<p><strong>Please note<\/strong> \u2013 it cannot be seen or used by anyone else until it is attached to an assignment.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>We have switched to a new version of Turnitin. The new version of Turnitin is being used for all assignments due 1st\u00a0August or later \u2013 including coursework resubmissions and resit exams on all Blackboard courses for 2022\/23. This article relates only to the old version of Turnitin. For Turnitin LTI assignments, send a reminder via the Blackboard Grade Centre. For help with the new version of Turnitin please see\u00a0Turnitin LTI Assignments Downloading the Excel Template Access the Turnitin Assignment Inbox by going to Course Tools &gt; Turnitin Assignments &gt; choose an assignment from the list. &nbsp; 1.\u00a0\u00a0\u00a0\u00a0 Click on the Libraries tab. 2.\u00a0\u00a0\u00a0\u00a0 Click on Rubric\/Form Manager. 3.\u00a0\u00a0\u00a0\u00a0 Click the Import\/Export button in the right-hand corner of blue menu bar. 4.\u00a0\u00a0\u00a0\u00a0 Click on Import from the menu. 5.\u00a0\u00a0\u00a0\u00a0 In the Import Rubric window, scroll down and click on Download Example Template button. &nbsp; This will download an Excel file you can edit to produce your own custom rubric for an assignment. &nbsp; Creating a rubric In Excel, enter: 1.\u00a0\u00a0\u00a0\u00a0 Headings for the assessment criteria in column A 2.\u00a0\u00a0\u00a0\u00a0 Titles for the scales in row 1 3.\u00a0\u00a0\u00a0\u00a0 Descriptive text in each cell \u00a0Don\u2019t worry about formatting\u2013 it will display in Turnitin as plain text. The Description field is optional and can be left blank. There is a 13-character limit for the criteria names, so you will have to use short headings (e.g. \u2018Analysis\u2019 rather than \u2018Analytical skills\u2019). However, you can enter a fuller description of these headings on a new line, as shown below. \u00a0 To insert a line break inside an Excel cell: &#8211; double-click the cell &#8211; click in the text where you want to insert the line break &#8211; press ALT+ENTER. When you save the Excel file, ensure the filename is no more than 30 characters long. Once you have saved the Excel file, you can import it into your Turnitin Rubric Library, ready to be attached to an assignment. &nbsp; Import a rubric 1.\u00a0\u00a0\u00a0\u00a0 Click on the Libraries tab. 2.\u00a0\u00a0\u00a0\u00a0 Click on Rubric\/Form Manager. 3.\u00a0\u00a0\u00a0\u00a0 Click the Import\/Export button in the right-hand corner of blue menu bar. 4.\u00a0\u00a0\u00a0\u00a0 Click on Import from the menu. 5.\u00a0\u00a0\u00a0\u00a0 Click on Select Files and upload the file from your PC or Drag and Drop the file into the dotted Import box. 6.\u00a0\u00a0\u00a0\u00a0 Wait for the file to upload. You will see a message to tell you that the import was successful. 7.\u00a0\u00a0\u00a0\u00a0 The Rubric is now available in your Turnitin Rubric Library, and can be attached to any assignment for which you are responsible. Please note \u2013 it cannot be seen or used by anyone else until it is attached to an assignment.<\/p>\n","protected":false},"author":57,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"image","meta":{"om_disable_all_campaigns":false,"_lmt_disableupdate":"","_lmt_disable":"","_exactmetrics_skip_tracking":false,"_exactmetrics_sitenote_active":false,"_exactmetrics_sitenote_note":"","_exactmetrics_sitenote_category":0,"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_newsletter_tier_id":0,"jetpack_publicize_message":"","jetpack_is_tweetstorm":false,"jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","enabled":false}},"_links_to":"","_links_to_target":""},"categories":[228,232,251],"tags":[101,60,59,100],"jetpack_publicize_connections":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.8.1 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Turnitin: Create and Import a qualitative rubric using Excel - Blackboard Help for Staff - University of Reading<\/title>\n<meta name=\"robots\" content=\"noindex, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<meta property=\"og:locale\" content=\"en_GB\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Turnitin: Create and Import a qualitative rubric using Excel - Blackboard Help for Staff - University of Reading\" \/>\n<meta property=\"og:description\" content=\"We have switched to a new version of Turnitin. The new version of Turnitin is being used for all assignments due 1st\u00a0August or later \u2013 including coursework resubmissions and resit exams on all Blackboard courses for 2022\/23. This article relates only to the old version of Turnitin. For Turnitin LTI assignments, send a reminder via the Blackboard Grade Centre. For help with the new version of Turnitin please see\u00a0Turnitin LTI Assignments Downloading the Excel Template Access the Turnitin Assignment Inbox by going to Course Tools &gt; Turnitin Assignments &gt; choose an assignment from the list. &nbsp; 1.\u00a0\u00a0\u00a0\u00a0 Click on the Libraries tab. 2.\u00a0\u00a0\u00a0\u00a0 Click on Rubric\/Form Manager. 3.\u00a0\u00a0\u00a0\u00a0 Click the Import\/Export button in the right-hand corner of blue menu bar. 4.\u00a0\u00a0\u00a0\u00a0 Click on Import from the menu. 5.\u00a0\u00a0\u00a0\u00a0 In the Import Rubric window, scroll down and click on Download Example Template button. &nbsp; This will download an Excel file you can edit to produce your own custom rubric for an assignment. &nbsp; Creating a rubric In Excel, enter: 1.\u00a0\u00a0\u00a0\u00a0 Headings for the assessment criteria in column A 2.\u00a0\u00a0\u00a0\u00a0 Titles for the scales in row 1 3.\u00a0\u00a0\u00a0\u00a0 Descriptive text in each cell \u00a0Don\u2019t worry about formatting\u2013 it will display in Turnitin as plain text. The Description field is optional and can be left blank. There is a 13-character limit for the criteria names, so you will have to use short headings (e.g. \u2018Analysis\u2019 rather than \u2018Analytical skills\u2019). However, you can enter a fuller description of these headings on a new line, as shown below. \u00a0 To insert a line break inside an Excel cell: - double-click the cell - click in the text where you want to insert the line break - press ALT+ENTER. When you save the Excel file, ensure the filename is no more than 30 characters long. Once you have saved the Excel file, you can import it into your Turnitin Rubric Library, ready to be attached to an assignment. &nbsp; Import a rubric 1.\u00a0\u00a0\u00a0\u00a0 Click on the Libraries tab. 2.\u00a0\u00a0\u00a0\u00a0 Click on Rubric\/Form Manager. 3.\u00a0\u00a0\u00a0\u00a0 Click the Import\/Export button in the right-hand corner of blue menu bar. 4.\u00a0\u00a0\u00a0\u00a0 Click on Import from the menu. 5.\u00a0\u00a0\u00a0\u00a0 Click on Select Files and upload the file from your PC or Drag and Drop the file into the dotted Import box. 6.\u00a0\u00a0\u00a0\u00a0 Wait for the file to upload. You will see a message to tell you that the import was successful. 7.\u00a0\u00a0\u00a0\u00a0 The Rubric is now available in your Turnitin Rubric Library, and can be attached to any assignment for which you are responsible. Please note \u2013 it cannot be seen or used by anyone else until it is attached to an assignment.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/sites.reading.ac.uk\/tel-support\/2018\/06\/28\/turnitin-create-and-import-a-qualitative-rubric-using-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Blackboard Help for Staff - University of Reading\" \/>\n<meta property=\"article:published_time\" content=\"2018-06-28T14:51:55+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-02-01T22:45:06+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/sites.reading.ac.uk\/tel-support-for-students\/wp-content\/uploads\/sites\/34\/2022\/03\/tii_logo_black_50sq.jpg\" \/>\n<meta name=\"author\" content=\"Sev Raychev\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@UniRdg_TEL\" \/>\n<meta name=\"twitter:site\" content=\"@UniRdg_TEL\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Sev Raychev\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimated reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/sites.reading.ac.uk\/tel-support\/2018\/06\/28\/turnitin-create-and-import-a-qualitative-rubric-using-excel\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/sites.reading.ac.uk\/tel-support\/2018\/06\/28\/turnitin-create-and-import-a-qualitative-rubric-using-excel\/\"},\"author\":{\"name\":\"Sev Raychev\",\"@id\":\"https:\/\/sites.reading.ac.uk\/tel-support\/#\/schema\/person\/640d7afe549491adc1dee885a5869d46\"},\"headline\":\"Turnitin: Create and Import a qualitative rubric using Excel\",\"datePublished\":\"2018-06-28T14:51:55+00:00\",\"dateModified\":\"2023-02-01T22:45:06+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/sites.reading.ac.uk\/tel-support\/2018\/06\/28\/turnitin-create-and-import-a-qualitative-rubric-using-excel\/\"},\"wordCount\":307,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/sites.reading.ac.uk\/tel-support\/#organization\"},\"keywords\":[\"excel\",\"Export\",\"Import\",\"Share\"],\"articleSection\":[\"Assessment &amp; Feedback\",\"Rubrics \/ Assessment Criteria\",\"Turnitin\"],\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/sites.reading.ac.uk\/tel-support\/2018\/06\/28\/turnitin-create-and-import-a-qualitative-rubric-using-excel\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/sites.reading.ac.uk\/tel-support\/2018\/06\/28\/turnitin-create-and-import-a-qualitative-rubric-using-excel\/\",\"url\":\"https:\/\/sites.reading.ac.uk\/tel-support\/2018\/06\/28\/turnitin-create-and-import-a-qualitative-rubric-using-excel\/\",\"name\":\"Turnitin: Create and Import a qualitative rubric using Excel - Blackboard Help for Staff - University of Reading\",\"isPartOf\":{\"@id\":\"https:\/\/sites.reading.ac.uk\/tel-support\/#website\"},\"datePublished\":\"2018-06-28T14:51:55+00:00\",\"dateModified\":\"2023-02-01T22:45:06+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/sites.reading.ac.uk\/tel-support\/2018\/06\/28\/turnitin-create-and-import-a-qualitative-rubric-using-excel\/#breadcrumb\"},\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/sites.reading.ac.uk\/tel-support\/2018\/06\/28\/turnitin-create-and-import-a-qualitative-rubric-using-excel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/sites.reading.ac.uk\/tel-support\/2018\/06\/28\/turnitin-create-and-import-a-qualitative-rubric-using-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/sites.reading.ac.uk\/tel-support\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Turnitin: Create and Import a qualitative rubric using Excel\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/sites.reading.ac.uk\/tel-support\/#website\",\"url\":\"https:\/\/sites.reading.ac.uk\/tel-support\/\",\"name\":\"Blackboard Help for Staff - University of Reading\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/sites.reading.ac.uk\/tel-support\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/sites.reading.ac.uk\/tel-support\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-GB\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/sites.reading.ac.uk\/tel-support\/#organization\",\"name\":\"University of Reading\",\"url\":\"https:\/\/sites.reading.ac.uk\/tel-support\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/sites.reading.ac.uk\/tel-support\/#\/schema\/logo\/image\/\",\"url\":\"\/wp-content\/uploads\/sites\/30\/2018\/10\/rdg.jpg\",\"contentUrl\":\"\/wp-content\/uploads\/sites\/30\/2018\/10\/rdg.jpg\",\"width\":317,\"height\":317,\"caption\":\"University of Reading\"},\"image\":{\"@id\":\"https:\/\/sites.reading.ac.uk\/tel-support\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/twitter.com\/UniRdg_TEL\",\"https:\/\/www.youtube.com\/channel\/UCem8bKo2tjqIZnyGA4aNizw\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/sites.reading.ac.uk\/tel-support\/#\/schema\/person\/640d7afe549491adc1dee885a5869d46\",\"name\":\"Sev Raychev\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/sites.reading.ac.uk\/tel-support\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/d291c30fbc4ff89a61d36261c3764100?s=96&d=retro&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/d291c30fbc4ff89a61d36261c3764100?s=96&d=retro&r=g\",\"caption\":\"Sev Raychev\"},\"url\":\"https:\/\/sites.reading.ac.uk\/tel-support\/author\/tel\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Turnitin: Create and Import a qualitative rubric using Excel - Blackboard Help for Staff - University of Reading","robots":{"index":"noindex","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"og_locale":"en_GB","og_type":"article","og_title":"Turnitin: Create and Import a qualitative rubric using Excel - Blackboard Help for Staff - University of Reading","og_description":"We have switched to a new version of Turnitin. The new version of Turnitin is being used for all assignments due 1st\u00a0August or later \u2013 including coursework resubmissions and resit exams on all Blackboard courses for 2022\/23. This article relates only to the old version of Turnitin. For Turnitin LTI assignments, send a reminder via the Blackboard Grade Centre. For help with the new version of Turnitin please see\u00a0Turnitin LTI Assignments Downloading the Excel Template Access the Turnitin Assignment Inbox by going to Course Tools &gt; Turnitin Assignments &gt; choose an assignment from the list. &nbsp; 1.\u00a0\u00a0\u00a0\u00a0 Click on the Libraries tab. 2.\u00a0\u00a0\u00a0\u00a0 Click on Rubric\/Form Manager. 3.\u00a0\u00a0\u00a0\u00a0 Click the Import\/Export button in the right-hand corner of blue menu bar. 4.\u00a0\u00a0\u00a0\u00a0 Click on Import from the menu. 5.\u00a0\u00a0\u00a0\u00a0 In the Import Rubric window, scroll down and click on Download Example Template button. &nbsp; This will download an Excel file you can edit to produce your own custom rubric for an assignment. &nbsp; Creating a rubric In Excel, enter: 1.\u00a0\u00a0\u00a0\u00a0 Headings for the assessment criteria in column A 2.\u00a0\u00a0\u00a0\u00a0 Titles for the scales in row 1 3.\u00a0\u00a0\u00a0\u00a0 Descriptive text in each cell \u00a0Don\u2019t worry about formatting\u2013 it will display in Turnitin as plain text. The Description field is optional and can be left blank. There is a 13-character limit for the criteria names, so you will have to use short headings (e.g. \u2018Analysis\u2019 rather than \u2018Analytical skills\u2019). However, you can enter a fuller description of these headings on a new line, as shown below. \u00a0 To insert a line break inside an Excel cell: - double-click the cell - click in the text where you want to insert the line break - press ALT+ENTER. When you save the Excel file, ensure the filename is no more than 30 characters long. Once you have saved the Excel file, you can import it into your Turnitin Rubric Library, ready to be attached to an assignment. &nbsp; Import a rubric 1.\u00a0\u00a0\u00a0\u00a0 Click on the Libraries tab. 2.\u00a0\u00a0\u00a0\u00a0 Click on Rubric\/Form Manager. 3.\u00a0\u00a0\u00a0\u00a0 Click the Import\/Export button in the right-hand corner of blue menu bar. 4.\u00a0\u00a0\u00a0\u00a0 Click on Import from the menu. 5.\u00a0\u00a0\u00a0\u00a0 Click on Select Files and upload the file from your PC or Drag and Drop the file into the dotted Import box. 6.\u00a0\u00a0\u00a0\u00a0 Wait for the file to upload. You will see a message to tell you that the import was successful. 7.\u00a0\u00a0\u00a0\u00a0 The Rubric is now available in your Turnitin Rubric Library, and can be attached to any assignment for which you are responsible. Please note \u2013 it cannot be seen or used by anyone else until it is attached to an assignment.","og_url":"https:\/\/sites.reading.ac.uk\/tel-support\/2018\/06\/28\/turnitin-create-and-import-a-qualitative-rubric-using-excel\/","og_site_name":"Blackboard Help for Staff - University of Reading","article_published_time":"2018-06-28T14:51:55+00:00","article_modified_time":"2023-02-01T22:45:06+00:00","og_image":[{"url":"https:\/\/sites.reading.ac.uk\/tel-support-for-students\/wp-content\/uploads\/sites\/34\/2022\/03\/tii_logo_black_50sq.jpg"}],"author":"Sev Raychev","twitter_card":"summary_large_image","twitter_creator":"@UniRdg_TEL","twitter_site":"@UniRdg_TEL","twitter_misc":{"Written by":"Sev Raychev","Estimated reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/sites.reading.ac.uk\/tel-support\/2018\/06\/28\/turnitin-create-and-import-a-qualitative-rubric-using-excel\/#article","isPartOf":{"@id":"https:\/\/sites.reading.ac.uk\/tel-support\/2018\/06\/28\/turnitin-create-and-import-a-qualitative-rubric-using-excel\/"},"author":{"name":"Sev Raychev","@id":"https:\/\/sites.reading.ac.uk\/tel-support\/#\/schema\/person\/640d7afe549491adc1dee885a5869d46"},"headline":"Turnitin: Create and Import a qualitative rubric using Excel","datePublished":"2018-06-28T14:51:55+00:00","dateModified":"2023-02-01T22:45:06+00:00","mainEntityOfPage":{"@id":"https:\/\/sites.reading.ac.uk\/tel-support\/2018\/06\/28\/turnitin-create-and-import-a-qualitative-rubric-using-excel\/"},"wordCount":307,"commentCount":0,"publisher":{"@id":"https:\/\/sites.reading.ac.uk\/tel-support\/#organization"},"keywords":["excel","Export","Import","Share"],"articleSection":["Assessment &amp; Feedback","Rubrics \/ Assessment Criteria","Turnitin"],"inLanguage":"en-GB","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/sites.reading.ac.uk\/tel-support\/2018\/06\/28\/turnitin-create-and-import-a-qualitative-rubric-using-excel\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/sites.reading.ac.uk\/tel-support\/2018\/06\/28\/turnitin-create-and-import-a-qualitative-rubric-using-excel\/","url":"https:\/\/sites.reading.ac.uk\/tel-support\/2018\/06\/28\/turnitin-create-and-import-a-qualitative-rubric-using-excel\/","name":"Turnitin: Create and Import a qualitative rubric using Excel - Blackboard Help for Staff - University of Reading","isPartOf":{"@id":"https:\/\/sites.reading.ac.uk\/tel-support\/#website"},"datePublished":"2018-06-28T14:51:55+00:00","dateModified":"2023-02-01T22:45:06+00:00","breadcrumb":{"@id":"https:\/\/sites.reading.ac.uk\/tel-support\/2018\/06\/28\/turnitin-create-and-import-a-qualitative-rubric-using-excel\/#breadcrumb"},"inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/sites.reading.ac.uk\/tel-support\/2018\/06\/28\/turnitin-create-and-import-a-qualitative-rubric-using-excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/sites.reading.ac.uk\/tel-support\/2018\/06\/28\/turnitin-create-and-import-a-qualitative-rubric-using-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/sites.reading.ac.uk\/tel-support\/"},{"@type":"ListItem","position":2,"name":"Turnitin: Create and Import a qualitative rubric using Excel"}]},{"@type":"WebSite","@id":"https:\/\/sites.reading.ac.uk\/tel-support\/#website","url":"https:\/\/sites.reading.ac.uk\/tel-support\/","name":"Blackboard Help for Staff - University of Reading","description":"","publisher":{"@id":"https:\/\/sites.reading.ac.uk\/tel-support\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/sites.reading.ac.uk\/tel-support\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-GB"},{"@type":"Organization","@id":"https:\/\/sites.reading.ac.uk\/tel-support\/#organization","name":"University of Reading","url":"https:\/\/sites.reading.ac.uk\/tel-support\/","logo":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/sites.reading.ac.uk\/tel-support\/#\/schema\/logo\/image\/","url":"\/wp-content\/uploads\/sites\/30\/2018\/10\/rdg.jpg","contentUrl":"\/wp-content\/uploads\/sites\/30\/2018\/10\/rdg.jpg","width":317,"height":317,"caption":"University of Reading"},"image":{"@id":"https:\/\/sites.reading.ac.uk\/tel-support\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/twitter.com\/UniRdg_TEL","https:\/\/www.youtube.com\/channel\/UCem8bKo2tjqIZnyGA4aNizw"]},{"@type":"Person","@id":"https:\/\/sites.reading.ac.uk\/tel-support\/#\/schema\/person\/640d7afe549491adc1dee885a5869d46","name":"Sev Raychev","image":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/sites.reading.ac.uk\/tel-support\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/d291c30fbc4ff89a61d36261c3764100?s=96&d=retro&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/d291c30fbc4ff89a61d36261c3764100?s=96&d=retro&r=g","caption":"Sev Raychev"},"url":"https:\/\/sites.reading.ac.uk\/tel-support\/author\/tel\/"}]}},"modified_by":"taralehane","jetpack_sharing_enabled":true,"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/p9WwLV-9i","_links":{"self":[{"href":"https:\/\/sites.reading.ac.uk\/tel-support\/wp-json\/wp\/v2\/posts\/576"}],"collection":[{"href":"https:\/\/sites.reading.ac.uk\/tel-support\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sites.reading.ac.uk\/tel-support\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sites.reading.ac.uk\/tel-support\/wp-json\/wp\/v2\/users\/57"}],"replies":[{"embeddable":true,"href":"https:\/\/sites.reading.ac.uk\/tel-support\/wp-json\/wp\/v2\/comments?post=576"}],"version-history":[{"count":1,"href":"https:\/\/sites.reading.ac.uk\/tel-support\/wp-json\/wp\/v2\/posts\/576\/revisions"}],"predecessor-version":[{"id":14667,"href":"https:\/\/sites.reading.ac.uk\/tel-support\/wp-json\/wp\/v2\/posts\/576\/revisions\/14667"}],"wp:attachment":[{"href":"https:\/\/sites.reading.ac.uk\/tel-support\/wp-json\/wp\/v2\/media?parent=576"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sites.reading.ac.uk\/tel-support\/wp-json\/wp\/v2\/categories?post=576"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sites.reading.ac.uk\/tel-support\/wp-json\/wp\/v2\/tags?post=576"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}