This tutorial explains how to import scores into an existing assessment in AT&S. To learn how to import scores into multiple assessments or to create one or more offline assessments and load their scores, see Import Assessments and Scores into AT&S.
Import Scores Into An Existing Assessment
- Go to AT&S and click on Grading.
- Select your assessment.
Click on the “Import Scores” function available in the Global Actions area.
You will then browse to select and upload your spreadsheet CSV file. For information on the proper format for the file, see below.
You will have a chance to preview the data and confirm the import of the scores.
CSV File Format
The file format for importing scores into AT&S is the same for both multiple assessment creation and score importing and for single assessment score importing.
The spreadsheet file for importing scores into an existing assessment must meet the following criteria:
- The file must be a comma separated value file (CSV).
- The first row of the file must contain headers. The headers are described below.
One of the columns in the file must have a header titled “Student ID”. The Student ID can be:
- The student’s college student identification number (just the ID, without any extraneous characters like @laccd, @fh, etc.). Or,
- The student’s login user ID.
The Student ID column’s data may contain extra information, such as the students’ name, to help you organize your spreadsheet, as long as one of the accepted ID values is included at the end of the text, in parenthesis. For example, for student Jane Dough, who has a college student id number of 12345678, and logs into Etudes with jado45678, the first column of your spreadsheet could have any of these values:
Dough, Jane (12345678)
Jane Dough (12345678)
Any rows of the file for which the Student ID does not identify an enrolled student in the course site will be skipped on import.
Tip: A fast way to get started with a file that includes your students’ ID’s is via the gradebook’s Export in CSV function. It includes the proper Student ID column and columns for all assignments. Etudes will ignore extraneous columns and entries for other assignments.
You must have another column that contains a header whose title matches the selected assessment, with the scores of the students. For example, to import scores for Homework 7, the file will look like the following:
The file may contain columns for other assessments. Etudes will ignore extraneous column data, and will import scores for the selected assessment only.
The confirmation view will display the scores that will be logged for each student.
- If you are happy with the entries listed, click on Import at the bottom (or Cancel to abandon the process). Any lines of the file that are not successfully interpreted will be flagged with a reason, and will be ignored if you choose to import.
Note: The scores uploaded represent the final scores for an assessment. In other words, if an assessment consists of many questions, each worth different point values, the import function does not award points to students for each question, but rather logs or updates the score in the Final score column only.