Easy-to-follow video tutorials help you learn software, creative, and business skills.Become a member
In our last movie, we downloaded the Blackboard Grade Center. What I've done for the past couple of minutes is I've actually added scores for all my students for Quiz #1 and just to be dangerous, I created a new column. Remember that if you create a new column here in Excel instead of Blackboard, when you upload it, Blackboard is going to create a text column. So this is actually not going to be a score of 90. It's going to be text of 90. It's not going to count. I'll show you how to fix that, but the best way to fix it is to create the column in Blackboard in the first place and download it there.
But if you want to live life on the edge, let me show you how to fix it. And when I do, Internet Explorer is going to yell at me. It's going to say, "You keep calling this in Excel file and you really need to stop doing that, because this is really just a tab delimited file. Stop saying it's an Excel file!" I said no, I'm going to keep calling this an Excel file even though it's tab delimited. Again, this is a file that I've downloaded from Blackboard. I'm now going to go to Blackboard and, oh no, over on the left-hand side, my Course menu is gone. Blackboard is broken! No. Remember, if you are ever in your Grade Center and needs some extra room, you can hide your Course menu.
To get it back, just click on the Show Course menu. So if you're in the Grade Center and you don't see a menu on the left-hand side, don't panic. That's normal. In this case I'm going to scroll over. Click on Work Offline and now I'm going to upload my Grade Center. Click on Upload. It's going to ask me to browse for the file. Remember the second Browse box allows me to search either the content collection or course files area, but this is actually on my computer. So I'm going to click on the first Browse button and attach a local file.
It's up on my desktop. So there's the file. I'm going to click on Open. Because I downloaded the file from Blackboard, made the changes in Excel, saved it and uploaded it, Blackboard is actually going to recognize all of the columns except for that new one. In fact, when I go and click on this, it's going to say, "Oh look, I've got a whole bunch of new grades here and hey, I got a new column." It's not going to make any other changes. It's just basically saying I'm going to change the Quiz 1 column and the NEWCOLUMN. Blackboard is smart enough to read that file and say "Oh, I see new values here" and it's actually going to create a new column.
So when I click on Submit, it'll actually upload it and then take me to the Grade Center. Since I added a new score column, new score columns are always added to the far right-hand side. First of all, we can see all the grades correctly uploaded. It shows you the raw score and because we have the display settings here to show percentage, it's showing that as well. I want to keep scrolling all the way over and there is the NEWCOLUMN and it sure does look like it gave my students a score of 90.
But no, it actually gave the students the word 90. It doesn't count towards the students grades. In this case, it won't count in the weighted total until I go and add it to the weighted total. It will show up in the Total column now. In this case, I'm going to go and click on Edit Column Information. Remember how I said that when you create a column outside of Blackboard and uploaded it, it's going to come in and say Text? Well that's what I'm showing you right here. I'm going to change this from a Text to a Score and I can try to choose the Secondary Display as Percentage, but it may not actually do that.
Let's give it a shot. when I submit, I might actually get an error message and now I have to say how many point this is worth. So it's worth 100 points. Scroll down and then click on Submit and it's going to say, "You know, I'm about to do some conversions for you. If I can't convert it, I'm just going to display to 0." In this case, since we're just transcoding the word 90 into the number 90. That's perfectly fine It should work fine.
And yeah, it did. So 90.00. So to upload a Blackboard Grade Center file from your computer to Blackboard and it's a Grade Center file you've already downloaded, get into your Grade Center, click on Work Offline, and then click Upload. Blackboard will automatically enter the scores and if you created any new columns, Blackboard will create the column. However, it's going to create that new column as a text column. You need to go into Edit Column Information and change the display from Text to Score.
Get unlimited access to all courses for just $25/month.Become a member
82 Video lessons · 80730 Viewers
80 Video lessons · 132925 Viewers
52 Video lessons · 66389 Viewers
59 Video lessons · 52174 Viewers
Access exercise files from a button right under the course name.
Search within course videos and transcripts, and jump right to the results.
Remove icons showing you already watched videos if you want to start over.
Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.
Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.
Your file was successfully uploaded.