{"id":597,"date":"2024-11-13T11:37:40","date_gmt":"2024-11-13T16:37:40","guid":{"rendered":"https:\/\/openlab.sps.cuny.edu\/teaching-guides\/?p=597"},"modified":"2025-09-19T13:18:25","modified_gmt":"2025-09-19T17:18:25","slug":"how-to-override-individual-grades-in-spreadsheet-view","status":"publish","type":"post","link":"https:\/\/openlab.sps.cuny.edu\/teaching-guides\/2024\/11\/13\/how-to-override-individual-grades-in-spreadsheet-view\/","title":{"rendered":"Overriding Individual Grades in Spreadsheet View"},"content":{"rendered":"\n<p>In Brightspace, instructors can override individual grades directly in the Spreadsheet View, providing flexibility for unique grading circumstances. This guide walks through the steps to modify grades manually in the gradebook.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Steps to Override Individual Grades<\/h3>\n\n\n\n<ol class=\"wp-block-list\">\n<li>In your course, select <strong>Grades <\/strong>in the navigation bar.<\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh7-rt.googleusercontent.com\/docsz\/AD_4nXc_DR3jwsjBa6YpIHqomr41JDlO6uTQTXPQHBSdrzc4GUZZHN_GTjnDVCVD6uQ_yoRfydJhx41QuIF-7scRIJ6kkqNZlyJD_Jjvq20RYHnBmcvJlTTZi1owDzdioC8vz-4nntIsfUw17KzilSbGda8iGJI?key=K1WNEAZ_I6hFjvIZ0mGrs3w4\" alt=\"\" \/><\/figure>\n\n\n\n<ol start=\"2\" class=\"wp-block-list\">\n<li>On the <strong>Enter Grades <\/strong>tab, select <strong>Switch to Spreadsheet View<\/strong> to see text input fields in the grades.<\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh7-rt.googleusercontent.com\/docsz\/AD_4nXfwCYFW19pdEPkcx_5ZmOil42XY1to4DBKz08gL2NwNcUzYX-fsk7BRG0-yr1rUUSpHrNrfS_awt2OcQDIPcx2fHw8WQQo-fK3fPvao70I2i3iq1nZpBYB1o8qQcqPK6rlPcbHkcLvhljtecJxCIPxzMaf8?key=K1WNEAZ_I6hFjvIZ0mGrs3w4\" alt=\"\" \/><\/figure>\n\n\n\n<p>Note: If you see <strong>Switch to Standard View<\/strong> instead of <strong>Switch to Spreadsheet View<\/strong>, you are already in Spreadsheet View.<\/p>\n\n\n\n<ol start=\"3\" class=\"wp-block-list\">\n<li>In the table, locate the learner\u2019s row and the assignment\u2019s grade column and enter the individual\u2019s adjusted grade. Alternatively, use the <strong>Search<\/strong> function to display specific students for easier access.<\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh7-rt.googleusercontent.com\/docsz\/AD_4nXf7yGg44ZQUbZ1kNRZC0z93_2lRqYC7WXJjHzsBXuRwLuXaTquhoCq65s7EbALUzqYVy3NbXCZy4UWJMryrzopzoC-5tqEtsa_ToicPWqyvxMr90QTUpVCdvbOfInUTCk32yKd6Hw?key=K1WNEAZ_I6hFjvIZ0mGrs3w4\" alt=\"\" \/><\/figure>\n\n\n\n<ol start=\"4\" class=\"wp-block-list\">\n<li>Click on the grade cell you want to modify. Enter the new grade directly into the cell, replacing the existing grade.<\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh7-rt.googleusercontent.com\/docsz\/AD_4nXdhZ3uZHfrGR-VGV6DSVF9Hnzh-JHSoFyoB1_sfTtCWK4FwWCi4xyV899MH9XgCyRqzL2Xmhbu7yD83hyfbdxpbJcsBqEhZ1PjOj-1i2CykvTIPVTdF3KpCDj-r14fRq2HTWsIUbjBEScHCLeTa8Zz6moc?key=K1WNEAZ_I6hFjvIZ0mGrs3w4\" alt=\"\" \/><\/figure>\n\n\n\n<p>Click <strong>Save <\/strong>to proceed.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\" \/>\n\n\n\n<p>Still have questions? Email us at <a href=\"mailto:FacultySupport@sps.cuny.edu\">FacultySupport@sps.cuny.edu<\/a>. We&#8217;re here to help!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>In Brightspace, instructors can override individual grades directly in the Spreadsheet View, providing flexibility for unique grading circumstances. This guide walks through the steps to modify grades manually in the gradebook. Steps to Override Individual Grades Note: If you see Switch to Standard View instead of Switch to Spreadsheet View, you are already in Spreadsheet [&hellip;]<\/p>\n","protected":false},"author":82,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"portfolio_post_id":0,"portfolio_citation":"","portfolio_annotation":"","openlab_post_visibility":"","_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[6],"tags":[],"class_list":["post-597","post","type-post","status-publish","format-standard","hentry","category-brightspace"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/openlab.sps.cuny.edu\/teaching-guides\/wp-json\/wp\/v2\/posts\/597","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/openlab.sps.cuny.edu\/teaching-guides\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/openlab.sps.cuny.edu\/teaching-guides\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/openlab.sps.cuny.edu\/teaching-guides\/wp-json\/wp\/v2\/users\/82"}],"replies":[{"embeddable":true,"href":"https:\/\/openlab.sps.cuny.edu\/teaching-guides\/wp-json\/wp\/v2\/comments?post=597"}],"version-history":[{"count":3,"href":"https:\/\/openlab.sps.cuny.edu\/teaching-guides\/wp-json\/wp\/v2\/posts\/597\/revisions"}],"predecessor-version":[{"id":922,"href":"https:\/\/openlab.sps.cuny.edu\/teaching-guides\/wp-json\/wp\/v2\/posts\/597\/revisions\/922"}],"wp:attachment":[{"href":"https:\/\/openlab.sps.cuny.edu\/teaching-guides\/wp-json\/wp\/v2\/media?parent=597"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/openlab.sps.cuny.edu\/teaching-guides\/wp-json\/wp\/v2\/categories?post=597"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/openlab.sps.cuny.edu\/teaching-guides\/wp-json\/wp\/v2\/tags?post=597"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}