Import Assessments and Scores in AT&S

 

Using the “Import Assessments and Scores” function, you can perform the following functions via a single spreadsheet CSV file:

  • Import scores into multiple existing assessments at once; and / or,
  • Create one or more offline assessments and load their scores.  

    (To import grades into one assessment, you can also use Import Scores).

Import Assessments and Scores

  1. Go to AT&S and click on Import.
  2. Click on “Import Assessments and Scores.”

     

    Import assessments and scores
     

  3. You will then browse to select and upload your spreadsheet CSV file. For information on the proper format for the file, see below. 

     

    browse to select a file
     

  4. You will have a chance to preview the data and confirm the import of the scores and creation of offline assessments.
     

CSV File Format

The file format for importing scores into AT&S is the same for both multiple assessment creation and importing scores and for single assessment score importing

The file for importing scores into existing assessments, or creating offline assessments with their scores, 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:

12345678
jado45678
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 and a list of existing assessments is via the gradebook’s Export in CSV function. It includes the proper Student ID column and additional columns for all assignments. Etudes will ignore extraneous columns, like “Section ID”, or invalid data. 

  • The other columns contain scores for assessments to be created or updated with scores. The columns must have headers.

    • The header of each column must include the exact title of the assessment, as you have created it in AT&S (or want it created via this process). The remaining rows contain the score of each student. Etudes will ignore any extraneous column data. To specify a new offline assessment’s point value, you can include the point value surrounded by {{ }} after the title of the assessment in the header. For example, the header for a new offline assessment titled “Homework 7” that is worth 100 points will look like:

Homework 7 {{100}}

Notes: 

For existing assessments with established point values in AT&S, the point value will not be changed by the import. 

The point value format {{ }} in the headers for titles is for creating new offline assessments and setting their point value on-the-fly, along with loading student scores. For existing assessments, you need not include a point value in the titles.

If a column in the CSV file includes a new offline assessment but does not have a point value in {{ }}, the import function will create an offline assessment and will load the scores, but it will not publish the assessment, since it needs points to be valid. You will need to use AT&S to set the points and publish it.  

Import scores for multiple assessments
 

  • The confirmation view will display the offline assessment(s) that will be created with their scores, and / or the existing assessments whose scores will be logged. 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. 

    If your file contains a column that looks like an assessment, with a title in the header row and numeric score values in the other rows, but is not, or if you don’t want to import all the columns of the file, you can remove the check from “Selected for Import” for each one. Only the checked ones will be imported. 

confirmation screen

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. 

[rule_top]

Print Friendly