Gradescope grades to MyLab grades

It is important that all the written
homework scores of our students get
copied to the MyLab gradebook. The
MyLab gradebook is designed to give
students complete feedback about their
performance in the course, and it will
make it very easy for us to compute
final grades if all the scores are
there. If your grader has not been
doing this all along, there is a way
to import scores from the Gradescope
gradebook to the MyLab gradebook. I
explain here how.

First, log into Gradescope and click
on Assignments in the left column.
Scroll down and click on the Download
Grades box. Select Download .cvs to
get a comma separated values file.
Open the file in Excel and delete
all the extraneous columns. Keep the
Name column, the Email column, and
the first column of each assignment
(that contains actual scores). Delete
the other two columns for each assignment
that contain the max score and pound
signs.

Next, delete the names in the Names
column that are not last names. This
is tedious (see the next paragraph for
a shortcut), but you only have to do it
once. I had two Cho's in my list. I
changed their last names to ChoJ and ChoK
to distinguish them and keep them in
the right order. (One of my Cho's used
an alias in Gradescope that was not
their official first name. I had to
check their PU id to make sure they
were who I thought they were.)

(Here is a way to automate isolating
the last names in a column: in Excel,
widen the Name column and select the
whole column after inserting two empty
columns to the right of it. Next, click
on the Data tab and click on the
"Text to columns" icon. Choose the
Delimited radio button. Click Next.
Check the Space box, and uncheck the
others. Click Next. Select the Text
radio button. Click on Finish and then
click on Ok in the pop-up box that
warns you that you are replacing
data in those blank columns with new
data. Finally, you might have to
manually make some changes to people
like Mr. St. John or people who have
multiple last names or multiple first
names. Almost all of them got their
names split into two columns, but some
got three. Be careful about those first
name alias issues.)

Next, reorder the whole sheet via
the new last names column and make
sure the order is the same as the
order in the MyLab gradebook. (Keeping
the email column in the file helped
me confirm that my reordering was done
properly across all columns.)

Finally, enter zeroes in all the empty
score boxes.

Then save the file as GS.cvs to keep
a backup copy and keep the file open
for use in the next steps.

Next, open MyLab Mastering and Basic
inside Brigtspace and click on the
Course Home link in the left column.
In the big Assignments box (below the
Gradebook box), scroll down and click
on the

Manage Assignments

link (and NOT the Manage Gradebook link
in the Gradebook box).

Scroll down to the first written assignment
in the list for which you'd like to upload
scores. Click on the Select box in the right
column and choose Change scores. You'll
see a list of your students ordered by
last name. Check that list against your
list in the Gradescope .csv file that you
created and still have open.

Click on the link near the top of the page
that says Upload scores from a .csv spreadsheet.

Click on the box that says Download Scores
Template and make sure the Comma choice is
selected. I saved the file as MLtemplate.csv

Open the template file and the Gradescope
grades file in separate windows. Mouse over
the column of written homework scores in the
Gradescope file you want to import and push
control-c to copy the column. Click in the
column in the template file where scores go
and push control-v to paste the column there.
Save the file as

hw12w.csv

for example.

Now go back to the dialogue box and click
on the Select File box and choose the file
you just created. Click on the Upload File
box.

The score boxes will now have scores in
them. Check to make sure they line up
correctly. If all looks good, click on
Save at the bottom.

After you do the first one, the rest are
easy. (You only have to make that template
once. I undo the column I pasted and then
paste the next one, etc.)

Repeat for each column.

-Steve

---