User Tools

Site Tools


general:assignment_grades_import_data_file

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Next revision
Previous revision
general:assignment_grades_import_data_file [2020/04/01 12:59] – created jstanfordgeneral:assignment_grades_import_data_file [2021/12/17 15:08] (current) apape
Line 1: Line 1:
-\\   
 <WRAP box> <WRAP box>
-VCV Click {{:images:import.png|import icon}} to import grades for the assignment.<div indent>The Import Assignment Grades window opens allowing you to upload the data file, review the data, and import the file.</div> +VCV Click {{:images:import.png|Import}} to import grades for the assignment. 
-VCV Under **Step 1**, click **Browse** to select the data file. Locate and open the file.<div indent>he file name is displayed.</div>  +<div indent>The Import Assignment Grades window opens allowing you to upload the data file, review the data, and import the file.</div> 
-VCV Click **Upload File**.<div indent>When the upload is complete, the "Success" message is displayed indicating the name of the uploaded file.</div>+VCV Under **Step 1**, click **Browse** to select the data file. Locate and open the file. 
 +<div indent>The file name is displayed.</div>  
 +VCV Click **Upload File**. 
 +<div indent>When the upload is complete, the "Success" message is displayed indicating the name of the uploaded file.</div>
 VCV Under **Step 2**, review the default file format and adjust the columns of your data if necessary:\\  \\   VCV Under **Step 2**, review the default file format and adjust the columns of your data if necessary:\\  \\  
 <div indent> <div indent>
  
-VCV  Under **Our Column**, the default file format is listed. The format is determined according to the type of data found in the uploaded file. For example, a six-digit string of numbers is assumed to be the student ID, and a string of up to three characters is assumed to be an assignment grade. There are four columns:\\  \\  +VCV  Under **To Column**, the default file format is listed. The format is determined according to the type of data found in the uploaded file. For example, a six-digit string of numbers is assumed to be the student ID, and a string of up to three characters is assumed to be an assignment grade. There are four columns:\\  \\  
 <div indent> <div indent>
 BBB Student ID\\   BBB Student ID\\  
Line 13: Line 15:
 BBB First Name\\   BBB First Name\\  
 BBB Last Name\\  \\   BBB Last Name\\  \\  
-<WRAP round>**NOTE:** For the six-digit student ID, include all leading zeros.</WRAP>+<WRAP round>**NOTE:** For the six-digit student ID, include all leading zeros.</WRAP>  
 +</div>
 \\   \\  
 +VCV Under **From Column**, make adjustments as needed.
 +<div indent>For example, if the default file format has the first name before the last name, and you want the last name before the first name, you can change the columns under **From Column** accordingly (i.e., change column 3 to 4, and change column 4 to 3). **NOTE:** The order of the first and last names is not important when uploading this file.
 </div> </div>
-VCV Under **Your Column**, make adjustments as needed. For example, if the default file format has the first name before the last name, and you want the last name before the first name, you can change the columns under **Your Column** accordingly (i.e., change column 3 to 4, and change column 4 to 3). **NOTE:** The order of the first and last names is not important when uploading this file. 
 </div> </div>
 \\   \\  
Line 25: Line 29:
 <div indent> <div indent>
 BBB If errors are encountered, the records with errors are displayed in red with a strikethrough. The number of errors found is listed below the grid. Errors may include mismatched or invalid data.\\  \\   BBB If errors are encountered, the records with errors are displayed in red with a strikethrough. The number of errors found is listed below the grid. Errors may include mismatched or invalid data.\\  \\  
-BBB The file can be imported even if errors exist (unless no valid records exist). The valid records are importedand the invalid records are not imported.+BBB Currently, the only acceptable error is an error due to the student already having a grade for the assignment. Exception errors due to invaid records will cause the import to fail.
 </div> </div>
-When you are satisfied with the data under **Step 3**, click **Import Now** under **Step 4**. The data is imported, and the assignment grade fields on the Assignment Grades page are populated with data from the import file.\\  \\   +VCV When you are satisfied with the data under **Step 3**, click **Import Now** under **Step 4**. The data is imported, and the assignment grade fields on the Assignment Grades page are populated with data from the import file. 
-The **Import Now** button is disabled if there are no valid records to import. +<div indent>The **Import Now** button is disabled if there are no valid records to import. 
-\\  +</div> 
 <WRAP box>**NOTE:** If the course has any withdrawn students, the import file has a record for the withdrawn students. Therefore, you must select **Show withdrawn students** on the Assignment Grades page to import the grade for the withdrawn students. If you do not select **Show withdrawn students**, the import file will generate errors for the withdrawn students.</WRAP> <WRAP box>**NOTE:** If the course has any withdrawn students, the import file has a record for the withdrawn students. Therefore, you must select **Show withdrawn students** on the Assignment Grades page to import the grade for the withdrawn students. If you do not select **Show withdrawn students**, the import file will generate errors for the withdrawn students.</WRAP>
  
 </WRAP>\\  \\   </WRAP>\\  \\  
general/assignment_grades_import_data_file.1585745990.txt.gz · Last modified: 2020/04/01 07:59 (external edit)