{"id":1583,"date":"2018-07-27T14:14:40","date_gmt":"2018-07-27T14:14:40","guid":{"rendered":"http:\/\/sites.reading.ac.uk\/tel-support\/?p=1583"},"modified":"2022-06-09T14:03:15","modified_gmt":"2022-06-09T14:03:15","slug":"blackboard-grade-centre-downloading-marks-and-marking-offline","status":"publish","type":"post","link":"https:\/\/sites.reading.ac.uk\/tel-support\/2018\/07\/27\/blackboard-grade-centre-downloading-marks-and-marking-offline\/","title":{"rendered":"Blackboard Grade Centre: Downloading marks, and marking offline"},"content":{"rendered":"

Why work offline?<\/h2>\n

Blackboard Learn allows you to download the whole Grade Centre for a course, or selected columns, which can then be opened and worked on in a spreadsheet application such as Excel, and later re-uploaded into the Grade Centre. This has many benefits such as:<\/p>\n

\u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Exporting details (names, usernames) of students who are enrolled on the course.<\/p>\n

\u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Entering marks (and general feedback) for an assessment without having to be logged into Blackboard.<\/p>\n

\u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Exporting test and assignment data for record-keeping purposes, or so that you can perform calculations in Excel.<\/p>\n

Once downloaded, marks can be entered \/ edited offline, and later uploaded back to the Grade Centre.<\/p>\n

 <\/p>\n

How to download marks from the Grade Centre<\/h2>\n

NOTE: This process can also be used if there are no marks yet and you want to enter marks.<\/p>\n

1.\u00a0\u00a0\u00a0 To download marks from the Grade Centre, go to Control Panel > \u00a0Grade Centre > Full Grade Centre<\/strong>, click on Work Offline<\/strong> in the top navigation menu, then select Download<\/strong>.<\/p>\n

\"Grade<\/p>\n

2.\u00a0\u00a0\u00a0 On the page that loads, select which data you wish to download. The options are:<\/p>\n

\u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Full Grade Centre<\/strong>
\nContains all columns and associated data.
\nComments will not be included and cannot be added offline.<\/p>\n

\u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Select Grading Period<\/strong>
\nContains all the columns from the selected Grading Period.
\nGrading Periods must be created before they can be chosen.<\/p>\n

\u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Select Column<\/strong>
\nContains the data from one Grade Centre column.<\/p>\n

If you want to download previously-entered feedback, or want to add feedback comments offline, tick the box next to Include comments for this Column<\/strong>.<\/p>\n

\"Data<\/p>\n

\u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 User Information Only<\/strong>
\nContains columns with user data such as First Name, Last Name, and User Name.<\/p>\n

3.\u00a0\u00a0\u00a0 The other options are non-essential.<\/p>\n

4.\u00a0\u00a0\u00a0 Under Download Location<\/strong> you will normally accept the default of downloading the file to your computer.<\/p>\n

5.\u00a0\u00a0\u00a0 Do not change the name of the file that downloads, as the file name includes useful information to identify the course and date e.g.
\ngc_PY2CP-16-7A_fullgc_2017-02-06-13-54-39.csv
\ngc_FB2EFA-15-6A_column_2016-06-06-15-32-30.xls<\/p>\n

\"ImportantBe careful when saving the Grade Centre file, as it autmatically saves as a *.txt file.  This will need to be changed to a .xls to continue.\r\n\"Showing\r\n<\/pre>\n
 <\/p>\n
Working Offline<\/h2>\n
When the file has downloaded, open it in editing software such as Excel.<\/p>\n
If the Full Grade Centre has been downloaded, marks can be added or changed, and the file saved for uploading back to Blackboard.<\/p>\n
If a single Grade Centre column has been downloaded, marks and feedback comments can be added or changed, and the file saved for uploading back to Blackboard.<\/p>\n
 <\/p>\n
\u00a0\"Caution!\"\r\n\u00a0\r\nDo not change the name of any of the column headers in Excel, as Blackboard may not recognise it as the same field when you upload data back into the Grade Centre.\r\n<\/pre>\n
 <\/p>\n
Editing Comments<\/h2>\n
If you included Comments when downloading a Grade Centre column (even if there were no previously-entered comments), you will see four comment-related columns in the downloaded file:<\/p>\n
1.\u00a0\u00a0\u00a0 Grading Notes<\/strong>
\nGrade Centre column comments visible only to course Instructors. These will be visible when viewing the Grade Details screen for a student submission.<\/p>\n
2.\u00a0\u00a0\u00a0 Notes Format<\/strong>
\nSmart Text, Plain Text, or HTML.<\/p>\n
3.\u00a0\u00a0\u00a0 Feedback to User<\/strong>
\nFeedback comments which will be visible to Students in My Grades, and under FEEDBACK TO LEARNER when viewing work submitted to a Blackboard Assignment.<\/p>\n
4.\u00a0\u00a0\u00a0 Feedback Format<\/strong>
\nSmart Text, Plain Text, or HTML.<\/p>\n
The format options are:<\/p>\n
\u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Smart Text<\/strong>: Automatically recognises links, accepts HTML tags, and recognizes the ENTER key as a paragraph tag.<\/p>\n
\u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Plain Text<\/strong>: Displays text as it is written in the text area. Plain text does not render HTML code. HTML code will appear as text.<\/p>\n
\u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 HTML<\/strong>: Displays text as coded by the user using Hypertext Mark-up Language (HTML) tags.<\/p>\n
 <\/p>\n
\"Important\r\nEntering comments offline \u2013 some caveats<\/strong>\r\n\r\n\u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Links within comments to rich media, such as images or sound files, should be inserted and edited online.\r\n\r\n\u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 If students have made multiple attempts to a Blackboard assignment, you will not be able to upload marks or feedback for those students \u2013 this is a known issue for which there is not currently a solution.\r\n\r\n\u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 For columns relating to Tests and Assignments, where students have to make a submission, you cannot upload marks or feedback for students who have not submitted.\r\n<\/pre>\n
 <\/p>\n
Uploading marks back into Blackboard<\/h2>\n
When editing is complete, save the file, return to the Full Grade Centre in your Blackboard course, and click Work Offline > Upload<\/strong>. Browse for the file, and press Submit<\/strong>.<\/p>\n
 <\/p>\n
 <\/p>\n","protected":false},"excerpt":{"rendered":"
Why work offline? Blackboard Learn allows you to download the whole Grade Centre for a course, or selected columns, which can then be opened and worked on in a spreadsheet application such as Excel, and later re-uploaded into the Grade Centre. This has many benefits such as: \u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Exporting details (names, usernames) of students who are enrolled on the course. \u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Entering marks (and general feedback) for an assessment without having to be logged into Blackboard. \u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Exporting test and assignment data for record-keeping purposes, or so that you can perform calculations in Excel. Once downloaded, marks can be entered \/ edited offline, and later uploaded back to the Grade Centre.   How to download marks from the Grade Centre NOTE: This process can also be used if there are no marks yet and you want to enter marks. 1.\u00a0\u00a0\u00a0 To download marks from the Grade Centre, go to Control Panel > \u00a0Grade Centre > Full Grade Centre, click on Work Offline in the top navigation menu, then select Download. 2.\u00a0\u00a0\u00a0 On the page that loads, select which data you wish to download. The options are: \u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Full Grade Centre Contains all columns and associated data. Comments will not be included and cannot be added offline. \u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Select Grading Period Contains all the columns from the selected Grading Period. Grading Periods must be created before they can be chosen. \u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Select Column Contains the data from one Grade Centre column. If you want to download previously-entered feedback, or want to add feedback comments offline, tick the box next to Include comments for this Column. \u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 User Information Only Contains columns with user data such as First Name, Last Name, and User Name. 3.\u00a0\u00a0\u00a0 The other options are non-essential. 4.\u00a0\u00a0\u00a0 Under Download Location you will normally accept the default of downloading the file to your computer. 5.\u00a0\u00a0\u00a0 Do not change the name of the file that downloads, as the file name includes useful information to identify the course and date e.g. gc_PY2CP-16-7A_fullgc_2017-02-06-13-54-39.csv gc_FB2EFA-15-6A_column_2016-06-06-15-32-30.xls Be careful when saving the Grade Centre file, as it autmatically saves as a *.txt file. This will need to be changed to a .xls to continue.   Working Offline When the file has downloaded, open it in editing software such as Excel. If the Full Grade Centre has been downloaded, marks can be added or changed, and the file saved for uploading back to Blackboard. If a single Grade Centre column has been downloaded, marks and feedback comments can be added or changed, and the file saved for uploading back to Blackboard.   \u00a0 \u00a0 Do not change the name of any of the column headers in Excel, as Blackboard may not recognise it as the same field when you upload data back into the Grade Centre.   Editing Comments If you included Comments when downloading a Grade Centre column (even if there were no previously-entered comments), you will see four comment-related columns in the downloaded file: 1.\u00a0\u00a0\u00a0 Grading Notes Grade Centre column comments visible only to course Instructors. These will be visible when viewing the Grade Details screen for a student submission. 2.\u00a0\u00a0\u00a0 Notes Format Smart Text, Plain Text, or HTML. 3.\u00a0\u00a0\u00a0 Feedback to User Feedback comments which will be visible to Students in My Grades, and under FEEDBACK TO LEARNER when viewing work submitted to a Blackboard Assignment. 4.\u00a0\u00a0\u00a0 Feedback Format Smart Text, Plain Text, or HTML. The format options are: \u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Smart Text: Automatically recognises links, accepts HTML tags, and recognizes the ENTER key as a paragraph tag. \u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Plain Text: Displays text as it is written in the text area. Plain text does not render HTML code. HTML code will appear as text. \u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 HTML: Displays text as coded by the user using Hypertext Mark-up Language (HTML) tags.   Entering comments offline \u2013 some caveats \u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Links within comments to rich media, such as images or sound files, should be inserted and edited online. \u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 If students have made multiple attempts to a Blackboard assignment, you will not be able to upload marks or feedback for those students \u2013 this is a known issue for which there is not currently a solution. \u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 For columns relating to Tests and Assignments, where students have to make a submission, you cannot upload marks or feedback for students who have not submitted.   Uploading marks back into Blackboard When editing is complete, save the file, return to the Full Grade Centre in your Blackboard course, and click Work Offline > Upload. Browse for the file, and press Submit.    <\/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":"","_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,234,240,231,230],"tags":[103,107,46],"jetpack_publicize_connections":[],"yoast_head":"\nBlackboard Grade Centre: Downloading marks, and marking offline - 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 Grade Centre: Downloading marks, and marking offline - Blackboard Help for Staff - University of Reading\" \/>\n<meta property=\"og:description\" content=\"Why work offline? Blackboard Learn allows you to download the whole Grade Centre for a course, or selected columns, which can then be opened and worked on in a spreadsheet application such as Excel, and later re-uploaded into the Grade Centre. This has many benefits such as: \u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Exporting details (names, usernames) of students who are enrolled on the course. \u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Entering marks (and general feedback) for an assessment without having to be logged into Blackboard. \u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Exporting test and assignment data for record-keeping purposes, or so that you can perform calculations in Excel. Once downloaded, marks can be entered \/ edited offline, and later uploaded back to the Grade Centre.   How to download marks from the Grade Centre NOTE: This process can also be used if there are no marks yet and you want to enter marks. 1.\u00a0\u00a0\u00a0 To download marks from the Grade Centre, go to Control Panel > \u00a0Grade Centre > Full Grade Centre, click on Work Offline in the top navigation menu, then select Download. 2.\u00a0\u00a0\u00a0 On the page that loads, select which data you wish to download. The options are: \u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Full Grade Centre Contains all columns and associated data. Comments will not be included and cannot be added offline. \u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Select Grading Period Contains all the columns from the selected Grading Period. Grading Periods must be created before they can be chosen. \u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Select Column Contains the data from one Grade Centre column. If you want to download previously-entered feedback, or want to add feedback comments offline, tick the box next to Include comments for this Column. \u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 User Information Only Contains columns with user data such as First Name, Last Name, and User Name. 3.\u00a0\u00a0\u00a0 The other options are non-essential. 4.\u00a0\u00a0\u00a0 Under Download Location you will normally accept the default of downloading the file to your computer. 5.\u00a0\u00a0\u00a0 Do not change the name of the file that downloads, as the file name includes useful information to identify the course and date e.g. gc_PY2CP-16-7A_fullgc_2017-02-06-13-54-39.csv gc_FB2EFA-15-6A_column_2016-06-06-15-32-30.xls Be careful when saving the Grade Centre file, as it autmatically saves as a *.txt file. This will need to be changed to a .xls to continue.   Working Offline When the file has downloaded, open it in editing software such as Excel. If the Full Grade Centre has been downloaded, marks can be added or changed, and the file saved for uploading back to Blackboard. If a single Grade Centre column has been downloaded, marks and feedback comments can be added or changed, and the file saved for uploading back to Blackboard.   \u00a0 \u00a0 Do not change the name of any of the column headers in Excel, as Blackboard may not recognise it as the same field when you upload data back into the Grade Centre.   Editing Comments If you included Comments when downloading a Grade Centre column (even if there were no previously-entered comments), you will see four comment-related columns in the downloaded file: 1.\u00a0\u00a0\u00a0 Grading Notes Grade Centre column comments visible only to course Instructors. These will be visible when viewing the Grade Details screen for a student submission. 2.\u00a0\u00a0\u00a0 Notes Format Smart Text, Plain Text, or HTML. 3.\u00a0\u00a0\u00a0 Feedback to User Feedback comments which will be visible to Students in My Grades, and under FEEDBACK TO LEARNER when viewing work submitted to a Blackboard Assignment. 4.\u00a0\u00a0\u00a0 Feedback Format Smart Text, Plain Text, or HTML. The format options are: \u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Smart Text: Automatically recognises links, accepts HTML tags, and recognizes the ENTER key as a paragraph tag. \u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Plain Text: Displays text as it is written in the text area. Plain text does not render HTML code. HTML code will appear as text. \u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 HTML: Displays text as coded by the user using Hypertext Mark-up Language (HTML) tags.   Entering comments offline \u2013 some caveats \u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Links within comments to rich media, such as images or sound files, should be inserted and edited online. \u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 If students have made multiple attempts to a Blackboard assignment, you will not be able to upload marks or feedback for those students \u2013 this is a known issue for which there is not currently a solution. \u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 For columns relating to Tests and Assignments, where students have to make a submission, you cannot upload marks or feedback for students who have not submitted.   Uploading marks back into Blackboard When editing is complete, save the file, return to the Full Grade Centre in your Blackboard course, and click Work Offline > Upload. Browse for the file, and press Submit.    \" \/>\n<meta property=\"og:url\" content=\"https:\/\/sites.reading.ac.uk\/tel-support\/2018\/07\/27\/blackboard-grade-centre-downloading-marks-and-marking-offline\/\" \/>\n<meta property=\"og:site_name\" content=\"Blackboard Help for Staff - University of Reading\" \/>\n<meta property=\"article:published_time\" content=\"2018-07-27T14:14:40+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-06-09T14:03:15+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/sites.reading.ac.uk\/tel-support\/wp-content\/uploads\/sites\/30\/2018\/07\/Save-Excel.png\" \/>\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-grade-centre-downloading-marks-and-marking-offline\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/sites.reading.ac.uk\/tel-support\/2018\/07\/27\/blackboard-grade-centre-downloading-marks-and-marking-offline\/\"},\"author\":{\"name\":\"Peter Moll\",\"@id\":\"https:\/\/sites.reading.ac.uk\/tel-support\/#\/schema\/person\/688607e60ed4d958eb1a4f52e7441300\"},\"headline\":\"Blackboard Grade Centre: Downloading marks, and marking offline\",\"datePublished\":\"2018-07-27T14:14:40+00:00\",\"dateModified\":\"2022-06-09T14:03:15+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/sites.reading.ac.uk\/tel-support\/2018\/07\/27\/blackboard-grade-centre-downloading-marks-and-marking-offline\/\"},\"wordCount\":614,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/sites.reading.ac.uk\/tel-support\/#organization\"},\"keywords\":[\"Assessment\",\"Grade Centre\",\"marking\"],\"articleSection\":[\"Assessment & Feedback\",\"Blackboard Learn\",\"Grade Centre\",\"Managing Assessment\",\"Marking & Feedback\"],\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/sites.reading.ac.uk\/tel-support\/2018\/07\/27\/blackboard-grade-centre-downloading-marks-and-marking-offline\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/sites.reading.ac.uk\/tel-support\/2018\/07\/27\/blackboard-grade-centre-downloading-marks-and-marking-offline\/\",\"url\":\"https:\/\/sites.reading.ac.uk\/tel-support\/2018\/07\/27\/blackboard-grade-centre-downloading-marks-and-marking-offline\/\",\"name\":\"Blackboard Grade Centre: Downloading marks, and marking offline - Blackboard Help for Staff - University of Reading\",\"isPartOf\":{\"@id\":\"https:\/\/sites.reading.ac.uk\/tel-support\/#website\"},\"datePublished\":\"2018-07-27T14:14:40+00:00\",\"dateModified\":\"2022-06-09T14:03:15+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/sites.reading.ac.uk\/tel-support\/2018\/07\/27\/blackboard-grade-centre-downloading-marks-and-marking-offline\/#breadcrumb\"},\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/sites.reading.ac.uk\/tel-support\/2018\/07\/27\/blackboard-grade-centre-downloading-marks-and-marking-offline\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/sites.reading.ac.uk\/tel-support\/2018\/07\/27\/blackboard-grade-centre-downloading-marks-and-marking-offline\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/sites.reading.ac.uk\/tel-support\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Blackboard Grade Centre: Downloading marks, and marking offline\"}]},{\"@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 Grade Centre: Downloading marks, and marking offline - 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 Grade Centre: Downloading marks, and marking offline - Blackboard Help for Staff - University of Reading","og_description":"Why work offline? Blackboard Learn allows you to download the whole Grade Centre for a course, or selected columns, which can then be opened and worked on in a spreadsheet application such as Excel, and later re-uploaded into the Grade Centre. This has many benefits such as: \u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Exporting details (names, usernames) of students who are enrolled on the course. \u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Entering marks (and general feedback) for an assessment without having to be logged into Blackboard. \u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Exporting test and assignment data for record-keeping purposes, or so that you can perform calculations in Excel. Once downloaded, marks can be entered \/ edited offline, and later uploaded back to the Grade Centre.   How to download marks from the Grade Centre NOTE: This process can also be used if there are no marks yet and you want to enter marks. 1.\u00a0\u00a0\u00a0 To download marks from the Grade Centre, go to Control Panel > \u00a0Grade Centre > Full Grade Centre, click on Work Offline in the top navigation menu, then select Download. 2.\u00a0\u00a0\u00a0 On the page that loads, select which data you wish to download. The options are: \u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Full Grade Centre Contains all columns and associated data. Comments will not be included and cannot be added offline. \u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Select Grading Period Contains all the columns from the selected Grading Period. Grading Periods must be created before they can be chosen. \u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Select Column Contains the data from one Grade Centre column. If you want to download previously-entered feedback, or want to add feedback comments offline, tick the box next to Include comments for this Column. \u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 User Information Only Contains columns with user data such as First Name, Last Name, and User Name. 3.\u00a0\u00a0\u00a0 The other options are non-essential. 4.\u00a0\u00a0\u00a0 Under Download Location you will normally accept the default of downloading the file to your computer. 5.\u00a0\u00a0\u00a0 Do not change the name of the file that downloads, as the file name includes useful information to identify the course and date e.g. gc_PY2CP-16-7A_fullgc_2017-02-06-13-54-39.csv gc_FB2EFA-15-6A_column_2016-06-06-15-32-30.xls Be careful when saving the Grade Centre file, as it autmatically saves as a *.txt file. This will need to be changed to a .xls to continue.   Working Offline When the file has downloaded, open it in editing software such as Excel. If the Full Grade Centre has been downloaded, marks can be added or changed, and the file saved for uploading back to Blackboard. If a single Grade Centre column has been downloaded, marks and feedback comments can be added or changed, and the file saved for uploading back to Blackboard.   \u00a0 \u00a0 Do not change the name of any of the column headers in Excel, as Blackboard may not recognise it as the same field when you upload data back into the Grade Centre.   Editing Comments If you included Comments when downloading a Grade Centre column (even if there were no previously-entered comments), you will see four comment-related columns in the downloaded file: 1.\u00a0\u00a0\u00a0 Grading Notes Grade Centre column comments visible only to course Instructors. These will be visible when viewing the Grade Details screen for a student submission. 2.\u00a0\u00a0\u00a0 Notes Format Smart Text, Plain Text, or HTML. 3.\u00a0\u00a0\u00a0 Feedback to User Feedback comments which will be visible to Students in My Grades, and under FEEDBACK TO LEARNER when viewing work submitted to a Blackboard Assignment. 4.\u00a0\u00a0\u00a0 Feedback Format Smart Text, Plain Text, or HTML. The format options are: \u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Smart Text: Automatically recognises links, accepts HTML tags, and recognizes the ENTER key as a paragraph tag. \u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Plain Text: Displays text as it is written in the text area. Plain text does not render HTML code. HTML code will appear as text. \u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 HTML: Displays text as coded by the user using Hypertext Mark-up Language (HTML) tags.   Entering comments offline \u2013 some caveats \u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Links within comments to rich media, such as images or sound files, should be inserted and edited online. \u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 If students have made multiple attempts to a Blackboard assignment, you will not be able to upload marks or feedback for those students \u2013 this is a known issue for which there is not currently a solution. \u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 For columns relating to Tests and Assignments, where students have to make a submission, you cannot upload marks or feedback for students who have not submitted.   Uploading marks back into Blackboard When editing is complete, save the file, return to the Full Grade Centre in your Blackboard course, and click Work Offline > Upload. Browse for the file, and press Submit.    ","og_url":"https:\/\/sites.reading.ac.uk\/tel-support\/2018\/07\/27\/blackboard-grade-centre-downloading-marks-and-marking-offline\/","og_site_name":"Blackboard Help for Staff - University of Reading","article_published_time":"2018-07-27T14:14:40+00:00","article_modified_time":"2022-06-09T14:03:15+00:00","og_image":[{"url":"https:\/\/sites.reading.ac.uk\/tel-support\/wp-content\/uploads\/sites\/30\/2018\/07\/Save-Excel.png"}],"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-grade-centre-downloading-marks-and-marking-offline\/#article","isPartOf":{"@id":"https:\/\/sites.reading.ac.uk\/tel-support\/2018\/07\/27\/blackboard-grade-centre-downloading-marks-and-marking-offline\/"},"author":{"name":"Peter Moll","@id":"https:\/\/sites.reading.ac.uk\/tel-support\/#\/schema\/person\/688607e60ed4d958eb1a4f52e7441300"},"headline":"Blackboard Grade Centre: Downloading marks, and marking offline","datePublished":"2018-07-27T14:14:40+00:00","dateModified":"2022-06-09T14:03:15+00:00","mainEntityOfPage":{"@id":"https:\/\/sites.reading.ac.uk\/tel-support\/2018\/07\/27\/blackboard-grade-centre-downloading-marks-and-marking-offline\/"},"wordCount":614,"commentCount":0,"publisher":{"@id":"https:\/\/sites.reading.ac.uk\/tel-support\/#organization"},"keywords":["Assessment","Grade Centre","marking"],"articleSection":["Assessment & Feedback","Blackboard Learn","Grade Centre","Managing Assessment","Marking & Feedback"],"inLanguage":"en-GB","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/sites.reading.ac.uk\/tel-support\/2018\/07\/27\/blackboard-grade-centre-downloading-marks-and-marking-offline\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/sites.reading.ac.uk\/tel-support\/2018\/07\/27\/blackboard-grade-centre-downloading-marks-and-marking-offline\/","url":"https:\/\/sites.reading.ac.uk\/tel-support\/2018\/07\/27\/blackboard-grade-centre-downloading-marks-and-marking-offline\/","name":"Blackboard Grade Centre: Downloading marks, and marking offline - Blackboard Help for Staff - University of Reading","isPartOf":{"@id":"https:\/\/sites.reading.ac.uk\/tel-support\/#website"},"datePublished":"2018-07-27T14:14:40+00:00","dateModified":"2022-06-09T14:03:15+00:00","breadcrumb":{"@id":"https:\/\/sites.reading.ac.uk\/tel-support\/2018\/07\/27\/blackboard-grade-centre-downloading-marks-and-marking-offline\/#breadcrumb"},"inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/sites.reading.ac.uk\/tel-support\/2018\/07\/27\/blackboard-grade-centre-downloading-marks-and-marking-offline\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/sites.reading.ac.uk\/tel-support\/2018\/07\/27\/blackboard-grade-centre-downloading-marks-and-marking-offline\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/sites.reading.ac.uk\/tel-support\/"},{"@type":"ListItem","position":2,"name":"Blackboard Grade Centre: Downloading marks, and marking offline"}]},{"@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":"Peter Moll","jetpack_sharing_enabled":true,"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/p9WwLV-px","_links":{"self":[{"href":"https:\/\/sites.reading.ac.uk\/tel-support\/wp-json\/wp\/v2\/posts\/1583"}],"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=1583"}],"version-history":[{"count":2,"href":"https:\/\/sites.reading.ac.uk\/tel-support\/wp-json\/wp\/v2\/posts\/1583\/revisions"}],"predecessor-version":[{"id":13476,"href":"https:\/\/sites.reading.ac.uk\/tel-support\/wp-json\/wp\/v2\/posts\/1583\/revisions\/13476"}],"wp:attachment":[{"href":"https:\/\/sites.reading.ac.uk\/tel-support\/wp-json\/wp\/v2\/media?parent=1583"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sites.reading.ac.uk\/tel-support\/wp-json\/wp\/v2\/categories?post=1583"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sites.reading.ac.uk\/tel-support\/wp-json\/wp\/v2\/tags?post=1583"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}