{"id":1526,"date":"2018-07-27T09:15:41","date_gmt":"2018-07-27T09:15:41","guid":{"rendered":"http:\/\/sites.reading.ac.uk\/tel-support\/?p=1526"},"modified":"2023-09-01T09:11:01","modified_gmt":"2023-09-01T09:11:01","slug":"blackboard-downloading-blackboard-test-results","status":"publish","type":"post","link":"https:\/\/sites.reading.ac.uk\/tel-support\/2018\/07\/27\/blackboard-downloading-blackboard-test-results\/","title":{"rendered":"Blackboard Tests: Downloading test results"},"content":{"rendered":"
\"Important\r\nThis guide assumes that you have already set up a Blackboard test, students have submitted answers, and now you need to export them for analysis or record-keeping purposes.\r\n<\/pre>\n
Downloading overall test scores<\/h2>\n
This will download the Test scores for each student, but without any indication of which questions were answered correctly.<\/p>\n
Go to Control Panel > Grade Centre > Full Grade Centre<\/strong> \u00a0then Work Offline > Download<\/strong><\/p>\n
\"View<\/p>\n
On the Download Grades screen, under Selected Column<\/strong> choose the test for which you wish to export the results.<\/p>\n
\"Download<\/p>\n
Then choose the format required (you can accept the default of Tab-delimited, but Comma-delimited may be better as it opens directly in Excel).<\/p>\n
To save the file to your PC, leave the Download Location as \u2018My Computer\u2019<\/strong> and press Submit<\/strong>.<\/p>\n
On the next screen just click DOWNLOAD<\/strong> to download the file.<\/p>\n
\"Download<\/p>\n
The file should open directly in Excel.<\/p>\n
If you get this warning message in Excel, just click on Yes<\/strong> and the file should open.<\/p>\n
\"Excel<\/p>\n
You can then order the columns as desired \u2013 e.g. by student number, name, or highest to lowest score.<\/p>\n
\"View<\/p>\n
 <\/p>\n
Downloading scores per question<\/h2>\n
If you wish, you can download a complete breakdown of marks per question, for each user.<\/p>\n
Go to Control Panel > Grade Centre > Full Grade Centre\u00a0<\/strong> (or Tests<\/strong>), locate the Test for which you wish to download results and click on the editing arrow at the top of the column. Select Download Results<\/strong>.<\/p>\n
\"Column<\/p>\n
On the Download Results screen,\u00a0 choose the desired file format and then the way the results should be formatted.<\/p>\n
\"Download<\/p>\n
The on-screen help text states:<\/p>\n
\u201cThe format listed By User will include all of the questions for a user in one row.
\nThe format listed By Question and User will list each question for each user in a separate row\u201d.<\/p>\n
Examples are shown below:<\/p>\n
By User<\/h3>\n
\"View<\/p>\n
\u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Each user is shown on a new row.<\/p>\n
\u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 There are separate columns for each question, showing the question text, answer submitted by this student, points possible, points awarded.<\/p>\n
By Question and User<\/h3>\n
\"view<\/p>\n
\u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 There is a separate row for each student\u2019s response (or lack of response) to each question
\ni.e. if your Test contains five questions, the spreadsheet will contain five rows per student.<\/p>\n
\u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Separate columns show the question text, submitted answer, points possible, points awarded.<\/p>\n
\u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Initially the worksheet is arranged by username, but you could also sort it by question.<\/p>\n
 <\/p>\n
\"Important\r\n\u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Files downloaded from the Download Results screen are named \u2018download\u2019, and lack a file extension. Before you can open the file, you will need to edit its filename \u2013 simply add .xls to the end of the filename.\r\n\r\n\u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 In some cases the question and\/or answer text will be obscured by several lines of html code. This is almost certainly because the text was copied and pasted from MS Word.\r\n\r\n\"Showing\r\nYou can use Find and Replace to strip away this code in the downloaded Excel sheet.\r\n\r\nTo avoid the problem recurring in future, it would be worth editing the Test questions in Blackboard to remove the unnecessary formatting \u2013 there is a \u2018Remove Formatting\u2019 tool on the editing toolbar.\r\n\r\n\"Remove\r\n<\/pre>\n
 <\/p>\n
Analysing the questions in a Test<\/h2>\n
You can obtain a breakdown of responses to each question, and use this information to identify questions which are not effective, and which may need to be edited before the test is used again.<\/p>\n
Go to Control Panel > Grade Centre > Full Grade Centre<\/strong>\u00a0 (or Tests<\/strong>), locate the Test for which you wish to download results and click on the editing arrow at the top of the column. Select Item Analysis<\/strong>.<\/p>\n
On the Item Analysis screen, press Run<\/strong>.<\/p>\n
\"Item<\/p>\n
When the Analysis is ready to be viewed, you will be able to access it from the same screen.<\/p>\n
\"Success<\/p>\n
A range of information is shown, enabling you to evaluate the effectiveness of each question in the Test.<\/p>\n
\"Analysis<\/p>\n
 <\/p>\n
If you’d like more on Item Analysis see the Blackboard Help site at https:\/\/en-us.help.blackboard.com\/Learn\/9.1_2014_04\/Instructor\/110_Tests_Surveys_Pools\/140_Item_Analysis<\/a><\/p>\n
 <\/p>\n
 <\/p>\n","protected":false},"excerpt":{"rendered":"
This guide assumes that you have already set up a Blackboard test, students have submitted answers, and now you need to export them for analysis or record-keeping purposes. Downloading overall test scores This will download the Test scores for each student, but without any indication of which questions were answered correctly. Go to Control Panel > Grade Centre > Full Grade Centre \u00a0then Work Offline > Download On the Download Grades screen, under Selected Column choose the test for which you wish to export the results. Then choose the format required (you can accept the default of Tab-delimited, but Comma-delimited may be better as it opens directly in Excel). To save the file to your PC, leave the Download Location as \u2018My Computer\u2019 and press Submit. On the next screen just click DOWNLOAD to download the file. The file should open directly in Excel. If you get this warning message in Excel, just click on Yes and the file should open. You can then order the columns as desired \u2013 e.g. by student number, name, or highest to lowest score.   Downloading scores per question If you wish, you can download a complete breakdown of marks per question, for each user. Go to Control Panel > Grade Centre > Full Grade Centre\u00a0 (or Tests), locate the Test for which you wish to download results and click on the editing arrow at the top of the column. Select Download Results. On the Download Results screen,\u00a0 choose the desired file format and then the way the results should be formatted. The on-screen help text states: \u201cThe format listed By User will include all of the questions for a user in one row. The format listed By Question and User will list each question for each user in a separate row\u201d. Examples are shown below: By User \u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Each user is shown on a new row. \u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 There are separate columns for each question, showing the question text, answer submitted by this student, points possible, points awarded. By Question and User \u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 There is a separate row for each student\u2019s response (or lack of response) to each question i.e. if your Test contains five questions, the spreadsheet will contain five rows per student. \u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Separate columns show the question text, submitted answer, points possible, points awarded. \u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Initially the worksheet is arranged by username, but you could also sort it by question.   \u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Files downloaded from the Download Results screen are named \u2018download\u2019, and lack a file extension. Before you can open the file, you will need to edit its filename \u2013 simply add .xls to the end of the filename. \u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 In some cases the question and\/or answer text will be obscured by several lines of html code. This is almost certainly because the text was copied and pasted from MS Word. You can use Find and Replace to strip away this code in the downloaded Excel sheet. To avoid the problem recurring in future, it would be worth editing the Test questions in Blackboard to remove the unnecessary formatting \u2013 there is a \u2018Remove Formatting\u2019 tool on the editing toolbar.   Analysing the questions in a Test You can obtain a breakdown of responses to each question, and use this information to identify questions which are not effective, and which may need to be edited before the test is used again. Go to Control Panel > Grade Centre > Full Grade Centre\u00a0 (or Tests), locate the Test for which you wish to download results and click on the editing arrow at the top of the column. Select Item Analysis. On the Item Analysis screen, press Run. When the Analysis is ready to be viewed, you will be able to access it from the same screen. A range of information is shown, enabling you to evaluate the effectiveness of each question in the Test.   If you’d like more on Item Analysis see the Blackboard Help site at https:\/\/en-us.help.blackboard.com\/Learn\/9.1_2014_04\/Instructor\/110_Tests_Surveys_Pools\/140_Item_Analysis    <\/p>\n","protected":false},"author":65,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"image","meta":{"om_disable_all_campaigns":false,"_lmt_disableupdate":"no","_lmt_disable":"no","_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,234,231,245],"tags":[103,157,158],"jetpack_publicize_connections":[],"yoast_head":"\nBlackboard Tests: Downloading test results - 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=\"Blackboard Tests: Downloading test results - Blackboard Help for Staff - University of Reading\" \/>\n<meta property=\"og:description\" content=\"This guide assumes that you have already set up a Blackboard test, students have submitted answers, and now you need to export them for analysis or record-keeping purposes. Downloading overall test scores This will download the Test scores for each student, but without any indication of which questions were answered correctly. Go to Control Panel > Grade Centre > Full Grade Centre \u00a0then Work Offline > Download On the Download Grades screen, under Selected Column choose the test for which you wish to export the results. Then choose the format required (you can accept the default of Tab-delimited, but Comma-delimited may be better as it opens directly in Excel). To save the file to your PC, leave the Download Location as \u2018My Computer\u2019 and press Submit. On the next screen just click DOWNLOAD to download the file. The file should open directly in Excel. If you get this warning message in Excel, just click on Yes and the file should open. You can then order the columns as desired \u2013 e.g. by student number, name, or highest to lowest score.   Downloading scores per question If you wish, you can download a complete breakdown of marks per question, for each user. Go to Control Panel > Grade Centre > Full Grade Centre\u00a0 (or Tests), locate the Test for which you wish to download results and click on the editing arrow at the top of the column. Select Download Results. On the Download Results screen,\u00a0 choose the desired file format and then the way the results should be formatted. The on-screen help text states: \u201cThe format listed By User will include all of the questions for a user in one row. The format listed By Question and User will list each question for each user in a separate row\u201d. Examples are shown below: By User \u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Each user is shown on a new row. \u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 There are separate columns for each question, showing the question text, answer submitted by this student, points possible, points awarded. By Question and User \u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 There is a separate row for each student\u2019s response (or lack of response) to each question i.e. if your Test contains five questions, the spreadsheet will contain five rows per student. \u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Separate columns show the question text, submitted answer, points possible, points awarded. \u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Initially the worksheet is arranged by username, but you could also sort it by question.   \u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Files downloaded from the Download Results screen are named \u2018download\u2019, and lack a file extension. Before you can open the file, you will need to edit its filename \u2013 simply add .xls to the end of the filename. \u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 In some cases the question and\/or answer text will be obscured by several lines of html code. This is almost certainly because the text was copied and pasted from MS Word. You can use Find and Replace to strip away this code in the downloaded Excel sheet. To avoid the problem recurring in future, it would be worth editing the Test questions in Blackboard to remove the unnecessary formatting \u2013 there is a \u2018Remove Formatting\u2019 tool on the editing toolbar.   Analysing the questions in a Test You can obtain a breakdown of responses to each question, and use this information to identify questions which are not effective, and which may need to be edited before the test is used again. Go to Control Panel > Grade Centre > Full Grade Centre\u00a0 (or Tests), locate the Test for which you wish to download results and click on the editing arrow at the top of the column. Select Item Analysis. On the Item Analysis screen, press Run. When the Analysis is ready to be viewed, you will be able to access it from the same screen. A range of information is shown, enabling you to evaluate the effectiveness of each question in the Test.   If you’d like more on Item Analysis see the Blackboard Help site at https:\/\/en-us.help.blackboard.com\/Learn\/9.1_2014_04\/Instructor\/110_Tests_Surveys_Pools\/140_Item_Analysis    \" \/>\n<meta property=\"og:url\" content=\"https:\/\/sites.reading.ac.uk\/tel-support\/2018\/07\/27\/blackboard-downloading-blackboard-test-results\/\" \/>\n<meta property=\"og:site_name\" content=\"Blackboard Help for Staff - University of Reading\" \/>\n<meta property=\"article:published_time\" content=\"2018-07-27T09:15:41+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-09-01T09:11:01+00:00\" \/>\n<meta name=\"author\" content=\"Peter Moll\" \/>\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=\"Peter Moll\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimated reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 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\/07\/27\/blackboard-downloading-blackboard-test-results\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/sites.reading.ac.uk\/tel-support\/2018\/07\/27\/blackboard-downloading-blackboard-test-results\/\"},\"author\":{\"name\":\"Peter Moll\",\"@id\":\"https:\/\/sites.reading.ac.uk\/tel-support\/#\/schema\/person\/688607e60ed4d958eb1a4f52e7441300\"},\"headline\":\"Blackboard Tests: Downloading test results\",\"datePublished\":\"2018-07-27T09:15:41+00:00\",\"dateModified\":\"2023-09-01T09:11:01+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/sites.reading.ac.uk\/tel-support\/2018\/07\/27\/blackboard-downloading-blackboard-test-results\/\"},\"wordCount\":525,\"commentCount\":1,\"publisher\":{\"@id\":\"https:\/\/sites.reading.ac.uk\/tel-support\/#organization\"},\"keywords\":[\"Assessment\",\"Blackboard Tests\",\"Work Offline\"],\"articleSection\":[\"Assessment & Feedback\",\"Blackboard Learn\",\"Managing Assessment\",\"Tests\"],\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/sites.reading.ac.uk\/tel-support\/2018\/07\/27\/blackboard-downloading-blackboard-test-results\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/sites.reading.ac.uk\/tel-support\/2018\/07\/27\/blackboard-downloading-blackboard-test-results\/\",\"url\":\"https:\/\/sites.reading.ac.uk\/tel-support\/2018\/07\/27\/blackboard-downloading-blackboard-test-results\/\",\"name\":\"Blackboard Tests: Downloading test results - Blackboard Help for Staff - University of Reading\",\"isPartOf\":{\"@id\":\"https:\/\/sites.reading.ac.uk\/tel-support\/#website\"},\"datePublished\":\"2018-07-27T09:15:41+00:00\",\"dateModified\":\"2023-09-01T09:11:01+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/sites.reading.ac.uk\/tel-support\/2018\/07\/27\/blackboard-downloading-blackboard-test-results\/#breadcrumb\"},\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/sites.reading.ac.uk\/tel-support\/2018\/07\/27\/blackboard-downloading-blackboard-test-results\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/sites.reading.ac.uk\/tel-support\/2018\/07\/27\/blackboard-downloading-blackboard-test-results\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/sites.reading.ac.uk\/tel-support\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Blackboard Tests: Downloading test results\"}]},{\"@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\/688607e60ed4d958eb1a4f52e7441300\",\"name\":\"Peter Moll\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/sites.reading.ac.uk\/tel-support\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/9a6d5054670e8c4918a6a8baf060e7d3?s=96&d=retro&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/9a6d5054670e8c4918a6a8baf060e7d3?s=96&d=retro&r=g\",\"caption\":\"Peter Moll\"},\"url\":\"https:\/\/sites.reading.ac.uk\/tel-support\/author\/petermoll\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Blackboard Tests: Downloading test results - 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":"Blackboard Tests: Downloading test results - Blackboard Help for Staff - University of Reading","og_description":"This guide assumes that you have already set up a Blackboard test, students have submitted answers, and now you need to export them for analysis or record-keeping purposes. Downloading overall test scores This will download the Test scores for each student, but without any indication of which questions were answered correctly. Go to Control Panel > Grade Centre > Full Grade Centre \u00a0then Work Offline > Download On the Download Grades screen, under Selected Column choose the test for which you wish to export the results. Then choose the format required (you can accept the default of Tab-delimited, but Comma-delimited may be better as it opens directly in Excel). To save the file to your PC, leave the Download Location as \u2018My Computer\u2019 and press Submit. On the next screen just click DOWNLOAD to download the file. The file should open directly in Excel. If you get this warning message in Excel, just click on Yes and the file should open. You can then order the columns as desired \u2013 e.g. by student number, name, or highest to lowest score.   Downloading scores per question If you wish, you can download a complete breakdown of marks per question, for each user. Go to Control Panel > Grade Centre > Full Grade Centre\u00a0 (or Tests), locate the Test for which you wish to download results and click on the editing arrow at the top of the column. Select Download Results. On the Download Results screen,\u00a0 choose the desired file format and then the way the results should be formatted. The on-screen help text states: \u201cThe format listed By User will include all of the questions for a user in one row. The format listed By Question and User will list each question for each user in a separate row\u201d. Examples are shown below: By User \u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Each user is shown on a new row. \u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 There are separate columns for each question, showing the question text, answer submitted by this student, points possible, points awarded. By Question and User \u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 There is a separate row for each student\u2019s response (or lack of response) to each question i.e. if your Test contains five questions, the spreadsheet will contain five rows per student. \u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Separate columns show the question text, submitted answer, points possible, points awarded. \u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Initially the worksheet is arranged by username, but you could also sort it by question.   \u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Files downloaded from the Download Results screen are named \u2018download\u2019, and lack a file extension. Before you can open the file, you will need to edit its filename \u2013 simply add .xls to the end of the filename. \u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 In some cases the question and\/or answer text will be obscured by several lines of html code. This is almost certainly because the text was copied and pasted from MS Word. You can use Find and Replace to strip away this code in the downloaded Excel sheet. To avoid the problem recurring in future, it would be worth editing the Test questions in Blackboard to remove the unnecessary formatting \u2013 there is a \u2018Remove Formatting\u2019 tool on the editing toolbar.   Analysing the questions in a Test You can obtain a breakdown of responses to each question, and use this information to identify questions which are not effective, and which may need to be edited before the test is used again. Go to Control Panel > Grade Centre > Full Grade Centre\u00a0 (or Tests), locate the Test for which you wish to download results and click on the editing arrow at the top of the column. Select Item Analysis. On the Item Analysis screen, press Run. When the Analysis is ready to be viewed, you will be able to access it from the same screen. A range of information is shown, enabling you to evaluate the effectiveness of each question in the Test.   If you’d like more on Item Analysis see the Blackboard Help site at https:\/\/en-us.help.blackboard.com\/Learn\/9.1_2014_04\/Instructor\/110_Tests_Surveys_Pools\/140_Item_Analysis    ","og_url":"https:\/\/sites.reading.ac.uk\/tel-support\/2018\/07\/27\/blackboard-downloading-blackboard-test-results\/","og_site_name":"Blackboard Help for Staff - University of Reading","article_published_time":"2018-07-27T09:15:41+00:00","article_modified_time":"2023-09-01T09:11:01+00:00","author":"Peter Moll","twitter_card":"summary_large_image","twitter_creator":"@UniRdg_TEL","twitter_site":"@UniRdg_TEL","twitter_misc":{"Written by":"Peter Moll","Estimated reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/sites.reading.ac.uk\/tel-support\/2018\/07\/27\/blackboard-downloading-blackboard-test-results\/#article","isPartOf":{"@id":"https:\/\/sites.reading.ac.uk\/tel-support\/2018\/07\/27\/blackboard-downloading-blackboard-test-results\/"},"author":{"name":"Peter Moll","@id":"https:\/\/sites.reading.ac.uk\/tel-support\/#\/schema\/person\/688607e60ed4d958eb1a4f52e7441300"},"headline":"Blackboard Tests: Downloading test results","datePublished":"2018-07-27T09:15:41+00:00","dateModified":"2023-09-01T09:11:01+00:00","mainEntityOfPage":{"@id":"https:\/\/sites.reading.ac.uk\/tel-support\/2018\/07\/27\/blackboard-downloading-blackboard-test-results\/"},"wordCount":525,"commentCount":1,"publisher":{"@id":"https:\/\/sites.reading.ac.uk\/tel-support\/#organization"},"keywords":["Assessment","Blackboard Tests","Work Offline"],"articleSection":["Assessment & Feedback","Blackboard Learn","Managing Assessment","Tests"],"inLanguage":"en-GB","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/sites.reading.ac.uk\/tel-support\/2018\/07\/27\/blackboard-downloading-blackboard-test-results\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/sites.reading.ac.uk\/tel-support\/2018\/07\/27\/blackboard-downloading-blackboard-test-results\/","url":"https:\/\/sites.reading.ac.uk\/tel-support\/2018\/07\/27\/blackboard-downloading-blackboard-test-results\/","name":"Blackboard Tests: Downloading test results - Blackboard Help for Staff - University of Reading","isPartOf":{"@id":"https:\/\/sites.reading.ac.uk\/tel-support\/#website"},"datePublished":"2018-07-27T09:15:41+00:00","dateModified":"2023-09-01T09:11:01+00:00","breadcrumb":{"@id":"https:\/\/sites.reading.ac.uk\/tel-support\/2018\/07\/27\/blackboard-downloading-blackboard-test-results\/#breadcrumb"},"inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/sites.reading.ac.uk\/tel-support\/2018\/07\/27\/blackboard-downloading-blackboard-test-results\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/sites.reading.ac.uk\/tel-support\/2018\/07\/27\/blackboard-downloading-blackboard-test-results\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/sites.reading.ac.uk\/tel-support\/"},{"@type":"ListItem","position":2,"name":"Blackboard Tests: Downloading test results"}]},{"@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\/688607e60ed4d958eb1a4f52e7441300","name":"Peter Moll","image":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/sites.reading.ac.uk\/tel-support\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/9a6d5054670e8c4918a6a8baf060e7d3?s=96&d=retro&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/9a6d5054670e8c4918a6a8baf060e7d3?s=96&d=retro&r=g","caption":"Peter Moll"},"url":"https:\/\/sites.reading.ac.uk\/tel-support\/author\/petermoll\/"}]}},"modified_by":"taralehane","jetpack_sharing_enabled":true,"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/p9WwLV-oC","_links":{"self":[{"href":"https:\/\/sites.reading.ac.uk\/tel-support\/wp-json\/wp\/v2\/posts\/1526"}],"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\/65"}],"replies":[{"embeddable":true,"href":"https:\/\/sites.reading.ac.uk\/tel-support\/wp-json\/wp\/v2\/comments?post=1526"}],"version-history":[{"count":1,"href":"https:\/\/sites.reading.ac.uk\/tel-support\/wp-json\/wp\/v2\/posts\/1526\/revisions"}],"predecessor-version":[{"id":17359,"href":"https:\/\/sites.reading.ac.uk\/tel-support\/wp-json\/wp\/v2\/posts\/1526\/revisions\/17359"}],"wp:attachment":[{"href":"https:\/\/sites.reading.ac.uk\/tel-support\/wp-json\/wp\/v2\/media?parent=1526"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sites.reading.ac.uk\/tel-support\/wp-json\/wp\/v2\/categories?post=1526"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sites.reading.ac.uk\/tel-support\/wp-json\/wp\/v2\/tags?post=1526"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}