Previous icon

Next icon

Importing results from Excel to the highlighted results column

You can import student results from Excel into Student Results Maintenance. You are restricted to importing a column at a time.

To import results from Excel to the highlighted results column:

  1. Start Microsoft Excel.
  2. Open the spreadsheet containing the student results.

    Microsoft Excel - German A class results import

    Note: Column A must contain the Synergetic IDs of the students.

    Tip: To easily get the Synergetic IDs and students for the class, first export the blank results to Excel. For a similar example, see Exporting results to Microsoft Excel for a class.

  3. Highlight the cells containing the results that you want to import.

    Microsoft Excel - German A class results import (highlighted column)

  4. Switch to Synergetic.
  5. Open the All Students tab of Student Results Maintenance for the class you are updating the results for. See Student Results Maintenance - All Students tab.

    Student Results Maintenance - All Students tab (cut down)

  6. Highlight the column that you want to import results for.

    Student Results Maintenance - All Students tab (highlighted column)

    Tip: Click the heading to highlight the column.

  7. Right click.

    The menu is displayed.

  8. Select Import Results for Highlighted Column from Excel.

    Right click menu (Import Results for Highlighted Column from Excel, cut down)

    The following dialog window is displayed.

    Confirm - about to attempt to import from Microsoft Excel

  9. Click Yes button.

    The student results are imported and values updated for each corresponding student.

    Student Results Maintenance - All Students tab (import from Excel, 2)

  10. Repeat steps 2 through 9 for each additional column that needs importing.

Last modified: 22/12/2016 10:18:39 AM

See Also

Exporting and importing student results to and from Microsoft Excel

Exporting results to Microsoft Excel for a class

Exporting results to Microsoft Excel for classes in a subject assessment

Exporting mark book results to Microsoft Excel

© 2017 Synergetic Management Systems. Published 20 July 2017.

Top of page