{"id":12997,"date":"2021-10-21T14:13:21","date_gmt":"2021-10-21T14:13:21","guid":{"rendered":"https:\/\/microsites.bournemouth.ac.uk\/flie\/?p=12997"},"modified":"2021-10-27T16:14:10","modified_gmt":"2021-10-27T16:14:10","slug":"marking-excel-and-html-files-in-turnitin","status":"publish","type":"post","link":"https:\/\/microsites.bournemouth.ac.uk\/flie\/2021\/10\/21\/marking-excel-and-html-files-in-turnitin\/","title":{"rendered":"Marking Excel and HTML files in Turnitin"},"content":{"rendered":"<p>During the 20\/21 academic year, we saw an increase in different file types being submitted to Turnitin, specifically Excel and HTML files. Although these file types are accepted by Turnitin, the marking experience isn\u2019t always straightforward. When Turnitin states it can accept a certain file type, what this means is that it can process the file for similarity checking; it doesn\u2019t mean it can display the file within Turnitin using the file type\u2019s native software.<\/p>\n<p>This blog explains how Turnitin deals with these file types and has some tips on what you can do to improve the process.<\/p>\n<h2>How does Turnitin deal with Excel files?<\/h2>\n<p>Every file type Turnitin can accept will always be converted to a pdf and displayed using the page size and orientation the original file was saved as. Excel\u2019s default page size and orientation is A4 portrait.<\/p>\n<p>When an Excel file has a large amount of data, Turnitin receives the file and converts it to a pdf. Any columns that exceed the normal width of an A4 portrait page will be displayed on page 2.<\/p>\n<div id=\"attachment_13000\" style=\"width: 364px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/microsites.bournemouth.ac.uk\/flie\/files\/2021\/10\/01.jpg\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-13000\" class=\" wp-image-13000\" src=\"https:\/\/microsites.bournemouth.ac.uk\/flie\/files\/2021\/10\/01-300x150.jpg\" alt=\"Excel document displaying as A4 portrait in Turnitin\" width=\"354\" height=\"177\" srcset=\"https:\/\/microsites.bournemouth.ac.uk\/flie\/files\/2021\/10\/01-300x150.jpg 300w, https:\/\/microsites.bournemouth.ac.uk\/flie\/files\/2021\/10\/01-1024x510.jpg 1024w, https:\/\/microsites.bournemouth.ac.uk\/flie\/files\/2021\/10\/01-768x383.jpg 768w, https:\/\/microsites.bournemouth.ac.uk\/flie\/files\/2021\/10\/01.jpg 1266w\" sizes=\"auto, (max-width: 354px) 100vw, 354px\" \/><\/a><p id=\"caption-attachment-13000\" class=\"wp-caption-text\">Excel document displaying as A4 portrait in Turnitin<\/p><\/div>\n<p>For large data sets, we would recommend you ask students to save the original file as A3 Landscape. This isn\u2019t a perfect solution as any columns that exceed the width of an A3 landscape page will still be displayed on the second page but it does make reading larger data sets easier.<\/p>\n<div id=\"attachment_13001\" style=\"width: 378px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/microsites.bournemouth.ac.uk\/flie\/files\/2021\/10\/02.jpg\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-13001\" class=\" wp-image-13001\" src=\"https:\/\/microsites.bournemouth.ac.uk\/flie\/files\/2021\/10\/02-300x132.jpg\" alt=\"Excel document displaying as A3 landscape in Turnitin\" width=\"368\" height=\"162\" srcset=\"https:\/\/microsites.bournemouth.ac.uk\/flie\/files\/2021\/10\/02-300x132.jpg 300w, https:\/\/microsites.bournemouth.ac.uk\/flie\/files\/2021\/10\/02-1024x451.jpg 1024w, https:\/\/microsites.bournemouth.ac.uk\/flie\/files\/2021\/10\/02-768x339.jpg 768w, https:\/\/microsites.bournemouth.ac.uk\/flie\/files\/2021\/10\/02.jpg 1266w\" sizes=\"auto, (max-width: 368px) 100vw, 368px\" \/><\/a><p id=\"caption-attachment-13001\" class=\"wp-caption-text\">Excel document displaying as A3 landscape in Turnitin<\/p><\/div>\n<p>Alternatively, you could use Turnitin to accept the file simply for the similarity score, then download the file to open in Excel. This will be necessary if you are marking the use of formulas as formulas won\u2019t be shown in Turnitin, only the raw data. Feedback and grades can then be added back into Turnitin once marking is complete.<\/p>\n<h2>How does Turnitin deal with HTML files?<\/h2>\n<p>Although Turnitin doesn\u2019t have a dedicated system for checking code for similarity, it will accept HTML files. For these types of files, Turnitin will convert them to PDF and create a similarity report based on the content the HTML code creates.<\/p>\n<div id=\"attachment_13002\" style=\"width: 378px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/microsites.bournemouth.ac.uk\/flie\/files\/2021\/10\/03.jpg\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-13002\" class=\" wp-image-13002\" src=\"https:\/\/microsites.bournemouth.ac.uk\/flie\/files\/2021\/10\/03-300x172.jpg\" alt=\"Example of an HTML file\" width=\"368\" height=\"211\" srcset=\"https:\/\/microsites.bournemouth.ac.uk\/flie\/files\/2021\/10\/03-300x172.jpg 300w, https:\/\/microsites.bournemouth.ac.uk\/flie\/files\/2021\/10\/03-768x440.jpg 768w, https:\/\/microsites.bournemouth.ac.uk\/flie\/files\/2021\/10\/03.jpg 888w\" sizes=\"auto, (max-width: 368px) 100vw, 368px\" \/><\/a><p id=\"caption-attachment-13002\" class=\"wp-caption-text\">Excel document displaying as A3 landscape in Turnitin<\/p><\/div>\n<p>&nbsp;<\/p>\n<div id=\"attachment_13003\" style=\"width: 366px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/microsites.bournemouth.ac.uk\/flie\/files\/2021\/10\/04.jpg\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-13003\" class=\" wp-image-13003\" src=\"https:\/\/microsites.bournemouth.ac.uk\/flie\/files\/2021\/10\/04-300x80.jpg\" alt=\"HTML file converted to PDF in Turnitin\" width=\"356\" height=\"95\" srcset=\"https:\/\/microsites.bournemouth.ac.uk\/flie\/files\/2021\/10\/04-300x80.jpg 300w, https:\/\/microsites.bournemouth.ac.uk\/flie\/files\/2021\/10\/04-1024x274.jpg 1024w, https:\/\/microsites.bournemouth.ac.uk\/flie\/files\/2021\/10\/04-768x206.jpg 768w, https:\/\/microsites.bournemouth.ac.uk\/flie\/files\/2021\/10\/04.jpg 1266w\" sizes=\"auto, (max-width: 356px) 100vw, 356px\" \/><\/a><p id=\"caption-attachment-13003\" class=\"wp-caption-text\">HTML file converted to PDF in Turnitin<\/p><\/div>\n<p>This is fine if you are marking based on the content the HTML code creates.<\/p>\n<p>But if you are marking your students based on the raw code you will have to download the submitted file and open it in an HTML editor. Feedback and grades can then be added back into Turnitin once marking is complete.<\/p>\n<h2>Where do I go for help?<\/h2>\n<p>If you are thinking of using one of these file types as a submission for your unit, please get in touch with your <a href=\"https:\/\/brightspace.bournemouth.ac.uk\/d2l\/le\/content\/18315\/viewContent\/153692\/View\" target=\"_blank\" rel=\"noopener\">Faculty Learning Technologist<\/a> to discuss your requirements. This will help avoid any problems that you may have with these file types when it comes to marking.<\/p>\n<h2>Further help and guidance<\/h2>\n<p>You can find online guidance under the Assessment and Feedback area of the Brightspace Staff Resources Area:\u00a0<a href=\"https:\/\/brightspace.bournemouth.ac.uk\/d2l\/le\/content\/18315\/viewContent\/1068037\/View\" target=\"_blank\" rel=\"noopener\">Marking with Turnitin<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>During the 20\/21 academic year, we saw an increase in different file types being submitted to Turnitin, specifically Excel and HTML files. Although these file types are accepted by Turnitin, the marking experience isn\u2019t always straightforward. When Turnitin states it can accept a certain file type, what this means is that it can process the&#8230;  <a class=\"excerpt-read-more\" href=\"https:\/\/microsites.bournemouth.ac.uk\/flie\/2021\/10\/21\/marking-excel-and-html-files-in-turnitin\/\">Read more &raquo;<span class=\"sr-only\"> about Marking Excel and HTML files in Turnitin<\/span><\/a><\/p>\n","protected":false},"author":1492,"featured_media":12362,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[260,163,5,704],"tags":[],"class_list":["post-12997","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-assessment-and-feedback","category-digital-skills","category-news","category-teaching-and-learning"],"acf":[],"_links":{"self":[{"href":"https:\/\/microsites.bournemouth.ac.uk\/flie\/wp-json\/wp\/v2\/posts\/12997","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/microsites.bournemouth.ac.uk\/flie\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/microsites.bournemouth.ac.uk\/flie\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/microsites.bournemouth.ac.uk\/flie\/wp-json\/wp\/v2\/users\/1492"}],"replies":[{"embeddable":true,"href":"https:\/\/microsites.bournemouth.ac.uk\/flie\/wp-json\/wp\/v2\/comments?post=12997"}],"version-history":[{"count":14,"href":"https:\/\/microsites.bournemouth.ac.uk\/flie\/wp-json\/wp\/v2\/posts\/12997\/revisions"}],"predecessor-version":[{"id":13079,"href":"https:\/\/microsites.bournemouth.ac.uk\/flie\/wp-json\/wp\/v2\/posts\/12997\/revisions\/13079"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/microsites.bournemouth.ac.uk\/flie\/wp-json\/wp\/v2\/media\/12362"}],"wp:attachment":[{"href":"https:\/\/microsites.bournemouth.ac.uk\/flie\/wp-json\/wp\/v2\/media?parent=12997"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/microsites.bournemouth.ac.uk\/flie\/wp-json\/wp\/v2\/categories?post=12997"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/microsites.bournemouth.ac.uk\/flie\/wp-json\/wp\/v2\/tags?post=12997"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}