ATLAS Gradebook - Importing scores with "Name, Assignment, Score" format

Learn how to import scores using the "Name, Assignment, Score" format with ATLAS Gradebook.

In ATLAS Gradebook, we can import scores by attaching a properly formatted Excel spreadsheet, saving the user instances of multiple score entry.

To get started, let's go to the Course Term Home and select the "Import Scores" area.

for import scores by: select the Uploading a File radio button. for Type of Scores - select the Name / Assignment / Score format radio button

So, we have a variety of options for importing scores, but we're going to go with the Name / Assignment / Score Format.

We also have the option to upload one assignment or multiple assignments depending on the Excel sample spreadsheet we select.

Since we've only got one assignment to upload, let's select the "sample spreadsheet for single assignments" option.

Here's what the sample spreadsheet looks like:

sample spreadsheet. columns read left to right: Student NetId/UIN, Assignment Name, Score, Comments

Now that we've got the sample spreadsheet pulled up, we just have to enter our students' information into the sheet.

same format as above - but with our new scores entered

Once we've entered student UINs (also takes netID), the assignment name, and the score -- we can save our spreadsheet in any way that we see fit.

Now, let's go back to the Import Scores area and import our new spreadsheet!

hit choose file button

We're going to select the "Uploading a file" checkbox in the "Import scores by" area.

After that, we'll select the "Name / Assignment / Score Format" from the "Type of scores" area.

To add our new spreadsheet for Quiz 1, let's click the Choose File button.

The image below shows what this may look like while using Google Chrome. Your browser options will likely look slightly different.

select appropriate file from browser's file picker

When we select Choose File, a file chooser box will appear.

Once we find our file, we can select it and hit the Open button.

Now let's see what it looks like in the Preview area of Import Scores.

hit Save Results button

We can see all of the appropriate student names and see that the scores will display well in the Preview.

To finalize these scores for Quiz 1, we'll select the Save Results button.

 



Keywords:
ATLAS Gradebook, importing scores 
Doc ID:
51887
Owned by:
Todd R. in University of Illinois LAS
Created:
2015-06-03
Updated:
2015-09-23
Sites:
University of Illinois Liberal Arts and Sciences