Importing results from Excel

To import student results from Microsoft Excel:

1. Open the Class window of SynWeb Results Maintenance. See Results Maintenance - Class window.
2. Click .

   The Excel Results Import window is displayed.

   

3. Select .
4. Create or locate a Microsoft Excel file containing the student results that you want to import.

   Ensure that:

   • the first row contains column headings
   • the first column contains the Synergetic ID numbers for the students in the class
   • the information is recorded on "Sheet 1" of the spreadsheet.

   

5. Select the Excel file to upload and click .

   The filename is displayed in the Excel Results Import window.

   Note: If you have selected the wrong file, click to remove the filepath.

6. Click .

   The Excel Results Import window is redisplayed with information from the spreadsheet.

   

7. For each Excel Column that you want to import, select the Import checkbox.
8. Select Overwrite if a column that you want to import should replace an existing column in SynWeb.
9. Select the relevant Assessment Area from the drop-down list.

   Tip: Synergetic automatically attempts to match the columns in the spreadsheet with the columns in SynWeb.

   Note: You cannot import results from Excel into read-only columns or map more than one Excel column to an Assessment Area.

   Tip: You can import a Test Comment against comment fields.

10. Select .

    The results are imported and added to the Results Maintenance - Classes view for the relevant students.

    Note: Marks can only be imported if they conform to the result mask defined for the class. See Maintaining mark books.

    

Last modified: 13/08/2014 8:03:47 AM