The University of Tennessee, Knoxville

Office of Information Technology


About OIT  |  Contact Us  |  Employment  |  Policies   
Search:     Advanced search
Browse by category:
Glossary

OIT HelpDesk - Knowledgebase / Software/Applications/Clients / Blackboard Learn / Online@UT /

Now that I've downloaded grades from Grade Center and opened the spreadsheet in Microsoft Excel, how do I edit it?
Print
Comment on the article
Views: 78787
Votes: 0
Comments: 0
You can use the downloaded spreadsheet to manage the grades in a a Microsoft Excel spreadsheet on your computer. For example, you can:

- enter grades in columns downloaded from the Grade Center
- create new columns
- enter grades in the new columns
- perform grade calculations using the Excel functions

Note:
Don't change any student information (name, username, and student ID) and existing column headers if you plan to upload the spreadsheet back into Blackboard. When you add a new column, remember to type the name of the column in the header. Blackboard will add a column ID automatically when you upload the column.
Others in this Category
document I've forgotten my password for Blackboard Learn. What do I need to do?
document I am an instructor. What do I need to access Blackboard Learn? What are the recommended system requirements?
document As an instructor, how do my courses get into Blackboard Learn? When will they appear?
document When do students see course sites in Blackboard Learn? Why can't they see my class?
document I'm teaching a cross-listed course or multiple sections of the same class. In Blackboard, can I combine multiple sections into a single course site so I only have to work in one course site?
document How long do courses from previous semesters stay in Blackboard?
document Who is responsible for adding students to my courses in Blackboard?
document How can I add or enroll a colleague (another Instructor, a TA, etc.) to my course site in Blackboard Learn?
document I can't find anything in Online@UT/Blackboard because of all these old courses! What can I do to clean out my course list?
document As an instructor, how do I reuse the materials in my Blackboard course?
document As an instructor, can I rename my course in Blackboard?
document Why is there no "Reply" button on my class Discussion Board's threads in Blackboard?
document I have created a test or quiz in Tests, Surveys, and Pools, but students cannot see it. Do I need to do something?
document In Blackboard, what is this "Hide results for this test completely from instructor and the Grade Center" option I see when I deploy a test, and when should I use it?
document Why aren't students receiving email I send through Blackboard?
document Can I change my name in Blackboard?
document Can I change my email address in Blackboard?
document As an instructor, can I get training for Blackboard?
document In Blackboard, I'm having difficulty using the Wimba Voice Tools. What can I do?
document What do I need to access Blackboard? What are the recommended system requirements?
document When will I see my classes for next semester in Online@UT?
document I just dropped/added a class in Blackboard. When will it go away/show up?
document In Blackboard, I don't see all of my classes listed/I still see old classes listed. Do I need to do anything?
document My instructor told the class to look at some materials in the course site in Blackboard, but when I look there's nothing there. Am I doing something wrong?
document In Blackboard, how do I access course sites from previous semesters?
document What information is stored and displayed about me in Blackboard?
document Why am I not receiving email sent from Blackboard?
document How do I contact my instructor in Blackboard?
document When I try to log in to Blackboard, I see this error message: No authentication credentials were provided with the request.
document When I try to log in to Blackboard, I see this error message: Could not login. Valid authentication credentials were not provided.
document When I try to log in to Blackboard, I see this error message: Could not login. The specified username does not exist in the system or An error occurred while the system was processing this login request.
document When I try to log in to Blackboard, I see this error message: An error occurred in the authentication module: Error occurred while trying to lookup the current session or An error occurred in the authentication module: Empty ResultSet for the session query.
document When I try to log in to Blackboard, I see this error message: There was a problem with this login request. Contact the system administrator or Challenge token null
document When I try to log in to Blackboard, nothing happens.
document Attempting to open a file uploaded to the Discussion Board, in Blackboard, results in a "HTTP Status 404" error message.
document I'm trying to add a student in Blackboard and get this error message: "No user matching the search criteria was found."
document I can't access media files that are linked from Online@UT/Blackboard.
document When using Blackboard, on some pages I get a message asking if I want to trust a certificate from DesignScience, Thawte Consulting, or Blackboard.
document In Blackboard, some or all item types are missing in the "Add Item" menu of course content areas.
document I'm using Firefox and can't paste into text boxes in Blackboard.
document The AOL browser does not function correctly with Blackboard.
document I'm an instructor using Blackboard, and one of my tests shows up in my Grade Center with a green check. Where's the grade?
document I'm trying to add grades to the Grade Center, and they keep turning negative.
document I just added grades to the Grade Center, and now they have disappeared. Where did they go?
document What is an External Grade and when should I use it?
document I don't have a scrollbar at the bottom of the Grade Center. Where did it go?
document I can only see one or two students in the Grade Center. Where are the rest?
document I'm using Internet Explorer and the Grade Center is acting really weird. What's going on?
document I copied my materials from an old course site, but my Assignments didn't copy. Where are they?
document I'd like to post an announcement in my course site, but I'd also like my students to get an email letting them know about it. Is it possible to do both at once?
document I'm trying to upload a SafeAssignment, but I keep getting an "InstanceNotFound" error message. What can I do to fix the problem?
document I have two students in my class with the same last name and they aren't sorting correctly in the Grade Center. What's going on?
document What does the red 'X' next to my student's name mean?
document What are the acceptable file formats for uploading grades to the Grade Center?
document How do I access my Blackboard courses after receiving my UT NetID?
document How do I add a thread to a forum in my course site?
document How do I post a reply to a thread on my Discussion Board?
document Can students add Forums to a Discussion Board in my course site?
document I'd like to archive my Discussion Board. Can I do that?
document I heard I could change the thread status in the Discussion Board? How can I and why would I do that?
document I'd like to modify and/or remove a Forum in my Discussion Board. How can I do that?
document Can you tell me more about student photos and privacy concerns?
document How do I copy a Forum in my Discussion Board?
document How do I create a Forum in a Discussion Board?
document How do I set up my Discussion Board so it can be graded?
document What is the difference between 'Grade Forum' and 'Grade Threads'?
document I've set up my Discussion Board so it can be graded. Now, how do I actually assign a grade?
document How do I rate a post in a forum in my Discussion Board?
document How do I add an event or item to my Blackboard Calendar?
document How do I add a discussion board to a content area in my course site?
document How do I add, modify, or remove Announcements in my course site?
document How do I add/change my Course Banner (the image on the announcement page)?
document How do I change the course calendar view in my course site?
document Which operating systems and browsers are compatible with Blackboard?
document How do I check events on my Blackboard calendar?
document I am experiencing weird browser problems. Do you know what's going on?
document How do I remove an instructor or a TA from my course site in Blackboard?
document What's the difference between the Smart Text, Plain Text, and HTML options?
document How is access to my Blackboard Learn course site(s) controlled and what are the roles available within Bb Learn course sites?
document Can I change how my Blackboard course menu looks?
document Do I have control over adding and removing users from my Blackboard course?
document How do I access a list of users in my Blackboard course?
document How do I protect my personal information in Blackboard?
document Can I let guest users see my Blackboard course site?
document How do I view the adaptive release map by user in my Blackboard course?
document How do I use Review Status to manage a content item in a Blackboard course?
document How do I check my students' progress on items enabled with review status?
document If I wanted to categorize my Blackboard course, how would I do that?
document I'd like to change the entry page on my Blackboard course site. Can I do that?
document How do I modify user roles in my Blackboard course?
document How do I export or archive my Blackboard course?
document How do I create groups in my Blackboard course?
document How do I modify a group in my Blackboard course?
document How do I delete most or all my Blackboard course content?
document I have several forums in my discussion board. How do I search them to find what I need?
document Is there any way to access e-mails that I have sent from my Blackboard course?
document How do I send email through the Grade Center in my course?
document I'm an instructor; can you explain the email options in my Blackboard course site?
document I'm a student; can you explain the email options in my Blackboard course site?
document How do I view a student's overall grades in my Blackboard course site?
document I'd like to add materials to a content area. What are my options and how do I do this?
document How do I add an assignment to a content area in my course site?
document Can I add a link to my course group(s) from a content area?
document Can I add a link to a specific course tool in a content area?
document How do I add an External Link to my course menu?
document How do I copy an individual content item in my course site?
document How do I enable or disable tool links or content areas on my course menu in Blackboard?
document How do I view and grade submitted assignments?
document How do I set tool availability in my Blackboard course?
document How do I set the duration of availability for my Blackboard course?
document What do the different symbols in the Grade Center mean?
document How do I modify a post in a forum in my Blackboard course?
document How do I remove a task from my course site?
document How do I remove a content item from my Blackboard course site?
document How do I remove groups from my Blackboard course?
document How do I remove a post from a Discussion Board forum in my course site?
document How do I use Adaptive Release to manage a content item in my Blackboard course?
document Can I display copyright protected materials in my online course in Blackboard?
document Can I add non-UT users to my Blackboard course?
document When I log on to Blackboard my course does not appear or I see a message that says "You are not currently enrolled in any available courses in the Blackboard system". What is wrong and what should I do?
document When I send email through Blackboard, there is an option to receive a Return Receipt. What is a Return Receipt and why would I want one?
document What are the uses of the Assignments tool in Blackboard?
document How do I add a Calculated Column to my Grade Center?
document How do I add a Grade Column in my Grade Center?
document How do I change a grade's display options in the Grade Center?
document How do I check my grades in Blackboard?
document What can do with my Grade Center's grading schema?
document I found something called Smart Views in my Grade Center. What are Smart Views?
document How do I download my Grade Center from my Blackboard course into Excel format?
document How do I check the history of my student's grades?
document How do I filter large Grade Center displays?
document How do I hide a column in my Grade Center?
document How do I edit column information in the Grade Center?
document How do I view Column Statistics in the Grade Center?
document Is there a quick way to view column information in my Grade Center?
document How do I view Attempts Statistics in Grade Center?
document How do I generate reports from the Grade Center?
document How can I organize the columns in my Grade Center?
document Some of my students are showing up in my Grade Center, while others are not. What's going on?
document What is Statistics Tracking and why would I use it?
document How do I open my tab-delimited Grade Center file in Excel?
document How do I create, edit, or delete a category in the Grade Center?
document How do I modify an individual column's category in the Grade Center?
document How would I save my grade spreadsheet as a tab-delimited text file for uploading back to my Grade Center?
document How do I upload a spreadsheet containing grades into Grade Center?
document Why would I want to create question pools in my Blackboard course site?
document I would like to create a question pool in my course site. How would I do that?
document How do I create a test in my Blackboard course site?
document How do I use existing assessments to create a Question Pool?
document Now that I've created a test/survey, how do I make it available to my students?
document How would I export or import question pools in my Blackboard course site?
document How do I create a survey in my Blackboard course site?
document How do I export or import a test from within my course site?
document How do I export or import a survey from within my course site?
document How do I remove surveys from my course site?
document How do I remove a test from my course site?
document How do I add true/false questions to tests, surveys, and question pools in Blackboard?
document How do I add multiple choice questions to tests, surveys, and question pools in my Blackboard course?
document How do I add fill in the blank questions to tests, surveys and question pools in my Blackboard course?
document How do I add multiple answer questions to tests, surveys, and question pools in my Blackboard course?
document How do I add matching questions to tests, surveys and question pools in my Blackboard course?
document How do I add ordering questions to tests, surveys and question pools in my Blackboard course?
document How do I add essay questions to tests, surveys and question pools in my Blackboard course?
document How do I add calculated formula questions to tests, surveys, or question pools in my Blackboard course?
document How do I add calculated numeric questions to tests, surveys or question pools in my Blackboard course?
document How do I add file response questions to a test or question pool in my Blackboard course?
document How do I add hot spot questions to tests, surveys and question pools in my Blackboard course?
document How do I add fill in multiple blanks questions to tests, surveys or question pools in my Blackboard course?
document How do I add jumbled sentence questions to tests, surveys and question pools in my Blackboard course?
document How do I add opinion scale/Likert questions to tests, surveys, and question pools in my Blackboard course?
document How do I add short answer questions to tests, surveys and question pools in my Blackboard course?
document How do I add either/or questions to tests, surveys and question pools in my Blackboard course?
document How do I add quiz bowl questions to tests, surveys and question pools in my Blackboard course?
document How do I add random block questions to tests in my course site?
document How do I clear a test or survey attempt in my course site?
document How do I extend quiz/test access to some students, but not all of them?
document How do I play Mediasite files from my Blackboard course site?
document How do I download survey results in my Blackboard course?
document How do I download test results from the Grade Center?
document How do I allow students to have multiple test attempts in my Blackboard course?
document How do I grade an individual student's test attempt in my Blackboard course?
document How do I modify an existing assessment question in Blackboard?
document How do I modify an existing test in my Blackboard course?
document How do I reorder questions on a test, survey, or question pool in Blackboard?
document How do I remove an existing question from a test, survey, or question pool in Blackboard?
document Why am I unable to modify or remove questions in a quiz pool?
document How do I view overall statistics for survey and quiz results in the Grade Center?
document How do I view assessment results in the Grade Center?
document How do I register my clicker?
document How can I tell if I have Java installed?
document Where can I get a clicker and how much does it cost?
document My clicker turns off/goes blank every time after I put in an answer. Is this normal?
document Which clicker are we using at UT Knoxville?
document What steps must faculty take to use clickers in the class?
document How do I reset a quiz or test attempt in my Blackboard Learn course site?
document How do I remove existing question pools from my Blackboard course?
document How do I modify existing surveys in my course in Blackboard Learn?
document A course site in Blackboard Learn says that it's "Unavailable". What does that mean?
document I'm trying to upload a document and get a message that says "Please enter a valid file." What's going on?
document I've returned papers to my students with comments written on them using the Reviewing tool in Microsoft Word, but they can't see them. Why did Blackboard strip out the comments from these papers?
document I've gotten my paper back from my instructor but the comments that are supposed to be there are missing. Where did they go?
document What is the Early Warning System in Blackboard Learn?
document I've forgotten my non-LDAP guest account password? Is there a way to retrieve it and/or change it?
document Can you explain the difference between Due Dates and the Date/Time restrictions in Blackboard Learn?
document All of my grades for one student are missing in Blackboard Learn - in fact, the student's whole row of grades is missing in Grade Center. Where are they?
document I'm trying to take a test in Blackboard Learn, but the assessment text is cut off on the right side. What can I do to fix this problem?
document I'm trying to submit a .ZIP file of multiple assignment files using SafeAssign in Blackboard Learn, but I get a "Maximum file size (10 MB) exceeded" error. What does this mean?
document What steps must students take to use clickers in a Blackboard Learn course site?
document Can 2 people (friend, roommate, relative, etc.) share a clicker in Blackboard Learn?
document How can mobile devices be used as clickers in my course site in Blackboard Learn?
document I've downloaded and installed TurningPoint 2008 4.2.2.3. However, the Settings Pane is not visible for me to indicate the correct answer or to change the point value.
document I've tried to Import my clicker Participant List into my course site in Blackboard Learn and I get an error message that the List contains duplicate device IDs. What do I do?
document Where can I see my official class roster?
document What is the SafeAssign "Synchronize this Course" option that appears in the "Direct Submit" area of my Blackboard Learn course site?
document When I try to login to Online@UT, my browser flashes repeatedly and never loads. What can I do?
document When I try to load a page in Blackboard, I get a message about an applet; what do I need to do?
document I can't find the Digital Dropbox; where did it go?
document I'm using Internet Explorer and Blackboard Learn is acting strange. What's going on?
document I copied materials from an old course site in Blackboard Learn, but it looks like not everything copied. What do I need to do?
document My students say they can't see my course site in Blackboard Learn, but I can see it. What's going on?
document All I can see in my course site in Blackboard Learn is the Announcements! Where is everything?
document How do I enroll in Emergency Preparedness Training in Blackboard Learn?
document What roles are available in Blackboard Learn course sites, and what can they do?
document How do I clear my browser's cache?
document I'm trying to access Grade Center in my Blackboard Learn course site, but it won't load. What do I need to do?
document Can I send emails through Blackboard Learn course sites that show as "unavailable"?
document Why am I receiving emails of old announcements in my Blackboard Learn course site?
document When I edit an Announcement, will it automatically send out an email copy of the Announcement to my students?
document Will Statistics Tracking track a single Item I've posted in a Content Area in my Blackboard Learn Course Site?
document What is Blackboard IM?
document Why do I have to be enrolled in Blackboard Learn before I can create a Blackboard IM account?
document Why do I have to create a Blackboard IM account before I can download the software?
document How can I learn more about Blackboard IM?
document Why doesn't the Send Email function in Blackboard Learn have an Outbox? I want to check who I've sent emails to.
document How do I make suggestions for product enhancements to Blackboard Learn? How can I send my comments about Learn to Blackboard?
document In Blackboard Learn, I've set up an Average calculated column in my Grade Center...but it's not averaging correctly. What's the deal?
document How do I find out what version of Microsoft Internet Explorer I'm currently using?
document I'd like to turn Compatibility Mode/View off in Internet Explorer. How do I do this?
document In Blackboard Learn, what is the difference between a Blog and a Journal?
document How can I comment on a Blog entry in Blackboard Learn?
document How do I create a Blog entry in Blackboard Learn?
document I created a Blog post in my Blackboard Learn course site, but saved it as a Draft. How do I get to my saved draft to edit and/or post it?
document It's the end of the semester and some of my students' grades seem inflated in Blackboard Learn's Grade Center.
document How do I turn off Running Total in Grade Center so I can have an accurate final grade to enter into MyUTK?
document If I create an individual Blog in Blackboard Learn (as opposed to a group or class Blog), can other students view it? Or is it private?
document Can I add a Twitter feed to my Blackboard Learn course site?
document What's all this stuff in my test/email/assignment/announcement? I see things like "mso" "normal" and "MsoNormalTable" all over the place.
document When I try to launch a Collaborate session, I get an error that says something like "unable to launch application". What do I do?
document How can I embed video in my course in Blackboard Learn using the Item tool?
document How can I embed YouTube videos in my Blackboard Learn course site using the Mashup tool?
document I'd like to be able to email my students through my course site in Blackboard Learn, but I don't want my students to be able to email anyone through my course site except me. In some cases, I don't want them to be able to use the Send Email function at all. How can I set that up?
document On my Course Menu in my course in Blackboard Learn, I keep selecting a Content Area's chevron button and choosing "Show Link"...but the link still won't show for my students. What's happening?
document I have more than one section of a course in Blackboard Learn. How do I merge or combine these sites so I only have to post things once for the whole class?
document What email address should I tell my students to add to their email exceptions list to ensure that they get the emails I send them through Blackboard Learn?
document I'd like to be able to copy my quizzes and tests into this semester's course shell in Blackboard Learn without having to re-deploy them. In other words, I want to copy my Assignments folder and have my quizzes already deployed there. How do I do this?
document I'd like to change the color of the Course Menu or the titles of Assignments, Items, etc...but I want a color that matches my banner, or even just to be able to use the official UTK orange. How do I do that?
document How does an instructor make a course site available or unavailable in Blackboard Learn?
document How do I change the Course Name for my course site in Blackboard Learn? I don't like the default Course Name my college or department assigned to my course in Blackboard Learn.
document Can I change my course site's Course ID in Blackboard Learn?
document I've successfully bought and downloaded the Blackboard Mobile Learn app for my smart phone. I also have a tablet; I want to use the app on the tablet as well without buying the app again. Is this possible?
document I've bought a new Google-powered smart phone/tablet/device and I want to put my previously-purchased Blackboard Mobile Learn app onto it. I've already paid for the app once; how do I retrieve the app for my new device VIA Google Play without having to pay for it again?
document I've bought a new Apple smart phone/tablet/device and I want to put my previously-purchased Blackboard Mobile Learn app onto it. I've already paid for the app once; how do I retrieve the app for my new device VIA the Apple App Store or iTunes Store without having to pay for it again?
document What versions of Android devices are supported by Blackboard Mobile Learn?
document What versions of BlackBerry devices are supported by Blackboard Mobile Learn?
document What versions of iOS (Apple) devices are supported by Blackboard Mobile Learn?
document I am one of several instructors enrolled in a course site. How can I add the other enrolled instructors as Moderators to a Blackboard Collaborate session?
document How do I add images or links to assessment questions in a Pool in Blackboard Learn?
document How do I add images or links to assessment questions in a Test in Blackboard Learn?
document How can an instructor print students' posts or entries in the Discussion Board in Blackboard Learn?
document What is Blackboard IM?
document How do I access Blackboard IM?
document What are the system requirements for Blackboard IM?
document How do I register and create a Blackboard IM account?
document How do I download and install Blackboard IM for Windows?
document How are Course IDs for merged course sites in Blackboard Learn determined?
document How do I download and install Blackboard IM for Mac OS?
document What's the best browser to use with Blackboard Learn?
document I'm trying to download an Exported ZIP file from Blackboard Learn, but I'm using Safari as my browser and Safari keeps unzipping my ZIP file automatically, rendering it useless. What do I do?
document I'm trying to turn in my assignment VIA SafeAssign in my course site in Blackboard Learn. When I click on the SafeAssignment link, I get sent back to the My Institution page. Help!
document I've narrated a slide presentation using Microsoft's PowerPoint, and I want to upload it into my course site in Blackboard Learn. When I try to, I get the slides in okay, but no audio. How do I upload a PowerPoint with voice-over into Bb Learn?
document I'm trying to use Google Docs to allow students to share and edit certain documents I post there. I'd like to link to this Google Docs document out of my Blackboard Learn course site. How can I do that without having to invite every student in my class separately?
document How can I get help with WebAssign?
document I'd like to use MyLab by Pearson in my course site in Blackboard Learn. How can I do this?
document How can I add a lot of files at once to my course site in Blackboard Learn so that students can then see them?
document I'm an Instructor using Blackboard Learn and I would like to show comments on tests to the student after they complete the test or quiz.
document I see that Blackboard Learn provides me with two ways to calculate my students’ grades in Grade Center: Total and Weighted Total. What do I need to do?
document I just sent an email through Blackboard Learn using the Send Email and/or Email Announcement tools. No one got the email, including me. What just happened?
document When I go to Grade Center in my course site in Blackboard Learn, none of my students are there. Where did my students go? It's as if Grade Center won't load properly.


RSS

 

The University of Tennessee, Knoxville. Big Orange. Big Ideas.

Knoxville, Tennessee 37996 | 865-974-1000
The flagship campus of the University of Tennessee System