Tip:
Highlight text to annotate it
X
Okay so if you're using Excel to edit your grades, and then upload it into Blackboard,
be sure that you start with an Excel spreadsheet that came from Blackboard. So it will have
all of this stuff already populated in it for you. So I'm in the Full Grade Center,
and I'm going to look for the Work Offline button at the top right, and then select Download.
And I want to download the Full Grade Center, keep it tab-delimited, and I'm going to open
it up on My Computer. So I hit Download, and I have the option to open it with Excel which
is what I want. Yes, I want to open it. So here's that Excel download that came from
the Grade Center. Now you'll notice as you move your cursor across these columns you'll
notice there's a code that gets populated up here, you want to keep that code, and then
for anything that's new. Like, so now you're grading in a different program, and you've
got a new column that you want to add, and upload to Blackboard, you would call this
column, let's say Quiz 1. And you would go down the line and give the students grade
for their quizzes. So let me just enter some data here. So, of course, I'm still in Excel,
I'm just putting data into this. I'll keep one of them blank - or a couple. We could
do the same thing for another column. Let's do that - I'll paste it and call it HW2. I'll
just leave the numbers the same, just to show you what this process is like, okay? Maybe
we'll do... So now we save this on our desktop. And we want to save it as CSV... Actually
hold on a second... I got to figure out which one we are saving as... Yeah, so we're going
to do file save as, keep this as a CSV file, comma-delimited file. We'll call this "grades-katie"
and I'll put it on the desktop. So, .CSV, and that's okay. Okay so now I go back to
Blackboard, in that same class, back to Full Grade Center, and notice I just have those
original columns in here still. I haven't touched anything in here. So now, Work Offline,
I'm going to say "Upload." And I'm going to Browse my computer, go to my Desktop, and
find that grades-katie-CSV, there it is. And I can keep the delimiter type "Auto." It will
figure out that it is comma. So here I submit. And now it's telling me what it's found a
match for. So these are the things that are in the spreadsheet that are also in the Grade
Center already. And here are the two columns that I created in Excel that are also going
to be uploaded, because these are checked. I could choose to not upload those. But they
will be uploaded and here's the data that's going to be uploaded to those two columns.
So, then I hit submit, and then it tells me that that was successful and now I've got
the quiz 1 and the HW2 columns. Notice the ones that were kept blank, are still blank
here. So that is the process that you'll want to follow if you're planning on entering your
grades into Excel. You'll want to start with an Excel file that was downloaded from Blackboard.
And you can make all of your edits in Excel and then upload it to Blackboard in the way
that I've shown you here.