Importing results from Excel

To import student results from Microsoft Excel:

Note: When importing 1997-2003 Excel files the worksheet must be the first sheet and must be spelt Sheet1 with capitalisation and without internal spacing.

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 "Sheet1" of the spreadsheet. *Note that the label of the sheet with your data to import must be called "Sheet1", otherwise the import will fail.
   
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.
    
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.